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.PSA_FUNDS_CHECKER_PKG dependencies on GL_BC_DUAL2

Line 284: /* GL_BC_DUAL2 */

280: /* GL_BC_OPTIONS */
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 */

Line 3103: -- dummy table gl_bc_dual2 in row share mode to ensure data consistency

3099: end if; -- g_fcmode <> 'U'
3100:
3101:
3102: -- Prior to inserting Summary Transactions for the packet, we lock the
3103: -- dummy table gl_bc_dual2 in row share mode to ensure data consistency
3104: -- between the Funds Checker Summarization and the Add/Delete Summary
3105: -- Accounts process. This ensures that that only one process will
3106: -- summarize the transactions in the queue
3107:

Line 3108: -- When a lock on gl_bc_dual2 is not available then

3104: -- between the Funds Checker Summarization and the Add/Delete Summary
3105: -- Accounts process. This ensures that that only one process will
3106: -- summarize the transactions in the queue
3107:
3108: -- When a lock on gl_bc_dual2 is not available then
3109: --
3110: -- if Funds Checker is invoked from a Concurrent Process, it waits
3111: --
3112: -- if Funds Checker is invoked from an Online Process, it exits with

Line 3119: ' Lock gl_bc_dual2 in row share mode' );

3115:
3116: if g_conc_flag then
3117: -- =========================== FND LOG ===========================
3118: psa_utils.debug_other_string(g_state_level,l_full_path,
3119: ' Lock gl_bc_dual2 in row share mode' );
3120: -- ========================= FND LOG =============================
3121: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE;
3122: else
3123: -- =========================== FND LOG ===========================

Line 3121: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE;

3117: -- =========================== FND LOG ===========================
3118: psa_utils.debug_other_string(g_state_level,l_full_path,
3119: ' Lock gl_bc_dual2 in row share mode' );
3120: -- ========================= FND LOG =============================
3121: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE;
3122: else
3123: -- =========================== FND LOG ===========================
3124: psa_utils.debug_other_string(g_state_level,l_full_path,
3125: ' Lock gl_bc_dual2 in row share mode nowait' );

Line 3125: ' Lock gl_bc_dual2 in row share mode nowait' );

3121: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE;
3122: else
3123: -- =========================== FND LOG ===========================
3124: psa_utils.debug_other_string(g_state_level,l_full_path,
3125: ' Lock gl_bc_dual2 in row share mode nowait' );
3126: -- ========================= FND LOG =============================
3127: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT;
3128: end if;
3129:

Line 3127: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT;

3123: -- =========================== FND LOG ===========================
3124: psa_utils.debug_other_string(g_state_level,l_full_path,
3125: ' Lock gl_bc_dual2 in row share mode nowait' );
3126: -- ========================= FND LOG =============================
3127: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT;
3128: end if;
3129:
3130:
3131: -- Insert Summary Transactions for the Packet. Summarization Grouping is

Line 3361: -- Since the previous Commit has also released the lock on gl_bc_dual2, we

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
3362: -- need to reestablish the lock to maintain data consistency between the
3363: -- Funds Checker Summarization and the Add/Delete Summary Accounts
3364: -- process
3365:

Line 3368: ' lock table gl_bc_dual2 in row share mode nowait');

3364: -- process
3365:
3366: -- =========================== FND LOG ===========================
3367: psa_utils.debug_other_string(g_state_level,l_full_path,
3368: ' lock table gl_bc_dual2 in row share mode nowait');
3369: -- ========================= FND LOG =============================
3370:
3371: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT;
3372:

Line 3371: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT;

3367: psa_utils.debug_other_string(g_state_level,l_full_path,
3368: ' lock table gl_bc_dual2 in row share mode nowait');
3369: -- ========================= FND LOG =============================
3370:
3371: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT;
3372:
3373: -- =========================== FND LOG ===========================
3374: psa_utils.debug_other_string(g_state_level,l_full_path,
3375: ' RETURN -> TRUE ');

Line 3969: -- Reestablish the Row Share Lock on gl_bc_dual2 to maintain data

3965: -- Commit to release Lock on gl_bc_dual
3966: -- commit; Commented for Bug 7476309
3967:
3968:
3969: -- Reestablish the Row Share Lock on gl_bc_dual2 to maintain data
3970: -- consistency between the Funds Checker Summarization and the Add/Delete
3971: -- Summary Accounts program
3972:
3973: -- =========================== FND LOG ===========================

Line 3975: -- ' Lock table gl_bc_dual2 in row share mode nowait' ); --Commented for Bug 7476309

3971: -- Summary Accounts program
3972:
3973: -- =========================== FND LOG ===========================
3974: -- psa_utils.debug_other_string(g_state_level,l_full_path,
3975: -- ' Lock table gl_bc_dual2 in row share mode nowait' ); --Commented for Bug 7476309
3976: -- ========================= FND LOG =============================
3977: -- LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT; --Commented for Bug 7476309
3978:
3979: -- =========================== FND LOG ===========================

Line 3977: -- LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT; --Commented for Bug 7476309

3973: -- =========================== FND LOG ===========================
3974: -- psa_utils.debug_other_string(g_state_level,l_full_path,
3975: -- ' Lock table gl_bc_dual2 in row share mode nowait' ); --Commented for Bug 7476309
3976: -- ========================= FND LOG =============================
3977: -- LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT; --Commented for Bug 7476309
3978:
3979: -- =========================== FND LOG ===========================
3980: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN -> TRUE ' );
3981: -- ========================= FND LOG =============================