1 PACKAGE ddr_webservices_pub AS
2 /* $Header: ddrpcwss.pls 120.0 2008/02/16 02:47:07 vbhave noship $ */
3
4 -- Start of comments
5 -- API name : get_dsr_fact_aggr
6 -- Type: Public
7 -- Pre-reqs: None.
8 -- Function: to get aggregate data from DSR facts
9 -- Parameters:
10 -- IN :
11 -- p_api_version IN NUMBER Required
12 -- p_mfg_org_cd IN VARCHAR2 Required
13 -- Manufaturer organization code
14 -- p_org_dim_lvl_cd IN VARCHAR2
15 -- Identifies the organization hierarchy level code
16 -- p_org_lvl_val IN VARCHAR2
17 -- Organization hierarchy level code value
18 -- p_exp_org_level IN VARCHAR2
19 -- expected aggregation level of organization hierarchy
20 -- p_loc_dim_lvl_cd IN VARCHAR2
21 -- Identifies the location hierarchy level code
22 -- p_loc_lvl_val IN VARCHAR2
23 -- Location hierarchy level code
24 -- p_exp_loc_level IN VARCHAR2
25 -- Expected aggregation level of location hierarchy
26 -- p_item_dim_lvl_cd IN VARCHAR2
27 -- p_item_lvl_val IN VARCHAR2
28 -- p_exp_item_level IN VARCHAR2
29 -- p_time_dim_lvl_cd IN VARCHAR2
30 -- p_time_lvl_val IN VARCHAR2
31 -- p_exp_time_level IN VARCHAR2
32 -- p_fact_code IN VARCHAR2
33 -- p_attribute1 IN VARCHAR2
34 -- p_attribute2 IN VARCHAR2
35 -- p_attribute3 IN VARCHAR2
36 -- p_attribute4 IN VARCHAR2
37 -- p_attribute5 IN VARCHAR2
38 -- Version: Current version1.0
39 -- Initial version 1.0
40 -- End of comments
41
42 PROCEDURE ddr_fact_aggr_prc(p_api_version IN NUMBER,
43 p_job_id IN NUMBER,
44 p_mfg_org_cd IN VARCHAR2,
45 p_org_cd IN VARCHAR2,
46 p_org_dim_lvl_cd IN VARCHAR2,
47 p_org_lvl_val IN VARCHAR2,
48 p_exp_org_level IN VARCHAR2,
49 p_loc_dim_lvl_cd IN VARCHAR2,
50 p_loc_lvl_val IN VARCHAR2,
51 p_exp_loc_level IN VARCHAR2,
52 p_item_dim_lvl_cd IN VARCHAR2,
53 p_item_lvl_val IN VARCHAR2,
54 p_exp_item_level IN VARCHAR2,
55 p_time_dim_lvl_cd IN VARCHAR2,
56 p_time_lvl_val IN VARCHAR2,
57 p_exp_time_level IN VARCHAR2,
58 p_fact_code IN VARCHAR2,
59 p_attribute1 IN VARCHAR2,
60 p_attribute2 IN VARCHAR2,
61 p_attribute3 IN VARCHAR2,
62 p_attribute4 IN VARCHAR2,
63 p_attribute5 IN VARCHAR2);
64
65 -- Start of comments
66 -- API name : get_dsr_fact_details
67 -- Type: Public
68 -- Pre-reqs: None.
69 -- Function: to get detailed data from DSR facts
70 -- Parameters:
71 -- IN :
72 -- p_api_version IN NUMBERRequired
73 -- p_mfg_org_cd IN VARCHAR2Required
74 -- Manufaturer organization code
75 -- p_org_dim_lvl_cd IN VARCHAR2
76 -- Identifies the organization hierarchy level code
77 -- p_org_cd IN VARCHAR2
78 -- Organization hierarchy level code value
79 -- p_loc_dim_lvl_cd IN VARCHAR2
80 -- Identifies the location hierarchy level code
81 -- p_loc_cd IN VARCHAR2
82 -- Location hierarchy level code
83 -- p_item_dim_lvl_cd IN VARCHAR2
84 -- p_item_cd IN VARCHAR2
85 -- p_time_dim_lvl_cd IN VARCHAR2
86 -- p_time_cd IN VARCHAR2
87 -- p_fact_code IN VARCHAR2
88 -- p_attribute1 IN VARCHAR2
89 -- p_attribute2 IN VARCHAR2
90 -- p_attribute3 IN VARCHAR2
91 -- p_attribute4 IN VARCHAR2
92 -- p_attribute5 IN VARCHAR2
93 -- Version: Current version1.0
94 -- Initial version 1.0
95 -- End of comments
96
97 PROCEDURE ddr_fact_details_prc(p_api_version IN NUMBER,
98 p_job_id IN NUMBER,
99 p_mfg_org_cd IN VARCHAR2,
100 p_org_cd IN VARCHAR2,
101 p_org_dim_lvl_cd IN VARCHAR2,
102 p_org_lvl_val IN VARCHAR2,
103 p_loc_dim_lvl_cd IN VARCHAR2,
104 p_loc_lvl_val IN VARCHAR2,
105 p_item_dim_lvl_cd IN VARCHAR2,
106 p_item_lvl_val IN VARCHAR2,
107 p_time_dim_lvl_cd IN VARCHAR2,
108 p_time_lvl_val IN VARCHAR2,
109 p_fact_code IN VARCHAR2,
110 p_attribute1 IN VARCHAR2,
111 p_attribute2 IN VARCHAR2,
112 p_attribute3 IN VARCHAR2,
113 p_attribute4 IN VARCHAR2,
114 p_attribute5 IN VARCHAR2);
115
116 -- Start of comments
117 -- API name : get_sys_var_val
118 -- Type: Private
119 -- Pre-reqs: None.
120 -- Function: to wget the variable from system variable table
121 -- Parameters:
122 -- IN :
123 -- p_sys_var
124 -- system variable name
125 -- OUT :
126 -- x_sys_var_val
127 -- system variable value
128 -- Version: Current version1.0
129 -- Initial version 1.0
130 -- End of comments
131 PROCEDURE get_sys_var_val(p_sys_var IN VARCHAR2,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 x_sys_var_val OUT NOCOPY VARCHAR2);
136
137 END;