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_JE_BATCHES

Line 295: /* GL_JE_BATCHES */

291: /* GL_BUDGETS */
292: /* GL_BUDGET_VERSIONS */
293: /* GL_BUDGET_ASSIGNMENTS */
294: /* GL_BUDGET_PERIOD_RANGES */
295: /* GL_JE_BATCHES */
296: /* GL_JE_HEADERS */
297: /* GL_JE_LINES */
298: /* GL_SETS_OF_BOOKS */
299: /* GL_CODE_COMBINATIONS */

Line 5514: select gl_je_batches_s.nextval

5510: where bp.packet_id = g_packet_id
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

Line 5547: l_approval_status_code gl_je_batches.approval_status_code%type;

5543:
5544: l_je_source je_source%rowtype;
5545: l_enable_app enable_approval%rowtype;
5546: l_je_approval je_approval%rowtype;
5547: l_approval_status_code gl_je_batches.approval_status_code%type;
5548: l_reversal_method VARCHAR2(1);
5549: l_seg_val_ret_code NUMBER;
5550: l_avoid_copying_attr VARCHAR2(1);
5551:

Line 5851: update gl_je_batches jb

5847:
5848: -- Update Batch Control Total, Running Totals, Budgetary Control Status and
5849: -- Packet ID
5850:
5851: update gl_je_batches jb
5852: set (jb.control_total,
5853: jb.running_total_dr,
5854: jb.running_total_cr,
5855: jb.running_total_accounted_dr,

Line 5882: ' Update gl_je_batches - Batch Control Total, Running Totals, ' ||

5878: where jb.je_batch_id = l_je_batch_id;
5879:
5880: -- ========================= FND LOG ===========================
5881: psa_utils.debug_other_string(g_state_level,l_full_path,
5882: ' Update gl_je_batches - Batch Control Total, Running Totals, ' ||
5883: ' Budgetary Control Status ' || SQL%ROWCOUNT);
5884: psa_utils.debug_other_string(g_state_level,l_full_path, ' goto normal_exit label ');
5885: -- ========================= FND LOG ===========================
5886:

Line 5949: insert into gl_je_batches

5945: ' l_approval_status_code -> '|| l_approval_status_code);
5946: -- ========================= FND LOG ===========================
5947:
5948: -- Create new Actual Batch for the Generated Transactions
5949: insert into gl_je_batches
5950: (je_batch_id,
5951: last_update_date,
5952: last_updated_by,
5953: set_of_books_id_11i,

Line 6006: gl_je_batches jb

6002: min(jb.period_set_name),
6003: min(jb.accounted_period_type)
6004: from gl_period_statuses ps,
6005: gl_bc_packets bp,
6006: gl_je_batches jb
6007: where ps.application_id = 101
6008: and ps.ledger_id = g_ledger_id
6009: and ps.period_name = bp.period_name
6010: and bp.packet_id = g_packet_id

Line 6017: ' Creating new actual bacth - gl_je_batches -> '|| SQL%ROWCOUNT);

6013:
6014:
6015: -- ========================= FND LOG ===========================
6016: psa_utils.debug_other_string(g_state_level,l_full_path,
6017: ' Creating new actual bacth - gl_je_batches -> '|| SQL%ROWCOUNT);
6018: -- ========================= FND LOG ===========================
6019:
6020:
6021: -- ========================= FND LOG ===========================

Line 6386: delete from gl_je_batches jb

6382: -- Delete the associated batch of the generated transactions
6383:
6384: FOR x IN generated_bat
6385: LOOP
6386: delete from gl_je_batches jb
6387: where jb.je_batch_id = x.je_batch_id;
6388:
6389: -- ========================= FND LOG ===========================
6390: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 6391: ' Delete gl_je_batches - ' || SQL%ROWCOUNT);

6387: where jb.je_batch_id = x.je_batch_id;
6388:
6389: -- ========================= FND LOG ===========================
6390: psa_utils.debug_other_string(g_state_level,l_full_path,
6391: ' Delete gl_je_batches - ' || SQL%ROWCOUNT);
6392: psa_utils.debug_other_string(g_state_level,l_full_path, ' RETURN - TRUE ');
6393: -- ========================= FND LOG ===========================
6394:
6395: -- Invoke the GL API to fix the GL_JE_SEGMENT_VALUES table

Line 7801: gl_je_batches B,

7797: B.je_batch_id,
7798: substrb(B.name,1,88)
7799: FROM
7800: gl_je_headers H,
7801: gl_je_batches B,
7802: gl_automatic_posting_options O,
7803: gl_automatic_posting_sets S
7804: WHERE
7805: S.autopost_set_id = p_autopost_set_id

Line 7850: gl_je_batches b,

7846: b.je_batch_id,
7847: substrb(b.name,1,88)
7848: FROM
7849: gl_je_headers h,
7850: gl_je_batches b,
7851: gl_automatic_posting_options o,
7852: gl_automatic_posting_sets s
7853: WHERE
7854: s.autopost_set_id = p_autopost_set_id

Line 7916: l_actual_flag gl_je_batches.actual_flag%TYPE;

7912: l_autopost_set_name gl_automatic_posting_sets.autopost_set_name%TYPE;
7913: l_appl_id fnd_application.application_id%TYPE;
7914: l_resp_id fnd_responsibility.responsibility_id%TYPE;
7915: l_user_id fnd_user.user_id%TYPE;
7916: l_actual_flag gl_je_batches.actual_flag%TYPE;
7917: l_source_name gl_je_headers.je_source%TYPE;
7918: l_period_name gl_je_batches.default_period_name%TYPE;
7919: l_je_batch_id gl_je_batches.je_batch_id%TYPE;
7920: l_batch_name gl_je_batches.name%TYPE;

Line 7918: l_period_name gl_je_batches.default_period_name%TYPE;

7914: l_resp_id fnd_responsibility.responsibility_id%TYPE;
7915: l_user_id fnd_user.user_id%TYPE;
7916: l_actual_flag gl_je_batches.actual_flag%TYPE;
7917: l_source_name gl_je_headers.je_source%TYPE;
7918: l_period_name gl_je_batches.default_period_name%TYPE;
7919: l_je_batch_id gl_je_batches.je_batch_id%TYPE;
7920: l_batch_name gl_je_batches.name%TYPE;
7921: l_packet_id gl_bc_packets.packet_id%TYPE;
7922: l_main_stmt varchar2(4000);

Line 7919: l_je_batch_id gl_je_batches.je_batch_id%TYPE;

7915: l_user_id fnd_user.user_id%TYPE;
7916: l_actual_flag gl_je_batches.actual_flag%TYPE;
7917: l_source_name gl_je_headers.je_source%TYPE;
7918: l_period_name gl_je_batches.default_period_name%TYPE;
7919: l_je_batch_id gl_je_batches.je_batch_id%TYPE;
7920: l_batch_name gl_je_batches.name%TYPE;
7921: l_packet_id gl_bc_packets.packet_id%TYPE;
7922: l_main_stmt varchar2(4000);
7923: l_tmp_stmt varchar2(4000);

Line 7920: l_batch_name gl_je_batches.name%TYPE;

7916: l_actual_flag gl_je_batches.actual_flag%TYPE;
7917: l_source_name gl_je_headers.je_source%TYPE;
7918: l_period_name gl_je_batches.default_period_name%TYPE;
7919: l_je_batch_id gl_je_batches.je_batch_id%TYPE;
7920: l_batch_name gl_je_batches.name%TYPE;
7921: l_packet_id gl_bc_packets.packet_id%TYPE;
7922: l_main_stmt varchar2(4000);
7923: l_tmp_stmt varchar2(4000);
7924: l_action_stmt varchar2(4000);

Line 8379: gl_je_batches

8375: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: l_glxfck_return_code -> '||l_glxfck_return_code);
8376: -- =========================== FND LOG =============================
8377: BEGIN
8378: UPDATE
8379: gl_je_batches
8380: SET
8381: budgetary_control_status = decode(l_check_flag, 'R',
8382: decode (l_glxfck_return_code,
8383: 'S', 'P',

Line 8403: 'Funds C/R: Failed to update budgetary_control_status for gl_je_batches');

8399: EXCEPTION
8400: WHEN OTHERS THEN
8401: -- =========================== FND LOG ===========================
8402: psa_utils.debug_other_string(g_excep_level,l_full_path,
8403: 'Funds C/R: Failed to update budgetary_control_status for gl_je_batches');
8404: fnd_file.put_line(fnd_file.log,
8405: 'Funds C/R: Failed to update budgetary_control_status for gl_je_batches');
8406: -- ========================= FND LOG =============================
8407: END;

Line 8405: 'Funds C/R: Failed to update budgetary_control_status for gl_je_batches');

8401: -- =========================== FND LOG ===========================
8402: psa_utils.debug_other_string(g_excep_level,l_full_path,
8403: 'Funds C/R: Failed to update budgetary_control_status for gl_je_batches');
8404: fnd_file.put_line(fnd_file.log,
8405: 'Funds C/R: Failed to update budgetary_control_status for gl_je_batches');
8406: -- ========================= FND LOG =============================
8407: END;
8408:
8409: BEGIN

Line 8440: gl_lookups l, gl_je_batches b

8436: l.meaning
8437: INTO
8438: l_jmeaning
8439: FROM
8440: gl_lookups l, gl_je_batches b
8441: WHERE
8442: l.lookup_code = b.budgetary_control_status
8443: AND l.lookup_type = 'JE_BATCH_BC_STATUS'
8444: AND b.je_batch_id = l_bc_pkts(x).je_batch_id;

Line 8450: 'Funds C/R: Failed to fetch meaning from gl_je_batches');

8446: EXCEPTION
8447: WHEN OTHERS THEN
8448: -- =========================== FND LOG ===========================
8449: psa_utils.debug_other_string(g_excep_level,l_full_path,
8450: 'Funds C/R: Failed to fetch meaning from gl_je_batches');
8451: fnd_file.put_line(fnd_file.log,
8452: 'Funds C/R: Failed to fetch meaning from gl_be_batches');
8453: -- ========================= FND LOG =============================
8454: END;