APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USEC_ACT_TYPE

Line 8116: FROM igs_ps_usec_act_type

8112: l_c_ret_status VARCHAR2(30);
8113:
8114: CURSOR cur_activity_cd(cp_activity_type_code IN VARCHAR2) IS
8115: SELECT activity_type_id
8116: FROM igs_ps_usec_act_type
8117: WHERE activity_type_code=cp_activity_type_code;
8118:
8119: CURSOR cur_building(cp_location_cd IN VARCHAR2,cp_building_code IN VARCHAR2) IS
8120: SELECT building_id

Line 8235: IF NOT igs_ps_usec_act_type_pkg.get_pk_for_validation ( l_n_activity_id ) THEN

8231: p_usec_plus_hr_rec.status := 'E';
8232: END IF;
8233:
8234: -- Check for existence of Activity Code
8235: IF NOT igs_ps_usec_act_type_pkg.get_pk_for_validation ( l_n_activity_id ) THEN
8236: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'ACTIVITY_TYPE_CODE', 'LEGACY_TOKENS', FALSE);
8237: p_usec_plus_hr_rec.status := 'E';
8238: END IF;
8239: