[Home] [Help]
PACKAGE: APPS.QPR_LOAD_MEAS_DATA
Source
1 PACKAGE QPR_LOAD_MEAS_DATA AS
2 /* $Header: QPRUFMDS.pls 120.5 2008/03/31 11:03:32 kdhabali ship $ */
3 type num_type is table of number index by binary_integer;
4 type char240_type is table of varchar2(240) index by binary_integer;
5 type char2000_type is table of varchar2(2000) index by binary_integer;
6 type real_type is table of number(32,10) index by binary_integer;
7 type date_type is table of date index by binary_integer;
8
9 g_origin number;
10
11 type QPR_MEAS_DATA_TYPE is record(
12 ORD_LEVEL_VALUE char240_type,
13 ADJ_LEVEL_VALUE char240_type,
14 TIME_LEVEL_VALUE date_type,
15 CUS_LEVEL_VALUE char240_type,
16 GEO_LEVEL_VALUE char240_type,
17 PRD_LEVEL_VALUE char240_type,
18 REP_LEVEL_VALUE char240_type,
19 CHN_LEVEL_VALUE char240_type,
20 ORG_LEVEL_VALUE char240_type,
21 USR1_LEVEL_VALUE char240_type,
22 USR2_LEVEL_VALUE char240_type,
23 USR3_LEVEL_VALUE char240_type,
24 USR4_LEVEL_VALUE char240_type,
25 USR5_LEVEL_VALUE char240_type,
26 MEASURE1_NUMBER num_type,
27 MEASURE2_NUMBER real_type,
28 MEASURE3_NUMBER real_type,
29 MEASURE4_NUMBER real_type,
30 MEASURE5_NUMBER real_type,
31 MEASURE6_NUMBER real_type,
32 MEASURE7_NUMBER real_type,
33 MEASURE8_NUMBER real_type,
34 MEASURE9_NUMBER real_type,
35 MEASURE10_NUMBER real_type,
36 MEASURE11_NUMBER real_type,
37 MEASURE12_NUMBER real_type,
38 MEASURE13_NUMBER real_type,
39 MEASURE14_NUMBER real_type,
40 MEASURE15_NUMBER real_type,
41 MEASURE16_NUMBER real_type,
42 MEASURE17_NUMBER real_type,
43 MEASURE18_NUMBER real_type,
44 MEASURE19_NUMBER real_type,
45 MEASURE20_NUMBER real_type,
46 MEASURE21_NUMBER real_type,
47 MEASURE22_NUMBER real_type,
48 MEASURE23_NUMBER real_type,
49 MEASURE24_NUMBER real_type,
50 MEASURE25_NUMBER real_type,
51 MEASURE26_NUMBER real_type,
52 MEASURE27_NUMBER real_type,
53 MEASURE28_NUMBER real_type,
54 MEASURE29_NUMBER real_type,
55 MEASURE30_NUMBER real_type,
56 MEASURE1_CHAR char240_type,
57 MEASURE2_CHAR char240_type,
58 MEASURE3_CHAR char240_type,
59 MEASURE4_CHAR char240_type,
60 MEASURE5_CHAR char240_type,
61 MEASURE6_CHAR char240_type,
62 MEASURE7_CHAR char240_type,
63 MEASURE8_CHAR char240_type,
64 MEASURE9_CHAR char240_type,
65 MEASURE10_CHAR char240_type,
66 MEASURE_UOM char240_type);
67
68 type QPR_MEAS_DATA_TYPE1 is record(
69 MEASURE_VALUE_ID num_type,
70 MEASURE1_NUMBER num_type,
71 MEASURE2_NUMBER real_type,
72 MEASURE3_NUMBER real_type,
73 MEASURE4_NUMBER real_type,
74 MEASURE5_NUMBER real_type,
75 MEASURE6_NUMBER real_type,
76 MEASURE7_NUMBER real_type,
77 MEASURE8_NUMBER real_type,
78 MEASURE9_NUMBER real_type,
79 MEASURE10_NUMBER real_type,
80 MEASURE11_NUMBER real_type,
81 MEASURE12_NUMBER real_type,
82 MEASURE13_NUMBER real_type,
83 MEASURE14_NUMBER real_type,
84 MEASURE15_NUMBER real_type,
85 MEASURE16_NUMBER real_type,
86 MEASURE17_NUMBER real_type,
87 MEASURE18_NUMBER real_type,
88 MEASURE19_NUMBER real_type,
89 MEASURE20_NUMBER real_type,
90 MEASURE21_NUMBER real_type,
91 MEASURE22_NUMBER real_type,
92 MEASURE23_NUMBER real_type,
93 MEASURE24_NUMBER real_type,
94 MEASURE25_NUMBER real_type,
95 MEASURE26_NUMBER real_type,
96 MEASURE27_NUMBER real_type,
97 MEASURE28_NUMBER real_type,
98 MEASURE29_NUMBER real_type,
99 MEASURE30_NUMBER real_type,
100 MEASURE1_CHAR char240_type,
101 MEASURE2_CHAR char240_type,
102 MEASURE3_CHAR char240_type,
103 MEASURE4_CHAR char240_type,
104 MEASURE5_CHAR char240_type,
105 MEASURE6_CHAR char240_type,
106 MEASURE7_CHAR char240_type,
107 MEASURE8_CHAR char240_type,
108 MEASURE9_CHAR char240_type,
109 MEASURE10_CHAR char240_type,
110 MEASURE_UOM char240_type);
111
112 type QPR_DIM_DATA_TYPE is record(
113 ORD_LEVEL_VALUE char240_type,
114 TIME_LEVEL_VALUE date_type,
115 CUS_LEVEL_VALUE char240_type,
116 GEO_LEVEL_VALUE char240_type,
117 ORG_LEVEL_VALUE char240_type,
118 REP_LEVEL_VALUE char240_type,
119 CHN_LEVEL_VALUE char240_type,
120 PRD_LEVEL_VALUE char240_type,
121 ADJ_LEVEL_VALUE char240_type,
122 USR1_LEVEL_VALUE char240_type,
123 USR2_LEVEL_VALUE char240_type,
124 USR3_LEVEL_VALUE char240_type,
125 USR4_LEVEL_VALUE char240_type,
126 USR5_LEVEL_VALUE char240_type,
127 MEASURE_VALUE_ID num_type);
128
129 procedure fill_measure_data(errbuf out nocopy varchar2,
130 retcode out nocopy varchar2,
131 p_instance_id in number,
132 p_date_from in varchar2,
133 p_date_to in varchar2,
134 p_meas_type in varchar2,
135 p_header_id in number default 0);
136 type QPR_DEAL_LINE_TYPE is record(
137 PN_REQ_INTERFACE_LINE_ID num_type,
138 SOURCE_REF_HDR_ID num_type,
139 SOURCE_REF_LINE_ID num_type,
140 SOURCE_REQ_LINE_NO char240_type,
141 SOURCE_ID num_type,
142 ORG_ID num_type,
143 ORG_SHORT_DESC char240_type,
144 ORG_LONG_DESC char240_type,
145 INVENTORY_ITEM_ID num_type,
146 INVENTORY_ITEM_SHORT_DESC char240_type,
147 INVENTORY_ITEM_LONG_DESC char240_type,
148 GEOGRAPHY_ID num_type,
149 GEOGRAPHY_SHORT_DESC char240_type,
150 GEOGRAPHY_LONG_DESC char240_type,
151 ITEM_TYPE_CODE char240_type,
152 TOP_MDL_SRC_LINE_ID num_type,
153 PAYMENT_TERM_ID num_type,
154 PAYMENT_TERM_SHORT_DESC char240_type,
155 PAYMENT_TERM_LONG_DESC char240_type,
156 UOM_CODE char240_type,
157 UOM_SHORT_DESC char240_type,
158 CURRENCY_CODE char240_type,
159 CURRENCY_SHORT_DESC char240_type,
160 ORDERED_QTY num_type,
161 LIST_PRICE num_type,
162 PROPOSED_PRICE num_type,
163 REVISED_OQ num_type,
164 COMPETITOR_NAME char240_type,
165 COMPETITOR_PRICE num_type,
166 COMMENTS char2000_type,
167 ADDITIONAL_INFO char2000_type,
168 SHIP_METHOD_CODE char240_type,
169 SHIP_METHOD_SHORT_DESC char240_type,
170 SHIP_METHOD_LONG_DESC char240_type,
171 FREIGHT_CHARGES num_type,
172 MEASURE1_NUMBER num_type,
173 MEASURE2_NUMBER num_type,
174 MEASURE3_NUMBER num_type,
175 MEASURE4_NUMBER num_type,
176 MEASURE5_NUMBER num_type,
177 MEASURE6_NUMBER num_type,
178 MEASURE7_NUMBER num_type,
179 MEASURE8_NUMBER num_type,
180 MEASURE9_NUMBER num_type,
181 MEASURE10_NUMBER num_type,
182 MEASURE1_CHAR char240_type,
183 MEASURE2_CHAR char240_type,
184 MEASURE3_CHAR char240_type,
185 MEASURE4_CHAR char240_type,
186 MEASURE5_CHAR char240_type,
187 MEASURE6_CHAR char240_type,
188 MEASURE7_CHAR char240_type,
189 MEASURE8_CHAR char240_type,
190 MEASURE9_CHAR char240_type,
191 MEASURE10_CHAR char240_type);
192
193 type QPR_DEAL_ADJ_TYPE is record(
194 SRC_REF_HDR_ID num_type,
195 SRC_REF_LINE_ID num_type,
196 SOURCE_ID num_type,
197 EROSION_TYPE char240_type,
198 EROSION_NAME char240_type,
199 EROSION_DESC char240_type,
200 EROSION_PER_UNIT num_type,
201 EROSION_AMOUNT num_type);
202
203 procedure load_quote_data(errbuf out nocopy varchar2,
204 retcode out nocopy varchar2,
205 p_instance_id in number,
206 p_src_choice in number default 1,
207 p_quote_number in number default 0,
208 p_quote_version in number default 0,
209 p_order_type in varchar2 default null);
210
211 procedure load_quote_data_api(errbuf out nocopy varchar2,
212 retcode out nocopy varchar2,
213 p_instance_id in number,
214 p_src_choice in number default 1,
215 p_quote_header_id in number default null,
216 p_quote_number in number default 0,
217 p_quote_version in number default 0,
218 p_order_type in varchar2 default null);
219
220 function is_source_quote_changed(errbuf out nocopy varchar2,
221 retcode out nocopy varchar2,
222 p_instance_id in number,
223 p_source_id in number,
224 p_src_quote_header_id in number)
225 return varchar2;
226 END;
227