APPS.IGS_OR_VAL_LOC dependencies on IGS_AD_LOCATION_ALL

Line 31: p_location_type IGS_AD_LOCATION_ALL.location_type%TYPE ,

27: END orgp_val_loc_type;
28: --
29: -- Retrofitted
30: FUNCTION assp_val_loc_coord(
31: p_location_type IGS_AD_LOCATION_ALL.location_type%TYPE ,
32: p_coord_person_id IGS_AD_LOCATION_ALL.coord_person_id%TYPE ,
33: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
34: RETURN BOOLEAN AS
35: gv_other_detail VARCHAR2(255);

Line 32: p_coord_person_id IGS_AD_LOCATION_ALL.coord_person_id%TYPE ,

28: --
29: -- Retrofitted
30: FUNCTION assp_val_loc_coord(
31: p_location_type IGS_AD_LOCATION_ALL.location_type%TYPE ,
32: p_coord_person_id IGS_AD_LOCATION_ALL.coord_person_id%TYPE ,
33: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
34: RETURN BOOLEAN AS
35: gv_other_detail VARCHAR2(255);
36: BEGIN -- assp_val_loc_coord

Line 66: p_location_cd IGS_AD_LOCATION_ALL.location_cd%TYPE ,

62: END assp_val_loc_coord;
63: --
64: -- Retrofitted
65: FUNCTION assp_val_loc_ve_open(
66: p_location_cd IGS_AD_LOCATION_ALL.location_cd%TYPE ,
67: p_location_type IGS_AD_LOCATION_ALL.location_type%TYPE ,
68: p_closed_ind IGS_AD_LOCATION_ALL.closed_ind%TYPE ,
69: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
70: RETURN BOOLEAN AS

Line 67: p_location_type IGS_AD_LOCATION_ALL.location_type%TYPE ,

63: --
64: -- Retrofitted
65: FUNCTION assp_val_loc_ve_open(
66: p_location_cd IGS_AD_LOCATION_ALL.location_cd%TYPE ,
67: p_location_type IGS_AD_LOCATION_ALL.location_type%TYPE ,
68: p_closed_ind IGS_AD_LOCATION_ALL.closed_ind%TYPE ,
69: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
70: RETURN BOOLEAN AS
71: gv_other_detail VARCHAR2(255);

Line 68: p_closed_ind IGS_AD_LOCATION_ALL.closed_ind%TYPE ,

64: -- Retrofitted
65: FUNCTION assp_val_loc_ve_open(
66: p_location_cd IGS_AD_LOCATION_ALL.location_cd%TYPE ,
67: p_location_type IGS_AD_LOCATION_ALL.location_type%TYPE ,
68: p_closed_ind IGS_AD_LOCATION_ALL.closed_ind%TYPE ,
69: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
70: RETURN BOOLEAN AS
71: gv_other_detail VARCHAR2(255);
72: BEGIN -- assp_val_loc_ve_open

Line 115: p_location_cd IGS_AD_LOCATION_ALL.location_cd%TYPE ,

111: END assp_val_loc_ve_open;
112: --
113: -- Retrofitted
114: FUNCTION assp_val_loc_ve_xist(
115: p_location_cd IGS_AD_LOCATION_ALL.location_cd%TYPE ,
116: p_new_location_type IGS_AD_LOCATION_ALL.location_type%TYPE ,
117: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
118: RETURN BOOLEAN AS
119: gv_other_detail VARCHAR2(255);

Line 116: p_new_location_type IGS_AD_LOCATION_ALL.location_type%TYPE ,

112: --
113: -- Retrofitted
114: FUNCTION assp_val_loc_ve_xist(
115: p_location_cd IGS_AD_LOCATION_ALL.location_cd%TYPE ,
116: p_new_location_type IGS_AD_LOCATION_ALL.location_type%TYPE ,
117: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
118: RETURN BOOLEAN AS
119: gv_other_detail VARCHAR2(255);
120: BEGIN -- assp_val_loc_ve_xist