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_UC_PROC_APPLICATION_DATA dependencies on IGS_AD_INTERFACE_ALL

Line 156: FROM igs_ad_interface_all

152: l_starn_rec cur_ivstarn%ROWTYPE;
153:
154: CURSOR ad_interface_cur (p_interface_id igs_uc_istarn_ints.ad_interface_id%TYPE) IS
155: SELECT 'X'
156: FROM igs_ad_interface_all
157: WHERE interface_id = p_interface_id;
158:
159: l_exists_flag VARCHAR2(1);
160: l_success_cnt NUMBER;

Line 643: l_interface_id igs_ad_interface_all.interface_id%TYPE;

639: l_last_update_date DATE ;
640: l_alt_pers_seq_id igs_ad_api_int.interface_api_id%TYPE; -- for holding Alternate Person ID sequence
641: l_adm_batch_id igs_ad_imp_batch_det.batch_id%TYPE; -- for holding Adm Imp Proc batch ID.
642: l_source_type_id igs_pe_src_types_all.source_type_id%TYPE;
643: l_interface_id igs_ad_interface_all.interface_id%TYPE;
644: l_oss_sex_val igs_ad_interface_all.sex%TYPE;
645:
646: BEGIN
647: -- initialize variables

Line 644: l_oss_sex_val igs_ad_interface_all.sex%TYPE;

640: l_alt_pers_seq_id igs_ad_api_int.interface_api_id%TYPE; -- for holding Alternate Person ID sequence
641: l_adm_batch_id igs_ad_imp_batch_det.batch_id%TYPE; -- for holding Adm Imp Proc batch ID.
642: l_source_type_id igs_pe_src_types_all.source_type_id%TYPE;
643: l_interface_id igs_ad_interface_all.interface_id%TYPE;
644: l_oss_sex_val igs_ad_interface_all.sex%TYPE;
645:
646: BEGIN
647: -- initialize variables
648: l_created_by := fnd_global.user_id;

Line 1127: INSERT INTO igs_ad_interface_all

1123: CLOSE get_interface_id ;
1124:
1125:
1126: -- Populate Adm Interface table.
1127: INSERT INTO igs_ad_interface_all
1128: (
1129: interface_id,
1130: batch_id,
1131: source_type_id,