Posts

Showing posts from November, 2016

FND_REQUEST.SUBMIT_REQUEST

declare v_request_id number(15); v_user_id               fnd_user.user_id%TYPE := 40827; v_responsibility_id     fnd_responsibility.responsibility_id%TYPE; l_boolean  boolean begin     select name into l_db     from v$database;         SELECT responsibility_id     INTO v_responsibility_id     FROM fnd_responsibility_vl     WHERE responsibility_name = 'AR Receivables';         -- set environment context     fnd_global.apps_initialize (v_user_id,                                 v_responsibility_id,                 ...