APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_AD_INTERFACE

Line 123: SELECT igs_ad_interface_s.NEXTVAL int_id

119: SYSDATE BETWEEN NVL(pp.effective_start_date,SYSDATE) AND NVL(pp.effective_end_date,SYSDATE);
120: c_pe_person_rec c_pe_person%ROWTYPE;
121: -- Get the interface id
122: CURSOR c_int_id IS
123: SELECT igs_ad_interface_s.NEXTVAL int_id
124: FROM dual;
125: c_int_id_rec c_int_id%ROWTYPE;
126:
127: -- Get application interface ID

Line 281: -- Get the interface ID for this person to be used to create record in igs_ad_interface table

277: fnd_file.put_line( fnd_file.LOG ,fnd_message.get );
278: ELSE
279: -- Since person is present in OSS , get his person details to populate person interface tables
280:
281: -- Get the interface ID for this person to be used to create record in igs_ad_interface table
282: c_int_id_rec := NULL ;
283: OPEN c_int_id;
284: FETCH c_int_id INTO c_int_id_rec;
285: CLOSE c_int_id;

Line 288: INSERT INTO igs_ad_interface(person_number,

284: FETCH c_int_id INTO c_int_id_rec;
285: CLOSE c_int_id;
286:
287: -- Create an interface record for this person
288: INSERT INTO igs_ad_interface(person_number,
289: interface_id,
290: batch_id,
291: org_id,
292: source_type_id,

Line 706: l_interface_run_id igs_ad_interface_ctl.interface_run_id%TYPE;

702: FROM igs_pe_match_sets
703: WHERE source_type_id = p_source_type_id;
704: match_set_rec cur_match_set%ROWTYPE;
705:
706: l_interface_run_id igs_ad_interface_ctl.interface_run_id%TYPE;
707: l_errbuff VARCHAR2(100) ;
708: l_retcode NUMBER ;
709:
710:

Line 935: SELECT igs_ad_interface_ctl_s.NEXTVAL

931:
932:
933: -- Get the interface ctl ID
934: CURSOR c_interface_run_id IS
935: SELECT igs_ad_interface_ctl_s.NEXTVAL
936: FROM dual ;
937: l_interface_run_id NUMBER ;
938:
939: -- Get the application to be voided ,i.e the currently active application instance

Line 2247: SELECT igs_ad_interface_batch_id_s.NEXTVAL

2243: c_ap_ch_rec c_ap_ch%ROWTYPE ;
2244:
2245: -- Get the Batch ID for admission application import process
2246: CURSOR c_bat_id IS
2247: SELECT igs_ad_interface_batch_id_s.NEXTVAL
2248: FROM dual;
2249:
2250: -- Get the Source type ID of UCAS for admission import process
2251: CURSOR c_src_type_id IS

Line 2264: FROM igs_ad_interface a, igs_ad_apl_int b , igs_ad_ps_appl_inst_int c ,

2260: CURSOR c_appl_int( cp_batch_id igs_uc_app_choices.batch_id%TYPE,
2261: cp_app_no igs_uc_app_choices.app_no%TYPE ,
2262: cp_choice_no igs_uc_app_choices.choice_no%TYPE ) IS
2263: SELECT a.interface_id -- if application details import fails
2264: FROM igs_ad_interface a, igs_ad_apl_int b , igs_ad_ps_appl_inst_int c ,
2265: igs_uc_app_choices ch , igs_uc_applicants ap
2266: WHERE a.batch_id = cp_batch_id AND
2267: a.interface_id = b.interface_id AND
2268: b.choice_number = ch.choice_no AND

Line 2278: FROM igs_ad_interface a, igs_ad_apl_int b , igs_ad_ps_appl_inst_int c ,

2274: ch.app_no = cp_app_no AND
2275: ch.choice_no = cp_choice_no
2276: UNION -- if person or person details import fail
2277: SELECT a.interface_id
2278: FROM igs_ad_interface a, igs_ad_apl_int b , igs_ad_ps_appl_inst_int c ,
2279: igs_uc_app_choices ch , igs_uc_applicants ap
2280: WHERE a.batch_id = cp_batch_id AND
2281: a.interface_id = b.interface_id AND
2282: b.choice_number = ch.choice_no AND