DBA Data[Home] [Help]

APPS.IGS_EN_IVR_PUB dependencies on IGS_PS_VER

Line 171: l_primary_code igs_ps_ver.course_cd%TYPE;

167: l_person_id igs_pe_person_base_v.person_id%TYPE;
168: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
169: l_cal_type igs_ca_inst.cal_type%TYPE;
170: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
171: l_primary_code igs_ps_ver.course_cd%TYPE;
172: l_primary_version igs_ps_ver.version_number%TYPE;
173: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
174: l_error_message VARCHAR2(2000);
175: l_ret_status VARCHAR2(6);

Line 172: l_primary_version igs_ps_ver.version_number%TYPE;

168: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
169: l_cal_type igs_ca_inst.cal_type%TYPE;
170: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
171: l_primary_code igs_ps_ver.course_cd%TYPE;
172: l_primary_version igs_ps_ver.version_number%TYPE;
173: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
174: l_error_message VARCHAR2(2000);
175: l_ret_status VARCHAR2(6);
176: l_message_count NUMBER;

Line 808: l_primary_code igs_ps_ver.course_cd%TYPE;

804: l_person_id igs_pe_person_base_v.person_id%TYPE;
805: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
806: l_cal_type igs_ca_inst.cal_type%TYPE;
807: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
808: l_primary_code igs_ps_ver.course_cd%TYPE;
809: l_primary_version igs_ps_ver.version_number%TYPE;
810: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
811: l_message_data VARCHAR2(2000);
812: l_ret_status VARCHAR2(6);

Line 809: l_primary_version igs_ps_ver.version_number%TYPE;

805: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
806: l_cal_type igs_ca_inst.cal_type%TYPE;
807: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
808: l_primary_code igs_ps_ver.course_cd%TYPE;
809: l_primary_version igs_ps_ver.version_number%TYPE;
810: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
811: l_message_data VARCHAR2(2000);
812: l_ret_status VARCHAR2(6);
813: l_deny_warn igs_en_cpd_ext_v.notification_flag%TYPE;