APPS.PO_DIFF_SUMMARY_PKG dependencies on PO_ATTRIBUTE_VALUES_TLP

Line 834: FROM po_attribute_values_tlp_draft

830: WHERE draft_id = l_draft_id
831: AND change_accepted_flag IS NULL
832: UNION
833: SELECT po_line_id
834: FROM po_attribute_values_tlp_draft
835: WHERE draft_id = l_draft_id
836: AND language = l_created_language
837: AND change_accepted_flag IS NULL
838: );

Line 1686: UPDATE po_attribute_values_tlp_draft PAVTD

1682: po_headers_all PH
1683: WHERE DFT.draft_id = p_draft_id
1684: AND PH.po_header_id = DFT.document_id;
1685:
1686: UPDATE po_attribute_values_tlp_draft PAVTD
1687: SET change_accepted_flag = 'Y'
1688: WHERE change_accepted_flag IS NULL
1689: AND PAVTD.draft_id = p_draft_id
1690: AND PAVTD.language <> l_created_language;

Line 1797: UPDATE po_attribute_values_tlp_draft PAVTD

1793:
1794: d_position := 40;
1795:
1796: -- Attr Values TLP Level
1797: UPDATE po_attribute_values_tlp_draft PAVTD
1798: SET PAVTD.change_accepted_flag = 'Y'
1799: WHERE PAVTD.draft_id = p_draft_id
1800: AND PAVTD.change_accepted_flag IS NULL
1801: AND PAVTD.delete_flag = 'Y'

Line 1804: FROM po_attribute_values_tlp PAVT

1800: AND PAVTD.change_accepted_flag IS NULL
1801: AND PAVTD.delete_flag = 'Y'
1802: AND NOT EXISTS
1803: ( SELECT 1
1804: FROM po_attribute_values_tlp PAVT
1805: WHERE PAVTD.attribute_values_tlp_id = PAVT.attribute_values_tlp_id);
1806:
1807: IF (PO_LOG.d_proc) THEN
1808: PO_LOG.proc_end (d_module);

Line 2629: UPDATE po_attribute_values_tlp_draft PAVTD

2625:
2626: d_position := 40;
2627:
2628: -- Attribute values tlp
2629: UPDATE po_attribute_values_tlp_draft PAVTD
2630: SET PAVTD.change_accepted_flag = 'Y'
2631: WHERE PAVTD.draft_id = p_draft_id
2632: AND PAVTD.change_accepted_flag IS NULL
2633: AND NVL(PAVTD.delete_flag, 'N') <> 'Y'

Line 2636: FROM po_attribute_values_tlp PAVT

2632: AND PAVTD.change_accepted_flag IS NULL
2633: AND NVL(PAVTD.delete_flag, 'N') <> 'Y'
2634: AND EXISTS
2635: ( SELECT 1
2636: FROM po_attribute_values_tlp PAVT
2637: WHERE PAVTD.attribute_values_tlp_id = PAVT.attribute_values_tlp_id
2638: AND DECODE (PAVTD.description,
2639: PAVT.description, 'Y', 'N') = 'Y'
2640: AND DECODE (PAVTD.manufacturer,

Line 3040: FROM po_attribute_values_tlp_draft

3036: WHERE draft_id = p_draft_id
3037: AND change_accepted_flag IS NULL)
3038: OR EXISTS
3039: ( SELECT 1
3040: FROM po_attribute_values_tlp_draft
3041: WHERE draft_id = p_draft_id
3042: AND change_accepted_flag IS NULL);
3043:
3044:

Line 3127: UPDATE po_attribute_values_tlp_draft PLVTD

3123: AND PLDA.draft_id = PLVD.draft_id );
3124:
3125: d_position := 20;
3126:
3127: UPDATE po_attribute_values_tlp_draft PLVTD
3128: SET PLVTD.change_accepted_flag = 'Y'
3129: WHERE PLVTD.draft_id = p_draft_id
3130: AND NVL(PLVTD.change_accepted_flag, 'N') <> 'Y'
3131: AND NOT EXISTS

Line 3257: UPDATE po_attribute_values_tlp_draft

3253: d_position := 30;
3254:
3255: -- attribute values tlp
3256: FORALL i IN 1..p_line_id_list.COUNT
3257: UPDATE po_attribute_values_tlp_draft
3258: SET change_accepted_flag = p_change_accepted_value
3259: WHERE draft_id = p_draft_id
3260: AND po_line_id = p_line_id_list(i);
3261: