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_ENCUMBRANCE_POSTPROCESSING dependencies on GL_BC_PACKETS

Line 310: -- GL_BC_PACKETS

306: --Pre-reqs:
307: -- PO_ENCUMBRANCE_GT has been updated with the data that should
308: -- be inserted into PO_BC_DISTRIBUTIONS.
309: --Modifies:
310: -- GL_BC_PACKETS
311: --Locks:
312: -- None.
313: --Function:
314: -- This procedure inserts all of the entries in

Line 555: SELECT GL_BC_PACKETS_S.nextval

551:
552: -- Get the next packet_id from the sequence. This is required as
553: -- we insert all the records with same packet ID.
554:
555: SELECT GL_BC_PACKETS_S.nextval
556: INTO x_packet_id
557: FROM DUAL;
558:
559: l_progress := '020';

Line 700: --already exists between xla_distribution_links and gl_bc_packets. This

696: --
697: --We need to set the value of APPLIED_TO_DIST_ID_2 this would be passed
698: --onto the allocation attributes so that a 1-1 mapping can be created
699: --between po_bc_distributions and xla_distribution_links. A 1-1 mapping
700: --already exists between xla_distribution_links and gl_bc_packets. This
701: --is the route to be followed to establish a 1-1 mapping between
702: --po_bc_distributions and xla_distribution_links
703: l_num_of_rows_inserted :=sql%rowcount;
704: IF g_debug_stmt THEN

Line 1109: -- The packet has already been inserted and committed to GL_BC_PACKETS.

1105: -------------------------------------------------------------------------------
1106: --Start of Comments
1107: --Name: execute_gl_call
1108: --Pre-reqs:
1109: -- The packet has already been inserted and committed to GL_BC_PACKETS.
1110: --Modifies:
1111: -- GL_BC_PACKETS
1112: --Locks:
1113: -- None.

Line 1111: -- GL_BC_PACKETS

1107: --Name: execute_gl_call
1108: --Pre-reqs:
1109: -- The packet has already been inserted and committed to GL_BC_PACKETS.
1110: --Modifies:
1111: -- GL_BC_PACKETS
1112: --Locks:
1113: -- None.
1114: --Function:
1115: -- This procedure calls the GL funds checker that operates on the

Line 1116: -- data in GL_BC_PACKETS and updates that table with the

1112: --Locks:
1113: -- None.
1114: --Function:
1115: -- This procedure calls the GL funds checker that operates on the
1116: -- data in GL_BC_PACKETS and updates that table with the
1117: -- success/failure results.
1118: --Parameters:
1119: --IN:
1120: --p_set_of_books_id

Line 1123: -- The packet_id in GL_BC_PACKETS that should be operated on.

1119: --IN:
1120: --p_set_of_books_id
1121: -- The set of books of this org.
1122: --p_packet_id
1123: -- The packet_id in GL_BC_PACKETS that should be operated on.
1124: --p_gl_mode
1125: -- Specifies whether to call GL in 'R'eserve, 'A'djust or
1126: -- 'F'orce mode
1127: --p_partial_resv_flag

Line 1301: -- GL_BC_PACKETS

1297: --Pre-reqs:
1298: -- PO_ENCUMBRANCE_GT is populated with all calculations.
1299: -- Call to GL Funds Checker already made on given packet ID.
1300: --Modifies:
1301: -- GL_BC_PACKETS
1302: --Locks:
1303: -- None.
1304: --Function:
1305: -- Copies result information from gl_bc_packets into PO_ENCUMBRANCE_GT

Line 1305: -- Copies result information from gl_bc_packets into PO_ENCUMBRANCE_GT

1301: -- GL_BC_PACKETS
1302: --Locks:
1303: -- None.
1304: --Function:
1305: -- Copies result information from gl_bc_packets into PO_ENCUMBRANCE_GT
1306: -- Further post-processing/error reporting relies on this information from GTT
1307: --Parameters:
1308: --IN:
1309: --p_packet_id

Line 1310: -- ID of the packet inserted into gl_bc_packets table.

1306: -- Further post-processing/error reporting relies on this information from GTT
1307: --Parameters:
1308: --IN:
1309: --p_packet_id
1310: -- ID of the packet inserted into gl_bc_packets table.
1311: --p_gl_return_code
1312: -- The overall transaction return code provided by GL from the glxfck() call
1313: --Testing:
1314: --

Line 1355: --Modified the query below to join with gl_bc_packets_hists

1351: END IF;
1352: --
1353: l_progress := '010';
1354: --
1355: --Modified the query below to join with gl_bc_packets_hists
1356: --This is so that the error rows are always found. GL moves
1357: --all errored rows to gl_bc_packets_hist for performance reasons.
1358: --
1359: --We have to join with xla_distribution_links to get a mapping between

Line 1357: --all errored rows to gl_bc_packets_hist for performance reasons.

1353: l_progress := '010';
1354: --
1355: --Modified the query below to join with gl_bc_packets_hists
1356: --This is so that the error rows are always found. GL moves
1357: --all errored rows to gl_bc_packets_hist for performance reasons.
1358: --
1359: --We have to join with xla_distribution_links to get a mapping between
1360: --po_bc_distributions and gl_bc_packets. We need a distinct to ensure that
1361: --for federal /customization cases where there could be multiple rows in

Line 1360: --po_bc_distributions and gl_bc_packets. We need a distinct to ensure that

1356: --This is so that the error rows are always found. GL moves
1357: --all errored rows to gl_bc_packets_hist for performance reasons.
1358: --
1359: --We have to join with xla_distribution_links to get a mapping between
1360: --po_bc_distributions and gl_bc_packets. We need a distinct to ensure that
1361: --for federal /customization cases where there could be multiple rows in
1362: --gl_bc_packets for the same distribution po_bc_distributions we are returned
1363: --just one row.
1364: --

Line 1362: --gl_bc_packets for the same distribution po_bc_distributions we are returned

1358: --
1359: --We have to join with xla_distribution_links to get a mapping between
1360: --po_bc_distributions and gl_bc_packets. We need a distinct to ensure that
1361: --for federal /customization cases where there could be multiple rows in
1362: --gl_bc_packets for the same distribution po_bc_distributions we are returned
1363: --just one row.
1364: --
1365: -- We will get all the packets id from gl_bc_packets for the events which we have populated in
1366: -- psa_bc_xla_events_gt table for the current packet Id. We won't use the packet id returned by

Line 1365: -- We will get all the packets id from gl_bc_packets for the events which we have populated in

1361: --for federal /customization cases where there could be multiple rows in
1362: --gl_bc_packets for the same distribution po_bc_distributions we are returned
1363: --just one row.
1364: --
1365: -- We will get all the packets id from gl_bc_packets for the events which we have populated in
1366: -- psa_bc_xla_events_gt table for the current packet Id. We won't use the packet id returned by
1367: -- Execute GL call as there can be mutiple packet id from which we need to take the result from
1368: -- GL BC PACKETS. In case of Cancel action with recreate demand we create two events, which belong
1369: -- to different entity. So two packets will be created by PSA.

Line 1368: -- GL BC PACKETS. In case of Cancel action with recreate demand we create two events, which belong

1364: --
1365: -- We will get all the packets id from gl_bc_packets for the events which we have populated in
1366: -- psa_bc_xla_events_gt table for the current packet Id. We won't use the packet id returned by
1367: -- Execute GL call as there can be mutiple packet id from which we need to take the result from
1368: -- GL BC PACKETS. In case of Cancel action with recreate demand we create two events, which belong
1369: -- to different entity. So two packets will be created by PSA.
1370: --
1371: -- Performance Fix : Changed in Inner query based on psa_bc_xla_events_gt to
1372: -- change the Plan of the Overall SQL.

Line 1405: GL_BC_PACKETS GLBC

1401: PBD.accounted_amt TRANSACTION_AMOUNT,
1402: PBD.reference15 REFERENCE15
1403: FROM XLA_DISTRIBUTION_LINKS XLD,
1404: PO_BC_DISTRIBUTIONS PBD,
1405: GL_BC_PACKETS GLBC
1406: WHERE GLBC.PACKET_ID IN (SELECT DISTINCT glbc1.packet_id
1407: FROM psa_bc_xla_events_gt ps_ev_Gt ,
1408: GL_BC_PACKETS glbc1
1409: WHERE ps_ev_Gt.event_id = glbc1.event_id)

Line 1408: GL_BC_PACKETS glbc1

1404: PO_BC_DISTRIBUTIONS PBD,
1405: GL_BC_PACKETS GLBC
1406: WHERE GLBC.PACKET_ID IN (SELECT DISTINCT glbc1.packet_id
1407: FROM psa_bc_xla_events_gt ps_ev_Gt ,
1408: GL_BC_PACKETS glbc1
1409: WHERE ps_ev_Gt.event_id = glbc1.event_id)
1410: AND XLD.AE_HEADER_ID = GLBC.ae_header_id
1411: AND xld.ae_line_num = GLBC.ae_line_num
1412: AND xld.event_id = GLBC.event_id

Line 1440: GL_BC_PACKETS_HISTS GLBCH

1436: PBD.accounted_amt TRANSACTION_AMOUNT,
1437: PBD.reference15 REFERENCE15
1438: FROM XLA_DISTRIBUTION_LINKS XLD,
1439: PO_BC_DISTRIBUTIONS PBD,
1440: GL_BC_PACKETS_HISTS GLBCH
1441: WHERE GLBCH.PACKET_ID IN (SELECT DISTINCT glbch1.packet_id
1442: FROM psa_bc_xla_events_gt ps_ev_Gt ,
1443: GL_BC_PACKETS_HISTS glbch1
1444: WHERE ps_ev_Gt.event_id = glbch1.event_id)

Line 1443: GL_BC_PACKETS_HISTS glbch1

1439: PO_BC_DISTRIBUTIONS PBD,
1440: GL_BC_PACKETS_HISTS GLBCH
1441: WHERE GLBCH.PACKET_ID IN (SELECT DISTINCT glbch1.packet_id
1442: FROM psa_bc_xla_events_gt ps_ev_Gt ,
1443: GL_BC_PACKETS_HISTS glbch1
1444: WHERE ps_ev_Gt.event_id = glbch1.event_id)
1445: AND XLD.AE_HEADER_ID = GLBCH.ae_header_id
1446: AND xld.ae_line_num = GLBCH.ae_line_num
1447: AND xld.event_id = GLBCH.event_id

Line 2322: -- approved GL_BC_PACKETS records is done. Just rollup the encumbered_flag

2318: END IF; -- RESERVE action and p_doc_type is PO or Release
2319:
2320:
2321: -- Now the updation of po_distributions/po_req_distributions for all the
2322: -- approved GL_BC_PACKETS records is done. Just rollup the encumbered_flag
2323: -- to the PO line locations and Requisition lines
2324:
2325: If l_flip_enc_flag = 'Y' Then
2326:

Line 3978: -- GL_BC_PACKETS

3974: --Name: delete_packet_autonomous
3975: --Pre-reqs:
3976: -- None.
3977: --Modifies:
3978: -- GL_BC_PACKETS
3979: --Locks:
3980: -- None.
3981: --Function:
3982: -- This procedure takes a packet id and deletes and

Line 3983: -- commits it to GL_BC_PACKETS in an autonomous transaction.

3979: --Locks:
3980: -- None.
3981: --Function:
3982: -- This procedure takes a packet id and deletes and
3983: -- commits it to GL_BC_PACKETS in an autonomous transaction.
3984: --Parameters:
3985: --IN:
3986: --p_packet_id
3987: -- The GL_BC_PACKETS.packet_id for the packet that is to be deleted.

Line 3987: -- The GL_BC_PACKETS.packet_id for the packet that is to be deleted.

3983: -- commits it to GL_BC_PACKETS in an autonomous transaction.
3984: --Parameters:
3985: --IN:
3986: --p_packet_id
3987: -- The GL_BC_PACKETS.packet_id for the packet that is to be deleted.
3988: --Testing:
3989: --
3990: --End of Comments
3991: -------------------------------------------------------------------------------