APPS.PO_DOCUMENT_ACTION_CLOSE dependencies on PO_DISTRIBUTIONS

Line 2270: -- a PA, we need to update gl_closed_date in po_distributions to the

2266:
2267: d_progress := 140;
2268:
2269: -- If Action is Finally Close and Encumbrance is ON and Document is not
2270: -- a PA, we need to update gl_closed_date in po_distributions to the
2271: -- System Date
2272:
2273: --
2274: -- If Action is Invoice Open and Calling from AP, we need to null out

Line 2275: -- update gl_closed_date in po_distributions

2271: -- System Date
2272:
2273: --
2274: -- If Action is Invoice Open and Calling from AP, we need to null out
2275: -- update gl_closed_date in po_distributions
2276:
2277: IF (p_shipment_id IS NOT NULL)
2278: THEN
2279:

Line 2284: FROM po_distributions pod

2280: d_progress := 141;
2281:
2282: SELECT pod.po_distribution_id
2283: BULK COLLECT INTO l_id_tbl
2284: FROM po_distributions pod
2285: WHERE pod.line_location_id = p_shipment_id;
2286:
2287: ELSIF(p_line_id IS NOT NULL)
2288: THEN

Line 2294: FROM po_distributions pod

2290: d_progress := 142;
2291:
2292: SELECT pod.po_distribution_id
2293: BULK COLLECT INTO l_id_tbl
2294: FROM po_distributions pod
2295: WHERE pod.po_line_id = p_line_id
2296: AND pod.po_release_id IS NULL;
2297:
2298: -- existing bug? the release_id = NULL filter was missing in POXPOACB.pls

Line 2308: FROM po_distributions pod

2304: d_progress := 143;
2305:
2306: SELECT pod.po_distribution_id
2307: BULK COLLECT INTO l_id_tbl
2308: FROM po_distributions pod
2309: WHERE pod.po_release_id = p_document_id;
2310:
2311: ELSE
2312:

Line 2317: FROM po_distributions pod

2313: d_progress := 144;
2314:
2315: SELECT pod.po_distribution_id
2316: BULK COLLECT INTO l_id_tbl
2317: FROM po_distributions pod
2318: WHERE pod.po_header_id = p_document_id
2319: AND pod.po_release_id IS NULL;
2320:
2321: -- existing bug? the release_id = NULL filter was missing in POXPOACB.pls

Line 2329: UPDATE po_distributions pod

2325:
2326: d_progress := 150;
2327:
2328: FORALL i IN 1..l_id_tbl.COUNT
2329: UPDATE po_distributions pod
2330: SET pod.gl_closed_date = DECODE(p_action, 'FINALLY CLOSE', SYSDATE, NULL)
2331: WHERE pod.po_distribution_id = l_id_tbl(i)
2332: ;
2333:

Line 2635: FROM po_distributions pod

2631: 1, 'OPEN',
2632: 'CLOSED FOR RECEIVING'),
2633: 'CLOSED FOR RECEIVING', 'CLOSED FOR RECEIVING',
2634: 'OPEN')))
2635: FROM po_distributions pod
2636: , po_system_parameters posp
2637: WHERE poll.line_location_id = l_id_tbl(i)
2638: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2639: AND pod.line_location_id = poll.line_location_id

Line 2750: FROM po_distributions pod

2746: 1, 'OPEN',
2747: 'CLOSED FOR RECEIVING'),
2748: 'CLOSED FOR RECEIVING', 'CLOSED FOR RECEIVING',
2749: 'OPEN')))
2750: FROM po_distributions pod
2751: , po_system_parameters posp
2752: WHERE poll.line_location_id = l_id_tbl(i)
2753: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2754: AND pod.line_location_id = poll.line_location_id

Line 2873: FROM po_distributions pod

2869: decode(nvl(poll.receipt_required_flag,'N'),'N',decode(nvl(poll.inspection_required_flag,'N'),'N',
2870: 'CLOSED','CLOSED FOR INVOICE')),'N','CLOSED FOR INVOICE'), -- Bug 11730977 end
2871: 'CLOSED FOR RECEIVING', 'OPEN',
2872: poll.closed_code)))
2873: FROM po_distributions pod
2874: , po_system_parameters posp
2875: WHERE poll.line_location_id = l_id_tbl(i)
2876: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2877: AND pod.line_location_id = poll.line_location_id

Line 2981: FROM po_distributions pod

2977: DECODE(poll.closed_code,
2978: 'CLOSED', 'CLOSED FOR RECEIVING',
2979: 'CLOSED FOR INVOICE', 'OPEN',
2980: poll.closed_code)))
2981: FROM po_distributions pod
2982: , po_system_parameters posp
2983: WHERE poll.line_location_id = l_id_tbl(i)
2984: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2985: AND pod.line_location_id = poll.line_location_id