APPS.PSA_FUNDS_CHECKER_PKG dependencies on GL_CONCURRENCY_CONTROL

Line 285: /* GL_CONCURRENCY_CONTROL */

281: /* GL_BC_OPTION_DETAILS */
282: /* GL_BC_PERIOD_MAP */
283: /* GL_BC_DUAL */
284: /* GL_BC_DUAL2 */
285: /* GL_CONCURRENCY_CONTROL */
286: /* GL_PERIOD_STATUSES */
287: /* GL_LOOKUPS */
288: /* GL_USSGL_TRANSACTION_CODES */
289: /* GL_USSGL_ACCOUNT_PAIRS */

Line 2810: from gl_concurrency_control ct

2806: from dual;
2807:
2808: cursor lock_gl_conc_ctrl is
2809: select 'Obtain Row Share Lock on the corresponding record for this Set of Books'
2810: from gl_concurrency_control ct
2811: where ct.concurrency_class = 'INSERT_PACKET_ARRIVAL'
2812: and ct.concurrency_entity_name = 'SET_OF_BOOKS'
2813: and ct.concurrency_entity_id = to_char(g_ledger_id)
2814: FOR UPDATE;

Line 3307: -- When a lock on gl_concurrency_control is not available then

3303:
3304: -- Insert Arrival Sequence for the Packet. The Row Share Lock ensures that
3305: -- packets are assigned sequences strictly in order of arrival
3306:
3307: -- When a lock on gl_concurrency_control is not available then
3308: --
3309: -- if Funds Checker is invoked from a Concurrent Process, it waits
3310: --
3311: -- if Funds Checker is invoked from an Online Process, it exits with

Line 3357: -- Commit to release Lock on gl_concurrency_control

3353: psa_utils.debug_other_string(g_state_level,l_full_path,
3354: ' insert gl_bc_packet_arrival_order -> ' || SQL%ROWCOUNT);
3355: -- ========================= FND LOG =============================
3356:
3357: -- Commit to release Lock on gl_concurrency_control
3358: commit;
3359:
3360:
3361: -- Since the previous Commit has also released the lock on gl_bc_dual2, we