APPS.QP_CLEANUP_ADJUSTMENTS_PVT dependencies on OE_PRICE_ADJUSTMENTS_S

Line 16: --sequence OE_PRICE_ADJUSTMENTS_S

12:
13: l_debug VARCHAR2(3);
14: --to populate the price_adjustment_id for modifiers applied by the
15: --pricing engine. The price_adjustment_id is queried from the
16: --sequence OE_PRICE_ADJUSTMENTS_S
17: PROCEDURE Populate_Price_Adj_ID(x_return_status OUT NOCOPY VARCHAR2,
18: x_return_status_text OUT NOCOPY VARCHAR2) IS
19:
20: BEGIN

Line 28: OE_PRICE_ADJUSTMENTS_S.NEXTVAL

24: QP_PREQ_GRP.ENGINE_DEBUG('Populate_Price_Adj_ID: Java Engine not Installed ----------');
25: END IF;
26: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
27: Update qp_npreq_ldets_tmp set price_adjustment_id =
28: OE_PRICE_ADJUSTMENTS_S.NEXTVAL
29: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
30: and process_code = QP_PREQ_PUB.G_STATUS_NEW
31: and (automatic_flag = QP_PREQ_PUB.G_YES
32: or created_from_list_line_type = QP_PREQ_PUB.G_FREIGHT_CHARGE)

Line 42: OE_PRICE_ADJUSTMENTS_S.NEXTVAL

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
46: or automatic_flag = QP_PREQ_PUB.G_YES)

Line 54: OE_PRICE_ADJUSTMENTS_S.NEXTVAL

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)
58: -- or created_from_list_line_type = QP_PREQ_PUB.G_FREIGHT_CHARGE)