APPS.IGS_PS_UNIT_VER_PKG dependencies on IGS_PS_UNT_CRCLM

Line 574: FROM igs_ps_unt_crclm ucur

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'
574: FROM igs_ps_unt_crclm ucur
575: WHERE ucur.curriculum_id = uv.curriculum_id
576: AND ucur.closed_ind = 'Y' ) ;
577:
578: l_c_igs_ps_unit_ver_all c_igs_ps_unit_ver_all%ROWTYPE ; -- cursor variable

Line 2329: ELSIF NOT igs_ps_unt_crclm_pkg.get_pk_for_validation (

2325: END IF;
2326: IF (((old_references.curriculum_id = new_references.curriculum_id)) OR
2327: ((new_references.curriculum_id IS NULL))) THEN
2328: NULL;
2329: ELSIF NOT igs_ps_unt_crclm_pkg.get_pk_for_validation (
2330: new_references.curriculum_id
2331: ) THEN
2332: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
2333: igs_ge_msg_stack.add;

Line 2888: PROCEDURE get_fk_igs_ps_unt_crclm_all (

2884: CLOSE cur_rowid;
2885:
2886: END get_fk_igs_ps_unit_subtitle;
2887: ---------------------------------------------------------------
2888: PROCEDURE get_fk_igs_ps_unt_crclm_all (
2889: x_curriculum_id IN VARCHAR2
2890: ) AS
2891: /*
2892: || Created By : apelleti

Line 2920: END get_fk_igs_ps_unt_crclm_all;

2916: RETURN;
2917: END IF;
2918: CLOSE cur_rowid;
2919:
2920: END get_fk_igs_ps_unt_crclm_all;
2921: ---------------------------------------------------------------
2922:
2923: PROCEDURE get_fk_igs_ca_inst_all (
2924: x_cal_type IN VARCHAR2,