APPS.PO_RESCHEDULE_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 337: DATE1: db dates in po_line_locations_all

333: po_session_gt map:
334: KEY : unique key for the current session processing
335: NUM1 : line_location_id
336: NUM2 : shipment_num
337: DATE1: db dates in po_line_locations_all
338: DATE2: new need by dates passed in
339: CHAR1: old need by dates passed in ,
340: using the char field since session_gt has only 2 date columns
341: CHAR2: indicates a valid record

Line 364: from po_line_locations_all pll

360: Nvl(pll.promised_date,pll.need_by_date),
361: X_need_by_dates(i),
362: To_Char(X_need_by_dates_old(i),'DD-MON-YYYY:hh:mi:ss'),
363: 'Y'
364: from po_line_locations_all pll
365: where pll.po_line_id = X_po_line_ids(i)
366: and pll.po_header_id = X_po_header_id
367: and (l_po_release_id is NULL OR
368: pll.po_release_id = l_po_release_id);

Line 378: DATE1: db dates in po_line_locations_all

374: po_session_gt map:
375: KEY : unique key for the current session processing
376: NUM1 : line_location_id
377: NUM2 : shipment_num
378: DATE1: db dates in po_line_locations_all
379: DATE2: new need by dates passed in
380: CHAR1: old need by dates passed in ,
381: using the char field since session_gt has only 2 date columns
382: CHAR2: indicates a valid record

Line 405: from po_line_locations_all pll

401: Nvl(pll.promised_date,pll.need_by_date),
402: X_need_by_dates(i),
403: To_Char(X_need_by_dates_old(i),'DD-MON-YYYY:hh:mi:ss'),
404: 'Y'
405: from po_line_locations_all pll
406: where pll.po_line_id = X_po_line_ids(i)
407: and pll.shipment_num = Nvl(X_shipment_nums(i), pll.shipment_num)
408: and pll.po_header_id = X_po_header_id
409: and (l_po_release_id is NULL OR