eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_ACTION_CLOSE dependencies on PO_DISTRIBUTIONS

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

2180:
2181: d_progress := 140;
2182:
2183: -- If Action is Finally Close and Encumbrance is ON and Document is not
2184: -- a PA, we need to update gl_closed_date in po_distributions to the
2185: -- System Date
2186:
2187: --
2188: -- If Action is Invoice Open and Calling from AP, we need to null out

Line 2189: -- update gl_closed_date in po_distributions

2185: -- System Date
2186:
2187: --
2188: -- If Action is Invoice Open and Calling from AP, we need to null out
2189: -- update gl_closed_date in po_distributions
2190:
2191: IF (p_shipment_id IS NOT NULL)
2192: THEN
2193:

Line 2198: FROM po_distributions pod

2194: d_progress := 141;
2195:
2196: SELECT pod.po_distribution_id
2197: BULK COLLECT INTO l_id_tbl
2198: FROM po_distributions pod
2199: WHERE pod.line_location_id = p_shipment_id;
2200:
2201: ELSIF(p_line_id IS NOT NULL)
2202: THEN

Line 2208: FROM po_distributions pod

2204: d_progress := 142;
2205:
2206: SELECT pod.po_distribution_id
2207: BULK COLLECT INTO l_id_tbl
2208: FROM po_distributions pod
2209: WHERE pod.po_line_id = p_line_id
2210: AND pod.po_release_id IS NULL;
2211:
2212: -- existing bug? the release_id = NULL filter was missing in POXPOACB.pls

Line 2222: FROM po_distributions pod

2218: d_progress := 143;
2219:
2220: SELECT pod.po_distribution_id
2221: BULK COLLECT INTO l_id_tbl
2222: FROM po_distributions pod
2223: WHERE pod.po_release_id = p_document_id;
2224:
2225: ELSE
2226:

Line 2231: FROM po_distributions pod

2227: d_progress := 144;
2228:
2229: SELECT pod.po_distribution_id
2230: BULK COLLECT INTO l_id_tbl
2231: FROM po_distributions pod
2232: WHERE pod.po_header_id = p_document_id
2233: AND pod.po_release_id IS NULL;
2234:
2235: -- existing bug? the release_id = NULL filter was missing in POXPOACB.pls

Line 2243: UPDATE po_distributions pod

2239:
2240: d_progress := 150;
2241:
2242: FORALL i IN 1..l_id_tbl.COUNT
2243: UPDATE po_distributions pod
2244: SET pod.gl_closed_date = DECODE(p_action, 'FINALLY CLOSE', SYSDATE, NULL)
2245: WHERE pod.po_distribution_id = l_id_tbl(i)
2246: ;
2247:

Line 2475: FROM po_distributions pod

2471: 1, 'OPEN',
2472: 'CLOSED FOR RECEIVING'),
2473: 'CLOSED FOR RECEIVING', 'CLOSED FOR RECEIVING',
2474: 'OPEN')))
2475: FROM po_distributions pod
2476: , po_system_parameters posp
2477: WHERE poll.line_location_id = l_id_tbl(i)
2478: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2479: AND pod.line_location_id = poll.line_location_id

Line 2587: FROM po_distributions pod

2583: DECODE(poll.closed_code,
2584: 'CLOSED', 'CLOSED FOR INVOICE',
2585: 'CLOSED FOR RECEIVING', 'OPEN',
2586: poll.closed_code)))
2587: FROM po_distributions pod
2588: , po_system_parameters posp
2589: WHERE poll.line_location_id = l_id_tbl(i)
2590: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2591: AND pod.line_location_id = poll.line_location_id

Line 2691: FROM po_distributions pod

2687: DECODE(poll.closed_code,
2688: 'CLOSED', 'CLOSED FOR RECEIVING',
2689: 'CLOSED FOR INVOICE', 'OPEN',
2690: poll.closed_code)))
2691: FROM po_distributions pod
2692: , po_system_parameters posp
2693: WHERE poll.line_location_id = l_id_tbl(i)
2694: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2695: AND pod.line_location_id = poll.line_location_id