APPS.QP_CLEANUP_ADJUSTMENTS_PVT dependencies on QP_NPREQ_RLTD_LINES_TMP

Line 1611: ,qp_npreq_rltd_lines_tmp ass

1607: attr.list_header_id,
1608: adj.list_line_no
1609: FROM qp_npreq_lines_tmp line
1610: ,qp_npreq_ldets_tmp adj_pbh
1611: ,qp_npreq_rltd_lines_tmp ass
1612: ,qp_npreq_ldets_tmp adj
1613: , qp_pricing_attributes attr
1614: -- WHERE p_request_type_code <> 'ONT'
1615: --bug 3085453 handle pricing availability UI

Line 1868: INSERT INTO qp_npreq_rltd_lines_tmp

1864: IF l_debug = FND_API.G_TRUE THEN
1865: QP_PREQ_GRP.engine_debug('price brk before insert ');
1866: END IF;
1867: FORALL I IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1868: INSERT INTO qp_npreq_rltd_lines_tmp
1869: (
1870: pricing_status_text,
1871: line_index,
1872: line_detail_index,

Line 2815: UPDATE qp_npreq_rltd_lines_tmp rltd

2811: QP_PREQ_GRP.engine_debug('DUPLICATE MANUAL-OVERR '||SQL%ROWCOUNT);
2812: END IF;
2813:
2814: -- bug 3359924 - AFTER APPLYING MANUAL PBH ENGINE RETURNS DUPLICATE RELATIONSHIP RECORDS
2815: UPDATE qp_npreq_rltd_lines_tmp rltd
2816: set rltd.pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED,
2817: rltd.pricing_status_text = 'DUPLICATE MANUAL-OVERRIDEABLE'
2818: where rltd.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2819: and rltd.line_detail_index in (select ldet.line_detail_index

Line 3509: delete from qp_npreq_rltd_lines_tmp

3505: -- THEN
3506: IF l_debug = FND_API.G_TRUE THEN
3507: QP_PREQ_GRP.engine_debug('deleting related lines');
3508: END IF;
3509: delete from qp_npreq_rltd_lines_tmp
3510: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
3511: and relationship_type_code = QP_PREQ_PUB.G_PBH_LINE
3512: and pricing_status_text = G_CALC_INSERT;
3513: IF l_debug = FND_API.G_TRUE THEN