APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USO_CM_GRP_PKG

Line 3224: IF igs_ps_uso_cm_grp_pkg.get_uk_for_validation (x_class_meet_group_name=>p_uso_cm_grp_rec.class_meet_group_name,

3220: PROCEDURE validate_db_cons ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,p_insert_update VARCHAR2 ) AS
3221: BEGIN
3222: IF (p_insert_update = 'I') THEN
3223: /* Unique Key Validation */
3224: IF igs_ps_uso_cm_grp_pkg.get_uk_for_validation (x_class_meet_group_name=>p_uso_cm_grp_rec.class_meet_group_name,
3225: x_cal_type=>l_c_cal_type,
3226: x_ci_sequence_number=>l_n_seq_num) THEN
3227: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'USEC_MEET_WITH_CLASS_GROUP', 'LEGACY_TOKENS', FALSE);
3228: p_uso_cm_grp_rec.status := 'W';

Line 3565: IF NOT igs_ps_uso_cm_grp_pkg.get_pk_for_validation ( l_n_class_meet_group_id ) THEN

3561: p_uso_clas_meet_rec.status := 'E';
3562: END IF;
3563:
3564: /* Validate FK Constraints */
3565: IF NOT igs_ps_uso_cm_grp_pkg.get_pk_for_validation ( l_n_class_meet_group_id ) THEN
3566: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'USEC_MEET_WITH_CLASS_GROUP', 'LEGACY_TOKENS', FALSE);
3567: p_uso_clas_meet_rec.status := 'E';
3568: END IF;
3569: