APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_AD_API_INT

Line 623: SELECT igs_ad_api_int_s.NEXTVAL

619: FROM DUAL;
620:
621: -- cursor to get the batch ID from sequence.
622: CURSOR get_alt_pers_id_cur IS
623: SELECT igs_ad_api_int_s.NEXTVAL
624: FROM DUAL;
625:
626: old_starn_rec old_starn_cur%ROWTYPE;
627: l_oss_title igs_pe_person_base_v.title%TYPE;

Line 632: l_alt_pers_id_type igs_ad_api_int.person_id_type%TYPE;

628: l_system_code igs_uc_ucas_control.system_code%TYPE;
629: l_invoke_adm_import_Proc_flag VARCHAR2(1) ; -- Flag to identify atleast one new rec imported
630: l_new_rec_flag VARCHAR2(1); -- flag to check whether a new record (i.e. insert) or old record(i.e.update)
631: l_recs_inserted NUMBER := 0;
632: l_alt_pers_id_type igs_ad_api_int.person_id_type%TYPE;
633:
634: -- for populating into Adm Int tables
635: l_created_by NUMBER ;
636: l_last_updated_by NUMBER ;

Line 640: l_alt_pers_seq_id igs_ad_api_int.interface_api_id%TYPE; -- for holding Alternate Person ID sequence

636: l_last_updated_by NUMBER ;
637: l_last_update_login NUMBER ;
638: l_creation_date DATE ;
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;

Line 1218: INSERT INTO igs_ad_api_int

1214: FETCH get_alt_pers_id_cur INTO l_alt_pers_seq_id;
1215: CLOSE get_alt_pers_id_cur ;
1216:
1217: -- insert into table
1218: INSERT INTO igs_ad_api_int
1219: (
1220: interface_api_id
1221: ,interface_id
1222: ,person_id_type