APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_AD_BUILDING

Line 5783: CURSOR c_bld_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE,

5779:
5780: -- Carry out derivations and validate them
5781: PROCEDURE validate_derivations ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) AS
5782:
5783: CURSOR c_bld_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE,
5784: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
5785: SELECT building_id
5786: FROM igs_ad_building_all
5787: WHERE building_cd = cp_building_cd

Line 5784: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS

5780: -- Carry out derivations and validate them
5781: PROCEDURE validate_derivations ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) AS
5782:
5783: CURSOR c_bld_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE,
5784: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
5785: SELECT building_id
5786: FROM igs_ad_building_all
5787: WHERE building_cd = cp_building_cd
5788: AND location_cd = cp_location_cd;

Line 5786: FROM igs_ad_building_all

5782:
5783: CURSOR c_bld_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE,
5784: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
5785: SELECT building_id
5786: FROM igs_ad_building_all
5787: WHERE building_cd = cp_building_cd
5788: AND location_cd = cp_location_cd;
5789:
5790: CURSOR c_room_id ( cp_building_id igs_ad_building_all.building_id%TYPE,

Line 5790: CURSOR c_room_id ( cp_building_id igs_ad_building_all.building_id%TYPE,

5786: FROM igs_ad_building_all
5787: WHERE building_cd = cp_building_cd
5788: AND location_cd = cp_location_cd;
5789:
5790: CURSOR c_room_id ( cp_building_id igs_ad_building_all.building_id%TYPE,
5791: cp_room_cd igs_ad_room_all.room_cd%TYPE ) IS
5792: SELECT room_id
5793: FROM igs_ad_room_all
5794: WHERE room_cd = cp_room_cd

Line 5972: IF NOT igs_ad_building_pkg.get_pk_for_validation ( l_n_building_id ) THEN

5968:
5969:
5970: -- Check for the existence of Buildings
5971: IF l_n_building_id IS NOT NULL THEN
5972: IF NOT igs_ad_building_pkg.get_pk_for_validation ( l_n_building_id ) THEN
5973: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'BUILDING_CODE', 'LEGACY_TOKENS', FALSE);
5974: p_usec_assmnt_rec.status := 'E';
5975: END IF;
5976: END IF;

Line 8121: FROM igs_ad_building

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
8121: FROM igs_ad_building
8122: WHERE location_cd = cp_location_cd
8123: AND building_cd=cp_building_code;
8124:
8125: CURSOR cur_room(cp_building_id IN VARCHAR2,cp_room_cd IN VARCHAR2) IS

Line 8247: IF NOT igs_ad_building_pkg.get_pk_for_validation ( l_n_building_id ) THEN

8243: p_usec_plus_hr_rec.status := 'E';
8244: END IF;
8245:
8246: -- Check for existence of Building Code Code
8247: IF NOT igs_ad_building_pkg.get_pk_for_validation ( l_n_building_id ) THEN
8248: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'BUILDING_CODE', 'LEGACY_TOKENS', FALSE);
8249: p_usec_plus_hr_rec.status := 'E';
8250: END IF;
8251: