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_PACKET_ARRIVAL_ORDER

Line 143: g_arrival_seq gl_bc_packet_arrival_order.arrival_seq%TYPE;

139: g_append_je_flag BOOLEAN;
140:
141: g_summarized_flag BOOLEAN;
142:
143: g_arrival_seq gl_bc_packet_arrival_order.arrival_seq%TYPE;
144:
145: g_no_msg_tokens NUMBER;
146:
147: g_requery_flag BOOLEAN;

Line 268: /* GL_BC_PACKET_ARRIVAL_ORDER */

264: /* */
265: /* GL Tables which are being used include : */
266: /* */
267: /* GL_BC_PACKETS */
268: /* GL_BC_PACKET_ARRIVAL_ORDER */
269: /* GL_BC_OPTIONS */
270: /* GL_BC_OPTION_DETAILS */
271: /* GL_BC_PERIOD_MAP */
272: /* GL_BC_DUAL */

Line 2794: select gl_bc_packet_arrival_order_s.nextval

2790: sql_bcp VARCHAR2(5000);
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'

Line 3324: insert into gl_bc_packet_arrival_order

3320: -- =========================== FND LOG ===========================
3321: psa_utils.debug_other_string(g_state_level,l_full_path, ' g_arrival_seq -> ' || g_arrival_seq);
3322: -- ========================= FND LOG =============================
3323:
3324: insert into gl_bc_packet_arrival_order
3325: (packet_id,
3326: ledger_id,
3327: arrival_seq,
3328: affect_funds_flag,

Line 3341: ' insert gl_bc_packet_arrival_order -> ' || SQL%ROWCOUNT);

3337:
3338:
3339: -- =========================== FND LOG ===========================
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;

Line 3435: -- table gl_bc_packet_arrival_order. This will then be used in the following

3431:
3432:
3433: -- Bug 3574935 .. Start
3434: -- Obtain the maximum packet_id less than the current arrival sequence from
3435: -- table gl_bc_packet_arrival_order. This will then be used in the following
3436: -- UPDATE statement to help improve performance of the query. Making use of
3437: -- packet_id condition in the subquery makes index gl_bc_packets_n2 more
3438: -- selective and reduces number of rows processed during access to the table
3439: -- gl_bc_packet_arrival_order

Line 3439: -- gl_bc_packet_arrival_order

3435: -- table gl_bc_packet_arrival_order. This will then be used in the following
3436: -- UPDATE statement to help improve performance of the query. Making use of
3437: -- packet_id condition in the subquery makes index gl_bc_packets_n2 more
3438: -- selective and reduces number of rows processed during access to the table
3439: -- gl_bc_packet_arrival_order
3440:
3441: -- Bug 4651919 .. Start
3442: -- Added ledger_id and affect_funds_flag conditions in WHERE clause
3443:

Line 3446: -- FROM gl_bc_packet_arrival_order

3442: -- Added ledger_id and affect_funds_flag conditions in WHERE clause
3443:
3444: -- Bug 6823089.
3445: -- SELECT max(packet_id) INTO l_max_packet_id
3446: -- FROM gl_bc_packet_arrival_order
3447: -- WHERE arrival_seq < g_arrival_seq
3448: -- AND ledger_id = g_ledger_id;
3449: -- AND affect_funds_flag = 'Y';
3450:

Line 3598: gl_bc_packet_arrival_order ao

3594: from gl_period_statuses ps,
3595: gl_budgets bd,
3596: gl_budget_versions bv,
3597: gl_bc_packets pk,
3598: gl_bc_packet_arrival_order ao
3599: where ps.application_id = 101
3600: and ps.ledger_id = g_ledger_id
3601: and ps.period_name = bd.last_valid_period_name
3602: and bd.budget_name = bv.budget_name

Line 6380: -- the associated Arrival Order record in gl_bc_packet_arrival_order

6376: -- called before any commit that would otherwise confirm the final Funds
6377: -- Check Status of the packet
6378:
6379: -- This Module deletes all transaction lines of a packet in gl_bc_packets and
6380: -- the associated Arrival Order record in gl_bc_packet_arrival_order
6381:
6382: -- This Module also deletes the corresponding records for a packet being
6383: -- Unreserved
6384:

Line 6418: delete from gl_bc_packet_arrival_order ao

6414: ' delete from gl_bc_packets ' || SQL%ROWCOUNT);
6415: -- ========================= FND LOG ===========================
6416:
6417: -- Delete Packet Arrival Order Record
6418: delete from gl_bc_packet_arrival_order ao
6419: where ao.packet_id in (p_packetid, p_packetid_ursvd);
6420:
6421: -- ========================= FND LOG ===========================
6422: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 6423: ' delete from gl_bc_packet_arrival_order ' || SQL%ROWCOUNT);

6419: where ao.packet_id in (p_packetid, p_packetid_ursvd);
6420:
6421: -- ========================= FND LOG ===========================
6422: psa_utils.debug_other_string(g_state_level,l_full_path,
6423: ' delete from gl_bc_packet_arrival_order ' || SQL%ROWCOUNT);
6424: -- ========================= FND LOG ===========================
6425:
6426: EXCEPTION
6427:

Line 6464: delete from gl_bc_packet_arrival_order ao

6460: ' delete from gl_bc_packets ' || SQL%ROWCOUNT);
6461: -- ========================= FND LOG ===========================
6462:
6463: -- Delete Packet Arrival Order Record
6464: delete from gl_bc_packet_arrival_order ao
6465: where ao.packet_id in (select packet_id
6466: from gl_bc_packets
6467: where event_id = p_eventid);
6468:

Line 6471: ' delete from gl_bc_packet_arrival_order ' || SQL%ROWCOUNT);

6467: where event_id = p_eventid);
6468:
6469: -- ========================= FND LOG ===========================
6470: psa_utils.debug_other_string(g_state_level,l_full_path,
6471: ' delete from gl_bc_packet_arrival_order ' || SQL%ROWCOUNT);
6472: -- ========================= FND LOG ===========================
6473:
6474: -- Delete History Record
6475: delete from gl_bc_packets_hists bp

Line 6502: -- updates affect_funds_flag in gl_bc_packet_arrival_order to 'N' so that

6498:
6499: -- Update Status Code for Transactions to Fatal
6500:
6501: -- Updates Status Code for all transactions in the Packet to 'T'; it also
6502: -- updates affect_funds_flag in gl_bc_packet_arrival_order to 'N' so that
6503: -- the available Funds calculation of packets arriving later is not affected
6504: -- in case an irrecoverable error halts Funds Check. SQLs for updating the
6505: -- columns are not guaranteed to succeed in many drastic cases. However, this
6506: -- step tries to ensure that the current packet does not affect the Funds

Line 6539: update gl_bc_packet_arrival_order ao

6535: ' update gl_bc_packets with T -> ' || SQL%ROWCOUNT );
6536: -- ========================= FND LOG ===========================
6537:
6538: -- Update Affect Funds Flag
6539: update gl_bc_packet_arrival_order ao
6540: set ao.affect_funds_flag = 'N'
6541: where ao.packet_id = g_packet_id;
6542:
6543: -- ========================= FND LOG ===========================

Line 6545: ' update gl_bc_packet_arrival_order to N -> ' || SQL%ROWCOUNT );

6541: where ao.packet_id = g_packet_id;
6542:
6543: -- ========================= FND LOG ===========================
6544: psa_utils.debug_other_string(g_state_level,l_full_path,
6545: ' update gl_bc_packet_arrival_order to N -> ' || SQL%ROWCOUNT );
6546: -- ========================= FND LOG ===========================
6547:
6548: if not glrchk('Z') then
6549: -- ========================= FND LOG ===========================

Line 6789: update gl_bc_packet_arrival_order ao

6785: if ((g_fcmode <> 'C') and
6786: (g_return_code = 'F')) then
6787: begin
6788:
6789: update gl_bc_packet_arrival_order ao
6790: set ao.affect_funds_flag = 'N'
6791: where ao.packet_id = g_packet_id;
6792:
6793: -- ========================= FND LOG ===========================

Line 6795: ' update gl_bc_packet_arrival_order -> ' || SQL%ROWCOUNT);

6791: where ao.packet_id = g_packet_id;
6792:
6793: -- ========================= FND LOG ===========================
6794: psa_utils.debug_other_string(g_state_level,l_full_path,
6795: ' update gl_bc_packet_arrival_order -> ' || SQL%ROWCOUNT);
6796: -- ========================= FND LOG ===========================
6797:
6798: -- Commit so that a later rollback does not reset this flag
6799: commit;

Line 8784: GL_BC_PACKET_ARRIVAL_ORDER AO,

8780: min(BP.application_id)
8781: FROM
8782: GL_ACCOUNT_HIERARCHIES AH,
8783: GL_BC_PACKETS BP,
8784: GL_BC_PACKET_ARRIVAL_ORDER AO,
8785: GL_SUMMARY_TEMPLATES ST,
8786: GL_SUMMARY_BC_OPTIONS SB,
8787: GL_BUDGETS B,
8788: GL_BUDGET_VERSIONS BV,

Line 8933: GL_BC_PACKET_ARRIVAL_ORDER AO,

8929: min(BP.application_id)
8930: FROM
8931: GL_ACCOUNT_HIERARCHIES AH,
8932: GL_BC_PACKETS BP,
8933: GL_BC_PACKET_ARRIVAL_ORDER AO,
8934: GL_SUMMARY_TEMPLATES ST,
8935: GL_SUMMARY_BC_OPTIONS SB,
8936: GL_BUDGETS B,
8937: GL_BUDGET_VERSIONS BV,

Line 9048: gl_bc_packet_arrival_order ao,

9044: )
9045: )
9046: FROM gl_bc_packets bp,
9047: gl_account_hierarchies ah,
9048: gl_bc_packet_arrival_order ao,
9049: gl_summary_templates st,
9050: gl_summary_bc_options sb,
9051: gl_budgets b,
9052: gl_budget_versions bv,

Line 9123: FROM gl_bc_packet_arrival_order ao

9119: WHERE bp.ledger_id = p_ledger_id
9120: AND bp.template_id = p_curr_temp_id
9121: AND bp.packet_id IN (
9122: SELECT ao.packet_id
9123: FROM gl_bc_packet_arrival_order ao
9124: WHERE ao.ledger_id = p_ledger_id
9125: AND ao.affect_funds_flag = 'Y')
9126: AND NOT EXISTS (
9127: SELECT 'Y'

Line 10911: UPDATE gl_bc_packet_arrival_order

10907: END IF;
10908:
10909: IF (l_success_evt_exist = 'N') THEN
10910:
10911: UPDATE gl_bc_packet_arrival_order
10912: SET affect_funds_flag = 'N'
10913: WHERE affect_funds_flag = 'Y'
10914: AND packet_id IN ( SELECT packet_id
10915: FROM gl_bc_packets bc

Line 10924: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated GL_BC_PACKET_ARRIVAL_ORDER '||sql%rowcount||

10920: AND result_code IN ('F81', 'F82')
10921: ) ;
10922:
10923: -- ====== FND LOG ======
10924: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated GL_BC_PACKET_ARRIVAL_ORDER '||sql%rowcount||
10925: ' rows.');
10926: -- ====== FND LOG ======
10927:
10928: