[Home] [Help]
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
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
409: , ATTR.comparison_operator
410: , ATTR.flex_title
411: , ATTR.price_adj_attrib_id
412: , 1
413: FROM PO_PRICE_ADJ_ATTRIBS ATTR
414: WHERE ATTR.price_adjustment_id = p_price_adjustment_id_tbl(i)
415: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
416: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
417:
658: DELETE FROM po_price_adjustments ADJ
659: WHERE ADJ.parent_adjustment_id = l_price_adjustment_id_tbl(i);
660:
661: --Delete the attributes corresponding to the lines that are marked for deletion
662: DELETE FROM po_price_adj_attribs ATTR
663: WHERE ATTR.price_adjustment_id IN
664: (SELECT ADJD.price_adjustment_id
665: FROM po_price_adjustments_draft ADJD
666: WHERE ADJD.draft_id = p_draft_id
1064: , 1
1065: )
1066: WHERE NVL(ADJD.delete_flag, 'N') <> 'Y';
1067:
1068: INSERT INTO po_price_adj_attribs
1069: (PRICE_ADJUSTMENT_ID
1070: , PRICING_CONTEXT
1071: , PRICING_ATTRIBUTE
1072: , CREATION_DATE
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