DBA Data[Home] [Help]

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USEC_OCCURS_PKG

Line 969: IF NOT igs_ps_usec_occurs_pkg.get_pk_for_validation (l_n_uso_id) THEN

965: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'FACILITY_CODE', 'LEGACY_TOKENS', FALSE);
966: p_uso_fclt_rec.status := 'E';
967: END IF;
968:
969: IF NOT igs_ps_usec_occurs_pkg.get_pk_for_validation (l_n_uso_id) THEN
970: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'USEC_OCCUR', 'LEGACY_TOKENS', FALSE);
971: p_uso_fclt_rec.status := 'E';
972: END IF;
973:

Line 6357: IF igs_ps_usec_occurs_pkg.get_pk_for_validation(p_uso_ins_rec.production_uso_id) THEN

6353:
6354: -- if the production unit section occurrence identifier is provided then validate it
6355: -- otherwise derive the production unit section occurrence identifier.
6356: IF p_uso_ins_rec.production_uso_id IS NOT NULL THEN
6357: IF igs_ps_usec_occurs_pkg.get_pk_for_validation(p_uso_ins_rec.production_uso_id) THEN
6358: l_n_uso_id := p_uso_ins_rec.production_uso_id;
6359: -- Also derive the unit section identifier uoo_id for the the unit section occurrence identifier
6360: OPEN c_uoo_id(l_n_uso_id);
6361: FETCH c_uoo_id INTO l_n_uoo_id;