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 1758: UPDATE po_line_locations_draft_all PLLD

1754:
1755: d_position := 10;
1756:
1757: -- Price Break Level
1758: UPDATE po_line_locations_draft_all PLLD
1759: SET PLLD.change_accepted_flag = 'Y'
1760: WHERE PLLD.draft_id = p_draft_id
1761: AND PLLD.change_accepted_flag IS NULL
1762: AND PLLD.delete_flag = 'Y'

Line 1937: UPDATE po_line_locations_draft_all PLLD

1933:
1934: d_position := 10;
1935:
1936: -- Price Break attributes
1937: UPDATE po_line_locations_draft_all PLLD
1938: SET PLLD.change_accepted_flag = 'Y'
1939: WHERE PLLD.draft_id = p_draft_id
1940: AND PLLD.change_accepted_flag IS NULL
1941: AND NVL(PLLD.delete_flag, 'N') <> 'Y'

Line 3025: FROM po_line_locations_draft_all

3021: WHERE draft_id = p_draft_id
3022: AND change_accepted_flag IS NULL)
3023: OR EXISTS
3024: ( SELECT 1
3025: FROM po_line_locations_draft_all
3026: WHERE draft_id = p_draft_id
3027: AND change_accepted_flag IS NULL)
3028: OR EXISTS
3029: ( SELECT 1

Line 3103: UPDATE po_line_locations_draft_all PLLDA

3099: IF (PO_LOG.d_proc) THEN
3100: PO_LOG.proc_begin (d_module);
3101: END IF;
3102:
3103: UPDATE po_line_locations_draft_all PLLDA
3104: SET PLLDA.change_accepted_flag = 'Y'
3105: WHERE PLLDA.draft_id = p_draft_id
3106: AND NVL(PLLDA.change_accepted_flag, 'N') <> 'Y'
3107: AND NOT EXISTS

Line 3155: FROM po_line_locations_draft_all PLLDA,

3151: OR
3152: ( PPDD.entity_type = 'PRICE BREAK'
3153: AND NOT EXISTS
3154: ( SELECT NULL
3155: FROM po_line_locations_draft_all PLLDA,
3156: po_lines_draft_all PLDA
3157: WHERE PLLDA.line_location_id = PPDD.entity_id
3158: AND PLLDA.draft_id = PPDD.draft_id
3159: AND PLDA.po_line_id = PLLDA.po_line_id

Line 3239: UPDATE po_line_locations_draft_all

3235: d_position := 10;
3236:
3237: -- price breaks
3238: FORALL i IN 1..p_line_id_list.COUNT
3239: UPDATE po_line_locations_draft_all
3240: SET change_accepted_flag = p_change_accepted_value
3241: WHERE draft_id = p_draft_id
3242: AND po_line_id = p_line_id_list(i);
3243:

Line 3282: FROM po_line_locations_draft_all PLLD

3278: SET change_accepted_flag = p_change_accepted_value
3279: WHERE draft_id = p_draft_id
3280: AND entity_type = 'PRICE BREAK'
3281: AND EXISTS (SELECT 1
3282: FROM po_line_locations_draft_all PLLD
3283: WHERE PLLD.draft_id = p_draft_id
3284: AND PLLD.po_line_id = p_line_id_list(i)
3285: AND PLLD.line_location_id = PPDD.entity_id
3286: UNION ALL

Line 3549: FROM po_line_locations_draft_all

3545: FROM po_lines_draft_all
3546: WHERE draft_id = l_draft_id
3547: AND nvl(change_accepted_flag,'Y') = 'Y')
3548: OR EXISTS (SELECT 1
3549: FROM po_line_locations_draft_all
3550: WHERE draft_id = l_draft_id
3551: AND nvl(change_accepted_flag,'Y') = 'Y')
3552: OR EXISTS (SELECT 1
3553: FROM po_price_diff_draft