APPS.IGS_PS_UNIT_VER_PKG dependencies on IGS_PS_UNIT_VER_V

Line 569: FROM igs_ps_unit_ver_v uv

565: -- cursor which picks all the unit codes whose curriculum id is closed
566:
567: CURSOR c_igs_ps_unit_ver_all is
568: SELECT '1'
569: FROM igs_ps_unit_ver_v uv
570: WHERE unit_cd = new_references.unit_cd
571: AND version_number = new_references.version_number
572: AND curriculum_id = new_references.curriculum_id
573: AND EXISTS (SELECT '1'

Line 3276: p_n_version_number igs_ps_unit_ver.version_number%TYPE,

3272: END Before_DML;
3273: ----------------------------------------------------------------------------
3274: PROCEDURE dflt_unit_ref_code (
3275: p_c_unit_cd igs_ps_unit_ver.unit_cd%TYPE,
3276: p_n_version_number igs_ps_unit_ver.version_number%TYPE,
3277: p_c_message_name OUT NOCOPY VARCHAR2
3278: ) AS
3279: CURSOR c_igs_ge_ref_cd_type IS
3280: SELECT reference_cd_type

Line 3337: l_version_number igs_ps_unit_ver.version_number%TYPE;

3333: SELECT unit_cd, version_number
3334: FROM igs_ps_unit_ver
3335: WHERE ROWID = cp_rowid;
3336: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
3337: l_version_number igs_ps_unit_ver.version_number%TYPE;
3338:
3339: CURSOR c_occurs(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE , cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
3340: SELECT uso.unit_section_occurrence_id
3341: FROM Igs_ps_usec_occurs_all uso,

Line 3339: CURSOR c_occurs(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE , cp_version_number igs_ps_unit_ver.version_number%TYPE) IS

3335: WHERE ROWID = cp_rowid;
3336: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
3337: l_version_number igs_ps_unit_ver.version_number%TYPE;
3338:
3339: CURSOR c_occurs(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE , cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
3340: SELECT uso.unit_section_occurrence_id
3341: FROM Igs_ps_usec_occurs_all uso,
3342: Igs_ps_unit_ofr_opt_all us,
3343: Igs_ca_inst_all ci