eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.QP_BULK_PREQ_GRP dependencies on QP_PREQ_GRP

Line 23: l_line_line_index QP_PREQ_GRP.number_type;

19:
20: l_qual_ctxts_result_tbl QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE;
21: l_price_ctxts_result_tbl QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE;
22:
23: l_line_line_index QP_PREQ_GRP.number_type;
24: l_hdr_line_index QP_PREQ_GRP.number_type;
25: l_line_count NUMBER;
26: l_preq_count NUMBER;
27: my_usage_type VARCHAR2(30);

Line 24: l_hdr_line_index QP_PREQ_GRP.number_type;

20: l_qual_ctxts_result_tbl QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE;
21: l_price_ctxts_result_tbl QP_ATTR_MAPPING_PUB.CONTEXTS_RESULT_TBL_TYPE;
22:
23: l_line_line_index QP_PREQ_GRP.number_type;
24: l_hdr_line_index QP_PREQ_GRP.number_type;
25: l_line_count NUMBER;
26: l_preq_count NUMBER;
27: my_usage_type VARCHAR2(30);
28: PRAGMA AUTONOMOUS_TRANSACTION;

Line 49: QP_PREQ_GRP.Set_QP_Debug;

45: l_line_count := p_line_rec.line_id.count;
46: G_header_rec := p_header_rec;
47: G_line_rec := p_line_rec;
48: l_line_count := p_line_rec.line_id.count;
49: QP_PREQ_GRP.Set_QP_Debug;
50: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
51: If l_debug = 'T' Then
52: i := p_line_rec.line_id.first;
53: --changes for bug 3395657

Line 50: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

46: G_header_rec := p_header_rec;
47: G_line_rec := p_line_rec;
48: l_line_count := p_line_rec.line_id.count;
49: QP_PREQ_GRP.Set_QP_Debug;
50: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
51: If l_debug = 'T' Then
52: i := p_line_rec.line_id.first;
53: --changes for bug 3395657
54: --changed for to while loop and to loop based on line_index

Line 133: QP_PREQ_GRP.G_REGULAR_USAGE_TYPE,--usage_pricing_type

129: NULL,--rounding_factor is null
130: NULL,--updated_adjusted_unit_price w/b null for OM
131: p_header_rec.PRICE_LIST_ID(i),
132: NULL,--price_request_code not required as limits not supported
133: QP_PREQ_GRP.G_REGULAR_USAGE_TYPE,--usage_pricing_type
134: 'ORDER',--line_category
135: NULL,--CONTRACT_START_DATE
136: NULL,--CONTRACT_END_DATE
137: NULL,--CATCHWEIGHT_QTY

Line 143: QP_PREQ_GRP.G_INT_LINES_NO := QP_PREQ_GRP.G_INT_LINES_NO + l_line_count;

139: 'X',
140: p_header_rec.event_code(i)
141: );
142:
143: QP_PREQ_GRP.G_INT_LINES_NO := QP_PREQ_GRP.G_INT_LINES_NO + l_line_count;
144:
145: If l_debug = 'T' Then
146: select count(*) into l_preq_count
147: from qp_int_lines ;

Line 149: oe_debug_pub.add('QP_PREQ_GRP.G_INT_LINES_NO='||QP_PREQ_GRP.G_INT_LINES_NO);

145: If l_debug = 'T' Then
146: select count(*) into l_preq_count
147: from qp_int_lines ;
148: oe_debug_pub.add('bulk.l_preq_count := ' || l_preq_count);
149: oe_debug_pub.add('QP_PREQ_GRP.G_INT_LINES_NO='||QP_PREQ_GRP.G_INT_LINES_NO);
150: End If;
151:
152: G_line_index.delete;
153:

Line 236: QP_PREQ_GRP.G_INT_ATTRS_NO := QP_PREQ_GRP.G_INT_ATTRS_NO + G_attr_context.count;

232: QP_PREQ_PUB.G_STATUS_UNCHANGED,
233: QP_PREQ_PUB.G_YES
234: );
235:
236: QP_PREQ_GRP.G_INT_ATTRS_NO := QP_PREQ_GRP.G_INT_ATTRS_NO + G_attr_context.count;
237: IF l_debug = 'T' THEN
238: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_ATTRS_NO='||QP_PREQ_GRP.G_INT_ATTRS_NO);
239: END IF;
240: End If;

Line 238: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_ATTRS_NO='||QP_PREQ_GRP.G_INT_ATTRS_NO);

234: );
235:
236: QP_PREQ_GRP.G_INT_ATTRS_NO := QP_PREQ_GRP.G_INT_ATTRS_NO + G_attr_context.count;
237: IF l_debug = 'T' THEN
238: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_ATTRS_NO='||QP_PREQ_GRP.G_INT_ATTRS_NO);
239: END IF;
240: End If;
241: EXCEPTION
242: WHEN OTHERS THEN

Line 265: qp_preq_grp.engine_debug('UK Code '||l_currency_code_tbl(i));

261: END LOOP;
262: END LOOP;
263:
264: for i in l_currency_code_tbl.FIRST..l_currency_code_tbl.LAST LOOP
265: qp_preq_grp.engine_debug('UK Code '||l_currency_code_tbl(i));
266: qp_preq_grp.engine_debug('UK Date '||l_active_date_first_tbl(i));
267: end loop;
268:
269:

Line 266: qp_preq_grp.engine_debug('UK Date '||l_active_date_first_tbl(i));

262: END LOOP;
263:
264: for i in l_currency_code_tbl.FIRST..l_currency_code_tbl.LAST LOOP
265: qp_preq_grp.engine_debug('UK Code '||l_currency_code_tbl(i));
266: qp_preq_grp.engine_debug('UK Date '||l_active_date_first_tbl(i));
267: end loop;
268:
269:
270: forall i in p_line_rec.line_id.FIRST..p_line_rec.line_id.LAST

Line 333: QP_PREQ_GRP.G_REGULAR_USAGE_TYPE,--usage_pricing_type

329: NULL,--rounding_factor is null
330: NULL,--UPDATED_ADJUSTED_UNIT_PRICE is null for OM
331: p_line_rec.PRICE_LIST_ID(i),
332: NULL,--price_req_code is null limits not supported for this phase of HVOP
333: QP_PREQ_GRP.G_REGULAR_USAGE_TYPE,--usage_pricing_type
334: p_line_rec.LINE_CATEGORY_CODE(i),
335: NULL,--CONTRACT_START_DATE
336: NULL,--CONTRACT_END_DATE
337: NULL,--CATCHWT_QTY

Line 345: QP_PREQ_GRP.G_INT_LINES_NO := QP_PREQ_GRP.G_INT_LINES_NO + p_line_rec.LINE_ID.count;

341: /*FROM qp_int_lines line
342: WHERE line.header_id = p_line_rec.HEADER_ID(i)
343: AND ROWNUM = 1; */
344:
345: QP_PREQ_GRP.G_INT_LINES_NO := QP_PREQ_GRP.G_INT_LINES_NO + p_line_rec.LINE_ID.count;
346:
347: if l_debug = 'T' then
348: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_LINES_NO :=' || QP_PREQ_GRP.G_INT_LINES_NO);
349: end if; --debug

Line 348: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_LINES_NO :=' || QP_PREQ_GRP.G_INT_LINES_NO);

344:
345: QP_PREQ_GRP.G_INT_LINES_NO := QP_PREQ_GRP.G_INT_LINES_NO + p_line_rec.LINE_ID.count;
346:
347: if l_debug = 'T' then
348: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_LINES_NO :=' || QP_PREQ_GRP.G_INT_LINES_NO);
349: end if; --debug
350:
351: END IF;--p_line_rec.line_id.COUNT
352:

Line 420: QP_PREQ_GRP.G_INT_ATTRS_NO := QP_PREQ_GRP.G_INT_ATTRS_NO + G_attr_context.count;

416: QP_PREQ_PUB.G_LIST_NOT_APPLIED,
417: QP_PREQ_PUB.G_STATUS_UNCHANGED,
418: QP_PREQ_PUB.G_YES
419: );
420: QP_PREQ_GRP.G_INT_ATTRS_NO := QP_PREQ_GRP.G_INT_ATTRS_NO + G_attr_context.count;
421: IF l_debug = FND_API.G_TRUE THEN
422: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_ATTRS_NO='||QP_PREQ_GRP.G_INT_ATTRS_NO);
423: END IF;
424: end if;--G_line_index.count

Line 422: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_ATTRS_NO='||QP_PREQ_GRP.G_INT_ATTRS_NO);

418: QP_PREQ_PUB.G_YES
419: );
420: QP_PREQ_GRP.G_INT_ATTRS_NO := QP_PREQ_GRP.G_INT_ATTRS_NO + G_attr_context.count;
421: IF l_debug = FND_API.G_TRUE THEN
422: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_ATTRS_NO='||QP_PREQ_GRP.G_INT_ATTRS_NO);
423: END IF;
424: end if;--G_line_index.count
425:
426: If l_debug = 'T' Then

Line 659: QP_PREQ_GRP.G_INT_LDETS_NO := QP_PREQ_GRP.G_INT_LDETS_NO + ldet_count;

655: --and lines_iface.header_id = line.header_id
656: and ll.list_line_id = adj_iface.list_line_id
657: and lhdr.list_header_id = ll.list_header_id;
658:
659: QP_PREQ_GRP.G_INT_LDETS_NO := QP_PREQ_GRP.G_INT_LDETS_NO + ldet_count;
660: IF l_debug = FND_API.G_TRUE THEN
661: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_LDETS_NO='||QP_PREQ_GRP.G_INT_LDETS_NO);
662: END IF;
663:

Line 661: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_LDETS_NO='||QP_PREQ_GRP.G_INT_LDETS_NO);

657: and lhdr.list_header_id = ll.list_header_id;
658:
659: QP_PREQ_GRP.G_INT_LDETS_NO := QP_PREQ_GRP.G_INT_LDETS_NO + ldet_count;
660: IF l_debug = FND_API.G_TRUE THEN
661: oe_debug_pub.add ('QP_PREQ_GRP.G_INT_LDETS_NO='||QP_PREQ_GRP.G_INT_LDETS_NO);
662: END IF;
663:
664: IF l_debug = FND_API.G_TRUE THEN
665: FOR cl in (select line_index, line_detail_index, operand_value, operand_calculation_code, updated_flag, applied_flag