1 PACKAGE PA_ADW_COLLECT_MAIN AUTHID CURRENT_USER AS
2 /* $Header: PAADWCMS.pls 115.2 99/07/16 13:22:06 porting shi $ */
3
4 -- Standard who
5 x_last_updated_by NUMBER(15) := FND_GLOBAL.USER_ID;
6 x_last_update_date NUMBER(15) := FND_GLOBAL.USER_ID;
7 x_created_by NUMBER(15) := FND_GLOBAL.USER_ID;
8 x_last_update_login NUMBER(15) := FND_GLOBAL.LOGIN_ID;
9 x_request_id NUMBER(15) := FND_GLOBAL.CONC_REQUEST_ID;
10 x_program_application_id NUMBER(15) := FND_GLOBAL.PROG_APPL_ID;
11 x_program_id NUMBER(15) := FND_GLOBAL.CONC_PROGRAM_ID;
12
13 -- Variable to store the dimension statuses
14
15 dim_project VARCHAR2(1);
16 dim_resource VARCHAR2(1);
17 dim_project_org VARCHAR2(1);
18 dim_exp_org VARCHAR2(1);
19 dim_srvc_type VARCHAR2(1);
20 dim_time VARCHAR2(1);
21 dim_bgt_type VARCHAR2(1);
22 dim_exp_type VARCHAR2(1);
23 dim_operating_unit VARCHAR2(1);
24
25 -- profile option for collecting top level tasks
26
27 collect_top_tasks_flag VARCHAR2(1);
28 collect_lowest_tasks_flag VARCHAR2(1);
29 license_status VARCHAR2(1);
30 install_status VARCHAR2(1);
31
32 FUNCTION Initialize RETURN NUMBER;
33
34 PROCEDURE prepare_src_table_for_refresh
35 ( x_err_stage IN OUT VARCHAR2,
36 x_err_stack IN OUT VARCHAR2,
37 x_err_code IN OUT NUMBER);
38
39 PROCEDURE purge_interface_tables
40 ( x_err_stage IN OUT VARCHAR2,
41 x_err_stack IN OUT VARCHAR2,
42 x_err_code IN OUT NUMBER);
43
44 PROCEDURE purge_interface_tables_OADW
45 ( x_err_stage IN OUT VARCHAR2,
46 x_err_stack IN OUT VARCHAR2,
47 x_err_code IN OUT NUMBER);
48
49 PROCEDURE purge_it_OADW
50 ( x_table_name IN VARCHAR2,
51 x_wh_update_date IN DATE);
52
53 PROCEDURE clear_interface_tables
54 ( x_err_stage IN OUT VARCHAR2,
55 x_err_stack IN OUT VARCHAR2,
56 x_err_code IN OUT NUMBER);
57
58 PROCEDURE get_dimension_status
59 ( x_err_stage IN OUT VARCHAR2,
60 x_err_stack IN OUT VARCHAR2,
61 x_err_code IN OUT NUMBER);
62
63 PROCEDURE get_dim_and_fact_main
64 ( x_collect_dim_tables IN VARCHAR2,
65 x_dimension_table IN VARCHAR2,
66 x_collect_fact_tables IN VARCHAR2,
67 x_fact_table IN VARCHAR2,
68 x_project_num_from IN VARCHAR2,
69 x_project_num_to IN VARCHAR2,
70 x_err_stage IN OUT VARCHAR2,
71 x_err_stack IN OUT VARCHAR2,
72 x_err_code IN OUT NUMBER);
73
74 PROCEDURE ref_dim_and_fact_main
75 (x_err_stage IN OUT VARCHAR2,
76 x_err_stack IN OUT VARCHAR2,
77 x_err_code IN OUT NUMBER);
78
79 END PA_ADW_COLLECT_MAIN;