DBA Data[Home] [Help]

APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_AD_INTERFACE_CTL

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