[Home] [Help]
67: --the new control rec columns introduced on lines_tmp for java engine
68:
69: IF p_header_rec.header_id.COUNT > 0 THEN
70: forall i in p_header_rec.header_id.FIRST..p_header_rec.header_id.LAST
71: insert into qp_int_lines
72: (
73: LINE_INDEX,
74: LINE_TYPE_CODE,
75: PRICING_EFFECTIVE_DATE,
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 ;
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:
267: end loop;
268:
269:
270: forall i in p_line_rec.line_id.FIRST..p_line_rec.line_id.LAST
271: insert into qp_int_lines
272: (
273: LINE_INDEX,
274: LINE_TYPE_CODE,
275: PRICING_EFFECTIVE_DATE,
337: NULL,--CATCHWT_QTY
338:
339: NULL,--ACTUAL_ORDER_QTY
340: 'X' );
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;
526: NULL,
527: adj_iface.ADJUSTED_AMOUNT_PER_PQTY
528: From oe_price_adjs_iface_all adj_iface,
529: oe_lines_iface_all lines_iface,
530: qp_int_lines line,
531: qp_list_lines ll,
532: qp_list_headers_b lhdr
533: Where adj_iface.ORDER_SOURCE_ID = lines_iface.ORDER_SOURCE_ID
534: and adj_iface.ORIG_SYS_DOCUMENT_REF = lines_iface.ORIG_SYS_DOCUMENT_REF
625: NULL,
626: adj_iface.ADJUSTED_AMOUNT_PER_PQTY
627: From oe_price_adjs_iface_all adj_iface,
628: oe_headers_iface_all hdrs_iface,
629: qp_int_lines line,
630: qp_list_lines ll,
631: qp_list_headers_b lhdr
632: Where adj_iface.ORDER_SOURCE_ID = hdrs_iface.ORDER_SOURCE_ID
633: and adj_iface.ORIG_SYS_DOCUMENT_REF = hdrs_iface.ORIG_SYS_DOCUMENT_REF
646: --added for java engine stats accumulation on li's request
647: select count(*) into ldet_count
648: From oe_price_adjs_iface_all adj_iface,
649: oe_lines_iface_all lines_iface,
650: qp_int_lines line,
651: qp_list_lines ll,
652: qp_list_headers_b lhdr
653: Where adj_iface.ORIG_SYS_LINE_REF = lines_iface.ORIG_SYS_LINE_REF
654: and lines_iface.line_id = line.line_id