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

Line 311: INSERT INTO po_session_gt

307: IF p_line_id IS NULL THEN
308: -- payment instr code is from header level.
309: IF p_payment_instr_code = 'SEQ_ACRN_ORDER' THEN
310:
311: INSERT INTO po_session_gt
312: (key,-- l_key
313: num1,-- po_distribution_id
314: num2)-- payment_sequence_num
315: SELECT l_key,

Line 330: INSERT INTO po_session_gt

326: AND pd.po_header_id = p_po_header_id;
327:
328: ELSIF p_payment_instr_code = 'BY_PRORATION' THEN
329:
330: INSERT INTO po_session_gt
331: (key,-- l_key
332: num1,-- po_distribution_id
333: num2)-- payment_sequence_num
334: SELECT l_key,

Line 342: INSERT INTO po_session_gt

338: WHERE pd.po_header_id = p_po_header_id;
339:
340: ELSIF p_payment_instr_code = 'BY_FISCAL_YR' THEN
341:
342: INSERT INTO po_session_gt
343: (key,-- l_key
344: num1,-- po_distribution_id
345: num2)-- payment_sequence_num
346: SELECT l_key,

Line 361: INSERT INTO po_session_gt

357: AND pd.po_header_id = p_po_header_id;
358:
359: ELSIF p_payment_instr_code = 'BY_CANCELLATION_DATE' THEN
360:
361: INSERT INTO po_session_gt
362: (key,-- l_key
363: num1,-- po_distribution_id
364: num2)-- payment_sequence_num
365: SELECT l_key,

Line 383: INSERT INTO po_session_gt

379:
380: ELSE -- payment instr code is from line level.
381: IF p_payment_instr_code = 'SEQ_ACRN_ORDER' THEN
382:
383: INSERT INTO po_session_gt
384: (key,-- l_key
385: num1,-- po_distribution_id
386: num2)-- payment_sequence_num
387: SELECT l_key,

Line 404: INSERT INTO po_session_gt

400: AND pd.po_header_id = p_po_header_id;
401:
402: ELSIF p_payment_instr_code IN ('BY_PRORATION', 'SINGLE_FUNDING') THEN
403:
404: INSERT INTO po_session_gt
405: (key,-- l_key
406: num1,-- po_distribution_id
407: num2)-- payment_sequence_num
408: SELECT l_key,

Line 417: INSERT INTO po_session_gt

413: AND pd.po_line_id = p_line_id;
414:
415: ELSIF p_payment_instr_code = 'BY_FISCAL_YR' THEN
416:
417: INSERT INTO po_session_gt
418: (key,-- l_key
419: num1,-- po_distribution_id
420: num2)-- payment_sequence_num
421: SELECT l_key,

Line 438: INSERT INTO po_session_gt

434: AND pd.po_header_id = p_po_header_id;
435:
436: ELSIF p_payment_instr_code = 'BY_CANCELLATION_DATE' THEN
437:
438: INSERT INTO po_session_gt
439: (key,-- l_key
440: num1,-- po_distribution_id
441: num2)-- payment_sequence_num
442: SELECT l_key,

Line 463: FROM po_session_gt gt

459: END IF; -- end if for po_line_id is NULL
460: -- Update distributions with fetched sequence.
461: UPDATE po_distributions_all pda
462: SET pda.clm_payment_sequence_num = (SELECT gt.num2
463: FROM po_session_gt gt
464: WHERE gt.KEY = l_key
465: AND gt.num1 = pda.po_distribution_id)
466: WHERE pda.po_header_id= p_po_header_id
467: AND pda.po_line_id = Nvl(p_line_id, pda.po_line_id);