APPS.PO_PRICE_ADJUSTMENTS_PKG dependencies on QP_PREQ_PUB

Line 1604: AND QLINE.pricing_status_code IN (QP_PREQ_PUB.G_STATUS_UPDATED);

1600: WHERE QLINE.line_id = p_order_line_id_tbl(j)
1601: AND QLINE.line_type_code = 'LINE'
1602: AND QLINE.price_flag IN ('Y')
1603: AND QLINE.process_status <> 'NOT_VALID'
1604: AND QLINE.pricing_status_code IN (QP_PREQ_PUB.G_STATUS_UPDATED);
1605: EXCEPTION
1606: WHEN NO_DATA_FOUND THEN
1607: l_line_id := NULL;
1608: l_price_flag := NULL;

Line 2173: WHERE QPLAT.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW

2169: , QPLAT.attribute
2170: , QPLAT.setup_value_from
2171: , QPLAT.setup_value_to
2172: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
2173: WHERE QPLAT.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2174: AND QPLAT.line_detail_index = l_line_detail_index_tbl(i)
2175: );
2176:
2177: l_progress := '380';

Line 2227: WHERE QPLAT.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW

2223: 'QP_ATTR_DEFNS_PRICING')
2224: , PO_PRICE_ADJ_ATTRIBS_S.nextval
2225: , 1
2226: FROM QP_PREQ_LINE_ATTRS_TMP QPLAT
2227: WHERE QPLAT.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2228: AND QPLAT.LINE_DETAIL_INDEX = l_line_detail_index_tbl(i)
2229: AND ( QPLAT.context
2230: , QPLAT.attribute
2231: , QPLAT.setup_value_from

Line 2313: AND QPLAT.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW

2309: , QP_LDETS_v LDETS
2310: , PO_PRICE_ADJUSTMENTS_DRAFT ADJ
2311: , QP_PREQ_LINES_TMP QPLINE
2312: WHERE ADJ.po_header_id = p_order_header_id
2313: AND QPLAT.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2314: AND QPLAT.line_detail_index = LDETS.line_detail_index
2315: AND QPLAT.line_index = LDETS.line_index
2316: AND LDETS.list_line_id = ADJ.list_line_id
2317: AND LDETS.process_code = QP_PREQ_PUB.G_STATUS_NEW

Line 2317: AND LDETS.process_code = QP_PREQ_PUB.G_STATUS_NEW

2313: AND QPLAT.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2314: AND QPLAT.line_detail_index = LDETS.line_detail_index
2315: AND QPLAT.line_index = LDETS.line_index
2316: AND LDETS.list_line_id = ADJ.list_line_id
2317: AND LDETS.process_code = QP_PREQ_PUB.G_STATUS_NEW
2318: AND LDETS.line_index = QPLINE.line_index
2319: AND QPLINE.line_id = ADJ.po_line_id
2320: AND QPLINE.line_type_code = 'LINE'
2321: AND QPLINE.pricing_status_code IN (QP_PREQ_PUB.G_STATUS_UPDATED)

Line 2321: AND QPLINE.pricing_status_code IN (QP_PREQ_PUB.G_STATUS_UPDATED)

2317: AND LDETS.process_code = QP_PREQ_PUB.G_STATUS_NEW
2318: AND LDETS.line_index = QPLINE.line_index
2319: AND QPLINE.line_id = ADJ.po_line_id
2320: AND QPLINE.line_type_code = 'LINE'
2321: AND QPLINE.pricing_status_code IN (QP_PREQ_PUB.G_STATUS_UPDATED)
2322: AND QPLINE.process_status <> 'NOT_VALID'
2323: );
2324: l_progress := '460';
2325: IF g_debug_stmt THEN