APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_PE_SRC_TYPES_ALL

Line 456: p_source_type_id igs_pe_src_types_all.source_type_id%TYPE) IS

452:
453:
454:
455: PROCEDURE proc_invoke_adm_imp_process(p_batch_id NUMBER,
456: p_source_type_id igs_pe_src_types_all.source_type_id%TYPE) IS
457: /******************************************************************
458: Created By : rgangara
459: Date Created By : 12-JUN-03
460: Purpose : LOCAL PROCEDURE called from process_IVSTARN Procedure to

Line 608: FROM igs_pe_src_types_all

604:
605: -- Get the Source Type ID value
606: CURSOR src_types_cur IS
607: SELECT source_type_id
608: FROM igs_pe_src_types_all
609: WHERE source_type = 'UCAS PER';
610:
611: -- Cursor to get the Interface ID needed while populating records into Adm Interface table.
612: CURSOR get_interface_id IS

Line 642: l_source_type_id igs_pe_src_types_all.source_type_id%TYPE;

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;
645:
646: BEGIN