APPS.PO_DIFF_SUMMARY_PKG dependencies on PO_PRICE_DIFF_DRAFT

Line 812: FROM po_price_diff_draft

808: WHERE draft_id = l_draft_id
809: AND change_accepted_flag IS NULL
810: UNION
811: SELECT entity_id
812: FROM po_price_diff_draft
813: WHERE draft_id = l_draft_id
814: AND entity_type = 'BLANKET LINE'
815: AND change_accepted_flag IS NULL
816: UNION

Line 820: po_price_diff_draft PDD

816: UNION
817: SELECT NVL(LLD.po_line_id, LL.po_line_id)
818: FROM po_line_locations_draft_all LLD,
819: po_line_locations_all LL,
820: po_price_diff_draft PDD
821: WHERE PDD.draft_id = l_draft_id
822: AND entity_type = 'PRICE BREAK'
823: AND PDD.change_accepted_flag IS NULL
824: AND PDD.entity_id = LLD.line_location_id(+)

Line 910: FROM po_price_diff_draft

906: WHERE draft_id = l_draft_id
907: AND change_accepted_flag = 'N')
908: OR EXISTS
909: (SELECT 1
910: FROM po_price_diff_draft
911: WHERE draft_id = l_draft_id
912: AND change_accepted_flag = 'N')
913: OR EXISTS
914: (SELECT 1

Line 1745: UPDATE po_price_diff_draft PPDD

1741:
1742: d_position := 20;
1743:
1744: -- Price Diff Level
1745: UPDATE po_price_diff_draft PPDD
1746: SET PPDD.change_accepted_flag = 'Y'
1747: WHERE PPDD.draft_id = p_draft_id
1748: AND PPDD.change_accepted_flag IS NULL
1749: AND PPDD.delete_flag = 'Y'

Line 1942: UPDATE po_price_diff_draft PPDD

1938:
1939: d_position := 20;
1940:
1941: -- Pirce Differentials Attributes
1942: UPDATE po_price_diff_draft PPDD
1943: SET PPDD.change_accepted_flag = 'Y'
1944: WHERE PPDD.draft_id = p_draft_id
1945: AND PPDD.change_accepted_flag IS NULL
1946: AND NVL(PPDD.delete_flag, 'N') <> 'Y'

Line 3004: FROM po_price_diff_draft

3000: WHERE draft_id = p_draft_id
3001: AND change_accepted_flag IS NULL)
3002: OR EXISTS
3003: ( SELECT 1
3004: FROM po_price_diff_draft
3005: WHERE draft_id = p_draft_id
3006: AND change_accepted_flag IS NULL)
3007: OR EXISTS
3008: ( SELECT 1

Line 3113: UPDATE po_price_diff_draft PPDD

3109: AND PLDA.draft_id = PLVTD.draft_id );
3110:
3111: d_position := 30;
3112:
3113: UPDATE po_price_diff_draft PPDD
3114: SET PPDD.change_accepted_flag = 'Y'
3115: WHERE PPDD.draft_id = p_draft_id
3116: AND NVL(PPDD.change_accepted_flag, 'N') <> 'Y'
3117: AND (( PPDD.entity_type = 'BLANKET LINE'

Line 3240: UPDATE po_price_diff_draft

3236: d_position := 40;
3237:
3238: -- blanket line price differentials
3239: FORALL i IN 1..p_line_id_list.COUNT
3240: UPDATE po_price_diff_draft
3241: SET change_accepted_flag = p_change_accepted_value
3242: WHERE draft_id = p_draft_id
3243: AND entity_id = p_line_id_list(i)
3244: AND entity_type = 'BLANKET LINE';

Line 3251: UPDATE po_price_diff_draft PPDD

3247:
3248: -- Price break price diffs - the po_line_id reference can either
3249: -- be found in draft or transaction table
3250: FORALL i IN 1..p_line_id_list.COUNT
3251: UPDATE po_price_diff_draft PPDD
3252: SET change_accepted_flag = p_change_accepted_value
3253: WHERE draft_id = p_draft_id
3254: AND entity_type = 'PRICE BREAK'
3255: AND EXISTS (SELECT 1