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 653: , qp_int_ldets adj

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

Line 1397: UPDATE qp_int_ldets

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