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.GL_CI_DATA_TRANSFER_PKG dependencies on GL_JE_BATCHES

Line 1002: v_Batches gl_je_batches%ROWTYPE;

998: l_import_message_body OUT NOCOPY varchar2
999: ) IS
1000: v_SelectSQL varchar2(500);
1001: v_ReturnCursor t_RefCur;
1002: v_Batches gl_je_batches%ROWTYPE;
1003: l_batch_name varchar2(100);
1004: l_batch_id number;
1005: l_first_one boolean;
1006: BEGIN

Line 1009: v_SelectSQL := 'select * from ' || applSysSchema ||'.gl_je_batches@' || dblink ||

1005: l_first_one boolean;
1006: BEGIN
1007: l_first_one := TRUE;
1008: -- Get_Schema_Name(dblink); --=bug#2630145
1009: v_SelectSQL := 'select * from ' || applSysSchema ||'.gl_je_batches@' || dblink ||
1010: ' where name like ''%' || TO_CHAR(l_reqJI_id) || '%''';
1011: OPEN v_ReturnCursor FOR v_SelectSQL;
1012: LOOP --+for every batch in this transfer
1013: FETCH v_ReturnCursor INTO v_Batches;

Line 1016: v_SelectSQL := 'select name from ' || applSysSchema ||'.gl_je_batches@' || dblink ||

1012: LOOP --+for every batch in this transfer
1013: FETCH v_ReturnCursor INTO v_Batches;
1014: EXIT WHEN v_ReturnCursor%NOTFOUND;
1015: l_batch_id := v_Batches.je_batch_id;
1016: v_SelectSQL := 'select name from ' || applSysSchema ||'.gl_je_batches@' || dblink ||
1017: ' WHERE je_batch_id = :b_id';
1018: EXECUTE IMMEDIATE v_SelectSQL INTO l_batch_name USING l_batch_id;
1019: COMMIT;
1020: if l_first_one then

Line 1073: v_Batches gl_je_batches%ROWTYPE;

1069: l_batch_id number;
1070: v_SQL1 varchar2(1000);
1071: v_SQL2 varchar2(2000);
1072: v_ReturnCursor t_RefCur;
1073: v_Batches gl_je_batches%ROWTYPE;
1074: l_posted_rows number;
1075: l_status varchar2(1);
1076: l_target_ledger_name varchar2(30);
1077: l_post_run_id number;

Line 1304: v_SelectSQL := 'select * from ' || applSysSchema || '.gl_je_batches@' || dblink ||

1300: if (p_j_post = 'Y') then
1301: --+Journal Post
1302: section_number := 3;
1303: --+dbms_output.put_line('j post flag is ' || p_j_post);
1304: v_SelectSQL := 'select * from ' || applSysSchema || '.gl_je_batches@' || dblink ||
1305: ' where name like ''%' || TO_CHAR(l_reqJI_id) || '%''';
1306: OPEN v_ReturnCursor FOR v_SelectSQL;
1307: LOOP --+for every batch in this transfer
1308: FETCH v_ReturnCursor INTO v_Batches;

Line 1350: v_SQL2 := 'select name from ' || applSysSchema ||'.gl_je_batches@' || dblink ||

1346: EXECUTE IMMEDIATE v_SQL2 USING IN l_pd_name, IN l_postable_rows,
1347: IN l_to_ledger_id, IN l_batch_id, IN p_actual_flag, IN l_avg_flag, OUT l_verify;
1348: --COMMIT;
1349: --+dbms_output.put_line('After verify Journal post');
1350: v_SQL2 := 'select name from ' || applSysSchema ||'.gl_je_batches@' || dblink ||
1351: ' WHERE je_batch_id = :b_id';
1352: EXECUTE IMMEDIATE v_SQL2 INTO l_batch_name USING l_batch_id;
1353: --COMMIT;
1354: --+dbms_output.put_line('The name of the batch is' || l_batch_name);