APPS.QP_CLEANUP_ADJUSTMENTS_PVT dependencies on QP_INT_LDETS

Line 41: Update qp_int_ldets set price_adjustment_id =

37: IF l_debug = FND_API.G_TRUE THEN
38: QP_PREQ_GRP.ENGINE_DEBUG('Populate_Price_Adj_ID: Java Engine is Installed ----------');
39: END IF;
40: IF (QP_UTIL_PUB.HVOP_Pricing_ON = 'Y') THEN
41: Update qp_int_ldets set price_adjustment_id =
42: OE_PRICE_ADJUSTMENTS_S.NEXTVAL
43: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
44: and process_code = QP_PREQ_PUB.G_STATUS_NEW
45: and (applied_flag = QP_PREQ_PUB.G_YES

Line 53: Update qp_int_ldets set price_adjustment_id =

49: (QP_PREQ_PUB.G_PRICE_LIST_HEADER, QP_PREQ_PUB.G_AGR_LIST_HEADER);
50:
51: ELSE
52:
53: Update qp_int_ldets set price_adjustment_id =
54: OE_PRICE_ADJUSTMENTS_S.NEXTVAL
55: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
56: and process_code = QP_PREQ_PUB.G_STATUS_NEW
57: and (automatic_flag = QP_PREQ_PUB.G_YES)

Line 649: , qp_int_ldets adj

645: , adj.order_qty_adj_amt adj_ord_qty_adjamt
646: , ldet.order_qty_operand ord_qty_operand
647: , adj.order_qty_operand adj_ord_qty_operand
648: FROM qp_int_lines line
649: , qp_int_ldets adj
650: ,qp_ldets_v ldet
651: , qp_list_lines ql
652: -- WHERE p_request_type_code <> 'ONT'
653: --bug 3085453 handle pricing availability UI

Line 1393: UPDATE qp_int_ldets

1389: IF l_debug = FND_API.G_TRUE THEN
1390: QP_PREQ_GRP.ENGINE_DEBUG('Java Engine is Installed ----------');
1391: END IF;
1392: FORALL x IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1393: UPDATE qp_int_ldets
1394: SET process_code = l_process_code_tbl(x)
1395: , price_adjustment_id = l_price_adj_id_tbl(x)
1396: , pricing_status_text = l_pricing_sts_text_tbl(x)
1397: WHERE line_index = l_line_index_tbl(x)