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 284: /* GL_JE_BATCHES */

280: /* GL_BUDGETS */
281: /* GL_BUDGET_VERSIONS */
282: /* GL_BUDGET_ASSIGNMENTS */
283: /* GL_BUDGET_PERIOD_RANGES */
284: /* GL_JE_BATCHES */
285: /* GL_JE_HEADERS */
286: /* GL_JE_LINES */
287: /* GL_SETS_OF_BOOKS */
288: /* GL_CODE_COMBINATIONS */

Line 5439: select gl_je_batches_s.nextval

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

Line 5472: l_approval_status_code gl_je_batches.approval_status_code%type;

5468:
5469: l_je_source je_source%rowtype;
5470: l_enable_app enable_approval%rowtype;
5471: l_je_approval je_approval%rowtype;
5472: l_approval_status_code gl_je_batches.approval_status_code%type;
5473: l_reversal_method VARCHAR2(1);
5474: l_seg_val_ret_code NUMBER;
5475: l_avoid_copying_attr VARCHAR2(1);
5476:

Line 5776: update gl_je_batches jb

5772:
5773: -- Update Batch Control Total, Running Totals, Budgetary Control Status and
5774: -- Packet ID
5775:
5776: update gl_je_batches jb
5777: set (jb.control_total,
5778: jb.running_total_dr,
5779: jb.running_total_cr,
5780: jb.running_total_accounted_dr,

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

5803: where jb.je_batch_id = l_je_batch_id;
5804:
5805: -- ========================= FND LOG ===========================
5806: psa_utils.debug_other_string(g_state_level,l_full_path,
5807: ' Update gl_je_batches - Batch Control Total, Running Totals, ' ||
5808: ' Budgetary Control Status ' || SQL%ROWCOUNT);
5809: psa_utils.debug_other_string(g_state_level,l_full_path, ' goto normal_exit label ');
5810: -- ========================= FND LOG ===========================
5811:

Line 5874: insert into gl_je_batches

5870: ' l_approval_status_code -> '|| l_approval_status_code);
5871: -- ========================= FND LOG ===========================
5872:
5873: -- Create new Actual Batch for the Generated Transactions
5874: insert into gl_je_batches
5875: (je_batch_id,
5876: last_update_date,
5877: last_updated_by,
5878: set_of_books_id_11i,

Line 5931: gl_je_batches jb

5927: min(jb.period_set_name),
5928: min(jb.accounted_period_type)
5929: from gl_period_statuses ps,
5930: gl_bc_packets bp,
5931: gl_je_batches jb
5932: where ps.application_id = 101
5933: and ps.ledger_id = g_ledger_id
5934: and ps.period_name = bp.period_name
5935: and bp.packet_id = g_packet_id

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

5938:
5939:
5940: -- ========================= FND LOG ===========================
5941: psa_utils.debug_other_string(g_state_level,l_full_path,
5942: ' Creating new actual bacth - gl_je_batches -> '|| SQL%ROWCOUNT);
5943: -- ========================= FND LOG ===========================
5944:
5945:
5946: -- ========================= FND LOG ===========================

Line 6311: delete from gl_je_batches jb

6307: -- Delete the associated batch of the generated transactions
6308:
6309: FOR x IN generated_bat
6310: LOOP
6311: delete from gl_je_batches jb
6312: where jb.je_batch_id = x.je_batch_id;
6313:
6314: -- ========================= FND LOG ===========================
6315: psa_utils.debug_other_string(g_state_level,l_full_path,

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

6312: where jb.je_batch_id = x.je_batch_id;
6313:
6314: -- ========================= FND LOG ===========================
6315: psa_utils.debug_other_string(g_state_level,l_full_path,
6316: ' Delete gl_je_batches - ' || SQL%ROWCOUNT);
6317: psa_utils.debug_other_string(g_state_level,l_full_path, ' RETURN - TRUE ');
6318: -- ========================= FND LOG ===========================
6319:
6320: -- Invoke the GL API to fix the GL_JE_SEGMENT_VALUES table

Line 7615: gl_je_batches B,

7611: B.je_batch_id,
7612: substrb(B.name,1,88)
7613: FROM
7614: gl_je_headers H,
7615: gl_je_batches B,
7616: gl_automatic_posting_options O,
7617: gl_automatic_posting_sets S
7618: WHERE
7619: S.autopost_set_id = p_autopost_set_id

Line 7664: gl_je_batches b,

7660: b.je_batch_id,
7661: substrb(b.name,1,88)
7662: FROM
7663: gl_je_headers h,
7664: gl_je_batches b,
7665: gl_automatic_posting_options o,
7666: gl_automatic_posting_sets s
7667: WHERE
7668: s.autopost_set_id = p_autopost_set_id

Line 7730: l_actual_flag gl_je_batches.actual_flag%TYPE;

7726: l_autopost_set_name gl_automatic_posting_sets.autopost_set_name%TYPE;
7727: l_appl_id fnd_application.application_id%TYPE;
7728: l_resp_id fnd_responsibility.responsibility_id%TYPE;
7729: l_user_id fnd_user.user_id%TYPE;
7730: l_actual_flag gl_je_batches.actual_flag%TYPE;
7731: l_source_name gl_je_headers.je_source%TYPE;
7732: l_period_name gl_je_batches.default_period_name%TYPE;
7733: l_je_batch_id gl_je_batches.je_batch_id%TYPE;
7734: l_batch_name gl_je_batches.name%TYPE;

Line 7732: l_period_name gl_je_batches.default_period_name%TYPE;

7728: l_resp_id fnd_responsibility.responsibility_id%TYPE;
7729: l_user_id fnd_user.user_id%TYPE;
7730: l_actual_flag gl_je_batches.actual_flag%TYPE;
7731: l_source_name gl_je_headers.je_source%TYPE;
7732: l_period_name gl_je_batches.default_period_name%TYPE;
7733: l_je_batch_id gl_je_batches.je_batch_id%TYPE;
7734: l_batch_name gl_je_batches.name%TYPE;
7735: l_packet_id gl_bc_packets.packet_id%TYPE;
7736: l_main_stmt varchar2(4000);

Line 7733: l_je_batch_id gl_je_batches.je_batch_id%TYPE;

7729: l_user_id fnd_user.user_id%TYPE;
7730: l_actual_flag gl_je_batches.actual_flag%TYPE;
7731: l_source_name gl_je_headers.je_source%TYPE;
7732: l_period_name gl_je_batches.default_period_name%TYPE;
7733: l_je_batch_id gl_je_batches.je_batch_id%TYPE;
7734: l_batch_name gl_je_batches.name%TYPE;
7735: l_packet_id gl_bc_packets.packet_id%TYPE;
7736: l_main_stmt varchar2(4000);
7737: l_tmp_stmt varchar2(4000);

Line 7734: l_batch_name gl_je_batches.name%TYPE;

7730: l_actual_flag gl_je_batches.actual_flag%TYPE;
7731: l_source_name gl_je_headers.je_source%TYPE;
7732: l_period_name gl_je_batches.default_period_name%TYPE;
7733: l_je_batch_id gl_je_batches.je_batch_id%TYPE;
7734: l_batch_name gl_je_batches.name%TYPE;
7735: l_packet_id gl_bc_packets.packet_id%TYPE;
7736: l_main_stmt varchar2(4000);
7737: l_tmp_stmt varchar2(4000);
7738: l_action_stmt varchar2(4000);

Line 8193: gl_je_batches

8189: psa_utils.debug_other_string(g_state_level,l_full_path, 'Funds C/R: l_glxfck_return_code -> '||l_glxfck_return_code);
8190: -- =========================== FND LOG =============================
8191: BEGIN
8192: UPDATE
8193: gl_je_batches
8194: SET
8195: budgetary_control_status = decode(l_check_flag, 'R',
8196: decode (l_glxfck_return_code,
8197: 'S', 'P',

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

8213: EXCEPTION
8214: WHEN OTHERS THEN
8215: -- =========================== FND LOG ===========================
8216: psa_utils.debug_other_string(g_excep_level,l_full_path,
8217: 'Funds C/R: Failed to update budgetary_control_status for gl_je_batches');
8218: fnd_file.put_line(fnd_file.log,
8219: 'Funds C/R: Failed to update budgetary_control_status for gl_je_batches');
8220: -- ========================= FND LOG =============================
8221: END;

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

8215: -- =========================== FND LOG ===========================
8216: psa_utils.debug_other_string(g_excep_level,l_full_path,
8217: 'Funds C/R: Failed to update budgetary_control_status for gl_je_batches');
8218: fnd_file.put_line(fnd_file.log,
8219: 'Funds C/R: Failed to update budgetary_control_status for gl_je_batches');
8220: -- ========================= FND LOG =============================
8221: END;
8222:
8223: BEGIN

Line 8254: gl_lookups l, gl_je_batches b

8250: l.meaning
8251: INTO
8252: l_jmeaning
8253: FROM
8254: gl_lookups l, gl_je_batches b
8255: WHERE
8256: l.lookup_code = b.budgetary_control_status
8257: AND l.lookup_type = 'JE_BATCH_BC_STATUS'
8258: AND b.je_batch_id = l_bc_pkts(x).je_batch_id;

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

8260: EXCEPTION
8261: WHEN OTHERS THEN
8262: -- =========================== FND LOG ===========================
8263: psa_utils.debug_other_string(g_excep_level,l_full_path,
8264: 'Funds C/R: Failed to fetch meaning from gl_je_batches');
8265: fnd_file.put_line(fnd_file.log,
8266: 'Funds C/R: Failed to fetch meaning from gl_be_batches');
8267: -- ========================= FND LOG =============================
8268: END;