1 PACKAGE PA_ADW_COLLECT_DIMENSIONS AUTHID CURRENT_USER AS
2 /* $Header: PAADWCDS.pls 115.0 99/07/16 13:21:41 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
14 FUNCTION Initialize RETURN NUMBER;
15
16 PROCEDURE get_dim_status
17 ( x_dimension_code IN VARCHAR2,
18 x_dimension_status IN OUT VARCHAR2,
19 x_err_stage IN OUT VARCHAR2,
20 x_err_stack IN OUT VARCHAR2,
21 x_err_code IN OUT NUMBER);
22
23 PROCEDURE get_dim_tasks
24 ( x_err_stage IN OUT VARCHAR2,
25 x_err_stack IN OUT VARCHAR2,
26 x_err_code IN OUT NUMBER);
27
28 PROCEDURE get_dim_projects
29 ( x_err_stage IN OUT VARCHAR2,
30 x_err_stack IN OUT VARCHAR2,
31 x_err_code IN OUT NUMBER);
32
33 PROCEDURE get_dim_project_types
34 ( x_err_stage IN OUT VARCHAR2,
35 x_err_stack IN OUT VARCHAR2,
36 x_err_code IN OUT NUMBER);
37
38 PROCEDURE get_dim_expenditure_types
39 ( x_err_stage IN OUT VARCHAR2,
40 x_err_stack IN OUT VARCHAR2,
41 x_err_code IN OUT NUMBER);
42
43 PROCEDURE get_dim_project_classes
44 ( x_err_stage IN OUT VARCHAR2,
45 x_err_stack IN OUT VARCHAR2,
46 x_err_code IN OUT NUMBER);
47
48 PROCEDURE get_dim_class_categories
49 ( x_err_stage IN OUT VARCHAR2,
50 x_err_stack IN OUT VARCHAR2,
51 x_err_code IN OUT NUMBER);
52
53 PROCEDURE get_dim_class_codes
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_dim_resources
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_resource_lists
64 ( x_err_stage IN OUT VARCHAR2,
65 x_err_stack IN OUT VARCHAR2,
66 x_err_code IN OUT NUMBER);
67
68 PROCEDURE get_dim_budget_types
69 ( x_err_stage IN OUT VARCHAR2,
70 x_err_stack IN OUT VARCHAR2,
71 x_err_code IN OUT NUMBER);
72
73 PROCEDURE get_dim_periods
74 ( x_err_stage IN OUT VARCHAR2,
75 x_err_stack IN OUT VARCHAR2,
76 x_err_code IN OUT NUMBER);
77
78 PROCEDURE get_dim_service_types
79 ( x_err_stage IN OUT VARCHAR2,
80 x_err_stack IN OUT VARCHAR2,
81 x_err_code IN OUT NUMBER);
82
83 PROCEDURE get_dim_organizations
84 ( x_err_stage IN OUT VARCHAR2,
85 x_err_stack IN OUT VARCHAR2,
86 x_err_code IN OUT NUMBER);
87
88 END PA_ADW_COLLECT_DIMENSIONS;