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_CORE_S3

Line 2065: SET poll.need_by_date = po_core_s3.Add_period(l_effective_date,

2061: -- If POP Duration is there then we update POP Start date and not need by date.
2062: -- In case of Mods update only the New Lines
2063:
2064: UPDATE po_line_locations_draft_all poll
2065: SET poll.need_by_date = po_core_s3.Add_period(l_effective_date,
2066: poll.clm_delivery_period,
2067: poll.clm_delivery_period_uom)
2068: WHERE poll.po_header_id = p_document_id
2069: AND poll.po_release_id IS NULL

Line 2090: SET poll.need_by_date = po_core_s3.Add_period(l_effective_date,

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
2094: AND poll.po_release_id IS NULL

Line 2128: SET poll.promised_date = po_core_s3.Add_period(l_effective_date,

2124: -- In case of Mods update only the New Lines
2125: -- Also last_accep_date should be updated to promised_date + DAYS_LATE_RECEIPT_ALLOWED
2126:
2127: UPDATE po_line_locations_draft_all poll
2128: SET poll.promised_date = po_core_s3.Add_period(l_effective_date,
2129: poll.clm_promise_period,
2130: poll.clm_promise_period_uom),
2131: poll.last_accept_date = po_core_s3.Add_period(l_effective_date,
2132: poll.clm_promise_period,

Line 2131: poll.last_accept_date = po_core_s3.Add_period(l_effective_date,

2127: UPDATE po_line_locations_draft_all poll
2128: SET poll.promised_date = po_core_s3.Add_period(l_effective_date,
2129: poll.clm_promise_period,
2130: poll.clm_promise_period_uom),
2131: poll.last_accept_date = po_core_s3.Add_period(l_effective_date,
2132: poll.clm_promise_period,
2133: poll.clm_promise_period_uom)
2134: + Nvl(DAYS_LATE_RECEIPT_ALLOWED,0)
2135: WHERE poll.po_header_id = p_document_id

Line 2154: SET poll.promised_date = po_core_s3.Add_period(l_effective_date,

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,
2158: poll.clm_promise_period,

Line 2157: poll.last_accept_date = po_core_s3.Add_period(l_effective_date,

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,
2158: poll.clm_promise_period,
2159: poll.clm_promise_period_uom)
2160: + Nvl(DAYS_LATE_RECEIPT_ALLOWED,0)
2161: WHERE poll.po_header_id = p_document_id

Line 2193: SET poll.CLM_PERIOD_PERF_START_DATE = po_core_s3.Add_period(l_effective_date,

2189: -- If POP Duration is there then we update POP Start date and not need by date.
2190: -- In case of Mods update only the New Lines
2191:
2192: UPDATE po_line_locations_draft_all poll
2193: SET poll.CLM_PERIOD_PERF_START_DATE = po_core_s3.Add_period(l_effective_date,
2194: poll.clm_delivery_period,
2195: poll.clm_delivery_period_uom)
2196: WHERE poll.po_header_id = p_document_id
2197: AND poll.po_release_id IS NULL

Line 2218: SET poll.CLM_PERIOD_PERF_START_DATE = po_core_s3.Add_period(l_effective_date,

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
2222: AND poll.po_release_id IS NULL

Line 2255: SET poll.CLM_PERIOD_PERF_END_DATE = po_core_s3.Add_period(poll.clm_period_perf_start_date,

2251: -- POP end date = pop_start_date + pop_duration
2252: -- In case of Mods update only the New Lines
2253:
2254: UPDATE po_line_locations_draft_all poll
2255: SET poll.CLM_PERIOD_PERF_END_DATE = po_core_s3.Add_period(poll.clm_period_perf_start_date,
2256: poll.CLM_POP_DURATION,
2257: poll.CLM_POP_DURATION_UOM)
2258: WHERE poll.po_header_id = p_document_id
2259: AND poll.po_release_id IS NULL

Line 2280: SET poll.CLM_PERIOD_PERF_END_DATE = po_core_s3.Add_period(poll.clm_period_perf_start_date,

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
2284: AND poll.po_release_id IS NULL