APPS.PO_PRICE_ADJ_DRAFT_PKG dependencies on PO_PRICE_ADJ_ATTRIBS_DRAFT

Line 48: DELETE FROM po_price_adj_attribs_draft

44: IF (PO_LOG.d_proc) THEN
45: PO_LOG.proc_begin(d_module);
46: END IF;
47:
48: DELETE FROM po_price_adj_attribs_draft
49: WHERE draft_id = p_draft_id
50: AND price_adjustment_id = NVL(p_price_adjustment_id, price_adjustment_id);
51:
52: DELETE FROM po_price_adjustments_draft

Line 373: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT

369: END IF;
370:
371: --No Need to update the price adjustment attributes if already found in draft table
372: FORALL i IN 1..p_price_adjustment_id_tbl.COUNT
373: INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT
374: (DRAFT_ID
375: , PRICE_ADJUSTMENT_ID
376: , PRICING_CONTEXT
377: , PRICING_ATTRIBUTE

Line 1106: FROM po_price_adj_attribs_draft ATTR

1102: , ATTR.comparison_operator
1103: , ATTR.flex_title
1104: , ATTR.price_adj_attrib_id
1105: , 1
1106: FROM po_price_adj_attribs_draft ATTR
1107: ,po_price_adjustments_draft ADJD
1108: WHERE ADJD.draft_id = p_draft_id
1109: AND ADJD.draft_id = ATTR.draft_id
1110: AND ADJD.price_adjustment_id = ATTR.price_adjustment_id