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 1784: UPDATE po_attribute_values_draft PAVD

1780:
1781: d_position := 30;
1782:
1783: -- Attr Values Level
1784: UPDATE po_attribute_values_draft PAVD
1785: SET PAVD.change_accepted_flag = 'Y'
1786: WHERE PAVD.draft_id = p_draft_id
1787: AND PAVD.change_accepted_flag IS NULL
1788: AND PAVD.delete_flag = 'Y'

Line 1993: UPDATE po_attribute_values_draft PAVD

1989:
1990: d_position := 30;
1991:
1992: -- Attribute Values
1993: UPDATE po_attribute_values_draft PAVD
1994: SET PAVD.change_accepted_flag = 'Y'
1995: WHERE PAVD.draft_id = p_draft_id
1996: AND PAVD.change_accepted_flag IS NULL
1997: AND NVL(PAVD.delete_flag, 'N') <> 'Y'

Line 3035: FROM po_attribute_values_draft

3031: WHERE draft_id = p_draft_id
3032: AND change_accepted_flag IS NULL)
3033: OR EXISTS
3034: ( SELECT 1
3035: FROM po_attribute_values_draft
3036: WHERE draft_id = p_draft_id
3037: AND change_accepted_flag IS NULL)
3038: OR EXISTS
3039: ( SELECT 1

Line 3115: UPDATE po_attribute_values_draft PLVD

3111: AND PLDA.draft_id = PLLDA.draft_id );
3112:
3113: d_position := 10;
3114:
3115: UPDATE po_attribute_values_draft PLVD
3116: SET PLVD.change_accepted_flag = 'Y'
3117: WHERE PLVD.draft_id = p_draft_id
3118: AND NVL(PLVD.change_accepted_flag, 'N') <> 'Y'
3119: AND NOT EXISTS

Line 3248: UPDATE po_attribute_values_draft

3244: d_position := 20;
3245:
3246: -- attribute values
3247: FORALL i IN 1..p_line_id_list.COUNT
3248: UPDATE po_attribute_values_draft
3249: SET change_accepted_flag = p_change_accepted_value
3250: WHERE draft_id = p_draft_id
3251: AND po_line_id = p_line_id_list(i);
3252:

Line 3557: FROM po_attribute_values_draft

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
3558: WHERE draft_id = l_draft_id
3559: AND nvl(change_accepted_flag,'Y') = 'Y');
3560:
3561: EXCEPTION