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

275: /* */
276: /* GL Tables which are being used include : */
277: /* */
278: /* GL_BC_PACKETS */
279: /* GL_BC_PACKET_ARRIVAL_ORDER */
280: /* GL_BC_OPTIONS */
281: /* GL_BC_OPTION_DETAILS */
282: /* GL_BC_PERIOD_MAP */
283: /* GL_BC_DUAL */

Line 2805: select gl_bc_packet_arrival_order_s.nextval

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

Line 3337: insert into gl_bc_packet_arrival_order

3333: -- =========================== FND LOG ===========================
3334: psa_utils.debug_other_string(g_state_level,l_full_path, ' g_arrival_seq -> ' || g_arrival_seq);
3335: -- ========================= FND LOG =============================
3336:
3337: insert into gl_bc_packet_arrival_order
3338: (packet_id,
3339: ledger_id,
3340: arrival_seq,
3341: affect_funds_flag,

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

3350:
3351:
3352: -- =========================== FND LOG ===========================
3353: psa_utils.debug_other_string(g_state_level,l_full_path,
3354: ' insert gl_bc_packet_arrival_order -> ' || SQL%ROWCOUNT);
3355: -- ========================= FND LOG =============================
3356:
3357: -- Commit to release Lock on gl_concurrency_control
3358: commit;

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

3465: -- ========================= FND LOG =============================
3466:
3467: -- Bug 3574935 .. Start
3468: -- Obtain the maximum packet_id less than the current arrival sequence from
3469: -- table gl_bc_packet_arrival_order. This will then be used in the following
3470: -- UPDATE statement to help improve performance of the query. Making use of
3471: -- packet_id condition in the subquery makes index gl_bc_packets_n2 more
3472: -- selective and reduces number of rows processed during access to the table
3473: -- gl_bc_packet_arrival_order

Line 3473: -- gl_bc_packet_arrival_order

3469: -- table gl_bc_packet_arrival_order. This will then be used in the following
3470: -- UPDATE statement to help improve performance of the query. Making use of
3471: -- packet_id condition in the subquery makes index gl_bc_packets_n2 more
3472: -- selective and reduces number of rows processed during access to the table
3473: -- gl_bc_packet_arrival_order
3474:
3475: -- Bug 4651919 .. Start
3476: -- Added ledger_id and affect_funds_flag conditions in WHERE clause
3477:

Line 3480: -- FROM gl_bc_packet_arrival_order

3476: -- Added ledger_id and affect_funds_flag conditions in WHERE clause
3477:
3478: -- Bug 6823089.
3479: -- SELECT max(packet_id) INTO l_max_packet_id
3480: -- FROM gl_bc_packet_arrival_order
3481: -- WHERE arrival_seq < g_arrival_seq
3482: -- AND ledger_id = g_ledger_id;
3483: -- AND affect_funds_flag = 'Y';
3484:

Line 3672: gl_bc_packet_arrival_order ao

3668: from gl_period_statuses ps,
3669: gl_budgets bd,
3670: gl_budget_versions bv,
3671: gl_bc_packets pk,
3672: gl_bc_packet_arrival_order ao
3673: where ps.application_id = 101
3674: and ps.ledger_id = g_ledger_id
3675: and ps.period_name = bd.last_valid_period_name
3676: and bd.budget_name = bv.budget_name

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

6451: -- called before any commit that would otherwise confirm the final Funds
6452: -- Check Status of the packet
6453:
6454: -- This Module deletes all transaction lines of a packet in gl_bc_packets and
6455: -- the associated Arrival Order record in gl_bc_packet_arrival_order
6456:
6457: -- This Module also deletes the corresponding records for a packet being
6458: -- Unreserved
6459:

Line 6493: delete from gl_bc_packet_arrival_order ao

6489: ' delete from gl_bc_packets ' || SQL%ROWCOUNT);
6490: -- ========================= FND LOG ===========================
6491:
6492: -- Delete Packet Arrival Order Record
6493: delete from gl_bc_packet_arrival_order ao
6494: where ao.packet_id in (p_packetid, p_packetid_ursvd);
6495:
6496: -- ========================= FND LOG ===========================
6497: psa_utils.debug_other_string(g_state_level,l_full_path,

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

6494: where ao.packet_id in (p_packetid, p_packetid_ursvd);
6495:
6496: -- ========================= FND LOG ===========================
6497: psa_utils.debug_other_string(g_state_level,l_full_path,
6498: ' delete from gl_bc_packet_arrival_order ' || SQL%ROWCOUNT);
6499: -- ========================= FND LOG ===========================
6500:
6501: EXCEPTION
6502:

Line 6539: delete from gl_bc_packet_arrival_order ao

6535: ' delete from gl_bc_packets ' || SQL%ROWCOUNT);
6536: -- ========================= FND LOG ===========================
6537:
6538: -- Delete Packet Arrival Order Record
6539: delete from gl_bc_packet_arrival_order ao
6540: where ao.packet_id in (select packet_id
6541: from gl_bc_packets
6542: where event_id = p_eventid);
6543:

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

6542: where event_id = p_eventid);
6543:
6544: -- ========================= FND LOG ===========================
6545: psa_utils.debug_other_string(g_state_level,l_full_path,
6546: ' delete from gl_bc_packet_arrival_order ' || SQL%ROWCOUNT);
6547: -- ========================= FND LOG ===========================
6548:
6549: -- Delete History Record
6550: delete from gl_bc_packets_hists bp

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

6573:
6574: -- Update Status Code for Transactions to Fatal
6575:
6576: -- Updates Status Code for all transactions in the Packet to 'T'; it also
6577: -- updates affect_funds_flag in gl_bc_packet_arrival_order to 'N' so that
6578: -- the available Funds calculation of packets arriving later is not affected
6579: -- in case an irrecoverable error halts Funds Check. SQLs for updating the
6580: -- columns are not guaranteed to succeed in many drastic cases. However, this
6581: -- step tries to ensure that the current packet does not affect the Funds

Line 6614: update gl_bc_packet_arrival_order ao

6610: ' update gl_bc_packets with T -> ' || SQL%ROWCOUNT );
6611: -- ========================= FND LOG ===========================
6612:
6613: -- Update Affect Funds Flag
6614: update gl_bc_packet_arrival_order ao
6615: set ao.affect_funds_flag = 'N'
6616: where ao.packet_id = g_packet_id;
6617:
6618: -- ========================= FND LOG ===========================

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

6616: where ao.packet_id = g_packet_id;
6617:
6618: -- ========================= FND LOG ===========================
6619: psa_utils.debug_other_string(g_state_level,l_full_path,
6620: ' update gl_bc_packet_arrival_order to N -> ' || SQL%ROWCOUNT );
6621: -- ========================= FND LOG ===========================
6622:
6623: if not glrchk('Z') then
6624: -- ========================= FND LOG ===========================

Line 6864: update gl_bc_packet_arrival_order ao

6860: if ((g_fcmode <> 'C') and
6861: (g_return_code = 'F')) then
6862: begin
6863:
6864: update gl_bc_packet_arrival_order ao
6865: set ao.affect_funds_flag = 'N'
6866: where ao.packet_id = g_packet_id;
6867:
6868: -- ========================= FND LOG ===========================

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

6866: where ao.packet_id = g_packet_id;
6867:
6868: -- ========================= FND LOG ===========================
6869: psa_utils.debug_other_string(g_state_level,l_full_path,
6870: ' update gl_bc_packet_arrival_order -> ' || SQL%ROWCOUNT);
6871: -- ========================= FND LOG ===========================
6872:
6873: -- Commit so that a later rollback does not reset this flag
6874: commit;

Line 8970: GL_BC_PACKET_ARRIVAL_ORDER AO,

8966: min(BP.application_id)
8967: FROM
8968: GL_ACCOUNT_HIERARCHIES AH,
8969: GL_BC_PACKETS BP,
8970: GL_BC_PACKET_ARRIVAL_ORDER AO,
8971: GL_SUMMARY_TEMPLATES ST,
8972: GL_SUMMARY_BC_OPTIONS SB,
8973: GL_BUDGETS B,
8974: GL_BUDGET_VERSIONS BV,

Line 9119: GL_BC_PACKET_ARRIVAL_ORDER AO,

9115: min(BP.application_id)
9116: FROM
9117: GL_ACCOUNT_HIERARCHIES AH,
9118: GL_BC_PACKETS BP,
9119: GL_BC_PACKET_ARRIVAL_ORDER AO,
9120: GL_SUMMARY_TEMPLATES ST,
9121: GL_SUMMARY_BC_OPTIONS SB,
9122: GL_BUDGETS B,
9123: GL_BUDGET_VERSIONS BV,

Line 9234: gl_bc_packet_arrival_order ao,

9230: )
9231: )
9232: FROM gl_bc_packets bp,
9233: gl_account_hierarchies ah,
9234: gl_bc_packet_arrival_order ao,
9235: gl_summary_templates st,
9236: gl_summary_bc_options sb,
9237: gl_budgets b,
9238: gl_budget_versions bv,

Line 9309: FROM gl_bc_packet_arrival_order ao

9305: WHERE bp.ledger_id = p_ledger_id
9306: AND bp.template_id = p_curr_temp_id
9307: AND bp.packet_id IN (
9308: SELECT ao.packet_id
9309: FROM gl_bc_packet_arrival_order ao
9310: WHERE ao.ledger_id = p_ledger_id
9311: AND ao.affect_funds_flag = 'Y')
9312: AND NOT EXISTS (
9313: SELECT 'Y'

Line 11213: UPDATE gl_bc_packet_arrival_order

11209: END IF;
11210:
11211: IF (l_success_evt_exist = 'N') THEN
11212:
11213: UPDATE gl_bc_packet_arrival_order
11214: SET affect_funds_flag = 'N'
11215: WHERE affect_funds_flag = 'Y'
11216: AND packet_id IN ( SELECT packet_id
11217: FROM gl_bc_packets bc

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

11222: AND result_code IN ('F81', 'F82')
11223: ) ;
11224:
11225: -- ====== FND LOG ======
11226: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated GL_BC_PACKET_ARRIVAL_ORDER '||sql%rowcount||
11227: ' rows.');
11228: -- ====== FND LOG ======
11229:
11230: