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 1660: UPDATE po_attribute_values_tlp_draft PAVTD

1656: po_headers_all PH
1657: WHERE DFT.draft_id = p_draft_id
1658: AND PH.po_header_id = DFT.document_id;
1659:
1660: UPDATE po_attribute_values_tlp_draft PAVTD
1661: SET change_accepted_flag = 'Y'
1662: WHERE change_accepted_flag IS NULL
1663: AND PAVTD.draft_id = p_draft_id
1664: AND PAVTD.language <> l_created_language;

Line 1771: UPDATE po_attribute_values_tlp_draft PAVTD

1767:
1768: d_position := 40;
1769:
1770: -- Attr Values TLP Level
1771: UPDATE po_attribute_values_tlp_draft PAVTD
1772: SET PAVTD.change_accepted_flag = 'Y'
1773: WHERE PAVTD.draft_id = p_draft_id
1774: AND PAVTD.change_accepted_flag IS NULL
1775: AND PAVTD.delete_flag = 'Y'

Line 1778: FROM po_attribute_values_tlp PAVT

1774: AND PAVTD.change_accepted_flag IS NULL
1775: AND PAVTD.delete_flag = 'Y'
1776: AND NOT EXISTS
1777: ( SELECT 1
1778: FROM po_attribute_values_tlp PAVT
1779: WHERE PAVTD.attribute_values_tlp_id = PAVT.attribute_values_tlp_id);
1780:
1781: IF (PO_LOG.d_proc) THEN
1782: PO_LOG.proc_end (d_module);

Line 2603: UPDATE po_attribute_values_tlp_draft PAVTD

2599:
2600: d_position := 40;
2601:
2602: -- Attribute values tlp
2603: UPDATE po_attribute_values_tlp_draft PAVTD
2604: SET PAVTD.change_accepted_flag = 'Y'
2605: WHERE PAVTD.draft_id = p_draft_id
2606: AND PAVTD.change_accepted_flag IS NULL
2607: AND NVL(PAVTD.delete_flag, 'N') <> 'Y'

Line 2610: FROM po_attribute_values_tlp PAVT

2606: AND PAVTD.change_accepted_flag IS NULL
2607: AND NVL(PAVTD.delete_flag, 'N') <> 'Y'
2608: AND EXISTS
2609: ( SELECT 1
2610: FROM po_attribute_values_tlp PAVT
2611: WHERE PAVTD.attribute_values_tlp_id = PAVT.attribute_values_tlp_id
2612: AND DECODE (PAVTD.description,
2613: PAVT.description, 'Y', 'N') = 'Y'
2614: AND DECODE (PAVTD.manufacturer,

Line 3014: FROM po_attribute_values_tlp_draft

3010: WHERE draft_id = p_draft_id
3011: AND change_accepted_flag IS NULL)
3012: OR EXISTS
3013: ( SELECT 1
3014: FROM po_attribute_values_tlp_draft
3015: WHERE draft_id = p_draft_id
3016: AND change_accepted_flag IS NULL);
3017:
3018:

Line 3101: UPDATE po_attribute_values_tlp_draft PLVTD

3097: AND PLDA.draft_id = PLVD.draft_id );
3098:
3099: d_position := 20;
3100:
3101: UPDATE po_attribute_values_tlp_draft PLVTD
3102: SET PLVTD.change_accepted_flag = 'Y'
3103: WHERE PLVTD.draft_id = p_draft_id
3104: AND NVL(PLVTD.change_accepted_flag, 'N') <> 'Y'
3105: AND NOT EXISTS

Line 3231: UPDATE po_attribute_values_tlp_draft

3227: d_position := 30;
3228:
3229: -- attribute values tlp
3230: FORALL i IN 1..p_line_id_list.COUNT
3231: UPDATE po_attribute_values_tlp_draft
3232: SET change_accepted_flag = p_change_accepted_value
3233: WHERE draft_id = p_draft_id
3234: AND po_line_id = p_line_id_list(i);
3235: