APPS.PO_PRICE_ADJUSTMENTS_PKG dependencies on PO_PRICE_ADJ_ATTRIBS_DRAFT

Line 1675: DELETE FROM PO_PRICE_ADJ_ATTRIBS_DRAFT WHERE draft_id = p_draft_id AND price_adjustment_id = l_adj_id_tbl(i);

1671: END IF;
1672: /*
1673: IF l_adj_id_tbl.count > 0 THEN
1674: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
1675: DELETE FROM PO_PRICE_ADJ_ATTRIBS_DRAFT WHERE draft_id = p_draft_id AND price_adjustment_id = l_adj_id_tbl(i);
1676: l_progress := '100';
1677: IF g_debug_stmt THEN
1678: PO_DEBUG.debug_stmt(p_log_head,l_progress,'DELETED '|| SQL%ROWCOUNT ||' ATTRIBS');
1679: END IF;

Line 2161: DELETE FROM PO_PRICE_ADJ_ATTRIBS_DRAFT WHERE draft_id = p_draft_id AND price_adjustment_id = l_adj_id_tbl(i)

2157: FETCH refresh_attribs_cur BULK COLLECT INTO l_adj_id_tbl, l_line_detail_index_tbl;
2158:
2159: IF l_adj_id_tbl.count > 0 THEN
2160: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
2161: DELETE FROM PO_PRICE_ADJ_ATTRIBS_DRAFT WHERE draft_id = p_draft_id AND price_adjustment_id = l_adj_id_tbl(i)
2162: AND ( pricing_context
2163: , pricing_attribute
2164: , pricing_attr_value_from
2165: , pricing_attr_value_to

Line 2183: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT

2179: PO_DEBUG.debug_stmt(p_log_head,l_progress,'DELETED '|| SQL%ROWCOUNT ||' ATTRIBUTES');
2180: END IF;
2181:
2182: FORALL i IN l_adj_id_tbl.FIRST..l_adj_id_tbl.LAST
2183: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT
2184: (DRAFT_ID
2185: , PRICE_ADJUSTMENT_ID
2186: , PRICING_CONTEXT
2187: , PRICING_ATTRIBUTE

Line 2239: FROM PO_PRICE_ADJ_ATTRIBS_DRAFT

2235: (SELECT pricing_context
2236: , pricing_attribute
2237: , pricing_attr_value_from
2238: , pricing_attr_value_to
2239: FROM PO_PRICE_ADJ_ATTRIBS_DRAFT
2240: WHERE PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i))
2241: );
2242:
2243: l_progress := '390';

Line 2266: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT

2262: PO_DEBUG.debug_var(p_log_head,l_progress,'p_draft_id',p_draft_id);
2263: PO_DEBUG.debug_var(p_log_head,l_progress,'p_order_header_id',p_order_header_id);
2264: END IF;
2265:
2266: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT
2267: (DRAFT_ID
2268: , PRICE_ADJUSTMENT_ID
2269: , PRICING_CONTEXT
2270: , PRICING_ATTRIBUTE

Line 2375: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT

2371: PO_LOG.stmt(d_mod, d_position, 'Populate PO_PRICE_ADJ_ATTRIBS table with pricing attribute details');
2372: END IF;
2373:
2374: FORALL i IN l_price_adjustment_id_tbl.FIRST .. l_price_adjustment_id_tbl.LAST
2375: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT
2376: (DRAFT_ID
2377: , PRICE_ADJUSTMENT_ID
2378: , PRICING_CONTEXT
2379: , PRICING_ATTRIBUTE

Line 2435: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT

2431: PO_LOG.stmt(d_mod, d_position, 'Populate PO_PRICE_ADJ_ATTRIBS table with qualifier attribute details');
2432: END IF;
2433:
2434: FORALL i IN l_price_adjustment_id_tbl.FIRST .. l_price_adjustment_id_tbl.LAST
2435: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT
2436: (DRAFT_ID
2437: , PRICE_ADJUSTMENT_ID
2438: , PRICING_CONTEXT
2439: , PRICING_ATTRIBUTE

Line 3122: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT

3118: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Insert attributes corresponding to the adjustment');
3119: END IF;
3120:
3121: --copy attribute lines for the adjustment
3122: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT
3123: (DRAFT_ID
3124: , PRICE_ADJUSTMENT_ID
3125: , PRICING_CONTEXT
3126: , PRICING_ATTRIBUTE

Line 3796: DELETE FROM PO_PRICE_ADJ_ATTRIBS_DRAFT ATTR

3792: IS
3793: BEGIN
3794: --Delete dependant fields first
3795: --Delete Price Adjustment Attributes
3796: DELETE FROM PO_PRICE_ADJ_ATTRIBS_DRAFT ATTR
3797: WHERE ATTR.draft_id = p_draft_id
3798: AND ATTR.price_adjustment_id IN (SELECT p_price_adjustment_id FROM DUAL
3799: UNION
3800: SELECT ASOC.rltd_price_adj_id