APPS.IGS_AD_IMP_001 dependencies on IGS_AD_IMP_BATCH_DET

Line 603: l_batch_desc igs_ad_imp_batch_det.batch_desc%TYPE;

599: l_status VARCHAR2(5);
600: l_industry VARCHAR2(5);
601: l_schema VARCHAR2(30);
602:
603: l_batch_desc igs_ad_imp_batch_det.batch_desc%TYPE;
604: l_source_type igs_pe_src_types_all.system_source_type%TYPE;
605: l_match_set_name igs_pe_match_sets_all.match_set_name%TYPE;
606: l_interface_run_id igs_ad_interface_ctl.interface_run_id%TYPE;
607: l_rowid VARCHAR2(100);

Line 642: FROM igs_ad_imp_batch_det

638: igs_ge_msg_stack.initialize;
639:
640: BEGIN
641: SELECT batch_desc INTO l_batch_desc
642: FROM igs_ad_imp_batch_det
643: WHERE batch_id = p_batch_id ;
644:
645: SELECT system_source_type INTO l_source_type
646: FROM igs_pe_src_types_all