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_LINES

Line 297: /* GL_JE_LINES */

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 */
301: /* */

Line 5539: and descriptive_flexfield_name = 'GL_JE_LINES'

5535: cursor avoid_copy_dff_attr is
5536: SELECT 'Y'
5537: FROM FND_DESCRIPTIVE_FLEXS FD
5538: WHERE application_id = 101
5539: and descriptive_flexfield_name = 'GL_JE_LINES'
5540: and context_user_override_flag = 'N'
5541: and (UPPER(default_context_field_name) IN ('CONTEXT3', 'ACCOUNT_NUM'));
5542:
5543:

Line 5609: -- Insert generated transactions in the packet into gl_je_lines for all

5605: end if;
5606:
5607: end if;
5608:
5609: -- Insert generated transactions in the packet into gl_je_lines for all
5610: -- headers of the originating batch
5611:
5612: if g_fcmode <> 'U' then
5613:

Line 5616: insert into gl_je_lines

5612: if g_fcmode <> 'U' then
5613:
5614: if (l_avoid_copying_attr = 'Y') then
5615:
5616: insert into gl_je_lines
5617: (je_header_id,
5618: je_line_num,
5619: last_update_date,
5620: last_updated_by,

Line 5671: ' gl_je_lines for originating batch ' || sql%ROWCOUNT);

5667: and bp.ussgl_link_to_parent_id is not null;
5668:
5669: -- ========================= FND LOG ===========================
5670: psa_utils.debug_other_string(g_state_level,l_full_path,
5671: ' gl_je_lines for originating batch ' || sql%ROWCOUNT);
5672: -- ========================= FND LOG ===========================
5673:
5674: else
5675:

Line 5676: INSERT INTO GL_JE_LINES

5672: -- ========================= FND LOG ===========================
5673:
5674: else
5675:
5676: INSERT INTO GL_JE_LINES
5677: (je_header_id,
5678: je_line_num,
5679: last_update_date,
5680: last_updated_by,

Line 5760: GL_JE_LINES JL,

5756: decode(JL1.context,JL1.context3,null,JL1.attribute9),
5757: decode(JL1.context,JL1.context3,null,JL1.attribute10)
5758: FROM
5759: GL_PERIOD_STATUSES PS,
5760: GL_JE_LINES JL,
5761: GL_JE_LINES JL1,
5762: GL_BC_PACKETS BP
5763: WHERE
5764: PS.application_id = 101

Line 5761: GL_JE_LINES JL1,

5757: decode(JL1.context,JL1.context3,null,JL1.attribute10)
5758: FROM
5759: GL_PERIOD_STATUSES PS,
5760: GL_JE_LINES JL,
5761: GL_JE_LINES JL1,
5762: GL_BC_PACKETS BP
5763: WHERE
5764: PS.application_id = 101
5765: AND PS.ledger_id = g_ledger_id

Line 5769: FROM GL_JE_LINES JL1

5765: AND PS.ledger_id = g_ledger_id
5766: AND PS.period_name = BP.period_name
5767: AND JL.je_header_id = BP.je_header_id
5768: AND JL.je_line_num = (SELECT max(JL1.je_line_num)
5769: FROM GL_JE_LINES JL1
5770: WHERE JL1.je_header_id = BP.je_header_id)
5771: AND BP.packet_id = g_packet_id
5772: AND BP.ussgl_link_to_parent_id IS NOT NULL
5773: AND JL1.je_header_id = BP.je_header_id

Line 5778: ' Insert GL_JE_LINES -> ' || sql%ROWCOUNT);

5774: AND JL1.je_line_num = BP.je_line_num;
5775:
5776: -- ========================= FND LOG ===========================
5777: psa_utils.debug_other_string(g_state_level,l_full_path,
5778: ' Insert GL_JE_LINES -> ' || sql%ROWCOUNT);
5779: -- ========================= FND LOG ===========================
5780:
5781: end if;
5782: else

Line 5785: -- from gl_je_lines

5781: end if;
5782: else
5783:
5784: -- For Unreservation, delete previously appended generated transactions
5785: -- from gl_je_lines
5786:
5787: delete from gl_je_lines jl
5788: where jl.je_header_id in
5789: (

Line 5787: delete from gl_je_lines jl

5783:
5784: -- For Unreservation, delete previously appended generated transactions
5785: -- from gl_je_lines
5786:
5787: delete from gl_je_lines jl
5788: where jl.je_header_id in
5789: (
5790: select distinct bp.je_header_id
5791: from gl_bc_packets bp

Line 5799: ' delete gl_je_lines - Unreservation ' || sql%ROWCOUNT);

5795: and jl.reference_10 = 'glxfje() generated: ' || g_packet_id_ursvd;
5796:
5797: -- ========================= FND LOG ===========================
5798: psa_utils.debug_other_string(g_state_level,l_full_path,
5799: ' delete gl_je_lines - Unreservation ' || sql%ROWCOUNT);
5800: -- ========================= FND LOG ===========================
5801:
5802: end if;
5803:

Line 6161: -- Insert generated transactions in packet into gl_je_lines

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
6163:
6164: insert into gl_je_lines
6165: (je_header_id,

Line 6164: insert into gl_je_lines

6160:
6161: -- Insert generated transactions in packet into gl_je_lines
6162: if (l_avoid_copying_attr = 'Y') then
6163:
6164: insert into gl_je_lines
6165: (je_header_id,
6166: je_line_num,
6167: last_update_date,
6168: last_updated_by,

Line 6215: INSERT INTO GL_JE_LINES

6211: and bp.ussgl_link_to_parent_id is not null;
6212:
6213: else
6214:
6215: INSERT INTO GL_JE_LINES
6216: (je_header_id,
6217: je_line_num,
6218: last_update_date,
6219: last_updated_by,

Line 6283: GL_JE_LINES JL

6279: FROM
6280: GL_JE_HEADERS JH,
6281: GL_BC_PACKETS BP1,
6282: GL_BC_PACKETS BP,
6283: GL_JE_LINES JL
6284: WHERE
6285: JH.je_batch_id = l_gen_batch_id
6286: AND JH.attribute1 = to_char(BP.je_header_id)
6287: AND BP1.packet_id = BP.packet_id

Line 6302: ' Insert gl_je_lines - ' || SQL%ROWCOUNT);

6298: end if;
6299:
6300: -- ========================= FND LOG ===========================
6301: psa_utils.debug_other_string(g_state_level,l_full_path,
6302: ' Insert gl_je_lines - ' || SQL%ROWCOUNT);
6303: -- ========================= FND LOG ===========================
6304:
6305:
6306: -- Update je_batch_id of all associated generated transactions from the

Line 6347: -- gl_je_lines

6343: ' Reached delete_seperate_batch label ');
6344: -- ========================= FND LOG ===========================
6345:
6346: -- Delete all previously created associated generated transactions from
6347: -- gl_je_lines
6348:
6349: delete from gl_je_lines jl
6350: where jl.je_header_id in
6351: (

Line 6349: delete from gl_je_lines jl

6345:
6346: -- Delete all previously created associated generated transactions from
6347: -- gl_je_lines
6348:
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,

Line 6363: ' Delete gl_je_lines - ' || SQL%ROWCOUNT);

6359: and jl.reference_10 = 'glxfje() generated: ' || g_packet_id_ursvd;
6360:
6361: -- ========================= FND LOG ===========================
6362: psa_utils.debug_other_string(g_state_level,l_full_path,
6363: ' Delete gl_je_lines - ' || SQL%ROWCOUNT);
6364: -- ========================= FND LOG ===========================
6365:
6366: -- Delete all associated headers of the generated transactions
6367:

Line 7943: l_je_line_num gl_je_lines.je_line_num%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;
7947: l_line_result_code gl_bc_packets.result_code%TYPE;

Line 7944: l_entered_dr gl_je_lines.entered_dr%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;
7947: l_line_result_code gl_bc_packets.result_code%TYPE;
7948: l_ccid gl_je_lines.code_combination_id%TYPE;

Line 7945: l_entered_cr gl_je_lines.entered_cr%TYPE;

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;
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);

Line 7948: l_ccid gl_je_lines.code_combination_id%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;
7951: l_je_seg_stmt varchar2(4000);
7952: l_je_sum_flex varchar2(4000);

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