DBA Data[Home] [Help]

APPS.ZPB_DATA_LOAD dependencies on ZPB_AW

Line 16: ZPB_AW.EXECUTE('call DL.RUN.1(' || TO_CHAR(p_task_id) || ')');

12: BEGIN
13: -- Run the first part of the load, which among other things, sets
14: -- up all status-setting queries needed in the whole load.
15:
16: ZPB_AW.EXECUTE('call DL.RUN.1(' || TO_CHAR(p_task_id) || ')');
17:
18: -- Get the queue of SQL IDs that need to be executed.
19: -- l_query_list := zpb_aw.interp('show CM.SQLID.QUEUE');
20: -- l_query_list := SUBSTR(l_query_list, INSTR(l_query_list, '<<')+2);

Line 19: -- l_query_list := zpb_aw.interp('show CM.SQLID.QUEUE');

15:
16: ZPB_AW.EXECUTE('call DL.RUN.1(' || TO_CHAR(p_task_id) || ')');
17:
18: -- Get the queue of SQL IDs that need to be executed.
19: -- l_query_list := zpb_aw.interp('show CM.SQLID.QUEUE');
20: -- l_query_list := SUBSTR(l_query_list, INSTR(l_query_list, '<<')+2);
21:
22: -- ZPB_AW_STATUS.RUN_OLAPI_QUERIES(l_query_list);
23:

Line 22: -- ZPB_AW_STATUS.RUN_OLAPI_QUERIES(l_query_list);

18: -- Get the queue of SQL IDs that need to be executed.
19: -- l_query_list := zpb_aw.interp('show CM.SQLID.QUEUE');
20: -- l_query_list := SUBSTR(l_query_list, INSTR(l_query_list, '<<')+2);
21:
22: -- ZPB_AW_STATUS.RUN_OLAPI_QUERIES(l_query_list);
23:
24: -- Run the final part of the load.
25: ZPB_AW.EXECUTE('call DL.RUN.2');
26:

Line 25: ZPB_AW.EXECUTE('call DL.RUN.2');

21:
22: -- ZPB_AW_STATUS.RUN_OLAPI_QUERIES(l_query_list);
23:
24: -- Run the final part of the load.
25: ZPB_AW.EXECUTE('call DL.RUN.2');
26:
27: --
28: -- Update the metadata map for this instance
29: --