1 package body ZPB_DATA_LOAD AS
2 /* $Header: zpbdataload.plb 120.0.12010.2 2005/12/23 07:19:04 appldev noship $ */
3
4 PROCEDURE RUN_DATA_LOAD(p_task_id IN NUMBER,
5 p_dataAW in Varchar2,
6 p_codeAW in Varchar2,
7 p_annotAW in Varchar2)
8 IS
9 l_query_list VARCHAR2(3950);
10 l_instanceID VARCHAR2(30);
11
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);
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 --
30 -- select to_char(analysis_cycle_id)
31 -- into l_instanceID
32 -- from zpb_analysis_cycle_tasks
33 -- where task_id = p_task_id;
34
35 -- zpb_metadata_map_pkg.build_instance (p_dataAW, l_instanceID, 'SHARED');
36
37 commit;
38 return;
39
40 END RUN_DATA_LOAD;
41
42 END ZPB_DATA_LOAD;