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 1771: UPDATE po_price_diff_draft PPDD

1767:
1768: d_position := 20;
1769:
1770: -- Price Diff Level
1771: UPDATE po_price_diff_draft PPDD
1772: SET PPDD.change_accepted_flag = 'Y'
1773: WHERE PPDD.draft_id = p_draft_id
1774: AND PPDD.change_accepted_flag IS NULL
1775: AND PPDD.delete_flag = 'Y'

Line 1968: UPDATE po_price_diff_draft PPDD

1964:
1965: d_position := 20;
1966:
1967: -- Pirce Differentials Attributes
1968: UPDATE po_price_diff_draft PPDD
1969: SET PPDD.change_accepted_flag = 'Y'
1970: WHERE PPDD.draft_id = p_draft_id
1971: AND PPDD.change_accepted_flag IS NULL
1972: AND NVL(PPDD.delete_flag, 'N') <> 'Y'

Line 3030: FROM po_price_diff_draft

3026: WHERE draft_id = p_draft_id
3027: AND change_accepted_flag IS NULL)
3028: OR EXISTS
3029: ( SELECT 1
3030: FROM po_price_diff_draft
3031: WHERE draft_id = p_draft_id
3032: AND change_accepted_flag IS NULL)
3033: OR EXISTS
3034: ( SELECT 1

Line 3139: UPDATE po_price_diff_draft PPDD

3135: AND PLDA.draft_id = PLVTD.draft_id );
3136:
3137: d_position := 30;
3138:
3139: UPDATE po_price_diff_draft PPDD
3140: SET PPDD.change_accepted_flag = 'Y'
3141: WHERE PPDD.draft_id = p_draft_id
3142: AND NVL(PPDD.change_accepted_flag, 'N') <> 'Y'
3143: AND (( PPDD.entity_type = 'BLANKET LINE'

Line 3266: UPDATE po_price_diff_draft

3262: d_position := 40;
3263:
3264: -- blanket line price differentials
3265: FORALL i IN 1..p_line_id_list.COUNT
3266: UPDATE po_price_diff_draft
3267: SET change_accepted_flag = p_change_accepted_value
3268: WHERE draft_id = p_draft_id
3269: AND entity_id = p_line_id_list(i)
3270: AND entity_type = 'BLANKET LINE';

Line 3277: UPDATE po_price_diff_draft PPDD

3273:
3274: -- Price break price diffs - the po_line_id reference can either
3275: -- be found in draft or transaction table
3276: FORALL i IN 1..p_line_id_list.COUNT
3277: UPDATE po_price_diff_draft PPDD
3278: SET change_accepted_flag = p_change_accepted_value
3279: WHERE draft_id = p_draft_id
3280: AND entity_type = 'PRICE BREAK'
3281: AND EXISTS (SELECT 1

Line 3553: FROM po_price_diff_draft

3549: FROM po_line_locations_draft_all
3550: WHERE draft_id = l_draft_id
3551: AND nvl(change_accepted_flag,'Y') = 'Y')
3552: OR EXISTS (SELECT 1
3553: FROM po_price_diff_draft
3554: WHERE draft_id = l_draft_id
3555: AND nvl(change_accepted_flag,'Y') = 'Y')
3556: OR EXISTS (SELECT 1
3557: FROM po_attribute_values_draft