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_DRAFT_ALL

Line 142: po_line_locations_draft_all plld

138: cursor line_locs_with_attachments_c(p_draft_id number) is
139: select plld.po_line_id as po_line_id,
140: plld.line_location_id as line_location_id
141: from po_headers_draft_all phd,
142: po_line_locations_draft_all plld
143: where phd.draft_id = p_draft_id
144: and phd.po_header_id = plld.po_header_id
145: and exists (select 1
146: from fnd_attached_documents

Line 734: po_line_locations_draft_all plld

730: select nvl(plld.control_action, 'NULL') as control_action,
731: plld.po_line_id as po_line_id,
732: plld.line_location_id as po_line_location_id
733: from po_headers_draft_all phd,
734: po_line_locations_draft_all plld
735: where phd.draft_id = l_draft_id
736: and phd.po_header_id = plld.po_header_id
737: and plld.control_action is not NULL;
738:

Line 1703: from fnd_attached_documents fad, po_line_locations_draft_all plld , fnd_documents fd

1699: procedure MERGE_LINE_LOCATION_ATTACHMENT(p_draft_id NUMBER) AS
1700:
1701: cursor modified_line_loc_attachment_c(p_draft_id NUMBER,p_entity_name VARCHAR2) is
1702: select plld.line_location_id as line_location_id, fad.attached_document_id , fad.ORIG_ATTACH_DOC_ID ,fd.datatype_id
1703: from fnd_attached_documents fad, po_line_locations_draft_all plld , fnd_documents fd
1704: where plld.draft_id = p_draft_id
1705: and fad.entity_name = p_entity_name
1706: and fad.pk1_value = to_char(plld.line_location_id) || '-' || to_char(p_draft_id)
1707: AND ORIG_ATTACH_DOC_ID IS NOT NULL

Line 1718: from fnd_attached_documents fad, po_line_locations_draft_all plld , fnd_documents fd

1714: --Fetch all new attachments other than mod specific attachments as merge
1715: -- is not needed for these attachmnets
1716: cursor new_line_loc_attachment_c(p_draft_id NUMBER) is
1717: select plld.line_location_id as line_location_id, fad.attached_document_id , fad.ORIG_ATTACH_DOC_ID ,fd.datatype_id
1718: from fnd_attached_documents fad, po_line_locations_draft_all plld , fnd_documents fd
1719: where plld.draft_id = p_draft_id
1720: and fad.entity_name = 'PO_SHIPMENTS'
1721: and fad.pk1_value = to_char(plld.line_location_id) || '-' || to_char(p_draft_id)
1722: AND ORIG_ATTACH_DOC_ID IS NULL

Line 2064: UPDATE po_line_locations_draft_all poll

2060: -- need_by_date = effective_date + delivery_period
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

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

2082:
2083: d_progress := 3;
2084:
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,

Line 2107: FROM po_line_locations_draft_all polld

2103: AND poll.clm_delivery_period_uom IS NOT NULL
2104: AND poll.clm_pop_duration IS NULL
2105: AND ( p_draft_id = -1
2106: OR EXISTS (SELECT 'Y'
2107: FROM po_line_locations_draft_all polld
2108: WHERE polld.po_header_id = poll.po_header_id
2109: AND polld.line_location_id =
2110: poll.line_location_id
2111: AND polld.draft_id = p_draft_id

Line 2127: UPDATE po_line_locations_draft_all poll

2123: -- promised_date = effective_date + promise_period
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,

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

2146: AND poll.change_status = 'NEW';
2147:
2148: d_progress := 5;
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,

Line 2173: FROM po_line_locations_draft_all polld

2169: AND poll.clm_promise_period IS NOT NULL
2170: AND poll.clm_promise_period_uom IS NOT NULL
2171: AND ( p_draft_id = -1
2172: OR EXISTS (SELECT 'Y'
2173: FROM po_line_locations_draft_all polld
2174: WHERE polld.po_header_id = poll.po_header_id
2175: AND polld.line_location_id =
2176: poll.line_location_id
2177: AND polld.draft_id = p_draft_id

Line 2192: UPDATE po_line_locations_draft_all poll

2188: -- pop_start_date = effective_date + delivery_period
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

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

2210: AND poll.change_status = 'NEW';
2211:
2212: d_progress := 7;
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,

Line 2236: FROM po_line_locations_draft_all polld

2232: AND poll.clm_pop_duration IS NOT NULL
2233: AND poll.clm_pop_duration_uom IS NOT NULL
2234: AND ( p_draft_id = -1
2235: OR EXISTS (SELECT 'Y'
2236: FROM po_line_locations_draft_all polld
2237: WHERE polld.po_header_id = poll.po_header_id
2238: AND polld.line_location_id =
2239: poll.line_location_id
2240: AND polld.draft_id = p_draft_id

Line 2254: UPDATE po_line_locations_draft_all poll

2250: -- And delivery_period, pop_duration are not null.
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

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

2272: AND poll.change_status = 'NEW';
2273:
2274: d_progress := 9;
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,

Line 2298: FROM po_line_locations_draft_all polld

2294: AND poll.clm_pop_duration IS NOT NULL
2295: AND poll.clm_pop_duration_uom IS NOT NULL
2296: AND ( p_draft_id = -1
2297: OR EXISTS (SELECT 'Y'
2298: FROM po_line_locations_draft_all polld
2299: WHERE polld.po_header_id = poll.po_header_id
2300: AND polld.line_location_id =
2301: poll.line_location_id
2302: AND polld.draft_id = p_draft_id

Line 2329: FROM po_line_locations_draft_all polld

2325: AND pol.po_line_id = poll.po_line_id
2326: AND pol.clm_delivery_event_code IN ( 'ADC', 'ANA' ))
2327: AND ( p_draft_id = -1
2328: OR EXISTS (SELECT 'Y'
2329: FROM po_line_locations_draft_all polld
2330: WHERE polld.po_header_id = poll.po_header_id
2331: AND polld.line_location_id =
2332: poll.line_location_id
2333: AND polld.draft_id = p_draft_id