[Home] [Help]
149: **************************************************************************************************/
150: --!!!warning, Insert_Adj look oe_order_pub.g_hdr.header_id will need to change for hvop
151: --OE_ADV_PRICE_PVT.Insert_Adj;
152: --The reason not to call adv_price_pvt.insert_adj is because this will introduce dependency on
153: --qp data model. That is header_id will need to be added to qp_preq_lines_tmp. If we reference
154: --qp_preq_lines_tmp.header_id, in Oe_adj_price_pvt.insert_adj then we will need to include odf that
155: --will have the columns. Due to this reason, I have to copy the code over although it is 99% the same
156: --code.
157:
150: --!!!warning, Insert_Adj look oe_order_pub.g_hdr.header_id will need to change for hvop
151: --OE_ADV_PRICE_PVT.Insert_Adj;
152: --The reason not to call adv_price_pvt.insert_adj is because this will introduce dependency on
153: --qp data model. That is header_id will need to be added to qp_preq_lines_tmp. If we reference
154: --qp_preq_lines_tmp.header_id, in Oe_adj_price_pvt.insert_adj then we will need to include odf that
155: --will have the columns. Due to this reason, I have to copy the code over although it is 99% the same
156: --code.
157:
158:
378: , ldets.adjustment_amount
379: , 1
380: FROM
381: QP_LDETS_v ldets
382: , QP_PREQ_LINES_TMP lines
383: , QP_LIST_HEADERS_B QH
384: WHERE
385: ldets.list_header_id=qh.list_header_id
386: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
552: , decode(lines.parent_price, NULL, 0, 0, 0,
553: lines.adjusted_unit_price/lines.parent_price)
554: UNIT_SELLING_PERCENT
555: , lines.line_index line_index
556: from qp_preq_lines_tmp lines
557: where lines.line_type_code='LINE'
558: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
559: and lines.process_status <> 'NOT_VALID';
560:
853: Cursor list_lines_no is
854: Select c.name,
855: a.list_line_no
856: From qp_preq_ldets_tmp a,
857: qp_preq_lines_tmp b,
858: qp_list_headers_vl c
859: Where b.line_id = p_line_id
860: And b.line_index = a.line_index
861: And a.created_from_list_header_id = c.list_header_id
910: , qp.adjusted_unit_price
911: , qp.priced_quantity
912: , qp.line_quantity
913: , qp.priced_uom_code
914: from qp_preq_lines_tmp qp
915: where process_status <> 'NOT_VALID' and
916: (pricing_status_code not in
917: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
918: QP_PREQ_GRP.G_STATUS_UPDATED,
1270: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1271:
1272: CURSOR gsa_violators IS
1273: SELECT line_id, PRICING_STATUS_TEXT status_text, line_index
1274: FROM QP_PREQ_LINES_TMP
1275: WHERE LINE_TYPE_CODE='LINE'
1276: AND PROCESS_STATUS <> 'NOT_VALID'
1277: AND PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_GSA_VIOLATION;
1278: BEGIN
1396: l_end_time NUMBER;
1397:
1398:
1399: cursor test is
1400: select CURRENCY_CODE,LINE_INDEX,LINE_ID,LINE_TYPE_CODE from qp_preq_lines_tmp;
1401:
1402: --
1403: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1404: --
1444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1445: END IF;
1446:
1447: If l_debug_level > 0 Then
1448: select count(*) into l_count from qp_preq_lines_tmp;
1449: oe_debug_pub.add('l_count : '||l_count);
1450: for i in test loop
1451: oe_debug_pub.add('curr code : '||i.CURRENCY_CODE||' LINE_INDEX : '||i.LINE_INDEX||' LINE_ID : '||i.LINE_ID||' LINE_TYPE_CODE : '||i.LINE_TYPE_CODE);
1452: end loop;