APPS.PO_DIFF_SUMMARY_PKG dependencies on PO_ATTRIBUTE_VALUES_DRAFT

Line 829: FROM po_attribute_values_draft

825: AND PDD.draft_id = LLD.draft_id(+)
826: AND PDD.entity_id = LL.line_location_id(+)
827: UNION
828: SELECT po_line_id
829: FROM po_attribute_values_draft
830: WHERE draft_id = l_draft_id
831: AND change_accepted_flag IS NULL
832: UNION
833: SELECT po_line_id

Line 915: FROM po_attribute_values_draft

911: WHERE draft_id = l_draft_id
912: AND change_accepted_flag = 'N')
913: OR EXISTS
914: (SELECT 1
915: FROM po_attribute_values_draft
916: WHERE draft_id = l_draft_id
917: AND change_accepted_flag = 'N');
918: EXCEPTION
919: WHEN NO_DATA_FOUND THEN

Line 1758: UPDATE po_attribute_values_draft PAVD

1754:
1755: d_position := 30;
1756:
1757: -- Attr Values Level
1758: UPDATE po_attribute_values_draft PAVD
1759: SET PAVD.change_accepted_flag = 'Y'
1760: WHERE PAVD.draft_id = p_draft_id
1761: AND PAVD.change_accepted_flag IS NULL
1762: AND PAVD.delete_flag = 'Y'

Line 1967: UPDATE po_attribute_values_draft PAVD

1963:
1964: d_position := 30;
1965:
1966: -- Attribute Values
1967: UPDATE po_attribute_values_draft PAVD
1968: SET PAVD.change_accepted_flag = 'Y'
1969: WHERE PAVD.draft_id = p_draft_id
1970: AND PAVD.change_accepted_flag IS NULL
1971: AND NVL(PAVD.delete_flag, 'N') <> 'Y'

Line 3009: FROM po_attribute_values_draft

3005: WHERE draft_id = p_draft_id
3006: AND change_accepted_flag IS NULL)
3007: OR EXISTS
3008: ( SELECT 1
3009: FROM po_attribute_values_draft
3010: WHERE draft_id = p_draft_id
3011: AND change_accepted_flag IS NULL)
3012: OR EXISTS
3013: ( SELECT 1

Line 3089: UPDATE po_attribute_values_draft PLVD

3085: AND PLDA.draft_id = PLLDA.draft_id );
3086:
3087: d_position := 10;
3088:
3089: UPDATE po_attribute_values_draft PLVD
3090: SET PLVD.change_accepted_flag = 'Y'
3091: WHERE PLVD.draft_id = p_draft_id
3092: AND NVL(PLVD.change_accepted_flag, 'N') <> 'Y'
3093: AND NOT EXISTS

Line 3222: UPDATE po_attribute_values_draft

3218: d_position := 20;
3219:
3220: -- attribute values
3221: FORALL i IN 1..p_line_id_list.COUNT
3222: UPDATE po_attribute_values_draft
3223: SET change_accepted_flag = p_change_accepted_value
3224: WHERE draft_id = p_draft_id
3225: AND po_line_id = p_line_id_list(i);
3226: