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_PS_LGCY_CONC_PKG dependencies on IGS_PS_LGCY_UV_INT

Line 79: FROM igs_ps_lgcy_uv_int

75: CURSOR c_all_units IS
76: SELECT DISTINCT
77: unit_cd,
78: version_number
79: FROM igs_ps_lgcy_uv_int
80: WHERE batch_id=p_n_batch_id
81: AND import_status IN ('U','R')
82: UNION
83: SELECT DISTINCT

Line 144: FROM igs_ps_lgcy_uv_int

140: -- Unit Version Interface Table cursor
141:
142: CURSOR c_unit_ver(cp_c_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,cp_n_version_number igs_ps_unit_ver_all.version_number%TYPE) IS
143: SELECT *
144: FROM igs_ps_lgcy_uv_int
145: WHERE batch_id=p_n_batch_id
146: AND unit_cd=cp_c_unit_cd
147: AND version_number=cp_n_version_number
148: AND import_status IN ('U','R');

Line 265: l_n_request_id igs_ps_lgcy_uv_int.request_id%TYPE;

261: v_tab_usec_gs igs_ps_generic_pub.usec_gs_tbl_type;
262: v_tab_uso igs_ps_generic_pub.uso_tbl_type;
263: v_tab_unit_ref igs_ps_generic_pub.unit_ref_tbl_type;
264: v_tab_ins igs_ps_generic_pub.uso_ins_tbl_type;
265: l_n_request_id igs_ps_lgcy_uv_int.request_id%TYPE;
266: l_n_prog_appl_id igs_ps_lgcy_uv_int.program_application_id%TYPE;
267: l_n_prog_id igs_ps_lgcy_uv_int.program_id%TYPE;
268: l_d_prog_upd_dt igs_ps_lgcy_uv_int.program_update_date%TYPE;
269: p_head BOOLEAN ;

Line 266: l_n_prog_appl_id igs_ps_lgcy_uv_int.program_application_id%TYPE;

262: v_tab_uso igs_ps_generic_pub.uso_tbl_type;
263: v_tab_unit_ref igs_ps_generic_pub.unit_ref_tbl_type;
264: v_tab_ins igs_ps_generic_pub.uso_ins_tbl_type;
265: l_n_request_id igs_ps_lgcy_uv_int.request_id%TYPE;
266: l_n_prog_appl_id igs_ps_lgcy_uv_int.program_application_id%TYPE;
267: l_n_prog_id igs_ps_lgcy_uv_int.program_id%TYPE;
268: l_d_prog_upd_dt igs_ps_lgcy_uv_int.program_update_date%TYPE;
269: p_head BOOLEAN ;
270: l_ret_status BOOLEAN ; -- Holds return status, TRUE if all the attempted records to import result in Error.

Line 267: l_n_prog_id igs_ps_lgcy_uv_int.program_id%TYPE;

263: v_tab_unit_ref igs_ps_generic_pub.unit_ref_tbl_type;
264: v_tab_ins igs_ps_generic_pub.uso_ins_tbl_type;
265: l_n_request_id igs_ps_lgcy_uv_int.request_id%TYPE;
266: l_n_prog_appl_id igs_ps_lgcy_uv_int.program_application_id%TYPE;
267: l_n_prog_id igs_ps_lgcy_uv_int.program_id%TYPE;
268: l_d_prog_upd_dt igs_ps_lgcy_uv_int.program_update_date%TYPE;
269: p_head BOOLEAN ;
270: l_ret_status BOOLEAN ; -- Holds return status, TRUE if all the attempted records to import result in Error.
271: l_c_import_desc VARCHAR2(80);

Line 268: l_d_prog_upd_dt igs_ps_lgcy_uv_int.program_update_date%TYPE;

264: v_tab_ins igs_ps_generic_pub.uso_ins_tbl_type;
265: l_n_request_id igs_ps_lgcy_uv_int.request_id%TYPE;
266: l_n_prog_appl_id igs_ps_lgcy_uv_int.program_application_id%TYPE;
267: l_n_prog_id igs_ps_lgcy_uv_int.program_id%TYPE;
268: l_d_prog_upd_dt igs_ps_lgcy_uv_int.program_update_date%TYPE;
269: p_head BOOLEAN ;
270: l_ret_status BOOLEAN ; -- Holds return status, TRUE if all the attempted records to import result in Error.
271: l_c_import_desc VARCHAR2(80);
272: l_c_succ_desc VARCHAR2(80);

Line 431: tablenames_tbl(1) := 'IGS_PS_LGCY_UV_INT';

427: -- To fetch table schema name for gather statistics
428: l_b_return := fnd_installation.get_app_info('IGS', l_c_status, l_c_industry, l_c_schema);
429:
430: -- Collect statistics of the interface table as per standards. Bug # 2710978
431: tablenames_tbl(1) := 'IGS_PS_LGCY_UV_INT';
432: tablenames_tbl(2) := 'IGS_PS_LGCY_TR_INT';
433: tablenames_tbl(3) := 'IGS_PS_LGCY_UD_INT';
434: tablenames_tbl(4) := 'IGS_PS_LGCY_UG_INT';
435: tablenames_tbl(5) := 'IGS_PS_LGCY_US_INT';

Line 974: UPDATE igs_ps_lgcy_uv_int

970: IF l_unit_ver_rec.status = 'S' AND l_c_return_status = 'S' THEN
971:
972: /* Update the interface table */
973:
974: UPDATE igs_ps_lgcy_uv_int
975: SET import_status = 'I'
976: WHERE batch_id=p_n_batch_id
977: AND unit_version_int_id = l_unit_ver_rec.interface_id;
978:

Line 990: UPDATE igs_ps_lgcy_uv_int

986: ELSIF l_unit_ver_rec.status IN ('W','E') THEN
987:
988: /* Update the interface table */
989:
990: UPDATE igs_ps_lgcy_uv_int
991: SET import_status = l_unit_ver_rec.status
992: WHERE batch_id=p_n_batch_id
993: AND unit_version_int_id = l_unit_ver_rec.interface_id;
994:

Line 1918: DELETE FROM igs_ps_lgcy_uv_int

1914: IF p_c_del_flag='Y' AND l_c_return_status = 'S' THEN
1915:
1916: /* Delete from Unit Version Interface Table */
1917:
1918: DELETE FROM igs_ps_lgcy_uv_int
1919: WHERE batch_id=p_n_batch_id
1920: AND import_status = 'I';
1921:
1922: /* Delete from Teaching Responsibility Interface Table */