APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USEC_X_GRP_PKG

Line 3974: IF igs_ps_usec_x_grp_pkg.get_uk_for_validation (x_usec_x_listed_group_name=>p_usec_x_grp_rec.usec_x_listed_group_name,

3970: PROCEDURE validate_db_cons ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,p_insert_update VARCHAR2 ) AS
3971: BEGIN
3972: IF (p_insert_update = 'I') THEN
3973: /* Unique Key Validation */
3974: IF igs_ps_usec_x_grp_pkg.get_uk_for_validation (x_usec_x_listed_group_name=>p_usec_x_grp_rec.usec_x_listed_group_name,
3975: x_cal_type=>l_c_cal_type,
3976: x_ci_sequence_number=>l_n_seq_num) THEN
3977: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'USEC_CROSS_LIST_GROUP', 'LEGACY_TOKENS', FALSE);
3978: p_usec_x_grp_rec.status := 'W';

Line 4320: IF NOT igs_ps_usec_x_grp_pkg.get_pk_for_validation ( l_n_usec_x_listed_group_id ) THEN

4316: p_usec_x_grpmem.status := 'E';
4317: END IF;
4318:
4319: /* Validate FK Constraints */
4320: IF NOT igs_ps_usec_x_grp_pkg.get_pk_for_validation ( l_n_usec_x_listed_group_id ) THEN
4321: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'USEC_CROSS_LIST_GROUP', 'LEGACY_TOKENS', FALSE);
4322: p_usec_x_grpmem.status := 'E';
4323: END IF;
4324: