APPS.IGS_OR_GEN_001 dependencies on IGS_AD_LOCATION

Line 85: p_location_cd IGS_AD_LOCATION_ALL.location_cd%TYPE )

81: END orgp_get_local_inst;
82:
83:
84: FUNCTION orgp_get_s_loc_type(
85: p_location_cd IGS_AD_LOCATION_ALL.location_cd%TYPE )
86: RETURN VARCHAR2 IS
87: gv_other_detail VARCHAR2(255);
88: BEGIN -- orgp_get_s_loc_type
89: -- This module fetches the value for s_location_type for a IGS_AD_LOCATION

Line 89: -- This module fetches the value for s_location_type for a IGS_AD_LOCATION

85: p_location_cd IGS_AD_LOCATION_ALL.location_cd%TYPE )
86: RETURN VARCHAR2 IS
87: gv_other_detail VARCHAR2(255);
88: BEGIN -- orgp_get_s_loc_type
89: -- This module fetches the value for s_location_type for a IGS_AD_LOCATION
90: -- from the IGS_AD_LOCATION_TYPE table.
91: DECLARE
92: CURSOR c_lot IS
93: SELECT lot.s_location_type

Line 90: -- from the IGS_AD_LOCATION_TYPE table.

86: RETURN VARCHAR2 IS
87: gv_other_detail VARCHAR2(255);
88: BEGIN -- orgp_get_s_loc_type
89: -- This module fetches the value for s_location_type for a IGS_AD_LOCATION
90: -- from the IGS_AD_LOCATION_TYPE table.
91: DECLARE
92: CURSOR c_lot IS
93: SELECT lot.s_location_type
94: FROM IGS_AD_LOCATION_TYPE lot,

Line 94: FROM IGS_AD_LOCATION_TYPE lot,

90: -- from the IGS_AD_LOCATION_TYPE table.
91: DECLARE
92: CURSOR c_lot IS
93: SELECT lot.s_location_type
94: FROM IGS_AD_LOCATION_TYPE lot,
95: IGS_AD_LOCATION loc
96: WHERE lot.location_type = loc.location_type AND
97: loc.location_cd = p_location_cd;
98: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;

Line 95: IGS_AD_LOCATION loc

91: DECLARE
92: CURSOR c_lot IS
93: SELECT lot.s_location_type
94: FROM IGS_AD_LOCATION_TYPE lot,
95: IGS_AD_LOCATION loc
96: WHERE lot.location_type = loc.location_type AND
97: loc.location_cd = p_location_cd;
98: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
99: BEGIN

Line 98: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;

94: FROM IGS_AD_LOCATION_TYPE lot,
95: IGS_AD_LOCATION loc
96: WHERE lot.location_type = loc.location_type AND
97: loc.location_cd = p_location_cd;
98: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
99: BEGIN
100: -- Set the default value
101: v_s_location_type := NULL;
102: OPEN c_lot;

Line 122: p_location_type IGS_AD_LOCATION_ALL.location_type%TYPE )

118: END orgp_get_s_loc_type;
119:
120:
121: FUNCTION orgp_get_s_loc_type2(
122: p_location_type IGS_AD_LOCATION_ALL.location_type%TYPE )
123: RETURN VARCHAR2 IS
124: gv_other_detail VARCHAR2(255);
125: BEGIN -- orgp_get_s_loc_type2
126: -- This module fetches the value for s_location_type for a

Line 127: -- IGS_AD_LOCATION?s IGS_AD_LOCATION type from the IGS_AD_LOCATION_TYPE table.

123: RETURN VARCHAR2 IS
124: gv_other_detail VARCHAR2(255);
125: BEGIN -- orgp_get_s_loc_type2
126: -- This module fetches the value for s_location_type for a
127: -- IGS_AD_LOCATION?s IGS_AD_LOCATION type from the IGS_AD_LOCATION_TYPE table.
128: -- It is similar to ORGP_GET_S_LOC_TYPE except that it fetches the record
129: -- using the IGS_AD_LOCATION type instead of the IGS_AD_LOCATION code as a parameter.
130: DECLARE
131: CURSOR c_lot IS

Line 129: -- using the IGS_AD_LOCATION type instead of the IGS_AD_LOCATION code as a parameter.

125: BEGIN -- orgp_get_s_loc_type2
126: -- This module fetches the value for s_location_type for a
127: -- IGS_AD_LOCATION?s IGS_AD_LOCATION type from the IGS_AD_LOCATION_TYPE table.
128: -- It is similar to ORGP_GET_S_LOC_TYPE except that it fetches the record
129: -- using the IGS_AD_LOCATION type instead of the IGS_AD_LOCATION code as a parameter.
130: DECLARE
131: CURSOR c_lot IS
132: SELECT s_location_type
133: FROM IGS_AD_LOCATION_TYPE

Line 133: FROM IGS_AD_LOCATION_TYPE

129: -- using the IGS_AD_LOCATION type instead of the IGS_AD_LOCATION code as a parameter.
130: DECLARE
131: CURSOR c_lot IS
132: SELECT s_location_type
133: FROM IGS_AD_LOCATION_TYPE
134: WHERE location_type = p_location_type;
135: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
136: BEGIN
137: -- Set the default value

Line 135: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;

131: CURSOR c_lot IS
132: SELECT s_location_type
133: FROM IGS_AD_LOCATION_TYPE
134: WHERE location_type = p_location_type;
135: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
136: BEGIN
137: -- Set the default value
138: v_s_location_type := NULL;
139: OPEN c_lot;