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_RESCHEDULE_PKG dependencies on PO_SESSION_GT

Line 333: po_session_gt map:

329: forall i in 1..X_po_line_ids.Count
330:
331:
332: /*
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

Line 345: insert into po_session_gt (key,

341: CHAR2: indicates a valid record
342:
343: */
344:
345: insert into po_session_gt (key,
346: num1,
347: num2,
348: num3, --bug9693292
349: date1,

Line 374: po_session_gt map:

370: ELSE
371: forall i in 1..X_po_line_ids.Count
372:
373: /*
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

Line 386: insert into po_session_gt (key,

382: CHAR2: indicates a valid record
383:
384: */
385:
386: insert into po_session_gt (key,
387: num1,
388: num2,
389: num3, --bug9693292
390: date1,

Line 415: --update po_session_gt with line number as the error message should contain the

411: End If; -- End Of Bug 5610714
412:
413: l_progress:= '065';
414: --bug9693292
415: --update po_session_gt with line number as the error message should contain the
416: --line numbers
417: UPDATE po_session_gt scratch
418: SET num4 = (SELECT line_num FROM po_lines_all WHERE po_line_id = scratch.num3);
419: --bug9693292

Line 417: UPDATE po_session_gt scratch

413: l_progress:= '065';
414: --bug9693292
415: --update po_session_gt with line number as the error message should contain the
416: --line numbers
417: UPDATE po_session_gt scratch
418: SET num4 = (SELECT line_num FROM po_lines_all WHERE po_line_id = scratch.num3);
419: --bug9693292
420:
421: --Validations

Line 427: UPDATE po_session_gt scratch

423: -- Validation #1 : Old Need by date passed and the db need by date should
424: -- Match
425:
426: l_progress:= '070';
427: UPDATE po_session_gt scratch
428: SET char2 = 'N'
429: WHERE scratch.char1 <>
430: To_char(scratch.date1,'DD-MON-YYYY:hh:mi:ss')
431: AND scratch.KEY = l_session_gt_key;

Line 438: FROM po_session_gt scratch

434: --bug9693292
435: --We select the values for the tokens to be substituted in the error message
436: SELECT x_supply_number,scratch.num4,scratch.num2,scratch.char1, To_char(scratch.date1,'DD-MON-YYYY:hh:mi:ss')
437: BULK collect INTO supply_number_tbl,line_number_tbl,shipment_number_tbl,ascp_date_tbl,po_date_tbl
438: FROM po_session_gt scratch
439: WHERE scratch.KEY = l_session_gt_key
440: AND Nvl(scratch.char2,'Y') = 'N';
441:
442: x_error_message := po_tbl_varchar2000();

Line 468: UPDATE po_session_gt scratch

464: --bug9693292
465:
466: -- Validation 2: New need by date should not be NULL
467: l_progress:= '090';
468: UPDATE po_session_gt scratch
469: SET char2 = 'N'
470: WHERE scratch.date2 IS NULL
471: AND scratch.KEY = l_session_gt_key;
472:

Line 477: FROM po_session_gt scratch

473: --bug9693292
474:
475: SELECT x_supply_number,scratch.num4,scratch.num2
476: BULK collect INTO supply_number_tbl,line_number_tbl,shipment_number_tbl
477: FROM po_session_gt scratch
478: WHERE scratch.KEY = l_session_gt_key
479: AND scratch.date2 IS NULL;
480: x_error_count := x_error_message.Count;
481: IF (supply_number_tbl.Count > 0) THEN

Line 502: from po_session_gt SCRATCH

498: l_progress:= '100';
499:
500: select num1, date2
501: bulk collect into l_line_location_id_tbl, l_need_by_date_tbl
502: from po_session_gt SCRATCH
503: WHERE KEY = l_session_gt_key
504: AND Nvl(scratch.char2,'Y') = 'Y' ;
505: /* Step 5:
506:

Line 543: from po_session_gt SCRATCH

539: IF nvl(l_need_by_promise_def_prf,'N') = 'Y' THEN
540: l_promised_by_date_tbl := PO_TBL_DATE();
541: select date2
542: bulk collect into l_promised_by_date_tbl
543: from po_session_gt SCRATCH
544: WHERE KEY = l_session_gt_key
545: AND Nvl(scratch.char2,'Y') = 'Y' ;
546: l_shipment_changes := PO_SHIPMENTS_REC_TYPE.create_object (
547: p_po_line_location_id => l_line_location_id_tbl,

Line 615: /* Delete all the data from po_session_gt */

611: -- debug
612: /* Step 9: set the context back to the orginal context.*/
613: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_context) ; --
614:
615: /* Delete all the data from po_session_gt */
616: l_progress:= '170';
617:
618: -- debug
619: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Deleting data from session gt '

Line 623: DELETE FROM po_session_gt

619: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Deleting data from session gt '
620: );
621: -- debug
622:
623: DELETE FROM po_session_gt
624: WHERE KEY = l_session_gt_key;
625:
626: /*Step 10 : return from the api */
627: PO_DEBUG.debug_end(l_log_head);

Line 637: DELETE FROM po_session_gt

633: -- Set the org context back to the original operating unit.
634: IF (l_original_org_context IS NOT NULL) THEN
635: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_context) ; --
636: END IF;
637: DELETE FROM po_session_gt
638: WHERE KEY = l_session_gt_key;
639: RETURN FALSE;
640:
641: WHEN OTHERS THEN

Line 642: DELETE FROM po_session_gt

638: WHERE KEY = l_session_gt_key;
639: RETURN FALSE;
640:
641: WHEN OTHERS THEN
642: DELETE FROM po_session_gt
643: WHERE KEY = l_session_gt_key;
644: IF (l_original_org_context IS NOT NULL) THEN
645: FND_CLIENT_INFO.set_org_context(l_original_org_context);
646: END IF;