PACKAGE: APPS.PA_ADW_CREATE_VIEWS

Source

1 PACKAGE PA_ADW_CREATE_VIEWS AUTHID CURRENT_USER AS
2 /* $Header: PAADWVWS.pls 115.0 99/07/16 13:22:38 porting ship $ */
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    -- PL/SQL array and its index for storing View Definition
26 
27    view_act_cmt			 dbms_sql.varchar2s;
28    view_ref_act_cmt		 dbms_sql.varchar2s;
29    view_ref_ser_type_act_cmt	 dbms_sql.varchar2s;
30    view_budget_lines		 dbms_sql.varchar2s;
31    view_ref_budget_lines	 dbms_sql.varchar2s;
32 
33    view_idx_act_cmt		 BINARY_INTEGER;
34    view_idx_ref_act_cmt		 BINARY_INTEGER;
35    view_idx_ref_ser_type_act_cmt BINARY_INTEGER;
36    view_idx_budget_lines	 BINARY_INTEGER;
37    view_idx_ref_budget_lines	 BINARY_INTEGER;
38 
39    -- Values for unused dimensions
40    -- These values will replace actual values, for unused dimensions
41 
42    disabled_dim_value_number 	 NUMBER := -1;
43    disabled_dim_value_char   	 VARCHAR2(20) := '''Unknown''';
44 
45    FUNCTION Initialize RETURN NUMBER;
46 
47    PROCEDURE get_dimension_status
48                          (x_err_stage            IN OUT VARCHAR2,
49                           x_err_stack            IN OUT VARCHAR2,
50                           x_err_code             IN OUT NUMBER);
51 
52    PROCEDURE generate_collection_views
53                          (x_err_stage            IN OUT VARCHAR2,
54                           x_err_stack            IN OUT VARCHAR2,
55                           x_err_code             IN OUT NUMBER);
56 
57    PROCEDURE create_collection_views
58                          (x_err_stage            IN OUT VARCHAR2,
59                           x_err_stack            IN OUT VARCHAR2,
60                           x_err_code             IN OUT NUMBER);
61 
62    PROCEDURE output_collection_views
63                          (x_err_stage            IN OUT VARCHAR2,
64                           x_err_stack            IN OUT VARCHAR2,
65                           x_err_code             IN OUT NUMBER);
66 
67 END PA_ADW_CREATE_VIEWS;