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 DUAL

Line 283: /* GL_BC_DUAL */

279: /* GL_BC_PACKET_ARRIVAL_ORDER */
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 */

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 1772: from dual

1768: segment30 gl_code_combinations.segment30%TYPE;
1769:
1770: cursor ussgl is
1771: select 'USSGL Rows need to be created'
1772: from dual
1773: where exists
1774: (
1775: select 'Transaction with USSGL Code'
1776: from gl_bc_packets bp

Line 1783: from dual

1779: );
1780:
1781: cursor append_je is
1782: select 'Associated Generated JEs to be appended or inserted'
1783: from dual
1784: where exists
1785: (
1786: select 'Associated Generated Row from existing GL Batch'
1787: from gl_bc_packets bp

Line 2546: from dual;

2542: FUNCTION glxfiu RETURN BOOLEAN IS
2543:
2544: cursor pkt_id is
2545: select gl_bc_packets_s.nextval
2546: from dual;
2547:
2548: l_dummy VARCHAR2(80);
2549:
2550: -- ========================= FND LOG ===========================

Line 2729: DUAL

2725: 'There are USSGL rows in the packet'
2726: INTO
2727: l_dummy
2728: FROM
2729: DUAL
2730: WHERE EXISTS
2731: (
2732: SELECT
2733: 'Record with non-null USSGL transaction code'

Line 2806: from dual;

2802: str_bc_option_id VARCHAR2(128);
2803:
2804: cursor arrseq is
2805: select gl_bc_packet_arrival_order_s.nextval
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

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 3493: -- Lock dummy table gl_bc_dual in Row Share Mode to ensure Read Consistency

3489: -- =========================== FND LOG ===========================
3490: -- psa_utils.debug_other_string(g_state_level,l_full_path, ' l_max_packet_id -> '|| l_max_packet_id );
3491: -- ========================= FND LOG =============================
3492:
3493: -- Lock dummy table gl_bc_dual in Row Share Mode to ensure Read Consistency
3494: -- between gl_bc_packets and gl_balances in the next two balance update
3495: -- SQLs. This scheme requires posting to lock gl_bc_dual in exclusive mode
3496: -- before it commits, and to wait in a sleep cycle of 15 seconds until all
3497: -- the Funds Check processes release the locks. This prevents the Funds

Line 3495: -- SQLs. This scheme requires posting to lock gl_bc_dual in exclusive mode

3491: -- ========================= FND LOG =============================
3492:
3493: -- Lock dummy table gl_bc_dual in Row Share Mode to ensure Read Consistency
3494: -- between gl_bc_packets and gl_balances in the next two balance update
3495: -- SQLs. This scheme requires posting to lock gl_bc_dual in exclusive mode
3496: -- before it commits, and to wait in a sleep cycle of 15 seconds until all
3497: -- the Funds Check processes release the locks. This prevents the Funds
3498: -- Checker from counting the Balances twice, in case Posting Commits in
3499: -- between the two SQLs, and some of the pending balances got transferred

Line 3503: -- When a lock on gl_bc_dual is not available then

3499: -- between the two SQLs, and some of the pending balances got transferred
3500: -- to gl_balances, where the funds checker would mistakenly treat them as
3501: -- Posted Balances in the second SQL
3502:
3503: -- When a lock on gl_bc_dual is not available then
3504: --
3505: -- if Funds Checker is invoked from a Concurrent Process, it waits
3506: --
3507: -- if Funds Checker is invoked from an Online Process, it exits with

Line 3513: -- ' Lock table gl_bc_dual in exclusive mode' );

3509: --Commented out below section for bug 9907009. Changed lock mode to row share.
3510: -- if g_conc_flag then
3511: -- =========================== FND LOG ===========================
3512: -- psa_utils.debug_other_string(g_state_level,l_full_path,
3513: -- ' Lock table gl_bc_dual in exclusive mode' );
3514: -- ========================= FND LOG =============================
3515: -- LOCK TABLE gl_bc_dual IN EXCLUSIVE MODE; --Bug 7476309
3516: -- else
3517: -- =========================== FND LOG ===========================

Line 3515: -- LOCK TABLE gl_bc_dual IN EXCLUSIVE MODE; --Bug 7476309

3511: -- =========================== FND LOG ===========================
3512: -- psa_utils.debug_other_string(g_state_level,l_full_path,
3513: -- ' Lock table gl_bc_dual in exclusive mode' );
3514: -- ========================= FND LOG =============================
3515: -- LOCK TABLE gl_bc_dual IN EXCLUSIVE MODE; --Bug 7476309
3516: -- else
3517: -- =========================== FND LOG ===========================
3518: -- psa_utils.debug_other_string(g_state_level,l_full_path,
3519: -- ' Lock table gl_bc_dual in exclusive mode NOWAIT' );

Line 3519: -- ' Lock table gl_bc_dual in exclusive mode NOWAIT' );

3515: -- LOCK TABLE gl_bc_dual IN EXCLUSIVE MODE; --Bug 7476309
3516: -- else
3517: -- =========================== FND LOG ===========================
3518: -- psa_utils.debug_other_string(g_state_level,l_full_path,
3519: -- ' Lock table gl_bc_dual in exclusive mode NOWAIT' );
3520: -- ========================= FND LOG =============================
3521: -- LOCK TABLE gl_bc_dual IN EXCLUSIVE MODE NOWAIT; --Bug 7476309
3522: -- end if;
3523: -- Added below section for bug 9907009.

Line 3521: -- LOCK TABLE gl_bc_dual IN EXCLUSIVE MODE NOWAIT; --Bug 7476309

3517: -- =========================== FND LOG ===========================
3518: -- psa_utils.debug_other_string(g_state_level,l_full_path,
3519: -- ' Lock table gl_bc_dual in exclusive mode NOWAIT' );
3520: -- ========================= FND LOG =============================
3521: -- LOCK TABLE gl_bc_dual IN EXCLUSIVE MODE NOWAIT; --Bug 7476309
3522: -- end if;
3523: -- Added below section for bug 9907009.
3524:
3525: IF g_conc_flag THEN

Line 3527: LOCK TABLE gl_bc_dual IN ROW SHARE MODE;

3523: -- Added below section for bug 9907009.
3524:
3525: IF g_conc_flag THEN
3526:
3527: LOCK TABLE gl_bc_dual IN ROW SHARE MODE;
3528: -- =========================== FND LOG ===========================
3529: psa_utils.debug_other_string(g_state_level,l_full_path,
3530: ' Lock table gl_bc_dual in row share mode' );
3531: -- ========================= FND LOG =============================

Line 3530: ' Lock table gl_bc_dual in row share mode' );

3526:
3527: LOCK TABLE gl_bc_dual IN ROW SHARE MODE;
3528: -- =========================== FND LOG ===========================
3529: psa_utils.debug_other_string(g_state_level,l_full_path,
3530: ' Lock table gl_bc_dual in row share mode' );
3531: -- ========================= FND LOG =============================
3532: ELSE
3533: LOOP
3534: BEGIN

Line 3537: ' Lock table gl_bc_dual in row share mode NOWAIT, Try count left '||l_psa_max_lock_wait_count );

3533: LOOP
3534: BEGIN
3535: -- =========================== FND LOG ===========================
3536: psa_utils.debug_other_string(g_state_level,l_full_path,
3537: ' Lock table gl_bc_dual in row share mode NOWAIT, Try count left '||l_psa_max_lock_wait_count );
3538: -- ========================= FND LOG =============================
3539: LOCK TABLE gl_bc_dual IN ROW SHARE MODE NOWAIT;
3540: exit;
3541:

Line 3539: LOCK TABLE gl_bc_dual IN ROW SHARE MODE NOWAIT;

3535: -- =========================== FND LOG ===========================
3536: psa_utils.debug_other_string(g_state_level,l_full_path,
3537: ' Lock table gl_bc_dual in row share mode NOWAIT, Try count left '||l_psa_max_lock_wait_count );
3538: -- ========================= FND LOG =============================
3539: LOCK TABLE gl_bc_dual IN ROW SHARE MODE NOWAIT;
3540: exit;
3541:
3542: EXCEPTION when resource_busy then
3543: -- =========================== FND LOG ===========================

Line 3555: fnd_file.put_line(fnd_file.output, 'Failed to acquire lock on gl_bc_dual table');

3551: -- =========================== FND LOG ===========================
3552: psa_utils.debug_other_string(g_state_level,l_full_path,
3553: ' PSA_MAX_LOCK_WAIT_COUNT reached, raising resource_busy exception');
3554: -- ========================= FND LOG =============================
3555: fnd_file.put_line(fnd_file.output, 'Failed to acquire lock on gl_bc_dual table');
3556: fnd_file.put_line(fnd_file.output, 'Increase the following profile values and retry.');
3557: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Retry Count');
3558: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Wait Interval');
3559: RAISE resource_busy;

Line 3557: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Retry Count');

3553: ' PSA_MAX_LOCK_WAIT_COUNT reached, raising resource_busy exception');
3554: -- ========================= FND LOG =============================
3555: fnd_file.put_line(fnd_file.output, 'Failed to acquire lock on gl_bc_dual table');
3556: fnd_file.put_line(fnd_file.output, 'Increase the following profile values and retry.');
3557: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Retry Count');
3558: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Wait Interval');
3559: RAISE resource_busy;
3560: END IF;
3561: END;

Line 3558: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Wait Interval');

3554: -- ========================= FND LOG =============================
3555: fnd_file.put_line(fnd_file.output, 'Failed to acquire lock on gl_bc_dual table');
3556: fnd_file.put_line(fnd_file.output, 'Increase the following profile values and retry.');
3557: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Retry Count');
3558: fnd_file.put_line(fnd_file.output, 'PSA: Budgetary Control Acquire Dual Lock Wait Interval');
3559: RAISE resource_busy;
3560: END IF;
3561: END;
3562: END LOOP;

Line 3965: -- Commit to release Lock on gl_bc_dual

3961: psa_utils.debug_other_string(g_state_level,l_full_path,
3962: ' Update posted balance in gl_bc_packets ' || SQL%ROWCOUNT );
3963: -- ========================= FND LOG =============================
3964:
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

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 =============================

Line 5012: -- e.g individual lines with Pxx result codes within a

5008: -- Checking C (Checking) F (Failure) F (Failed Check)
5009: --
5010: -- NOTE: When Partial Reservation is not allowed, all transactions
5011: -- in a packet are updated to the same Status Code.
5012: -- e.g individual lines with Pxx result codes within a
5013: -- Failure packet get R (Rejected) Status Codes
5014: --
5015: -- (II) For return code P(Partial) :
5016: --

Line 5515: from dual;

5511: and bp.ussgl_link_to_parent_id is not null;
5512:
5513: cursor batch_id is
5514: select gl_je_batches_s.nextval
5515: from dual;
5516:
5517: cursor enable_approval is
5518: SELECT enable_je_approval_flag
5519: FROM gl_ledgers_public_v

Line 7157: from dual

7153:
7154:
7155: cursor append_je is
7156: select 'Associated Generated JEs to be appended or inserted'
7157: from dual
7158: where exists
7159: (
7160: select 'Associated Generated Row from existing GL Batch'
7161: from gl_bc_packets bp

Line 7736: from dual;

7732:
7733: l_full_path := g_path||'Get_Packet_Id';
7734:
7735: select gl_bc_packets_s.nextval into l_pkt_id
7736: from dual;
7737:
7738: -- =========================== FND LOG ===========================
7739: psa_utils.debug_other_string(g_state_level,l_full_path, ' l_pkt_id -> ' || l_pkt_id);
7740: -- ========================= FND LOG =============================

Line 8017: dual;

8013: TO_CHAR(SYSDATE, 'DD-MON-YY HH24:MI')
8014: INTO
8015: l_date
8016: FROM
8017: dual;
8018:
8019: --The xml reporting variables.
8020: l_header := true;
8021: l_xml_f_b_header := true;

Line 9837: FROM DUAL;

9833: SELECT (SELECT COUNT (*)
9834: FROM xla_events_gt) event_count,
9835: (SELECT COUNT (DISTINCT (event_id))
9836: FROM xla_ae_lines_gt) ae_event_count
9837: FROM DUAL;
9838:
9839: -- check whether allocation attributes are used or not
9840: /* This is to avoid additional processing for allocation attributes
9841: if they are NOT used. */

Line 9845: FROM DUAL

9841: if they are NOT used. */
9842: CURSOR c_chk_alloc_used(p_ledgerid NUMBER) is
9843: SELECT
9844: 'Allocation attributes are used'
9845: FROM DUAL
9846: WHERE EXISTS
9847: (
9848: SELECT
9849: 'Related transaction allocation setup exists'

Line 10033: FROM DUAL

10029: p_session_id NUMBER,
10030: p_serial_id NUMBER)
10031: IS
10032: SELECT 'Funds Failure for hierarchy'
10033: FROM DUAL
10034: WHERE EXISTS
10035: (SELECT 'X' FROM GL_BC_PACKETS
10036: WHERE (ae_header_id, ae_line_num, event_id)
10037: IN (select ae_header_id, ae_line_num, event_id