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_DRAFT_MERGE_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 2089: UPDATE po_line_locations_all poll

2085: IF (PO_LOG.d_stmt) THEN
2086: PO_LOG.stmt(d_module, d_progress, 'Updated Need By Date in po_line_locations_draft_all - No of rows updated :' , SQL%ROWCOUNT);
2087: END IF;
2088:
2089: UPDATE po_line_locations_all poll
2090: SET poll.need_by_date = po_core_s3.Add_period(l_effective_date,
2091: poll.clm_delivery_period,
2092: poll.clm_delivery_period_uom)
2093: WHERE poll.po_header_id = p_document_id

Line 2117: PO_LOG.stmt(d_module, d_progress, 'Updated Need By Date in po_line_locations_all- No of rows updated :' , SQL%ROWCOUNT);

2113:
2114: d_progress := 4;
2115:
2116: IF (PO_LOG.d_stmt) THEN
2117: PO_LOG.stmt(d_module, d_progress, 'Updated Need By Date in po_line_locations_all- No of rows updated :' , SQL%ROWCOUNT);
2118: END IF;
2119:
2120: -- Update Promised Date
2121: -- Only when After Date of Contract or Notice of Award event is used

Line 2153: UPDATE po_line_locations_all poll

2149: IF (PO_LOG.d_stmt) THEN
2150: PO_LOG.stmt(d_module, d_progress, 'Updated Promised in po_line_locations_draft_all- No of rows updated :' , SQL%ROWCOUNT);
2151: END IF;
2152:
2153: UPDATE po_line_locations_all poll
2154: SET poll.promised_date = po_core_s3.Add_period(l_effective_date,
2155: poll.clm_promise_period,
2156: poll.clm_promise_period_uom),
2157: poll.last_accept_date = po_core_s3.Add_period(l_effective_date,

Line 2182: PO_LOG.stmt(d_module, d_progress, 'Updated Promised in po_line_locations_all- No of rows updated :' , SQL%ROWCOUNT);

2178: AND polld.change_status = 'NEW') );
2179:
2180: d_progress := 6;
2181: IF (PO_LOG.d_stmt) THEN
2182: PO_LOG.stmt(d_module, d_progress, 'Updated Promised in po_line_locations_all- No of rows updated :' , SQL%ROWCOUNT);
2183: END IF;
2184:
2185: -- Update POP Start Date
2186: -- Only when After Date of Contract or Notice of Award event is used

Line 2217: UPDATE po_line_locations_all poll

2213: IF (PO_LOG.d_stmt) THEN
2214: PO_LOG.stmt(d_module, d_progress, 'Updated POP Start Date in po_line_locations_draft_all - No of rows updated :' , SQL%ROWCOUNT);
2215: END IF;
2216:
2217: UPDATE po_line_locations_all poll
2218: SET poll.CLM_PERIOD_PERF_START_DATE = po_core_s3.Add_period(l_effective_date,
2219: poll.clm_delivery_period,
2220: poll.clm_delivery_period_uom)
2221: WHERE poll.po_header_id = p_document_id

Line 2245: PO_LOG.stmt(d_module, d_progress, 'Updated POP Start Date in po_line_locations_all - No of rows updated :' , SQL%ROWCOUNT);

2241: AND polld.change_status = 'NEW') );
2242:
2243: d_progress := 8;
2244: IF (PO_LOG.d_stmt) THEN
2245: PO_LOG.stmt(d_module, d_progress, 'Updated POP Start Date in po_line_locations_all - No of rows updated :' , SQL%ROWCOUNT);
2246: END IF;
2247:
2248: -- Update POP End Date
2249: -- Only when After Date of Contract or Notice of Award event is used

Line 2279: UPDATE po_line_locations_all poll

2275: IF (PO_LOG.d_stmt) THEN
2276: PO_LOG.stmt(d_module, d_progress, 'Updated POP End Date in po_line_locations_draft_all - No of rows updated :' , SQL%ROWCOUNT);
2277: END IF;
2278:
2279: UPDATE po_line_locations_all poll
2280: SET poll.CLM_PERIOD_PERF_END_DATE = po_core_s3.Add_period(poll.clm_period_perf_start_date,
2281: poll.CLM_POP_DURATION,
2282: poll.CLM_POP_DURATION_UOM)
2283: WHERE poll.po_header_id = p_document_id

Line 2307: PO_LOG.stmt(d_module, d_progress, 'Updated POP End Date in po_line_locations_all - No of rows updated :' , SQL%ROWCOUNT);

2303: AND polld.change_status = 'NEW') );
2304:
2305: d_progress := 10;
2306: IF (PO_LOG.d_stmt) THEN
2307: PO_LOG.stmt(d_module, d_progress, 'Updated POP End Date in po_line_locations_all - No of rows updated :' , SQL%ROWCOUNT);
2308: END IF;
2309:
2310: -- Sync Archive
2311: FOR poll in (SELECT poll.po_header_id,

Line 2319: FROM po_line_locations_all poll

2315: poll.promised_date,
2316: poll.last_accept_date,
2317: poll.clm_period_perf_start_date,
2318: poll.clm_period_perf_end_date
2319: FROM po_line_locations_all poll
2320: WHERE poll.po_header_id = p_document_id
2321: AND poll.po_release_id IS NULL
2322: AND EXISTS (SELECT 'ADC/ANA Delivery Event used'
2323: FROM po_lines_all pol