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

Line 2803: -- Use an indexed column to store the sequence in PO_SESSION_GT. We will also

2799: -- preserving the guarantee that the output values are ordered
2800: -- corresponding to the order of the input values
2801:
2802: -- bug3546894
2803: -- Use an indexed column to store the sequence in PO_SESSION_GT. We will also
2804: -- save the same in PL/SQL table l_sequence_tbl
2805: FORALL i IN 1 .. p_agreement_id_tbl.COUNT
2806: INSERT INTO PO_SESSION_GT TEMP
2807: ( key

Line 2806: INSERT INTO PO_SESSION_GT TEMP

2802: -- bug3546894
2803: -- Use an indexed column to store the sequence in PO_SESSION_GT. We will also
2804: -- save the same in PL/SQL table l_sequence_tbl
2805: FORALL i IN 1 .. p_agreement_id_tbl.COUNT
2806: INSERT INTO PO_SESSION_GT TEMP
2807: ( key
2808: , num1
2809: , index_num1
2810: )

Line 2814: , PO_SESSION_GT_S.NEXTVAL

2810: )
2811: VALUES
2812: ( l_procedure_id
2813: , p_agreement_id_tbl(i)
2814: , PO_SESSION_GT_S.NEXTVAL
2815: )
2816: RETURNING TEMP.index_num1
2817: BULK COLLECT INTO l_sequence_tbl
2818: ;

Line 2833: UPDATE PO_SESSION_GT TEMP

2829: --SQL Why: Callers that are sourcing a Requisition against a BPA need to
2830: -- know whether the BPA is encumbered or not, because it determines
2831: -- the setting of the Reqs prevent_encumbrance_flag.
2832:
2833: UPDATE PO_SESSION_GT TEMP
2834: SET char1 =
2835: (SELECT POH.encumbrance_required_flag
2836: FROM PO_HEADERS POH
2837: WHERE POH.po_header_id = TEMP.num1

Line 2849: FROM PO_SESSION_GT WHERE key = l_procedure_id

2845: PO_DEBUG.debug_stmt(l_log_head,l_progress,
2846: 'Encumbrance information updated successfully');
2847:
2848: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
2849: FROM PO_SESSION_GT WHERE key = l_procedure_id
2850: ;
2851:
2852: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT'
2853: , PO_DEBUG.g_rowid_tbl

Line 2852: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT'

2848: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
2849: FROM PO_SESSION_GT WHERE key = l_procedure_id
2850: ;
2851:
2852: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT'
2853: , PO_DEBUG.g_rowid_tbl
2854: , po_tbl_varchar30('key','num1','char1','num2')
2855: );
2856:

Line 2866: -- PO_SESSION_GT in the first place.

2862: -- table, with the ordering preserved.
2863:
2864: -- bug3546894
2865: -- we want to obtain the result in the same order as we insert into
2866: -- PO_SESSION_GT in the first place.
2867: FORALL i IN 1..l_sequence_tbl.COUNT
2868: UPDATE PO_SESSION_GT
2869: SET char1 = NVL(char1,'N')
2870: WHERE key = l_procedure_id

Line 2868: UPDATE PO_SESSION_GT

2864: -- bug3546894
2865: -- we want to obtain the result in the same order as we insert into
2866: -- PO_SESSION_GT in the first place.
2867: FORALL i IN 1..l_sequence_tbl.COUNT
2868: UPDATE PO_SESSION_GT
2869: SET char1 = NVL(char1,'N')
2870: WHERE key = l_procedure_id
2871: AND index_num1 = l_sequence_tbl(i)
2872: RETURNING char1

Line 4621: -- PO_SESSION_GT column mapping

4617: -- Make a copy for each value in the adjustment status table.
4618: -- Use the scratchpad to do this in bulk.
4619:
4620: ----------------------------------------------------------------
4621: -- PO_SESSION_GT column mapping
4622: --
4623: -- num1 distribution id
4624: ----------------------------------------------------------------
4625:

Line 4631: INSERT INTO PO_SESSION_GT TEMP ( key, num1 )

4627:
4628: l_progress := '080';
4629:
4630: FORALL i IN 1 .. l_dist_id_tbl.COUNT
4631: INSERT INTO PO_SESSION_GT TEMP ( key, num1 )
4632: VALUES ( l_dist_id_key, l_dist_id_tbl(i) )
4633: ;
4634:
4635: l_progress := '090';

Line 4744: , PO_SESSION_GT DIST_IDS

4740: FROM
4741: PO_REQ_DISTRIBUTIONS_ALL PRD
4742: , PO_REQUISITION_LINES_ALL PRL
4743: , PO_REQUISITION_HEADERS_ALL PRH
4744: , PO_SESSION_GT DIST_IDS
4745: WHERE PRH.requisition_header_id = PRL.requisition_header_id --JOIN
4746: AND PRL.requisition_line_id = PRD.requisition_line_id --JOIN
4747: AND PRD.distribution_id = DIST_IDS.num1 --JOIN
4748: AND DIST_IDS.key = l_dist_id_key

Line 4897: , PO_SESSION_GT DIST_IDS

4893: PO_DISTRIBUTIONS_ALL POD
4894: , PO_LINE_LOCATIONS_ALL POLL
4895: , PO_LINES_ALL POL
4896: , PO_HEADERS_ALL POH
4897: , PO_SESSION_GT DIST_IDS
4898: WHERE POH.po_header_id = POD.po_header_id --JOIN
4899: AND POL.po_line_id(+) = POD.po_line_id --JOIN
4900: -- the distributions of PAs don't have associated lines
4901: AND POLL.line_location_id(+) = POD.line_location_id --JOIN

Line 5559: INSERT INTO po_session_gt TEMP

5555:
5556: l_progress := '030';
5557:
5558: FORALL i IN 1..l_dist_id_tbl.COUNT
5559: INSERT INTO po_session_gt TEMP
5560: (KEY,
5561: num1)
5562: VALUES (l_dist_id_key,
5563: L_dist_id_tbl(i));

Line 5693: po_session_gt dist_ids

5689: FROM po_distributions_merge_v pod,
5690: po_line_locations_merge_v poll,
5691: po_lines_merge_v pol,
5692: po_headers_merge_v poh,
5693: po_session_gt dist_ids
5694: WHERE poh.po_header_id = pod.po_header_id --JOIN
5695: AND pol.po_line_id (+) = pod.po_line_id --JOIN
5696: -- the distributions of PAs don't have associated lines
5697: AND poll.line_location_id (+) = pod.line_location_id --JOIN