APPS.PO_DIFF_SUMMARY_PKG dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 807: FROM po_line_locations_draft_all

803: WHERE draft_id = l_draft_id
804: AND change_accepted_flag IS NULL
805: UNION
806: SELECT po_line_id
807: FROM po_line_locations_draft_all
808: WHERE draft_id = l_draft_id
809: AND change_accepted_flag IS NULL
810: UNION
811: SELECT entity_id

Line 818: FROM po_line_locations_draft_all LLD,

814: AND entity_type = 'BLANKET LINE'
815: AND change_accepted_flag IS NULL
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'

Line 905: FROM po_line_locations_draft_all

901: WHERE draft_id = l_draft_id
902: AND change_accepted_flag = 'N')
903: OR EXISTS
904: (SELECT 1
905: FROM po_line_locations_draft_all
906: WHERE draft_id = l_draft_id
907: AND change_accepted_flag = 'N')
908: OR EXISTS
909: (SELECT 1

Line 1732: UPDATE po_line_locations_draft_all PLLD

1728:
1729: d_position := 10;
1730:
1731: -- Price Break Level
1732: UPDATE po_line_locations_draft_all PLLD
1733: SET PLLD.change_accepted_flag = 'Y'
1734: WHERE PLLD.draft_id = p_draft_id
1735: AND PLLD.change_accepted_flag IS NULL
1736: AND PLLD.delete_flag = 'Y'

Line 1911: UPDATE po_line_locations_draft_all PLLD

1907:
1908: d_position := 10;
1909:
1910: -- Price Break attributes
1911: UPDATE po_line_locations_draft_all PLLD
1912: SET PLLD.change_accepted_flag = 'Y'
1913: WHERE PLLD.draft_id = p_draft_id
1914: AND PLLD.change_accepted_flag IS NULL
1915: AND NVL(PLLD.delete_flag, 'N') <> 'Y'

Line 2999: FROM po_line_locations_draft_all

2995: WHERE draft_id = p_draft_id
2996: AND change_accepted_flag IS NULL)
2997: OR EXISTS
2998: ( SELECT 1
2999: FROM po_line_locations_draft_all
3000: WHERE draft_id = p_draft_id
3001: AND change_accepted_flag IS NULL)
3002: OR EXISTS
3003: ( SELECT 1

Line 3077: UPDATE po_line_locations_draft_all PLLDA

3073: IF (PO_LOG.d_proc) THEN
3074: PO_LOG.proc_begin (d_module);
3075: END IF;
3076:
3077: UPDATE po_line_locations_draft_all PLLDA
3078: SET PLLDA.change_accepted_flag = 'Y'
3079: WHERE PLLDA.draft_id = p_draft_id
3080: AND NVL(PLLDA.change_accepted_flag, 'N') <> 'Y'
3081: AND NOT EXISTS

Line 3129: FROM po_line_locations_draft_all PLLDA,

3125: OR
3126: ( PPDD.entity_type = 'PRICE BREAK'
3127: AND NOT EXISTS
3128: ( SELECT NULL
3129: FROM po_line_locations_draft_all PLLDA,
3130: po_lines_draft_all PLDA
3131: WHERE PLLDA.line_location_id = PPDD.entity_id
3132: AND PLLDA.draft_id = PPDD.draft_id
3133: AND PLDA.po_line_id = PLLDA.po_line_id

Line 3213: UPDATE po_line_locations_draft_all

3209: d_position := 10;
3210:
3211: -- price breaks
3212: FORALL i IN 1..p_line_id_list.COUNT
3213: UPDATE po_line_locations_draft_all
3214: SET change_accepted_flag = p_change_accepted_value
3215: WHERE draft_id = p_draft_id
3216: AND po_line_id = p_line_id_list(i);
3217:

Line 3256: FROM po_line_locations_draft_all PLLD

3252: SET change_accepted_flag = p_change_accepted_value
3253: WHERE draft_id = p_draft_id
3254: AND entity_type = 'PRICE BREAK'
3255: AND EXISTS (SELECT 1
3256: FROM po_line_locations_draft_all PLLD
3257: WHERE PLLD.draft_id = p_draft_id
3258: AND PLLD.po_line_id = p_line_id_list(i)
3259: AND PLLD.line_location_id = PPDD.entity_id
3260: UNION ALL