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 286: /* GL_JE_LINES */

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

Line 5464: and descriptive_flexfield_name = 'GL_JE_LINES'

5460: cursor avoid_copy_dff_attr is
5461: SELECT 'Y'
5462: FROM FND_DESCRIPTIVE_FLEXS FD
5463: WHERE application_id = 101
5464: and descriptive_flexfield_name = 'GL_JE_LINES'
5465: and context_user_override_flag = 'N'
5466: and (UPPER(default_context_field_name) IN ('CONTEXT3', 'ACCOUNT_NUM'));
5467:
5468:

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

5530: end if;
5531:
5532: end if;
5533:
5534: -- Insert generated transactions in the packet into gl_je_lines for all
5535: -- headers of the originating batch
5536:
5537: if g_fcmode <> 'U' then
5538:

Line 5541: insert into gl_je_lines

5537: if g_fcmode <> 'U' then
5538:
5539: if (l_avoid_copying_attr = 'Y') then
5540:
5541: insert into gl_je_lines
5542: (je_header_id,
5543: je_line_num,
5544: last_update_date,
5545: last_updated_by,

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

5592: and bp.ussgl_link_to_parent_id is not null;
5593:
5594: -- ========================= FND LOG ===========================
5595: psa_utils.debug_other_string(g_state_level,l_full_path,
5596: ' gl_je_lines for originating batch ' || sql%ROWCOUNT);
5597: -- ========================= FND LOG ===========================
5598:
5599: else
5600:

Line 5601: INSERT INTO GL_JE_LINES

5597: -- ========================= FND LOG ===========================
5598:
5599: else
5600:
5601: INSERT INTO GL_JE_LINES
5602: (je_header_id,
5603: je_line_num,
5604: last_update_date,
5605: last_updated_by,

Line 5685: GL_JE_LINES JL,

5681: decode(JL1.context,JL1.context3,null,JL1.attribute9),
5682: decode(JL1.context,JL1.context3,null,JL1.attribute10)
5683: FROM
5684: GL_PERIOD_STATUSES PS,
5685: GL_JE_LINES JL,
5686: GL_JE_LINES JL1,
5687: GL_BC_PACKETS BP
5688: WHERE
5689: PS.application_id = 101

Line 5686: GL_JE_LINES JL1,

5682: decode(JL1.context,JL1.context3,null,JL1.attribute10)
5683: FROM
5684: GL_PERIOD_STATUSES PS,
5685: GL_JE_LINES JL,
5686: GL_JE_LINES JL1,
5687: GL_BC_PACKETS BP
5688: WHERE
5689: PS.application_id = 101
5690: AND PS.ledger_id = g_ledger_id

Line 5694: FROM GL_JE_LINES JL1

5690: AND PS.ledger_id = g_ledger_id
5691: AND PS.period_name = BP.period_name
5692: AND JL.je_header_id = BP.je_header_id
5693: AND JL.je_line_num = (SELECT max(JL1.je_line_num)
5694: FROM GL_JE_LINES JL1
5695: WHERE JL1.je_header_id = BP.je_header_id)
5696: AND BP.packet_id = g_packet_id
5697: AND BP.ussgl_link_to_parent_id IS NOT NULL
5698: AND JL1.je_header_id = BP.je_header_id

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

5699: AND JL1.je_line_num = BP.je_line_num;
5700:
5701: -- ========================= FND LOG ===========================
5702: psa_utils.debug_other_string(g_state_level,l_full_path,
5703: ' Insert GL_JE_LINES -> ' || sql%ROWCOUNT);
5704: -- ========================= FND LOG ===========================
5705:
5706: end if;
5707: else

Line 5710: -- from gl_je_lines

5706: end if;
5707: else
5708:
5709: -- For Unreservation, delete previously appended generated transactions
5710: -- from gl_je_lines
5711:
5712: delete from gl_je_lines jl
5713: where jl.je_header_id in
5714: (

Line 5712: delete from gl_je_lines jl

5708:
5709: -- For Unreservation, delete previously appended generated transactions
5710: -- from gl_je_lines
5711:
5712: delete from gl_je_lines jl
5713: where jl.je_header_id in
5714: (
5715: select distinct bp.je_header_id
5716: from gl_bc_packets bp

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

5720: and jl.reference_10 = 'glxfje() generated: ' || g_packet_id_ursvd;
5721:
5722: -- ========================= FND LOG ===========================
5723: psa_utils.debug_other_string(g_state_level,l_full_path,
5724: ' delete gl_je_lines - Unreservation ' || sql%ROWCOUNT);
5725: -- ========================= FND LOG ===========================
5726:
5727: end if;
5728:

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

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
6088:
6089: insert into gl_je_lines
6090: (je_header_id,

Line 6089: insert into gl_je_lines

6085:
6086: -- Insert generated transactions in packet into gl_je_lines
6087: if (l_avoid_copying_attr = 'Y') then
6088:
6089: insert into gl_je_lines
6090: (je_header_id,
6091: je_line_num,
6092: last_update_date,
6093: last_updated_by,

Line 6140: INSERT INTO GL_JE_LINES

6136: and bp.ussgl_link_to_parent_id is not null;
6137:
6138: else
6139:
6140: INSERT INTO GL_JE_LINES
6141: (je_header_id,
6142: je_line_num,
6143: last_update_date,
6144: last_updated_by,

Line 6208: GL_JE_LINES JL

6204: FROM
6205: GL_JE_HEADERS JH,
6206: GL_BC_PACKETS BP1,
6207: GL_BC_PACKETS BP,
6208: GL_JE_LINES JL
6209: WHERE
6210: JH.je_batch_id = l_gen_batch_id
6211: AND JH.attribute1 = to_char(BP.je_header_id)
6212: AND BP1.packet_id = BP.packet_id

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

6223: end if;
6224:
6225: -- ========================= FND LOG ===========================
6226: psa_utils.debug_other_string(g_state_level,l_full_path,
6227: ' Insert gl_je_lines - ' || SQL%ROWCOUNT);
6228: -- ========================= FND LOG ===========================
6229:
6230:
6231: -- Update je_batch_id of all associated generated transactions from the

Line 6272: -- gl_je_lines

6268: ' Reached delete_seperate_batch label ');
6269: -- ========================= FND LOG ===========================
6270:
6271: -- Delete all previously created associated generated transactions from
6272: -- gl_je_lines
6273:
6274: delete from gl_je_lines jl
6275: where jl.je_header_id in
6276: (

Line 6274: delete from gl_je_lines jl

6270:
6271: -- Delete all previously created associated generated transactions from
6272: -- gl_je_lines
6273:
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,

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

6284: and jl.reference_10 = 'glxfje() generated: ' || g_packet_id_ursvd;
6285:
6286: -- ========================= FND LOG ===========================
6287: psa_utils.debug_other_string(g_state_level,l_full_path,
6288: ' Delete gl_je_lines - ' || SQL%ROWCOUNT);
6289: -- ========================= FND LOG ===========================
6290:
6291: -- Delete all associated headers of the generated transactions
6292:

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

Line 7758: l_entered_dr gl_je_lines.entered_dr%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;
7761: l_line_result_code gl_bc_packets.result_code%TYPE;
7762: l_ccid gl_je_lines.code_combination_id%TYPE;

Line 7759: l_entered_cr gl_je_lines.entered_cr%TYPE;

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;
7761: l_line_result_code gl_bc_packets.result_code%TYPE;
7762: l_ccid gl_je_lines.code_combination_id%TYPE;
7763: l_rowid varchar2(100);

Line 7762: l_ccid gl_je_lines.code_combination_id%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;
7761: l_line_result_code gl_bc_packets.result_code%TYPE;
7762: l_ccid gl_je_lines.code_combination_id%TYPE;
7763: l_rowid varchar2(100);
7764: l_priority gl_lookups.meaning%TYPE;
7765: l_je_seg_stmt varchar2(4000);
7766: l_je_sum_flex varchar2(4000);

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