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 272: /* GL_BC_DUAL */

268: /* GL_BC_PACKET_ARRIVAL_ORDER */
269: /* GL_BC_OPTIONS */
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 */

Line 273: /* GL_BC_DUAL2 */

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

Line 1761: from dual

1757: segment30 gl_code_combinations.segment30%TYPE;
1758:
1759: cursor ussgl is
1760: select 'USSGL Rows need to be created'
1761: from dual
1762: where exists
1763: (
1764: select 'Transaction with USSGL Code'
1765: from gl_bc_packets bp

Line 1772: from dual

1768: );
1769:
1770: cursor append_je is
1771: select 'Associated Generated JEs to be appended or inserted'
1772: from dual
1773: where exists
1774: (
1775: select 'Associated Generated Row from existing GL Batch'
1776: from gl_bc_packets bp

Line 2535: from dual;

2531: FUNCTION glxfiu RETURN BOOLEAN IS
2532:
2533: cursor pkt_id is
2534: select gl_bc_packets_s.nextval
2535: from dual;
2536:
2537: l_dummy VARCHAR2(80);
2538:
2539: -- ========================= FND LOG ===========================

Line 2718: DUAL

2714: 'There are USSGL rows in the packet'
2715: INTO
2716: l_dummy
2717: FROM
2718: DUAL
2719: WHERE EXISTS
2720: (
2721: SELECT
2722: 'Record with non-null USSGL transaction code'

Line 2795: from dual;

2791: str_bc_option_id VARCHAR2(128);
2792:
2793: cursor arrseq is
2794: select gl_bc_packet_arrival_order_s.nextval
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

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

3086: end if; -- g_fcmode <> 'U'
3087:
3088:
3089: -- Prior to inserting Summary Transactions for the packet, we lock the
3090: -- dummy table gl_bc_dual2 in row share mode to ensure data consistency
3091: -- between the Funds Checker Summarization and the Add/Delete Summary
3092: -- Accounts process. This ensures that that only one process will
3093: -- summarize the transactions in the queue
3094:

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

3091: -- between the Funds Checker Summarization and the Add/Delete Summary
3092: -- Accounts process. This ensures that that only one process will
3093: -- summarize the transactions in the queue
3094:
3095: -- When a lock on gl_bc_dual2 is not available then
3096: --
3097: -- if Funds Checker is invoked from a Concurrent Process, it waits
3098: --
3099: -- if Funds Checker is invoked from an Online Process, it exits with

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

3102:
3103: if g_conc_flag then
3104: -- =========================== FND LOG ===========================
3105: psa_utils.debug_other_string(g_state_level,l_full_path,
3106: ' Lock gl_bc_dual2 in row share mode' );
3107: -- ========================= FND LOG =============================
3108: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE;
3109: else
3110: -- =========================== FND LOG ===========================

Line 3108: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE;

3104: -- =========================== FND LOG ===========================
3105: psa_utils.debug_other_string(g_state_level,l_full_path,
3106: ' Lock gl_bc_dual2 in row share mode' );
3107: -- ========================= FND LOG =============================
3108: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE;
3109: else
3110: -- =========================== FND LOG ===========================
3111: psa_utils.debug_other_string(g_state_level,l_full_path,
3112: ' Lock gl_bc_dual2 in row share mode nowait' );

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

3108: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE;
3109: else
3110: -- =========================== FND LOG ===========================
3111: psa_utils.debug_other_string(g_state_level,l_full_path,
3112: ' Lock gl_bc_dual2 in row share mode nowait' );
3113: -- ========================= FND LOG =============================
3114: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT;
3115: end if;
3116:

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

3110: -- =========================== FND LOG ===========================
3111: psa_utils.debug_other_string(g_state_level,l_full_path,
3112: ' Lock gl_bc_dual2 in row share mode nowait' );
3113: -- ========================= FND LOG =============================
3114: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT;
3115: end if;
3116:
3117:
3118: -- Insert Summary Transactions for the Packet. Summarization Grouping is

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

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
3349: -- need to reestablish the lock to maintain data consistency between the
3350: -- Funds Checker Summarization and the Add/Delete Summary Accounts
3351: -- process
3352:

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

3351: -- process
3352:
3353: -- =========================== FND LOG ===========================
3354: psa_utils.debug_other_string(g_state_level,l_full_path,
3355: ' lock table gl_bc_dual2 in row share mode nowait');
3356: -- ========================= FND LOG =============================
3357:
3358: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT;
3359:

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

3354: psa_utils.debug_other_string(g_state_level,l_full_path,
3355: ' lock table gl_bc_dual2 in row share mode nowait');
3356: -- ========================= FND LOG =============================
3357:
3358: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT;
3359:
3360: -- =========================== FND LOG ===========================
3361: psa_utils.debug_other_string(g_state_level,l_full_path,
3362: ' RETURN -> TRUE ');

Line 3459: -- Lock dummy table gl_bc_dual in Row Share Mode to ensure Read Consistency

3455: -- =========================== FND LOG ===========================
3456: -- psa_utils.debug_other_string(g_state_level,l_full_path, ' l_max_packet_id -> '|| l_max_packet_id );
3457: -- ========================= FND LOG =============================
3458:
3459: -- Lock dummy table gl_bc_dual in Row Share Mode to ensure Read Consistency
3460: -- between gl_bc_packets and gl_balances in the next two balance update
3461: -- SQLs. This scheme requires posting to lock gl_bc_dual in exclusive mode
3462: -- before it commits, and to wait in a sleep cycle of 15 seconds until all
3463: -- the Funds Check processes release the locks. This prevents the Funds

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

3457: -- ========================= FND LOG =============================
3458:
3459: -- Lock dummy table gl_bc_dual in Row Share Mode to ensure Read Consistency
3460: -- between gl_bc_packets and gl_balances in the next two balance update
3461: -- SQLs. This scheme requires posting to lock gl_bc_dual in exclusive mode
3462: -- before it commits, and to wait in a sleep cycle of 15 seconds until all
3463: -- the Funds Check processes release the locks. This prevents the Funds
3464: -- Checker from counting the Balances twice, in case Posting Commits in
3465: -- between the two SQLs, and some of the pending balances got transferred

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

3465: -- between the two SQLs, and some of the pending balances got transferred
3466: -- to gl_balances, where the funds checker would mistakenly treat them as
3467: -- Posted Balances in the second SQL
3468:
3469: -- When a lock on gl_bc_dual is not available then
3470: --
3471: -- if Funds Checker is invoked from a Concurrent Process, it waits
3472: --
3473: -- if Funds Checker is invoked from an Online Process, it exits with

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

3475:
3476: if g_conc_flag then
3477: -- =========================== FND LOG ===========================
3478: psa_utils.debug_other_string(g_state_level,l_full_path,
3479: ' Lock table gl_bc_dual in row share mode' );
3480: -- ========================= FND LOG =============================
3481: LOCK TABLE gl_bc_dual IN ROW SHARE MODE;
3482: else
3483: -- =========================== FND LOG ===========================

Line 3481: LOCK TABLE gl_bc_dual IN ROW SHARE MODE;

3477: -- =========================== FND LOG ===========================
3478: psa_utils.debug_other_string(g_state_level,l_full_path,
3479: ' Lock table gl_bc_dual in row share mode' );
3480: -- ========================= FND LOG =============================
3481: LOCK TABLE gl_bc_dual IN ROW SHARE MODE;
3482: else
3483: -- =========================== FND LOG ===========================
3484: psa_utils.debug_other_string(g_state_level,l_full_path,
3485: ' Lock table gl_bc_dual in row share mode NOWAIT' );

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

3481: LOCK TABLE gl_bc_dual IN ROW SHARE MODE;
3482: else
3483: -- =========================== FND LOG ===========================
3484: psa_utils.debug_other_string(g_state_level,l_full_path,
3485: ' Lock table gl_bc_dual in row share mode NOWAIT' );
3486: -- ========================= FND LOG =============================
3487: LOCK TABLE gl_bc_dual IN ROW SHARE MODE NOWAIT;
3488: end if;
3489:

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

3483: -- =========================== FND LOG ===========================
3484: psa_utils.debug_other_string(g_state_level,l_full_path,
3485: ' Lock table gl_bc_dual in row share mode NOWAIT' );
3486: -- ========================= FND LOG =============================
3487: LOCK TABLE gl_bc_dual IN ROW SHARE MODE NOWAIT;
3488: end if;
3489:
3490:
3491: -- Update Approved and Pending Balances in gl_bc_packets

Line 3890: -- Commit to release Lock on gl_bc_dual

3886: psa_utils.debug_other_string(g_state_level,l_full_path,
3887: ' Update posted balance in gl_bc_packets ' || SQL%ROWCOUNT );
3888: -- ========================= FND LOG =============================
3889:
3890: -- Commit to release Lock on gl_bc_dual
3891: commit;
3892:
3893:
3894: -- Reestablish the Row Share Lock on gl_bc_dual2 to maintain data

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

3890: -- Commit to release Lock on gl_bc_dual
3891: commit;
3892:
3893:
3894: -- Reestablish the Row Share Lock on gl_bc_dual2 to maintain data
3895: -- consistency between the Funds Checker Summarization and the Add/Delete
3896: -- Summary Accounts program
3897:
3898: -- =========================== FND LOG ===========================

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

3896: -- Summary Accounts program
3897:
3898: -- =========================== FND LOG ===========================
3899: psa_utils.debug_other_string(g_state_level,l_full_path,
3900: ' Lock table gl_bc_dual2 in row share mode nowait' );
3901: -- ========================= FND LOG =============================
3902: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT;
3903:
3904: -- =========================== FND LOG ===========================

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

3898: -- =========================== FND LOG ===========================
3899: psa_utils.debug_other_string(g_state_level,l_full_path,
3900: ' Lock table gl_bc_dual2 in row share mode nowait' );
3901: -- ========================= FND LOG =============================
3902: LOCK TABLE gl_bc_dual2 IN ROW SHARE MODE NOWAIT;
3903:
3904: -- =========================== FND LOG ===========================
3905: psa_utils.debug_other_string(g_state_level,l_full_path,' RETURN -> TRUE ' );
3906: -- ========================= FND LOG =============================

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

4933: -- Checking C (Checking) F (Failure) F (Failed Check)
4934: --
4935: -- NOTE: When Partial Reservation is not allowed, all transactions
4936: -- in a packet are updated to the same Status Code.
4937: -- e.g individual lines with Pxx result codes within a
4938: -- Failure packet get R (Rejected) Status Codes
4939: --
4940: -- (II) For return code P(Partial) :
4941: --

Line 5440: from dual;

5436: and bp.ussgl_link_to_parent_id is not null;
5437:
5438: cursor batch_id is
5439: select gl_je_batches_s.nextval
5440: from dual;
5441:
5442: cursor enable_approval is
5443: SELECT enable_je_approval_flag
5444: FROM gl_ledgers_public_v

Line 7082: from dual

7078:
7079:
7080: cursor append_je is
7081: select 'Associated Generated JEs to be appended or inserted'
7082: from dual
7083: where exists
7084: (
7085: select 'Associated Generated Row from existing GL Batch'
7086: from gl_bc_packets bp

Line 7550: from dual;

7546:
7547: l_full_path := g_path||'Get_Packet_Id';
7548:
7549: select gl_bc_packets_s.nextval into l_pkt_id
7550: from dual;
7551:
7552: -- =========================== FND LOG ===========================
7553: psa_utils.debug_other_string(g_state_level,l_full_path, ' l_pkt_id -> ' || l_pkt_id);
7554: -- ========================= FND LOG =============================

Line 7831: dual;

7827: TO_CHAR(SYSDATE, 'DD-MON-YY HH24:MI')
7828: INTO
7829: l_date
7830: FROM
7831: dual;
7832:
7833: --The xml reporting variables.
7834: l_header := true;
7835: l_xml_f_b_header := true;

Line 9566: FROM DUAL;

9562: SELECT (SELECT COUNT (*)
9563: FROM xla_events_gt) event_count,
9564: (SELECT COUNT (DISTINCT (event_id))
9565: FROM xla_ae_lines_gt) ae_event_count
9566: FROM DUAL;
9567:
9568: -- check whether allocation attributes are used or not
9569: /* This is to avoid additional processing for allocation attributes
9570: if they are NOT used. */

Line 9574: FROM DUAL

9570: if they are NOT used. */
9571: CURSOR c_chk_alloc_used is
9572: SELECT
9573: 'Allocation attributes are used'
9574: FROM DUAL
9575: WHERE EXISTS
9576: (
9577: SELECT
9578: 'Related transaction allocation setup exists'

Line 9758: FROM DUAL

9754: p_session_id NUMBER,
9755: p_serial_id NUMBER)
9756: IS
9757: SELECT 'Funds Failure for hierarchy'
9758: FROM DUAL
9759: WHERE EXISTS
9760: (SELECT 'X' FROM GL_BC_PACKETS
9761: WHERE (ae_header_id, ae_line_num, event_id)
9762: IN (select ae_header_id, ae_line_num, event_id