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_HEADERS

Line 285: /* GL_JE_HEADERS */

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 */
289: /* GL_ACCOUNT_HIERARCHIES */

Line 5449: FROM GL_JE_HEADERS JH

5445: WHERE ledger_id = g_ledger_id;
5446:
5447: cursor je_source(c_orig_batch_id IN NUMBER) is
5448: SELECT JH.je_source je_source
5449: FROM GL_JE_HEADERS JH
5450: WHERE JH.je_header_id =
5451: (SELECT min(JH1.je_header_id)
5452: FROM GL_JE_HEADERS JH1
5453: WHERE JH1.je_batch_id = c_orig_batch_id);

Line 5452: FROM GL_JE_HEADERS JH1

5448: SELECT JH.je_source je_source
5449: FROM GL_JE_HEADERS JH
5450: WHERE JH.je_header_id =
5451: (SELECT min(JH1.je_header_id)
5452: FROM GL_JE_HEADERS JH1
5453: WHERE JH1.je_batch_id = c_orig_batch_id);
5454:
5455: cursor je_approval (c_je_source IN VARCHAR2) is
5456: SELECT journal_approval_flag

Line 5585: gl_je_headers jh,

5581: 'Y',
5582: BP.ussgl_link_to_parent_id,
5583: 'glxfje() generated: ' || g_packet_id
5584: from gl_period_statuses ps,
5585: gl_je_headers jh,
5586: gl_bc_packets bp
5587: where ps.application_id = 101
5588: and ps.ledger_id = g_ledger_id
5589: and ps.period_name = bp.period_name

Line 5733: update gl_je_headers jh

5729:
5730: -- Update Control Total and Running Totals of all headers with generated
5731: -- transactions appended/deleted
5732:
5733: update gl_je_headers jh
5734: set (jh.control_total,
5735: jh.running_total_dr,
5736: jh.running_total_cr,
5737: jh.running_total_accounted_dr,

Line 5769: ' Update Control Total and Running Totals - gl_je_headers ' || SQL%ROWCOUNT);

5765: );
5766:
5767: -- ========================= FND LOG ===========================
5768: psa_utils.debug_other_string(g_state_level,l_full_path,
5769: ' Update Control Total and Running Totals - gl_je_headers ' || SQL%ROWCOUNT);
5770: -- ========================= FND LOG ===========================
5771:
5772:
5773: -- Update Batch Control Total, Running Totals, Budgetary Control Status and

Line 5954: FROM gl_je_headers

5950: DECLARE
5951:
5952: CURSOR batch_sources IS
5953: SELECT je_header_id, je_category, je_source, period_name
5954: FROM gl_je_headers
5955: WHERE je_batch_id = l_je_batch_id;
5956:
5957: BEGIN
5958: FOR x IN batch_sources

Line 5984: insert into gl_je_headers

5980: return (FALSE);
5981: END IF;
5982:
5983: -- Create associated headers for the new Actual Batch
5984: insert into gl_je_headers
5985: (je_header_id,
5986: last_update_date,
5987: last_updated_by,
5988: ledger_id,

Line 6011: select gl_je_headers_s.nextval,

6007: currency_conversion_date,
6008: attribute1,
6009: accrual_rev_change_sign_flag,
6010: tax_status_code)
6011: select gl_je_headers_s.nextval,
6012: sysdate,
6013: g_user_id,
6014: g_ledger_id,
6015: jh.je_category,

Line 6040: from gl_je_headers jh

6036: sysdate,
6037: to_char(jh.je_header_id),
6038: l_reversal_method,
6039: 'N'
6040: from gl_je_headers jh
6041: where jh.je_batch_id = l_je_batch_id
6042: and jh.je_header_id = x.je_header_id
6043: and exists
6044: (

Line 6056: ' Insert gl_je_headers - Headers for Actual Batches ' || SQL%ROWCOUNT);

6052:
6053:
6054: -- ========================= FND LOG ===========================
6055: psa_utils.debug_other_string(g_state_level,l_full_path,
6056: ' Insert gl_je_headers - Headers for Actual Batches ' || SQL%ROWCOUNT);
6057: -- ========================= FND LOG ===========================
6058: END LOOP;
6059: END;
6060:

Line 6063: update gl_je_headers jh

6059: END;
6060:
6061: -- Update running totals of associated headers
6062:
6063: update gl_je_headers jh
6064: set (jh.running_total_dr,
6065: jh.running_total_cr,
6066: jh.running_total_accounted_dr,
6067: jh.running_total_accounted_cr) =

Line 6083: ' update gl_je_headers - running totals - ' || SQL%ROWCOUNT);

6079: where JH.je_batch_id = l_gen_batch_id;
6080:
6081: -- ========================= FND LOG ===========================
6082: psa_utils.debug_other_string(g_state_level,l_full_path,
6083: ' update gl_je_headers - running totals - ' || SQL%ROWCOUNT);
6084: -- ========================= FND LOG ===========================
6085:
6086: -- Insert generated transactions in packet into gl_je_lines
6087: if (l_avoid_copying_attr = 'Y') then

Line 6131: from gl_je_headers jh,

6127: ' ',
6128: ' ',
6129: 'Y',
6130: 'glxfje() generated: ' || g_packet_id
6131: from gl_je_headers jh,
6132: gl_bc_packets bp
6133: where jh.je_batch_id = l_gen_batch_id
6134: and jh.attribute1 = to_char(bp.je_header_id)
6135: and bp.packet_id = g_packet_id

Line 6205: GL_JE_HEADERS JH,

6201: decode(min(JL.context),min(JL.context3),null,min(JL.attribute8)),
6202: decode(min(JL.context),min(JL.context3),null,min(JL.attribute9)),
6203: decode(min(JL.context),min(JL.context3),null,min(JL.attribute10))
6204: FROM
6205: GL_JE_HEADERS JH,
6206: GL_BC_PACKETS BP1,
6207: GL_BC_PACKETS BP,
6208: GL_JE_LINES JL
6209: WHERE

Line 6245: -- Clean up attribute1 in gl_je_headers (contains header id of the

6241: psa_utils.debug_other_string(g_state_level,l_full_path,
6242: ' update gl_bc_packets - je_bacth_id - ' || SQL%ROWCOUNT);
6243: -- ========================= FND LOG ===========================
6244:
6245: -- Clean up attribute1 in gl_je_headers (contains header id of the
6246: -- originating line)
6247:
6248: update gl_je_headers jh
6249: set jh.attribute1 = null

Line 6248: update gl_je_headers jh

6244:
6245: -- Clean up attribute1 in gl_je_headers (contains header id of the
6246: -- originating line)
6247:
6248: update gl_je_headers jh
6249: set jh.attribute1 = null
6250: where jh.je_batch_id = l_gen_batch_id;
6251:
6252: -- ========================= FND LOG ===========================

Line 6254: ' update gl_je_headers -> ' || SQL%ROWCOUNT);

6250: where jh.je_batch_id = l_gen_batch_id;
6251:
6252: -- ========================= FND LOG ===========================
6253: psa_utils.debug_other_string(g_state_level,l_full_path,
6254: ' update gl_je_headers -> ' || SQL%ROWCOUNT);
6255: psa_utils.debug_other_string(g_state_level,l_full_path,
6256: ' goto normal_exit label ');
6257: -- ========================= FND LOG ===========================
6258:

Line 6278: from gl_je_headers jh,

6274: delete from gl_je_lines jl
6275: where jl.je_header_id in
6276: (
6277: select distinct jh.je_header_id
6278: from gl_je_headers jh,
6279: gl_bc_packets bp
6280: where jh.je_batch_id = bp.je_batch_id
6281: and bp.packet_id = g_packet_id
6282: and bp.ussgl_link_to_parent_id is not null

Line 6293: delete from gl_je_headers jh

6289: -- ========================= FND LOG ===========================
6290:
6291: -- Delete all associated headers of the generated transactions
6292:
6293: delete from gl_je_headers jh
6294: where jh.je_batch_id in
6295: (
6296: select distinct bp.je_batch_id
6297: from gl_bc_packets bp

Line 6304: ' Delete gl_je_headers - ' || SQL%ROWCOUNT);

6300: );
6301:
6302: -- ========================= FND LOG ===========================
6303: psa_utils.debug_other_string(g_state_level,l_full_path,
6304: ' Delete gl_je_headers - ' || SQL%ROWCOUNT);
6305: -- ========================= FND LOG ===========================
6306:
6307: -- Delete the associated batch of the generated transactions
6308:

Line 7614: gl_je_headers H,

7610: B.default_period_name,
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

Line 7636: FROM GL_JE_HEADERS H2

7632: AND B.status = 'U'
7633: AND B.budgetary_control_status in ('R', 'F')
7634: AND NOT EXISTS
7635: ( SELECT 'Not all category match'
7636: FROM GL_JE_HEADERS H2
7637: WHERE
7638: H2.je_batch_id = B.je_batch_id
7639: AND H2.je_category <> decode(O.je_category_name,
7640: 'ALL', H2.je_category,

Line 7644: FROM GL_JE_HEADERS GLH

7640: 'ALL', H2.je_category,
7641: O.je_category_name) )
7642: AND NOT EXISTS
7643: ( SELECT 'Untaxed Journals'
7644: FROM GL_JE_HEADERS GLH
7645: WHERE GLH.tax_status_code = 'R'
7646: AND GLH.je_batch_id = B.je_batch_id
7647: AND B.actual_flag = 'A'
7648: AND GLH.currency_code <> 'STAT'

Line 7663: gl_je_headers h,

7659: b.default_period_name,
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

Line 7685: FROM gl_je_headers h2

7681: AND b.status = 'U'
7682: AND b.budgetary_control_status in ('R', 'F')
7683: AND NOT EXISTS
7684: ( SELECT 'Not all category match'
7685: FROM gl_je_headers h2
7686: WHERE
7687: h2.je_batch_id = b.je_batch_id
7688: AND h2.je_category <> decode(o.je_category_name,
7689: 'ALL', h2.je_category,

Line 7731: l_source_name gl_je_headers.je_source%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;
7735: l_packet_id gl_bc_packets.packet_id%TYPE;

Line 7755: l_je_header_name gl_je_headers.name%TYPE;

7751: l_ledger_id gl_automatic_posting_options.ledger_id%TYPE;
7752: l_session_id gl_bc_packets.session_id%type;
7753: l_serial_id gl_bc_packets.serial_id%type;
7754: l_seg_ccid varchar2(200);
7755: l_je_header_name gl_je_headers.name%TYPE;
7756: l_je_header_id gl_je_headers.je_header_id%TYPE;
7757: l_je_line_num gl_je_lines.je_line_num%TYPE;
7758: l_entered_dr gl_je_lines.entered_dr%TYPE;
7759: l_entered_cr gl_je_lines.entered_cr%TYPE;

Line 7756: l_je_header_id gl_je_headers.je_header_id%TYPE;

7752: l_session_id gl_bc_packets.session_id%type;
7753: l_serial_id gl_bc_packets.serial_id%type;
7754: l_seg_ccid varchar2(200);
7755: l_je_header_name gl_je_headers.name%TYPE;
7756: l_je_header_id gl_je_headers.je_header_id%TYPE;
7757: l_je_line_num gl_je_lines.je_line_num%TYPE;
7758: l_entered_dr gl_je_lines.entered_dr%TYPE;
7759: l_entered_cr gl_je_lines.entered_cr%TYPE;
7760: l_line_description gl_lookups.description%TYPE;

Line 8073: l_tmp_stmt := l_tmp_stmt || ' FROM gl_je_lines l, gl_je_headers h, ';

8069: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_tmp_stmt -> '||l_tmp_stmt);
8070: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_tmp_stmt -> '||l_tmp_stmt);
8071: -- =========================== FND LOG =============================
8072:
8073: l_tmp_stmt := l_tmp_stmt || ' FROM gl_je_lines l, gl_je_headers h, ';
8074:
8075: IF (l_actual_flag = 'B') THEN
8076: l_tmp_stmt := l_tmp_stmt || 'gl_budget_versions bv, ';
8077: END IF;

Line 8341: 'FROM gl_je_lines l, gl_je_headers h, gl_code_combinations c, '||

8337:
8338: l_je_stmt := l_je_stmt||', SUBSTRB(h.name,1,20), h.je_header_id, l.je_line_num, l.entered_dr, '||
8339: 'l.entered_cr, lk.description, p.result_code, l.code_combination_id, '||
8340: 'p.rowid '||
8341: 'FROM gl_je_lines l, gl_je_headers h, gl_code_combinations c, '||
8342: 'gl_lookups lk, gl_bc_packets p '||
8343: 'WHERE p.je_batch_id = '||l_failed_bc_pkts(x).je_batch_id||
8344: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8345: ' and p.ledger_id = '||l_ledger_id||