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 296: /* GL_JE_HEADERS */

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

Line 5524: FROM GL_JE_HEADERS JH

5520: WHERE ledger_id = g_ledger_id;
5521:
5522: cursor je_source(c_orig_batch_id IN NUMBER) is
5523: SELECT JH.je_source je_source
5524: FROM GL_JE_HEADERS JH
5525: WHERE JH.je_header_id =
5526: (SELECT min(JH1.je_header_id)
5527: FROM GL_JE_HEADERS JH1
5528: WHERE JH1.je_batch_id = c_orig_batch_id);

Line 5527: FROM GL_JE_HEADERS JH1

5523: SELECT JH.je_source je_source
5524: FROM GL_JE_HEADERS JH
5525: WHERE JH.je_header_id =
5526: (SELECT min(JH1.je_header_id)
5527: FROM GL_JE_HEADERS JH1
5528: WHERE JH1.je_batch_id = c_orig_batch_id);
5529:
5530: cursor je_approval (c_je_source IN VARCHAR2) is
5531: SELECT journal_approval_flag

Line 5660: gl_je_headers jh,

5656: 'Y',
5657: BP.ussgl_link_to_parent_id,
5658: 'glxfje() generated: ' || g_packet_id
5659: from gl_period_statuses ps,
5660: gl_je_headers jh,
5661: gl_bc_packets bp
5662: where ps.application_id = 101
5663: and ps.ledger_id = g_ledger_id
5664: and ps.period_name = bp.period_name

Line 5808: update gl_je_headers jh

5804:
5805: -- Update Control Total and Running Totals of all headers with generated
5806: -- transactions appended/deleted
5807:
5808: update gl_je_headers jh
5809: set (jh.control_total,
5810: jh.running_total_dr,
5811: jh.running_total_cr,
5812: jh.running_total_accounted_dr,

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

5840: );
5841:
5842: -- ========================= FND LOG ===========================
5843: psa_utils.debug_other_string(g_state_level,l_full_path,
5844: ' Update Control Total and Running Totals - gl_je_headers ' || SQL%ROWCOUNT);
5845: -- ========================= FND LOG ===========================
5846:
5847:
5848: -- Update Batch Control Total, Running Totals, Budgetary Control Status and

Line 6029: FROM gl_je_headers

6025: DECLARE
6026:
6027: CURSOR batch_sources IS
6028: SELECT je_header_id, je_category, je_source, period_name
6029: FROM gl_je_headers
6030: WHERE je_batch_id = l_je_batch_id;
6031:
6032: BEGIN
6033: FOR x IN batch_sources

Line 6059: insert into gl_je_headers

6055: return (FALSE);
6056: END IF;
6057:
6058: -- Create associated headers for the new Actual Batch
6059: insert into gl_je_headers
6060: (je_header_id,
6061: last_update_date,
6062: last_updated_by,
6063: ledger_id,

Line 6086: select gl_je_headers_s.nextval,

6082: currency_conversion_date,
6083: attribute1,
6084: accrual_rev_change_sign_flag,
6085: tax_status_code)
6086: select gl_je_headers_s.nextval,
6087: sysdate,
6088: g_user_id,
6089: g_ledger_id,
6090: jh.je_category,

Line 6115: from gl_je_headers jh

6111: sysdate,
6112: to_char(jh.je_header_id),
6113: l_reversal_method,
6114: 'N'
6115: from gl_je_headers jh
6116: where jh.je_batch_id = l_je_batch_id
6117: and jh.je_header_id = x.je_header_id
6118: and exists
6119: (

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

6127:
6128:
6129: -- ========================= FND LOG ===========================
6130: psa_utils.debug_other_string(g_state_level,l_full_path,
6131: ' Insert gl_je_headers - Headers for Actual Batches ' || SQL%ROWCOUNT);
6132: -- ========================= FND LOG ===========================
6133: END LOOP;
6134: END;
6135:

Line 6138: update gl_je_headers jh

6134: END;
6135:
6136: -- Update running totals of associated headers
6137:
6138: update gl_je_headers jh
6139: set (jh.running_total_dr,
6140: jh.running_total_cr,
6141: jh.running_total_accounted_dr,
6142: jh.running_total_accounted_cr) =

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

6154: where JH.je_batch_id = l_gen_batch_id;
6155:
6156: -- ========================= FND LOG ===========================
6157: psa_utils.debug_other_string(g_state_level,l_full_path,
6158: ' update gl_je_headers - running totals - ' || SQL%ROWCOUNT);
6159: -- ========================= FND LOG ===========================
6160:
6161: -- Insert generated transactions in packet into gl_je_lines
6162: if (l_avoid_copying_attr = 'Y') then

Line 6206: from gl_je_headers jh,

6202: ' ',
6203: ' ',
6204: 'Y',
6205: 'glxfje() generated: ' || g_packet_id
6206: from gl_je_headers jh,
6207: gl_bc_packets bp
6208: where jh.je_batch_id = l_gen_batch_id
6209: and jh.attribute1 = to_char(bp.je_header_id)
6210: and bp.packet_id = g_packet_id

Line 6280: GL_JE_HEADERS JH,

6276: decode(min(JL.context),min(JL.context3),null,min(JL.attribute8)),
6277: decode(min(JL.context),min(JL.context3),null,min(JL.attribute9)),
6278: decode(min(JL.context),min(JL.context3),null,min(JL.attribute10))
6279: FROM
6280: GL_JE_HEADERS JH,
6281: GL_BC_PACKETS BP1,
6282: GL_BC_PACKETS BP,
6283: GL_JE_LINES JL
6284: WHERE

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

6316: psa_utils.debug_other_string(g_state_level,l_full_path,
6317: ' update gl_bc_packets - je_bacth_id - ' || SQL%ROWCOUNT);
6318: -- ========================= FND LOG ===========================
6319:
6320: -- Clean up attribute1 in gl_je_headers (contains header id of the
6321: -- originating line)
6322:
6323: update gl_je_headers jh
6324: set jh.attribute1 = null

Line 6323: update gl_je_headers jh

6319:
6320: -- Clean up attribute1 in gl_je_headers (contains header id of the
6321: -- originating line)
6322:
6323: update gl_je_headers jh
6324: set jh.attribute1 = null
6325: where jh.je_batch_id = l_gen_batch_id;
6326:
6327: -- ========================= FND LOG ===========================

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

6325: where jh.je_batch_id = l_gen_batch_id;
6326:
6327: -- ========================= FND LOG ===========================
6328: psa_utils.debug_other_string(g_state_level,l_full_path,
6329: ' update gl_je_headers -> ' || SQL%ROWCOUNT);
6330: psa_utils.debug_other_string(g_state_level,l_full_path,
6331: ' goto normal_exit label ');
6332: -- ========================= FND LOG ===========================
6333:

Line 6353: from gl_je_headers jh,

6349: delete from gl_je_lines jl
6350: where jl.je_header_id in
6351: (
6352: select distinct jh.je_header_id
6353: from gl_je_headers jh,
6354: gl_bc_packets bp
6355: where jh.je_batch_id = bp.je_batch_id
6356: and bp.packet_id = g_packet_id
6357: and bp.ussgl_link_to_parent_id is not null

Line 6368: delete from gl_je_headers jh

6364: -- ========================= FND LOG ===========================
6365:
6366: -- Delete all associated headers of the generated transactions
6367:
6368: delete from gl_je_headers jh
6369: where jh.je_batch_id in
6370: (
6371: select distinct bp.je_batch_id
6372: from gl_bc_packets bp

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

6375: );
6376:
6377: -- ========================= FND LOG ===========================
6378: psa_utils.debug_other_string(g_state_level,l_full_path,
6379: ' Delete gl_je_headers - ' || SQL%ROWCOUNT);
6380: -- ========================= FND LOG ===========================
6381:
6382: -- Delete the associated batch of the generated transactions
6383:

Line 7800: gl_je_headers H,

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

Line 7822: FROM GL_JE_HEADERS H2

7818: AND B.status = 'U'
7819: AND B.budgetary_control_status in ('R', 'F')
7820: AND NOT EXISTS
7821: ( SELECT 'Not all category match'
7822: FROM GL_JE_HEADERS H2
7823: WHERE
7824: H2.je_batch_id = B.je_batch_id
7825: AND H2.je_category <> decode(O.je_category_name,
7826: 'ALL', H2.je_category,

Line 7830: FROM GL_JE_HEADERS GLH

7826: 'ALL', H2.je_category,
7827: O.je_category_name) )
7828: AND NOT EXISTS
7829: ( SELECT 'Untaxed Journals'
7830: FROM GL_JE_HEADERS GLH
7831: WHERE GLH.tax_status_code = 'R'
7832: AND GLH.je_batch_id = B.je_batch_id
7833: AND B.actual_flag = 'A'
7834: AND GLH.currency_code <> 'STAT'

Line 7849: gl_je_headers h,

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

Line 7871: FROM gl_je_headers h2

7867: AND b.status = 'U'
7868: AND b.budgetary_control_status in ('R', 'F')
7869: AND NOT EXISTS
7870: ( SELECT 'Not all category match'
7871: FROM gl_je_headers h2
7872: WHERE
7873: h2.je_batch_id = b.je_batch_id
7874: AND h2.je_category <> decode(o.je_category_name,
7875: 'ALL', h2.je_category,

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

Line 7941: l_je_header_name gl_je_headers.name%TYPE;

7937: l_ledger_id gl_automatic_posting_options.ledger_id%TYPE;
7938: l_session_id gl_bc_packets.session_id%type;
7939: l_serial_id gl_bc_packets.serial_id%type;
7940: l_seg_ccid varchar2(200);
7941: l_je_header_name gl_je_headers.name%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;

Line 7942: l_je_header_id gl_je_headers.je_header_id%TYPE;

7938: l_session_id gl_bc_packets.session_id%type;
7939: l_serial_id gl_bc_packets.serial_id%type;
7940: l_seg_ccid varchar2(200);
7941: l_je_header_name gl_je_headers.name%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;

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

8255: fnd_file.put_line(fnd_file.log, 'Funds C/R: l_tmp_stmt -> '||l_tmp_stmt);
8256: psa_utils.debug_other_string(g_state_level, l_full_path, 'Funds C/R: l_tmp_stmt -> '||l_tmp_stmt);
8257: -- =========================== FND LOG =============================
8258:
8259: l_tmp_stmt := l_tmp_stmt || ' FROM gl_je_lines l, gl_je_headers h, ';
8260:
8261: IF (l_actual_flag = 'B') THEN
8262: l_tmp_stmt := l_tmp_stmt || 'gl_budget_versions bv, ';
8263: END IF;

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

8523:
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||