DBA Data[Home] [Help]

APPS.AS_GAR dependencies on DUAL

Line 11: -- called from within the individual entity packages.

7: -- ---------------------------------------------------------------------
8: -- NOTES
9: -- -----
10: -- 1: This package contains all the common procedures and functions
11: -- called from within the individual entity packages.
12: ---------------------------------------------------------------------------
13: /*-------------------------------------------------------------------------+
14: | PRIVATE CONSTANTS
15: +-------------------------------------------------------------------------*/

Line 61: SELECT fnd_concurrent_requests_s.nextval into px_terr_globals.request_id from dual;

57: IF px_terr_globals.request_id = 0 OR px_terr_globals.request_id IS NULL
58: THEN
59: -- Get concurrent sequence
60: AS_GAR.LOG('request_id is 0, get from sequence');
61: SELECT fnd_concurrent_requests_s.nextval into px_terr_globals.request_id from dual;
62: END IF;
63:
64: COMMIT;
65:

Line 159: SELECT AS_BUSINESS_EVENT_S.nextval INTO l_event_id FROM dual;

155: p_parameterlist => l_param_list);
156:
157: begin
158:
159: SELECT AS_BUSINESS_EVENT_S.nextval INTO l_event_id FROM dual;
160:
161: AS_GAR.LOG(' --- CALL WF_EVENT.RAISE.Start...');
162: AS_GAR.LOG(' --- l_event_id = '||l_event_id);
163: AS_GAR.LOG(' --- l_mode = '||l_mode);