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.IGS_HE_EXTRACT_PKG dependencies on IGS_HE_EXT_RUN_INTERIM

Line 983: Values : INTERIM - Igs_He_Ext_Run_Interim

979: Parameters :
980: p_extract_run_id IN The Extract Run Id
981: p_line_number IN Line Number
982: p_table_name IN Table Name
983: Values : INTERIM - Igs_He_Ext_Run_Interim
984: LINE - Igs_He_Ex_Rn_Dat_Ln
985: FIELD - Igs_He_Ex_Rn_Dat_Fd
986: ERROR - Igs_He_Ext_Run_Excp
987: WHO: AYEDUBAT

Line 1818: igs_he_ext_run_interim_pkg.insert_row

1814: l_rowid := NULL;
1815: l_ext_interim_id := NULL ;
1816: -- smaddali modified this call to pass l_std_inst.version_number instead of g_en_stdnt_ps_att.version_number
1817: -- as part of HECR214 build
1818: igs_he_ext_run_interim_pkg.insert_row
1819: (X_rowid => l_rowid,
1820: X_ext_interim_id => l_ext_interim_id,
1821: X_extract_run_id => p_extract_run_id,
1822: X_person_id => g_en_stdnt_ps_att.person_id,

Line 1904: l_he_ext_run_interim igs_he_ext_run_interim%ROWTYPE;

1900: WHERE unit_cd = cp_unit_cd
1901: AND version_number = cp_version_number;
1902:
1903: l_exclude igs_he_st_unt_vs_all.exclude_flag%TYPE;
1904: l_he_ext_run_interim igs_he_ext_run_interim%ROWTYPE;
1905: l_rowid VARCHAR2(50);
1906: l_dot_position NUMBER;
1907:
1908: BEGIN

Line 1948: igs_he_ext_run_interim_pkg.insert_row

1944:
1945: l_he_ext_run_interim.extract_run_id := p_extract_run_id;
1946: l_he_ext_run_interim.line_number := NULL;
1947:
1948: igs_he_ext_run_interim_pkg.insert_row
1949: (X_rowid => l_rowid,
1950: X_ext_interim_id => l_he_ext_run_interim.ext_interim_id,
1951: X_extract_run_id => l_he_ext_run_interim.extract_run_id,
1952: X_person_id => NULL,

Line 2140: igs_he_ext_run_interim_pkg.insert_row

2136: THEN
2137:
2138: l_ext_interim_id := NULL;
2139: l_rowid := NULL ;
2140: igs_he_ext_run_interim_pkg.insert_row
2141: (X_rowid => l_rowid,
2142: X_ext_interim_id => l_ext_interim_id ,
2143: X_extract_run_id => p_extract_run_id ,
2144: X_person_id => g_he_stdnt_dlhe.person_id,

Line 2218: l_he_ext_run_interim igs_he_ext_run_interim%ROWTYPE;

2214: AND (recalculate_flag = 'Y'
2215: OR person_id IN (SELECT only from igs_he_ext_run_prms WHERE param_type = 'RECALC-PERSON' AND extract_run_id = p_extract_run_id)
2216: OR course_cd IN (SELECT only from igs_he_ext_run_prms WHERE param_type = 'RECALC-PROGRAM'AND extract_run_id = p_extract_run_id));
2217:
2218: l_he_ext_run_interim igs_he_ext_run_interim%ROWTYPE;
2219: l_rowid VARCHAR2(50);
2220: l_temp VARCHAR2(3);
2221:
2222: BEGIN

Line 2233: -- Delete from igs_he_ext_run_interim, if rows exist

2229: fnd_message.set_name('IGS','IGS_HE_REC_RECAL');
2230: fnd_file.put_line(fnd_file.log,fnd_message.get());
2231:
2232:
2233: -- Delete from igs_he_ext_run_interim, if rows exist
2234: -- Replaced the procedure call which calls the TBH for deletion with direct DML for bug,3179585
2235: DELETE FROM igs_he_ext_run_interim WHERE extract_run_id = p_extract_run_id;
2236:
2237:

Line 2235: DELETE FROM igs_he_ext_run_interim WHERE extract_run_id = p_extract_run_id;

2231:
2232:
2233: -- Delete from igs_he_ext_run_interim, if rows exist
2234: -- Replaced the procedure call which calls the TBH for deletion with direct DML for bug,3179585
2235: DELETE FROM igs_he_ext_run_interim WHERE extract_run_id = p_extract_run_id;
2236:
2237:
2238: FOR l_c_mrk_row IN c_mrk_row
2239: LOOP

Line 2267: igs_he_ext_run_interim_pkg.insert_row

2263:
2264: l_he_ext_run_interim.extract_run_id := p_extract_run_id;
2265: l_he_ext_run_interim.line_number := l_c_mrk_row.line_number;
2266:
2267: igs_he_ext_run_interim_pkg.insert_row
2268: (X_rowid => l_rowid,
2269: X_ext_interim_id => l_he_ext_run_interim.ext_interim_id,
2270: X_extract_run_id => l_he_ext_run_interim.extract_run_id,
2271: X_person_id => l_he_ext_run_interim.person_id,

Line 2298: DELETE FROM igs_he_ext_run_interim

2294: get_dlhe(p_extract_run_id, TRUE);
2295: END IF;
2296:
2297: -- Delete any appended lines that are already marked for recalculation
2298: DELETE FROM igs_he_ext_run_interim
2299: WHERE ext_interim_id IN
2300: (SELECT MAX(ext_interim_id)
2301: FROM igs_he_ext_run_interim a
2302: GROUP BY extract_run_id, person_id, course_cd, crv_version_number, unit_cd, uv_version_number, student_inst_number

Line 2301: FROM igs_he_ext_run_interim a

2297: -- Delete any appended lines that are already marked for recalculation
2298: DELETE FROM igs_he_ext_run_interim
2299: WHERE ext_interim_id IN
2300: (SELECT MAX(ext_interim_id)
2301: FROM igs_he_ext_run_interim a
2302: GROUP BY extract_run_id, person_id, course_cd, crv_version_number, unit_cd, uv_version_number, student_inst_number
2303: HAVING COUNT(ext_interim_id) > 1)
2304: AND line_number IS NULL;
2305:

Line 2396: FROM igs_he_ext_run_interim

2392:
2393: -- Changed the cursor to COUNT(*) with 1 for bug, 3179585
2394: CURSOR c_interim_cnt IS
2395: SELECT 1
2396: FROM igs_he_ext_run_interim
2397: WHERE extract_run_id = p_extract_run_id;
2398:
2399: l_message VARCHAR2(2000);
2400: l_msg_code VARCHAR2(30);

Line 2502: FROM igs_he_ext_run_interim

2498: DELETE FROM igs_he_ext_run_excp excp
2499: WHERE excp.extract_run_id = p_extract_run_id
2500: AND excp.line_number IN
2501: (SELECT line_number
2502: FROM igs_he_ext_run_interim
2503: WHERE extract_run_id = excp.extract_run_id);
2504:
2505:
2506: ELSIF p_module_called_from = 'IGSHE007'

Line 2516: -- Delete from igs_he_ext_run_interim

2512: THEN
2513: -- Do a fresh run.
2514: -- Therefore, delete all data that was created previously
2515: -- for the same run.
2516: -- Delete from igs_he_ext_run_interim
2517: fnd_message.set_name('IGS','IGS_HE_DELETE_REC');
2518: fnd_file.put_line(fnd_file.log,fnd_message.get());
2519:
2520: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');

Line 2528: -- Delete from igs_he_ext_run_interim

2524:
2525: -- Changed the logic to replace the call to procedure, delete_rows with the
2526: -- Direct DMLs to improve performance for bug,3179585
2527:
2528: -- Delete from igs_he_ext_run_interim
2529: DELETE FROM igs_he_ext_run_interim WHERE extract_run_id = p_extract_run_id;
2530:
2531: -- Delete from igs_he_ex_rn_dat_fd
2532: DELETE FROM igs_he_ex_rn_dat_fd WHERE extract_run_id = p_extract_run_id;

Line 2529: DELETE FROM igs_he_ext_run_interim WHERE extract_run_id = p_extract_run_id;

2525: -- Changed the logic to replace the call to procedure, delete_rows with the
2526: -- Direct DMLs to improve performance for bug,3179585
2527:
2528: -- Delete from igs_he_ext_run_interim
2529: DELETE FROM igs_he_ext_run_interim WHERE extract_run_id = p_extract_run_id;
2530:
2531: -- Delete from igs_he_ex_rn_dat_fd
2532: DELETE FROM igs_he_ex_rn_dat_fd WHERE extract_run_id = p_extract_run_id;
2533: