1 PACKAGE QP_COPY_DEBUG_PVT AUTHID CURRENT_USER AS
2 /* $Header: QPXVCDBS.pls 120.0 2005/06/02 01:15:56 appldev noship $ */
3
4 TYPE CONTROL_REC_TYPE IS RECORD
5 (
6 REQUEST_ID NUMBER,
7 REQUEST_NAME VARCHAR2(240),
8 ORDER_NUMBER VARCHAR2(50), -- sfiresto 2374448
9 CREATED_BY NUMBER,
10 CREATION_DATE DATE,
11 CURRENCY_CODE VARCHAR2(30),
12 PRICING_EVENT VARCHAR2(30),
13 CALCULATE_FLAG VARCHAR2(30),
14 SIMULATION_FLAG VARCHAR2(1),
15 ROUNDING_FLAG VARCHAR2(1),
16 GSA_CHECK_FLAG VARCHAR2(1),
17 GSA_DUP_CHECK_FLAG VARCHAR2(1),
18 TEMP_TABLE_INSERT_FLAG VARCHAR2(1),
19 MANUAL_DISCOUNT_FLAG VARCHAR2(1),
20 DEBUG_FLAG VARCHAR2(1),
21 SOURCE_ORDER_AMOUNT_FLAG VARCHAR2(1),
22 PUBLIC_API_CALL_FLAG VARCHAR2(1),
23 MANUAL_ADJUSTMENTS_CALL_FLAG VARCHAR2(1),
24 REQUEST_TYPE_CODE VARCHAR2(30),
25 VIEW_CODE VARCHAR2(50),
26 CHECK_CUST_VIEW_FLAG VARCHAR2(1),
27 USE_MULTI_CURRENCY VARCHAR2(1) default 'N',
28 USER_CONVERSION_RATE NUMBER default NULL,
29 USER_CONVERSION_TYPE VARCHAR2(30) default NULL,
30 FUNCTION_CURRENCY VARCHAR2(30) default NULL
31 );
32
33
34 -- Table Type Declarations for Lines
35
36 TYPE REQUEST_ID_Tbl IS TABLE OF QP_DEBUG_REQ.REQUEST_ID%TYPE
37 INDEX BY BINARY_INTEGER;
38 REQUEST_ID_T REQUEST_ID_Tbl;
39 TYPE REQUEST_TYPE_CODE_Tbl IS TABLE OF qp_npreq_lines_tmp.REQUEST_TYPE_CODE%TYPE
40 INDEX BY BINARY_INTEGER;
41 REQUEST_TYPE_CODE_T REQUEST_TYPE_CODE_Tbl;
42 TYPE LINE_NUMBER_Tbl IS TABLE OF QP_DEBUG_REQ_LINES.LINE_NUMBER%TYPE -- sfiresto 2374448
43 INDEX BY BINARY_INTEGER; -- sfiresto 2374448
44 LINE_NUMBER_T LINE_NUMBER_Tbl; -- sfiresto 2374448
45 TYPE LINE_ID_Tbl IS TABLE OF qp_npreq_lines_tmp.LINE_ID%TYPE
46 INDEX BY BINARY_INTEGER;
47 LINE_ID_T LINE_ID_Tbl;
48 TYPE LINE_INDEX_Tbl IS TABLE OF qp_npreq_lines_tmp.LINE_INDEX%TYPE
49 INDEX BY BINARY_INTEGER;
50 LINE_INDEX_T LINE_INDEX_Tbl;
51 TYPE LINE_TYPE_CODE_Tbl IS TABLE OF qp_npreq_lines_tmp.LINE_TYPE_CODE%TYPE
52 INDEX BY BINARY_INTEGER;
53 LINE_TYPE_CODE_T LINE_TYPE_CODE_Tbl;
54 TYPE PRICING_EFFECTIVE_DATE_Tbl IS TABLE OF qp_npreq_lines_tmp.PRICING_EFFECTIVE_DATE%TYPE
55 INDEX BY BINARY_INTEGER;
56 PRICING_EFFECTIVE_DATE_T PRICING_EFFECTIVE_DATE_Tbl;
57 TYPE LINE_QUANTITY_Tbl IS TABLE OF qp_npreq_lines_tmp.LINE_QUANTITY%TYPE
58 INDEX BY BINARY_INTEGER;
59 LINE_QUANTITY_T LINE_QUANTITY_Tbl;
60 TYPE LINE_UOM_CODE_Tbl IS TABLE OF qp_npreq_lines_tmp.LINE_UOM_CODE%TYPE
61 INDEX BY BINARY_INTEGER;
62 LINE_UOM_CODE_T LINE_UOM_CODE_Tbl;
63 TYPE PRICED_QUANTITY_Tbl IS TABLE OF qp_npreq_lines_tmp.PRICED_QUANTITY%TYPE
64 INDEX BY BINARY_INTEGER;
65 PRICED_QUANTITY_T PRICED_QUANTITY_Tbl;
66 TYPE PRICED_UOM_CODE_Tbl IS TABLE OF qp_npreq_lines_tmp.PRICED_UOM_CODE%TYPE
67 INDEX BY BINARY_INTEGER;
68 PRICED_UOM_CODE_T PRICED_UOM_CODE_Tbl;
69 TYPE UOM_QUANTITY_Tbl IS TABLE OF qp_npreq_lines_tmp.UOM_QUANTITY%TYPE
70 INDEX BY BINARY_INTEGER;
71 UOM_QUANTITY_T UOM_QUANTITY_Tbl;
72 TYPE CURRENCY_CODE_Tbl IS TABLE OF qp_npreq_lines_tmp.CURRENCY_CODE%TYPE
73 INDEX BY BINARY_INTEGER;
74 CURRENCY_CODE_T CURRENCY_CODE_Tbl;
75 TYPE UNIT_PRICE_Tbl IS TABLE OF qp_npreq_lines_tmp.UNIT_PRICE%TYPE
76 INDEX BY BINARY_INTEGER;
77 UNIT_PRICE_T UNIT_PRICE_Tbl;
78 TYPE PERCENT_PRICE_Tbl IS TABLE OF qp_npreq_lines_tmp.PERCENT_PRICE%TYPE
79 INDEX BY BINARY_INTEGER;
80 PERCENT_PRICE_T PERCENT_PRICE_Tbl;
81 TYPE ADJUSTED_UNIT_PRICE_Tbl IS TABLE OF qp_npreq_lines_tmp.ADJUSTED_UNIT_PRICE%TYPE
82 INDEX BY BINARY_INTEGER;
83 ADJUSTED_UNIT_PRICE_T ADJUSTED_UNIT_PRICE_Tbl;
84 TYPE PARENT_PRICE_Tbl IS TABLE OF qp_npreq_lines_tmp.PARENT_PRICE%TYPE
85 INDEX BY BINARY_INTEGER;
86 PARENT_PRICE_T PARENT_PRICE_Tbl;
87 TYPE PARENT_QUANTITY_Tbl IS TABLE OF qp_npreq_lines_tmp.PARENT_QUANTITY%TYPE
88 INDEX BY BINARY_INTEGER;
89 PARENT_QUANTITY_T PARENT_QUANTITY_Tbl;
90 TYPE PARENT_UOM_CODE_Tbl IS TABLE OF qp_npreq_lines_tmp.PARENT_UOM_CODE%TYPE
91 INDEX BY BINARY_INTEGER;
92 PARENT_UOM_CODE_T PARENT_UOM_CODE_Tbl;
93 TYPE PROCESSING_ORDER_Tbl IS TABLE OF qp_npreq_lines_tmp.PROCESSING_ORDER%TYPE
94 INDEX BY BINARY_INTEGER;
95 PROCESSING_ORDER_T PROCESSING_ORDER_Tbl;
96 TYPE PROCESSED_FLAG_Tbl IS TABLE OF qp_npreq_lines_tmp.PROCESSED_FLAG%TYPE
97 INDEX BY BINARY_INTEGER;
98 PROCESSED_FLAG_T PROCESSED_FLAG_Tbl;
99 TYPE PROCESSED_CODE_Tbl IS TABLE OF qp_npreq_lines_tmp.PROCESSED_CODE%TYPE
100 INDEX BY BINARY_INTEGER;
101 PROCESSED_CODE_T PROCESSED_CODE_Tbl;
102 TYPE PRICE_FLAG_Tbl IS TABLE OF qp_npreq_lines_tmp.PRICE_FLAG%TYPE
103 INDEX BY BINARY_INTEGER;
104 PRICE_FLAG_T PRICE_FLAG_Tbl;
105 TYPE PRICING_STATUS_CODE_Tbl IS TABLE OF qp_npreq_lines_tmp.PRICING_STATUS_CODE%TYPE
106 INDEX BY BINARY_INTEGER;
107 PRICING_STATUS_CODE_T PRICING_STATUS_CODE_Tbl;
108 TYPE PRICING_STATUS_TEXT_Tbl IS TABLE OF qp_npreq_lines_tmp.PRICING_STATUS_TEXT%TYPE
109 INDEX BY BINARY_INTEGER;
110 PRICING_STATUS_TEXT_T PRICING_STATUS_TEXT_Tbl;
111 TYPE START_DATE_ACTIVE_FIRST_Tbl IS TABLE OF qp_npreq_lines_tmp.START_DATE_ACTIVE_FIRST%TYPE
112 INDEX BY BINARY_INTEGER;
113 START_DATE_ACTIVE_FIRST_T START_DATE_ACTIVE_FIRST_Tbl;
114 TYPE ACTIVE_DATE_FIRST_TYPE_Tbl IS TABLE OF qp_npreq_lines_tmp.ACTIVE_DATE_FIRST_TYPE%TYPE
115 INDEX BY BINARY_INTEGER;
116 ACTIVE_DATE_FIRST_TYPE_T ACTIVE_DATE_FIRST_TYPE_Tbl;
117 TYPE START_DATE_ACTIVE_SECOND_Tbl IS TABLE OF qp_npreq_lines_tmp.START_DATE_ACTIVE_SECOND%TYPE
118 INDEX BY BINARY_INTEGER;
119 START_DATE_ACTIVE_SECOND_T START_DATE_ACTIVE_SECOND_Tbl;
120 TYPE ACTIVE_DATE_SECOND_TYPE_Tbl IS TABLE OF qp_npreq_lines_tmp.ACTIVE_DATE_SECOND_TYPE%TYPE
121 INDEX BY BINARY_INTEGER;
122 ACTIVE_DATE_SECOND_TYPE_T ACTIVE_DATE_SECOND_TYPE_Tbl;
123 TYPE GROUP_QUANTITY_Tbl IS TABLE OF qp_npreq_lines_tmp.GROUP_QUANTITY%TYPE
124 INDEX BY BINARY_INTEGER;
125 GROUP_QUANTITY_T GROUP_QUANTITY_Tbl;
126 TYPE GROUP_AMOUNT_Tbl IS TABLE OF qp_npreq_lines_tmp.GROUP_AMOUNT%TYPE
127 INDEX BY BINARY_INTEGER;
128 GROUP_AMOUNT_T GROUP_AMOUNT_Tbl;
129 TYPE LINE_AMOUNT_Tbl IS TABLE OF qp_npreq_lines_tmp.LINE_AMOUNT%TYPE
130 INDEX BY BINARY_INTEGER;
131 LINE_AMOUNT_T LINE_AMOUNT_Tbl;
132 TYPE ROUNDING_FLAG_Tbl IS TABLE OF qp_npreq_lines_tmp.ROUNDING_FLAG%TYPE
133 INDEX BY BINARY_INTEGER;
134 ROUNDING_FLAG_T ROUNDING_FLAG_Tbl;
135 TYPE ROUNDING_FACTOR_Tbl IS TABLE OF qp_npreq_lines_tmp.ROUNDING_FACTOR%TYPE
136 INDEX BY BINARY_INTEGER;
137 ROUNDING_FACTOR_T ROUNDING_FACTOR_Tbl;
138 TYPE UPDATED_ADJ_UNIT_PRICE_Tbl IS TABLE OF qp_npreq_lines_tmp.UPDATED_ADJUSTED_UNIT_PRICE%TYPE
139 INDEX BY BINARY_INTEGER;
140 UPDATED_ADJUSTED_UNIT_PRICE_T UPDATED_ADJ_UNIT_PRICE_Tbl;
141 TYPE PRICE_REQUEST_CODE_Tbl IS TABLE OF qp_npreq_lines_tmp.PRICE_REQUEST_CODE%TYPE
142 INDEX BY BINARY_INTEGER;
143 PRICE_REQUEST_CODE_T PRICE_REQUEST_CODE_Tbl;
144 TYPE HOLD_CODE_Tbl IS TABLE OF qp_npreq_lines_tmp.HOLD_CODE%TYPE
145 INDEX BY BINARY_INTEGER;
146 HOLD_CODE_T HOLD_CODE_Tbl;
147 TYPE HOLD_TEXT_Tbl IS TABLE OF qp_npreq_lines_tmp.HOLD_TEXT%TYPE
148 INDEX BY BINARY_INTEGER;
149 HOLD_TEXT_T HOLD_TEXT_Tbl;
150 TYPE PRICE_LIST_HEADER_ID_Tbl IS TABLE OF qp_npreq_lines_tmp.PRICE_LIST_HEADER_ID%TYPE
151 INDEX BY BINARY_INTEGER;
152 PRICE_LIST_HEADER_ID_T PRICE_LIST_HEADER_ID_Tbl;
153 TYPE VALIDATED_FLAG_Tbl IS TABLE OF qp_npreq_lines_tmp.VALIDATED_FLAG%TYPE
154 INDEX BY BINARY_INTEGER;
155 VALIDATED_FLAG_T VALIDATED_FLAG_Tbl;
156 TYPE QUALIFIERS_EXIST_FLAG_Tbl IS TABLE OF qp_npreq_lines_tmp.QUALIFIERS_EXIST_FLAG%TYPE
157 INDEX BY BINARY_INTEGER;
158 QUALIFIERS_EXIST_FLAG_T QUALIFIERS_EXIST_FLAG_Tbl;
159 TYPE PRICING_ATTRS_EXIST_FLAG_Tbl IS TABLE OF qp_npreq_lines_tmp.PRICING_ATTRS_EXIST_FLAG%TYPE
160 INDEX BY BINARY_INTEGER;
161 PRICING_ATTRS_EXIST_FLAG_T PRICING_ATTRS_EXIST_FLAG_Tbl;
162 TYPE PRIMARY_QUAL_MATCH_FLAG_Tbl IS TABLE OF qp_npreq_lines_tmp.PRIMARY_QUALIFIERS_MATCH_FLAG%TYPE
163 INDEX BY BINARY_INTEGER;
164 PRIMARY_QUAL_MATCH_FLAG_T PRIMARY_QUAL_MATCH_FLAG_Tbl;
165 TYPE USAGE_PRICING_TYPE_Tbl IS TABLE OF qp_npreq_lines_tmp.USAGE_PRICING_TYPE%TYPE
166 INDEX BY BINARY_INTEGER;
167 USAGE_PRICING_TYPE_T USAGE_PRICING_TYPE_Tbl;
168 TYPE LINE_CATEGORY_Tbl IS TABLE OF qp_npreq_lines_tmp.LINE_CATEGORY%TYPE
169 INDEX BY BINARY_INTEGER;
170 LINE_CATEGORY_T LINE_CATEGORY_Tbl;
171 TYPE CONTRACT_START_DATE_Tbl IS TABLE OF qp_npreq_lines_tmp.LINE_CATEGORY%TYPE
172 INDEX BY BINARY_INTEGER;
173 CONTRACT_START_DATE_T CONTRACT_START_DATE_Tbl;
174 TYPE CONTRACT_END_DATE_Tbl IS TABLE OF qp_npreq_lines_tmp.CONTRACT_END_DATE%TYPE
175 INDEX BY BINARY_INTEGER;
176 CONTRACT_END_DATE_T CONTRACT_END_DATE_Tbl;
177
178
179 -- Table Type Declarations for LDets
180
181 TYPE LINE_DETAIL_INDEX_Tbl IS TABLE OF qp_npreq_ldets_tmp.LINE_DETAIL_INDEX%TYPE
182 INDEX BY BINARY_INTEGER;
183 LINE_DETAIL_INDEX_T LINE_DETAIL_INDEX_Tbl;
184 TYPE LINE_DETAIL_TYPE_CODE_Tbl IS TABLE OF qp_npreq_ldets_tmp.LINE_DETAIL_TYPE_CODE%TYPE
185 INDEX BY BINARY_INTEGER;
186 LINE_DETAIL_TYPE_CODE_T LINE_DETAIL_TYPE_CODE_Tbl;
187 TYPE PRICE_BREAK_TYPE_CODE_Tbl IS TABLE OF qp_npreq_ldets_tmp.PRICE_BREAK_TYPE_CODE%TYPE
188 INDEX BY BINARY_INTEGER;
189 PRICE_BREAK_TYPE_CODE_T PRICE_BREAK_TYPE_CODE_Tbl;
190 TYPE LIST_HEADER_ID_Tbl IS TABLE OF qp_npreq_ldets_tmp.CREATED_FROM_LIST_HEADER_ID%TYPE
191 INDEX BY BINARY_INTEGER;
192 LIST_HEADER_ID_T LIST_HEADER_ID_Tbl;
193 TYPE LIST_LINE_ID_Tbl IS TABLE OF qp_npreq_ldets_tmp.CREATED_FROM_LIST_LINE_ID%TYPE
194 INDEX BY BINARY_INTEGER;
195 LIST_LINE_ID_T LIST_LINE_ID_Tbl;
196 TYPE LIST_LINE_TYPE_Tbl IS TABLE OF qp_npreq_ldets_tmp.CREATED_FROM_LIST_LINE_TYPE%TYPE
197 INDEX BY BINARY_INTEGER;
198 LIST_LINE_TYPE_T LIST_LINE_TYPE_Tbl;
199 TYPE LIST_TYPE_CODE_Tbl IS TABLE OF qp_npreq_ldets_tmp.CREATED_FROM_LIST_TYPE_CODE%TYPE
200 INDEX BY BINARY_INTEGER;
201 LIST_TYPE_CODE_T LIST_TYPE_CODE_Tbl;
202 TYPE MODIFIER_LEVEL_CODE_Tbl IS TABLE OF qp_npreq_ldets_tmp.MODIFIER_LEVEL_CODE%TYPE
203 INDEX BY BINARY_INTEGER;
204 MODIFIER_LEVEL_CODE_T MODIFIER_LEVEL_CODE_Tbl;
205 TYPE CREATED_FROM_SQL_Tbl IS TABLE OF qp_npreq_ldets_tmp.CREATED_FROM_SQL%TYPE
206 INDEX BY BINARY_INTEGER;
207 CREATED_FROM_SQL_T CREATED_FROM_SQL_Tbl;
208 TYPE PRICING_GROUP_SEQUENCE_Tbl IS TABLE OF qp_npreq_ldets_tmp.PRICING_GROUP_SEQUENCE%TYPE
209 INDEX BY BINARY_INTEGER;
210 PRICING_GROUP_SEQUENCE_T PRICING_GROUP_SEQUENCE_Tbl;
211 TYPE OPERAND_CALCULATION_CODE_Tbl IS TABLE OF qp_npreq_ldets_tmp.OPERAND_CALCULATION_CODE%TYPE
212 INDEX BY BINARY_INTEGER;
213 OPERAND_CALCULATION_CODE_T OPERAND_CALCULATION_CODE_Tbl;
214 TYPE OPERAND_VALUE_Tbl IS TABLE OF qp_npreq_ldets_tmp.OPERAND_VALUE%TYPE
215 INDEX BY BINARY_INTEGER;
216 OPERAND_VALUE_T OPERAND_VALUE_Tbl;
217 TYPE ADJUSTMENT_AMOUNT_Tbl IS TABLE OF qp_npreq_ldets_tmp.ADJUSTMENT_AMOUNT%TYPE
218 INDEX BY BINARY_INTEGER;
219 ADJUSTMENT_AMOUNT_T ADJUSTMENT_AMOUNT_Tbl;
220 TYPE SUBSTITUTION_TYPE_CODE_Tbl IS TABLE OF qp_npreq_ldets_tmp.SUBSTITUTION_TYPE_CODE%TYPE
221 INDEX BY BINARY_INTEGER;
222 SUBSTITUTION_TYPE_CODE_T SUBSTITUTION_TYPE_CODE_Tbl;
223 TYPE SUBSTITUTION_VALUE_FROM_Tbl IS TABLE OF qp_npreq_ldets_tmp.SUBSTITUTION_VALUE_FROM%TYPE
224 INDEX BY BINARY_INTEGER;
225 SUBSTITUTION_VALUE_FROM_T SUBSTITUTION_VALUE_FROM_Tbl;
226 TYPE SUBSTITUTION_VALUE_TO_Tbl IS TABLE OF qp_npreq_ldets_tmp.SUBSTITUTION_VALUE_TO%TYPE
227 INDEX BY BINARY_INTEGER;
228 SUBSTITUTION_VALUE_TO_T SUBSTITUTION_VALUE_TO_Tbl;
232 TYPE PRICE_FORMULA_ID_Tbl IS TABLE OF qp_npreq_ldets_tmp.PRICE_FORMULA_ID%TYPE
229 TYPE ASK_FOR_FLAG_Tbl IS TABLE OF qp_npreq_ldets_tmp.ASK_FOR_FLAG%TYPE
230 INDEX BY BINARY_INTEGER;
231 ASK_FOR_FLAG_T ASK_FOR_FLAG_Tbl;
233 INDEX BY BINARY_INTEGER;
234 PRICE_FORMULA_ID_T PRICE_FORMULA_ID_Tbl;
235 TYPE PRODUCT_PRECEDENCE_Tbl IS TABLE OF qp_npreq_ldets_tmp.PRODUCT_PRECEDENCE%TYPE
236 INDEX BY BINARY_INTEGER;
237 PRODUCT_PRECEDENCE_T PRODUCT_PRECEDENCE_Tbl;
238 TYPE INCOMPATABILITY_GRP_CODE_Tbl IS TABLE OF qp_npreq_ldets_tmp.INCOMPATABILITY_GRP_CODE%TYPE
239 INDEX BY BINARY_INTEGER;
240 INCOMPATABILITY_GRP_CODE_T INCOMPATABILITY_GRP_CODE_Tbl;
241 TYPE BEST_PERCENT_Tbl IS TABLE OF qp_npreq_ldets_tmp.BEST_PERCENT%TYPE
242 INDEX BY BINARY_INTEGER;
243 BEST_PERCENT_T BEST_PERCENT_Tbl;
244 TYPE PRICING_PHASE_ID_Tbl IS TABLE OF qp_npreq_ldets_tmp.PRICING_PHASE_ID%TYPE
245 INDEX BY BINARY_INTEGER;
246 PRICING_PHASE_ID_T PRICING_PHASE_ID_Tbl;
247 TYPE APPLIED_FLAG_Tbl IS TABLE OF qp_npreq_ldets_tmp.APPLIED_FLAG%TYPE
248 INDEX BY BINARY_INTEGER;
249 APPLIED_FLAG_T APPLIED_FLAG_Tbl;
250 TYPE AUTOMATIC_FLAG_Tbl IS TABLE OF qp_npreq_ldets_tmp.AUTOMATIC_FLAG%TYPE
251 INDEX BY BINARY_INTEGER;
252 AUTOMATIC_FLAG_T AUTOMATIC_FLAG_Tbl;
253 TYPE OVERRIDE_FLAG_Tbl IS TABLE OF qp_npreq_ldets_tmp.OVERRIDE_FLAG%TYPE
254 INDEX BY BINARY_INTEGER;
255 OVERRIDE_FLAG_T OVERRIDE_FLAG_Tbl;
256 TYPE PRINT_ON_INVOICE_FLAG_Tbl IS TABLE OF qp_npreq_ldets_tmp.PRINT_ON_INVOICE_FLAG%TYPE
257 INDEX BY BINARY_INTEGER;
258 PRINT_ON_INVOICE_FLAG_T PRINT_ON_INVOICE_FLAG_Tbl;
259 TYPE PRIMARY_UOM_FLAG_Tbl IS TABLE OF qp_npreq_ldets_tmp.PRIMARY_UOM_FLAG%TYPE
260 INDEX BY BINARY_INTEGER;
261 PRIMARY_UOM_FLAG_T PRIMARY_UOM_FLAG_Tbl;
262 TYPE BENEFIT_QTY_Tbl IS TABLE OF qp_npreq_ldets_tmp.BENEFIT_QTY%TYPE
263 INDEX BY BINARY_INTEGER;
264 BENEFIT_QTY_T BENEFIT_QTY_Tbl;
265 TYPE BENEFIT_UOM_CODE_Tbl IS TABLE OF qp_npreq_ldets_tmp.BENEFIT_UOM_CODE%TYPE
266 INDEX BY BINARY_INTEGER;
267 BENEFIT_UOM_CODE_T BENEFIT_UOM_CODE_Tbl;
268 TYPE LIST_LINE_NO_Tbl IS TABLE OF qp_npreq_ldets_tmp.LIST_LINE_NO%TYPE
269 INDEX BY BINARY_INTEGER;
270 LIST_LINE_NO_T LIST_LINE_NO_Tbl;
271 TYPE ACCRUAL_FLAG_Tbl IS TABLE OF qp_npreq_ldets_tmp.ACCRUAL_FLAG%TYPE
272 INDEX BY BINARY_INTEGER;
273 ACCRUAL_FLAG_T ACCRUAL_FLAG_Tbl;
274 TYPE ACCRUAL_CONVERSION_RATE_Tbl IS TABLE OF qp_npreq_ldets_tmp.ACCRUAL_CONVERSION_RATE%TYPE
275 INDEX BY BINARY_INTEGER;
276 ACCRUAL_CONVERSION_RATE_T ACCRUAL_CONVERSION_RATE_Tbl;
277 TYPE ESTIM_ACCRUAL_RATE_Tbl IS TABLE OF qp_npreq_ldets_tmp.ESTIM_ACCRUAL_RATE%TYPE
278 INDEX BY BINARY_INTEGER;
279 ESTIM_ACCRUAL_RATE_T ESTIM_ACCRUAL_RATE_Tbl;
280 TYPE RECURRING_FLAG_Tbl IS TABLE OF qp_npreq_ldets_tmp.RECURRING_FLAG%TYPE
281 INDEX BY BINARY_INTEGER;
282 RECURRING_FLAG_T RECURRING_FLAG_Tbl;
283 TYPE SELECTED_VOLUME_ATTR_Tbl IS TABLE OF qp_npreq_ldets_tmp.SELECTED_VOLUME_ATTR%TYPE
284 INDEX BY BINARY_INTEGER;
285 SELECTED_VOLUME_ATTR_T SELECTED_VOLUME_ATTR_Tbl;
286 TYPE SECONDARY_PRICELIST_IND_Tbl IS TABLE OF qp_npreq_ldets_tmp.SECONDARY_PRICELIST_IND%TYPE
287 INDEX BY BINARY_INTEGER;
288 SECONDARY_PRICELIST_IND_T SECONDARY_PRICELIST_IND_Tbl;
289 TYPE PROCESS_CODE_Tbl IS TABLE OF qp_npreq_ldets_tmp.PROCESS_CODE%TYPE
290 INDEX BY BINARY_INTEGER;
291 PROCESS_CODE_T PROCESS_CODE_Tbl;
292 TYPE UPDATED_FLAG_Tbl IS TABLE OF qp_npreq_ldets_tmp.UPDATED_FLAG%TYPE
293 INDEX BY BINARY_INTEGER;
294 UPDATED_FLAG_T UPDATED_FLAG_Tbl;
295 TYPE CHARGE_TYPE_CODE_Tbl IS TABLE OF qp_npreq_ldets_tmp.CHARGE_TYPE_CODE%TYPE
296 INDEX BY BINARY_INTEGER;
297 CHARGE_TYPE_CODE_T CHARGE_TYPE_CODE_Tbl;
298 TYPE CHARGE_SUBTYPE_CODE_Tbl IS TABLE OF qp_npreq_ldets_tmp.CHARGE_SUBTYPE_CODE%TYPE
299 INDEX BY BINARY_INTEGER;
300 CHARGE_SUBTYPE_CODE_T CHARGE_SUBTYPE_CODE_Tbl;
301 TYPE LIMIT_CODE_Tbl IS TABLE OF qp_npreq_ldets_tmp.LIMIT_CODE%TYPE
302 INDEX BY BINARY_INTEGER;
303 LIMIT_CODE_T LIMIT_CODE_Tbl;
304 TYPE LIMIT_TEXT_Tbl IS TABLE OF qp_npreq_ldets_tmp.LIMIT_TEXT%TYPE
305 INDEX BY BINARY_INTEGER;
306 LIMIT_TEXT_T LIMIT_TEXT_Tbl;
307 TYPE HEADER_LIMIT_EXISTS_Tbl IS TABLE OF qp_npreq_ldets_tmp.HEADER_LIMIT_EXISTS%TYPE
308 INDEX BY BINARY_INTEGER;
309 HEADER_LIMIT_EXISTS_T HEADER_LIMIT_EXISTS_Tbl;
310 TYPE LINE_LIMIT_EXISTS_Tbl IS TABLE OF qp_npreq_ldets_tmp.LINE_LIMIT_EXISTS%TYPE
311 INDEX BY BINARY_INTEGER;
312 LINE_LIMIT_EXISTS_T LINE_LIMIT_EXISTS_Tbl;
313 TYPE CALCULATION_CODE_Tbl IS TABLE OF qp_npreq_ldets_tmp.CALCULATION_CODE%TYPE
314 INDEX BY BINARY_INTEGER;
315 CALCULATION_CODE_T CALCULATION_CODE_Tbl;
316 TYPE CURRENCY_HEADER_ID_Tbl IS TABLE OF qp_npreq_ldets_tmp.CURRENCY_HEADER_ID%TYPE
317 INDEX BY BINARY_INTEGER;
318 CURRENCY_HEADER_ID_T CURRENCY_HEADER_ID_Tbl;
319 TYPE BASE_CURRENCY_CODE_Tbl IS TABLE OF qp_npreq_ldets_tmp.BASE_CURRENCY_CODE%TYPE
320 INDEX BY BINARY_INTEGER;
321 BASE_CURRENCY_CODE_T BASE_CURRENCY_CODE_Tbl;
322 TYPE ORDER_CURRENCY_Tbl IS TABLE OF qp_npreq_ldets_tmp.ORDER_CURRENCY%TYPE
323 INDEX BY BINARY_INTEGER;
324 ORDER_CURRENCY_T ORDER_CURRENCY_Tbl;
325 TYPE CURRENCY_DETAIL_ID_Tbl IS TABLE OF qp_npreq_ldets_tmp.CURRENCY_DETAIL_ID%TYPE
326 INDEX BY BINARY_INTEGER;
327 CURRENCY_DETAIL_ID_T CURRENCY_DETAIL_ID_Tbl;
328
329 -- Table Type Declarations for Attrs
330
331 TYPE LINE_ATTRIBUTE_ID_Tbl IS TABLE OF QP_DEBUG_REQ_LINE_ATTRS.LINE_ATTRIBUTE_ID%TYPE
332 INDEX BY BINARY_INTEGER;
333 LINE_ATTRIBUTE_ID_T LINE_ATTRIBUTE_ID_Tbl;
334 TYPE ATTRIBUTE_LEVEL_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.ATTRIBUTE_LEVEL%TYPE
335 INDEX BY BINARY_INTEGER;
336 ATTRIBUTE_LEVEL_T ATTRIBUTE_LEVEL_Tbl;
337 TYPE ATTRIBUTE_TYPE_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.ATTRIBUTE_TYPE%TYPE
338 INDEX BY BINARY_INTEGER;
339 ATTRIBUTE_TYPE_T ATTRIBUTE_TYPE_Tbl;
340 TYPE CONTEXT_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.CONTEXT%TYPE
341 INDEX BY BINARY_INTEGER;
342 CONTEXT_T CONTEXT_Tbl;
343 TYPE ATTRIBUTE_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.ATTRIBUTE%TYPE
344 INDEX BY BINARY_INTEGER;
345 ATTRIBUTE_T ATTRIBUTE_Tbl;
346 TYPE VALUE_FROM_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.VALUE_FROM%TYPE
347 INDEX BY BINARY_INTEGER;
348 VALUE_FROM_T VALUE_FROM_Tbl;
349 TYPE SETUP_VALUE_FROM_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.SETUP_VALUE_FROM%TYPE
350 INDEX BY BINARY_INTEGER;
351 SETUP_VALUE_FROM_T SETUP_VALUE_FROM_Tbl;
352 TYPE VALUE_TO_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.VALUE_TO%TYPE
353 INDEX BY BINARY_INTEGER;
354 VALUE_TO_T VALUE_TO_Tbl;
355 TYPE SETUP_VALUE_TO_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.SETUP_VALUE_TO%TYPE
356 INDEX BY BINARY_INTEGER;
357 SETUP_VALUE_TO_T SETUP_VALUE_TO_Tbl;
358 TYPE GROUPING_NUMBER_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.GROUPING_NUMBER%TYPE
359 INDEX BY BINARY_INTEGER;
360 GROUPING_NUMBER_T GROUPING_NUMBER_Tbl;
361 TYPE NO_QUALIFIERS_IN_GRP_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.NO_QUALIFIERS_IN_GRP%TYPE
362 INDEX BY BINARY_INTEGER;
363 NO_QUALIFIERS_IN_GRP_T NO_QUALIFIERS_IN_GRP_Tbl;
364 TYPE COMP_OPERATOR_TYPE_CODE_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.COMPARISON_OPERATOR_TYPE_CODE%TYPE
365 INDEX BY BINARY_INTEGER;
366 COMP_OPERATOR_TYPE_CODE_T COMP_OPERATOR_TYPE_CODE_Tbl;
367 TYPE QUALIFIER_PRECEDENCE_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.QUALIFIER_PRECEDENCE%TYPE
368 INDEX BY BINARY_INTEGER;
369 QUALIFIER_PRECEDENCE_T QUALIFIER_PRECEDENCE_Tbl;
370 TYPE PRICING_ATTR_FLAG_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.PRICING_ATTR_FLAG%TYPE
371 INDEX BY BINARY_INTEGER;
372 PRICING_ATTR_FLAG_T PRICING_ATTR_FLAG_Tbl;
373 TYPE QUALIFIER_TYPE_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.QUALIFIER_TYPE%TYPE
374 INDEX BY BINARY_INTEGER;
375 QUALIFIER_TYPE_T QUALIFIER_TYPE_Tbl;
376 TYPE DATATYPE_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.DATATYPE%TYPE
377 INDEX BY BINARY_INTEGER;
378 DATATYPE_T DATATYPE_Tbl;
379 TYPE ATTR_PROCESSED_CODE_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.PROCESSED_CODE%TYPE
380 INDEX BY BINARY_INTEGER;
381 ATTR_PROCESSED_CODE_T ATTR_PROCESSED_CODE_Tbl;
382 TYPE PRODUCT_UOM_CODE_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.PRODUCT_UOM_CODE%TYPE
383 INDEX BY BINARY_INTEGER;
384 PRODUCT_UOM_CODE_T PRODUCT_UOM_CODE_Tbl;
385 TYPE EXCLUDER_FLAG_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.EXCLUDER_FLAG%TYPE
386 INDEX BY BINARY_INTEGER;
387 EXCLUDER_FLAG_T EXCLUDER_FLAG_Tbl;
388 TYPE DISTINCT_QUALIFIER_FLAG_Tbl IS TABLE OF qp_npreq_line_attrs_tmp.DISTINCT_QUALIFIER_FLAG%TYPE
389 INDEX BY BINARY_INTEGER;
390 DISTINCT_QUALIFIER_FLAG_T DISTINCT_QUALIFIER_FLAG_Tbl;
391
392
393 -- Table Type Declarations for RLTD Lines
394
395 TYPE RELATIONSHIP_TYPE_CODE_Tbl IS TABLE OF qp_npreq_rltd_lines_tmp.RELATIONSHIP_TYPE_CODE%TYPE
396 INDEX BY BINARY_INTEGER;
397 RELATIONSHIP_TYPE_CODE_T RELATIONSHIP_TYPE_CODE_Tbl;
398 TYPE RELATED_LINE_INDEX_Tbl IS TABLE OF qp_npreq_rltd_lines_tmp.RELATED_LINE_INDEX%TYPE
399 INDEX BY BINARY_INTEGER;
400 RELATED_LINE_INDEX_T RELATED_LINE_INDEX_Tbl;
401 TYPE RELATED_LINE_DETAIL_INDEX_Tbl IS TABLE OF qp_npreq_rltd_lines_tmp.RELATED_LINE_DETAIL_INDEX%TYPE
402 INDEX BY BINARY_INTEGER;
403 RELATED_LINE_DETAIL_INDEX_T RELATED_LINE_DETAIL_INDEX_Tbl;
404 TYPE RELATED_LIST_LINE_ID_Tbl IS TABLE OF qp_npreq_rltd_lines_tmp.RELATED_LIST_LINE_ID%TYPE
405 INDEX BY BINARY_INTEGER;
406 RELATED_LIST_LINE_ID_T RELATED_LIST_LINE_ID_Tbl;
407 TYPE OPERAND_Tbl IS TABLE OF qp_npreq_rltd_lines_tmp.OPERAND%TYPE
408 INDEX BY BINARY_INTEGER;
409 OPERAND_T OPERAND_Tbl;
410 TYPE RELATIONSHIP_TYPE_DETAIL_Tbl IS TABLE OF qp_npreq_rltd_lines_tmp.RELATIONSHIP_TYPE_DETAIL%TYPE
411 INDEX BY BINARY_INTEGER;
412 RELATIONSHIP_TYPE_DETAIL_T RELATIONSHIP_TYPE_DETAIL_Tbl;
413 TYPE QUALIFIER_VALUE_Tbl IS TABLE OF qp_npreq_rltd_lines_tmp.QUALIFIER_VALUE%TYPE
414 INDEX BY BINARY_INTEGER;
415 QUALIFIER_VALUE_T QUALIFIER_VALUE_Tbl;
416 TYPE SATISFIED_RANGE_VALUE_Tbl IS TABLE OF qp_npreq_rltd_lines_tmp.SATISFIED_RANGE_VALUE%TYPE
417 INDEX BY BINARY_INTEGER;
418 SATISFIED_RANGE_VALUE_T SATISFIED_RANGE_VALUE_Tbl;
419
420
421 -- Table Type Declarations for Step Values
422
423 TYPE STEP_NUMBER_Tbl IS TABLE OF qp_nformula_step_values_tmp.STEP_NUMBER%TYPE
424 INDEX BY BINARY_INTEGER;
425 STEP_NUMBER_T STEP_NUMBER_Tbl;
426 TYPE COMPONENT_VALUE_Tbl IS TABLE OF qp_nformula_step_values_tmp.COMPONENT_VALUE%TYPE
427 INDEX BY BINARY_INTEGER;
428 COMPONENT_VALUE_T COMPONENT_VALUE_Tbl;
429 TYPE PRICE_FORM_LINE_TYPE_CODE_Tbl IS TABLE OF qp_nformula_step_values_tmp.PRICE_FORMULA_LINE_TYPE_CODE%TYPE
430 INDEX BY BINARY_INTEGER;
431 PRICE_FORM_LINE_TYPE_CODE_T PRICE_FORM_LINE_TYPE_CODE_Tbl;
432
433 FUNCTION REQUEST_ID RETURN NUMBER;
434
435 PROCEDURE SET_REQUEST_TO_NULL;
436
437 PROCEDURE WRITE_TO_DEBUG_TABLES
438 (p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,
439 x_return_status OUT NOCOPY VARCHAR2,
440 x_return_status_text OUT NOCOPY VARCHAR2
441 );
442
443 PROCEDURE INSERT_DEBUG_LINE(p_text IN VARCHAR2);
444
445 PROCEDURE Generate_Debug_Req_Seq(x_return_status out NOCOPY varchar2,
446 x_status_text out NOCOPY varchar2);
447
448 g_control_rec CONTROL_REC_TYPE;
449 G_DEBUG_TEXT_LINE_NO NUMBER;
450 G_DEBUG_REQUEST_ID NUMBER;
451
452 END QP_COPY_DEBUG_PVT;
[Home] [Help]