APPS.PSA_FUNDS_CHECKER_PKG dependencies on GL_CONCURRENCY_CONTROL

Line 274: /* GL_CONCURRENCY_CONTROL */

270: /* GL_BC_OPTION_DETAILS */
271: /* GL_BC_PERIOD_MAP */
272: /* GL_BC_DUAL */
273: /* GL_BC_DUAL2 */
274: /* GL_CONCURRENCY_CONTROL */
275: /* GL_PERIOD_STATUSES */
276: /* GL_LOOKUPS */
277: /* GL_USSGL_TRANSACTION_CODES */
278: /* GL_USSGL_ACCOUNT_PAIRS */

Line 2799: from gl_concurrency_control ct

2795: from dual;
2796:
2797: cursor lock_gl_conc_ctrl is
2798: select 'Obtain Row Share Lock on the corresponding record for this Set of Books'
2799: from gl_concurrency_control ct
2800: where ct.concurrency_class = 'INSERT_PACKET_ARRIVAL'
2801: and ct.concurrency_entity_name = 'SET_OF_BOOKS'
2802: and ct.concurrency_entity_id = to_char(g_ledger_id)
2803: FOR UPDATE;

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

3290:
3291: -- Insert Arrival Sequence for the Packet. The Row Share Lock ensures that
3292: -- packets are assigned sequences strictly in order of arrival
3293:
3294: -- When a lock on gl_concurrency_control is not available then
3295: --
3296: -- if Funds Checker is invoked from a Concurrent Process, it waits
3297: --
3298: -- if Funds Checker is invoked from an Online Process, it exits with

Line 3344: -- Commit to release Lock on gl_concurrency_control

3340: psa_utils.debug_other_string(g_state_level,l_full_path,
3341: ' insert gl_bc_packet_arrival_order -> ' || SQL%ROWCOUNT);
3342: -- ========================= FND LOG =============================
3343:
3344: -- Commit to release Lock on gl_concurrency_control
3345: commit;
3346:
3347:
3348: -- Since the previous Commit has also released the lock on gl_bc_dual2, we