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_LOOKUPS

Line 287: /* GL_LOOKUPS */

283: /* GL_BC_DUAL */
284: /* GL_BC_DUAL2 */
285: /* GL_CONCURRENCY_CONTROL */
286: /* GL_PERIOD_STATUSES */
287: /* GL_LOOKUPS */
288: /* GL_USSGL_TRANSACTION_CODES */
289: /* GL_USSGL_ACCOUNT_PAIRS */
290: /* GL_BALANCES */
291: /* GL_BUDGETS */

Line 2158: ' from gl_lookups lu, ' ||

2154:
2155: if g_reverse_tc_flag = 'N' then
2156:
2157: sql_ussgl := sql_ussgl ||
2158: ' from gl_lookups lu, ' ||
2159: 'gl_ussgl_transaction_codes uc, ' ||
2160: 'gl_ussgl_account_pairs guap, ' ||
2161: 'gl_code_combinations ccg, ' ||
2162: 'gl_code_combinations cco, ' ||

Line 2194: ' from gl_lookups lu, ' ||

2190: else
2191:
2192: sql_ussgl := sql_ussgl ||
2193:
2194: ' from gl_lookups lu, ' ||
2195: 'gl_ussgl_transaction_codes uc, ' ||
2196: 'gl_ussgl_account_pairs guap, ' ||
2197: 'gl_code_combinations ccg, ' ||
2198: 'gl_code_combinations cco, ' ||

Line 7946: l_line_description gl_lookups.description%TYPE;

7942: l_je_header_id gl_je_headers.je_header_id%TYPE;
7943: l_je_line_num gl_je_lines.je_line_num%TYPE;
7944: l_entered_dr gl_je_lines.entered_dr%TYPE;
7945: l_entered_cr gl_je_lines.entered_cr%TYPE;
7946: l_line_description gl_lookups.description%TYPE;
7947: l_line_result_code gl_bc_packets.result_code%TYPE;
7948: l_ccid gl_je_lines.code_combination_id%TYPE;
7949: l_rowid varchar2(100);
7950: l_priority gl_lookups.meaning%TYPE;

Line 7950: l_priority gl_lookups.meaning%TYPE;

7946: l_line_description gl_lookups.description%TYPE;
7947: l_line_result_code gl_bc_packets.result_code%TYPE;
7948: l_ccid gl_je_lines.code_combination_id%TYPE;
7949: l_rowid varchar2(100);
7950: l_priority gl_lookups.meaning%TYPE;
7951: l_je_seg_stmt varchar2(4000);
7952: l_je_sum_flex varchar2(4000);
7953: l_je_bud_stmt varchar2(4000);
7954: l_je_bud_flex varchar2(4000);

Line 7958: l_je_bud_desc gl_lookups.description%TYPE;

7954: l_je_bud_flex varchar2(4000);
7955: l_je_bud_dr gl_bc_packets.entered_dr%TYPE;
7956: l_je_bud_cr gl_bc_packets.entered_cr%TYPE;
7957: l_je_bud_result_code gl_bc_packets.result_code%TYPE;
7958: l_je_bud_desc gl_lookups.description%TYPE;
7959: l_je_bud_ccid gl_code_combinations.code_combination_id%TYPE;
7960: l_ussgl_parent_id gl_bc_packets.ussgl_parent_id%TYPE;
7961: l_je_bud_seg_stmt varchar2(4000);
7962: l_je_bud_sum_flex varchar2(4000);

Line 8415: gl_lookups

8411: meaning
8412: INTO
8413: l_fmeaning
8414: FROM
8415: gl_lookups
8416: WHERE
8417: lookup_code = l_glxfck_return_code
8418: AND lookup_type = 'FUNDS_CHECK_RETURN_CODE';
8419: EXCEPTION

Line 8423: 'Funds C/R: Failed to fetch meaning from gl_lookups');

8419: EXCEPTION
8420: WHEN OTHERS THEN
8421: -- =========================== FND LOG ===========================
8422: psa_utils.debug_other_string(g_excep_level,l_full_path,
8423: 'Funds C/R: Failed to fetch meaning from gl_lookups');
8424: fnd_file.put_line(fnd_file.log,
8425: 'Funds C/R: Failed to fetch meaning from gl_lookups');
8426: -- ========================= FND LOG =============================
8427: END;

Line 8425: 'Funds C/R: Failed to fetch meaning from gl_lookups');

8421: -- =========================== FND LOG ===========================
8422: psa_utils.debug_other_string(g_excep_level,l_full_path,
8423: 'Funds C/R: Failed to fetch meaning from gl_lookups');
8424: fnd_file.put_line(fnd_file.log,
8425: 'Funds C/R: Failed to fetch meaning from gl_lookups');
8426: -- ========================= FND LOG =============================
8427: END;
8428:
8429: -- =========================== FND LOG ===========================

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 8528: 'gl_lookups lk, gl_bc_packets p '||

8524: l_je_stmt := l_je_stmt||', SUBSTRB(h.name,1,20), h.je_header_id, l.je_line_num, l.entered_dr, '||
8525: 'l.entered_cr, lk.description, p.result_code, l.code_combination_id, '||
8526: 'p.rowid '||
8527: 'FROM gl_je_lines l, gl_je_headers h, gl_code_combinations c, '||
8528: 'gl_lookups lk, gl_bc_packets p '||
8529: 'WHERE p.je_batch_id = '||l_failed_bc_pkts(x).je_batch_id||
8530: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8531: ' and p.ledger_id = '||l_ledger_id||
8532: ' and p.je_header_id = h.je_header_id'||

Line 8567: gl_lookups l

8563: l.meaning
8564: INTO
8565: l_priority
8566: FROM
8567: gl_lookups l
8568: WHERE
8569: l.lookup_type = 'BC_SEVERITY_FLAG'
8570: AND l.lookup_code = upper(substr(l_line_result_code,1,1));
8571:

Line 8575: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Funds C/R: Failed to fetch meaning from gl_lookups');

8571:
8572: EXCEPTION
8573: WHEN OTHERS THEN
8574: -- =========================== FND LOG ===========================
8575: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Funds C/R: Failed to fetch meaning from gl_lookups');
8576: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch meaning from gl_lookups');
8577: -- ========================= FND LOG =============================
8578: END;
8579:

Line 8576: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch meaning from gl_lookups');

8572: EXCEPTION
8573: WHEN OTHERS THEN
8574: -- =========================== FND LOG ===========================
8575: psa_utils.debug_other_string(g_excep_level,l_full_path, 'Funds C/R: Failed to fetch meaning from gl_lookups');
8576: fnd_file.put_line(fnd_file.log, 'Funds C/R: Failed to fetch meaning from gl_lookups');
8577: -- ========================= FND LOG =============================
8578: END;
8579:
8580:

Line 8707: ' gl_lookups l WHERE p.ussgl_link_to_parent_id = '||l_ussgl_parent_id||

8703: END;
8704:
8705: l_je_bud_stmt := l_je_bud_stmt||' , p.entered_dr, p.entered_cr, p.result_code, l.description, '||
8706: ' c.code_combination_id FROM gl_code_combinations c, gl_bc_packets p, '||
8707: ' gl_lookups l WHERE p.ussgl_link_to_parent_id = '||l_ussgl_parent_id||
8708: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8709: ' and c.code_combination_id = p.code_combination_id'||
8710: ' and p.result_code between ''F00'' AND ''F30'' and '||
8711: ' p.result_code = l.lookup_code and l.lookup_type = ''FUNDS_CHECK_RESULT_CODE'' '||