APPS.PO_DRAFT_MERGE_PKG dependencies on PO_CORE_S

Line 563: l_Encumbrance_on := po_core_s.Is_encumbrance_on(p_doc_type => l_document_type,p_org_id => NULL);

559: l_employee_id := po_wf_util_pkg.Getitemattrnumber(itemtype => itemtype,itemkey => itemkey,aname => 'APPROVER_EMPID');
560: l_note := po_wf_util_pkg.GetItemAttrText (itemtype => itemtype,itemkey => itemkey,aname => 'NOTE');
561:
562: Begin
563: l_Encumbrance_on := po_core_s.Is_encumbrance_on(p_doc_type => l_document_type,p_org_id => NULL);
564: EXCEPTION
565: WHEN OTHERS THEN
566: l_Encumbrance_on := FALSE;
567: END;

Line 1182: l_Encumbrance_on := po_core_s.Is_encumbrance_on(p_doc_type => p_doc_type,p_org_id => NULL);

1178: p_draft_id => p_draft_id);
1179: END IF; -- draft_id <> -1 , Mod loop
1180:
1181: Begin
1182: l_Encumbrance_on := po_core_s.Is_encumbrance_on(p_doc_type => p_doc_type,p_org_id => NULL);
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: l_Encumbrance_on := FALSE;
1186: END;

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