eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_HE_CODE_MAP_VAL

Line 178: (p_he_code_map_val IN igs_he_code_map_val%ROWTYPE,

174: modified to use bind variables.
175: Added new internal procedure - get_map_values_from_SQL()
176: ----------------------------------------------------------------------*/
177: PROCEDURE get_map_values
178: (p_he_code_map_val IN igs_he_code_map_val%ROWTYPE,
179: p_value_from IN VARCHAR2,
180: p_return_value OUT NOCOPY igs_he_code_map_val.map1%TYPE)
181: IS
182:

Line 180: p_return_value OUT NOCOPY igs_he_code_map_val.map1%TYPE)

176: ----------------------------------------------------------------------*/
177: PROCEDURE get_map_values
178: (p_he_code_map_val IN igs_he_code_map_val%ROWTYPE,
179: p_value_from IN VARCHAR2,
180: p_return_value OUT NOCOPY igs_he_code_map_val.map1%TYPE)
181: IS
182:
183: CURSOR cur_map1 (p_assoc igs_he_code_map_val.association_code%TYPE ,
184: p_map2 igs_he_code_map_val.map2%TYPE ) IS

Line 183: CURSOR cur_map1 (p_assoc igs_he_code_map_val.association_code%TYPE ,

179: p_value_from IN VARCHAR2,
180: p_return_value OUT NOCOPY igs_he_code_map_val.map1%TYPE)
181: IS
182:
183: CURSOR cur_map1 (p_assoc igs_he_code_map_val.association_code%TYPE ,
184: p_map2 igs_he_code_map_val.map2%TYPE ) IS
185: SELECT map1
186: FROM igs_he_code_map_val
187: WHERE association_code = p_assoc

Line 184: p_map2 igs_he_code_map_val.map2%TYPE ) IS

180: p_return_value OUT NOCOPY igs_he_code_map_val.map1%TYPE)
181: IS
182:
183: CURSOR cur_map1 (p_assoc igs_he_code_map_val.association_code%TYPE ,
184: p_map2 igs_he_code_map_val.map2%TYPE ) IS
185: SELECT map1
186: FROM igs_he_code_map_val
187: WHERE association_code = p_assoc
188: AND map2 = p_map2;

Line 186: FROM igs_he_code_map_val

182:
183: CURSOR cur_map1 (p_assoc igs_he_code_map_val.association_code%TYPE ,
184: p_map2 igs_he_code_map_val.map2%TYPE ) IS
185: SELECT map1
186: FROM igs_he_code_map_val
187: WHERE association_code = p_assoc
188: AND map2 = p_map2;
189:
190: CURSOR cur_map2 (p_assoc igs_he_code_map_val.association_code%TYPE ,

Line 190: CURSOR cur_map2 (p_assoc igs_he_code_map_val.association_code%TYPE ,

186: FROM igs_he_code_map_val
187: WHERE association_code = p_assoc
188: AND map2 = p_map2;
189:
190: CURSOR cur_map2 (p_assoc igs_he_code_map_val.association_code%TYPE ,
191: p_map1 igs_he_code_map_val.map1%TYPE ) IS
192: SELECT map2
193: FROM igs_he_code_map_val
194: WHERE association_code = p_assoc

Line 191: p_map1 igs_he_code_map_val.map1%TYPE ) IS

187: WHERE association_code = p_assoc
188: AND map2 = p_map2;
189:
190: CURSOR cur_map2 (p_assoc igs_he_code_map_val.association_code%TYPE ,
191: p_map1 igs_he_code_map_val.map1%TYPE ) IS
192: SELECT map2
193: FROM igs_he_code_map_val
194: WHERE association_code = p_assoc
195: AND map1 = p_map1;

Line 193: FROM igs_he_code_map_val

189:
190: CURSOR cur_map2 (p_assoc igs_he_code_map_val.association_code%TYPE ,
191: p_map1 igs_he_code_map_val.map1%TYPE ) IS
192: SELECT map2
193: FROM igs_he_code_map_val
194: WHERE association_code = p_assoc
195: AND map1 = p_map1;
196:
197: CURSOR cur_map3 (p_assoc igs_he_code_map_val.association_code%TYPE ,

Line 197: CURSOR cur_map3 (p_assoc igs_he_code_map_val.association_code%TYPE ,

193: FROM igs_he_code_map_val
194: WHERE association_code = p_assoc
195: AND map1 = p_map1;
196:
197: CURSOR cur_map3 (p_assoc igs_he_code_map_val.association_code%TYPE ,
198: p_map2 igs_he_code_map_val.map2%TYPE ) IS
199: SELECT map3
200: FROM igs_he_code_map_val
201: WHERE association_code = p_assoc

Line 198: p_map2 igs_he_code_map_val.map2%TYPE ) IS

194: WHERE association_code = p_assoc
195: AND map1 = p_map1;
196:
197: CURSOR cur_map3 (p_assoc igs_he_code_map_val.association_code%TYPE ,
198: p_map2 igs_he_code_map_val.map2%TYPE ) IS
199: SELECT map3
200: FROM igs_he_code_map_val
201: WHERE association_code = p_assoc
202: AND map2 = p_map2;

Line 200: FROM igs_he_code_map_val

196:
197: CURSOR cur_map3 (p_assoc igs_he_code_map_val.association_code%TYPE ,
198: p_map2 igs_he_code_map_val.map2%TYPE ) IS
199: SELECT map3
200: FROM igs_he_code_map_val
201: WHERE association_code = p_assoc
202: AND map2 = p_map2;
203:
204: CURSOR cur_map4 (p_assoc igs_he_code_map_val.association_code%TYPE ,

Line 204: CURSOR cur_map4 (p_assoc igs_he_code_map_val.association_code%TYPE ,

200: FROM igs_he_code_map_val
201: WHERE association_code = p_assoc
202: AND map2 = p_map2;
203:
204: CURSOR cur_map4 (p_assoc igs_he_code_map_val.association_code%TYPE ,
205: p_map2 igs_he_code_map_val.map2%TYPE,
206: p_map3 igs_he_code_map_val.map3%TYPE ) IS
207: SELECT map1
208: FROM igs_he_code_map_val

Line 205: p_map2 igs_he_code_map_val.map2%TYPE,

201: WHERE association_code = p_assoc
202: AND map2 = p_map2;
203:
204: CURSOR cur_map4 (p_assoc igs_he_code_map_val.association_code%TYPE ,
205: p_map2 igs_he_code_map_val.map2%TYPE,
206: p_map3 igs_he_code_map_val.map3%TYPE ) IS
207: SELECT map1
208: FROM igs_he_code_map_val
209: WHERE association_code = p_assoc

Line 206: p_map3 igs_he_code_map_val.map3%TYPE ) IS

202: AND map2 = p_map2;
203:
204: CURSOR cur_map4 (p_assoc igs_he_code_map_val.association_code%TYPE ,
205: p_map2 igs_he_code_map_val.map2%TYPE,
206: p_map3 igs_he_code_map_val.map3%TYPE ) IS
207: SELECT map1
208: FROM igs_he_code_map_val
209: WHERE association_code = p_assoc
210: AND map2 = p_map2

Line 208: FROM igs_he_code_map_val

204: CURSOR cur_map4 (p_assoc igs_he_code_map_val.association_code%TYPE ,
205: p_map2 igs_he_code_map_val.map2%TYPE,
206: p_map3 igs_he_code_map_val.map3%TYPE ) IS
207: SELECT map1
208: FROM igs_he_code_map_val
209: WHERE association_code = p_assoc
210: AND map2 = p_map2
211: AND map3 = p_map3;
212:

Line 213: CURSOR cur_map5 (p_assoc igs_he_code_map_val.association_code%TYPE ,

209: WHERE association_code = p_assoc
210: AND map2 = p_map2
211: AND map3 = p_map3;
212:
213: CURSOR cur_map5 (p_assoc igs_he_code_map_val.association_code%TYPE ,
214: p_map2 igs_he_code_map_val.map2%TYPE,
215: p_map3 igs_he_code_map_val.map3%TYPE,
216: p_map4 igs_he_code_map_val.map5%TYPE ) IS
217: SELECT map1

Line 214: p_map2 igs_he_code_map_val.map2%TYPE,

210: AND map2 = p_map2
211: AND map3 = p_map3;
212:
213: CURSOR cur_map5 (p_assoc igs_he_code_map_val.association_code%TYPE ,
214: p_map2 igs_he_code_map_val.map2%TYPE,
215: p_map3 igs_he_code_map_val.map3%TYPE,
216: p_map4 igs_he_code_map_val.map5%TYPE ) IS
217: SELECT map1
218: FROM igs_he_code_map_val

Line 215: p_map3 igs_he_code_map_val.map3%TYPE,

211: AND map3 = p_map3;
212:
213: CURSOR cur_map5 (p_assoc igs_he_code_map_val.association_code%TYPE ,
214: p_map2 igs_he_code_map_val.map2%TYPE,
215: p_map3 igs_he_code_map_val.map3%TYPE,
216: p_map4 igs_he_code_map_val.map5%TYPE ) IS
217: SELECT map1
218: FROM igs_he_code_map_val
219: WHERE association_code = p_assoc

Line 216: p_map4 igs_he_code_map_val.map5%TYPE ) IS

212:
213: CURSOR cur_map5 (p_assoc igs_he_code_map_val.association_code%TYPE ,
214: p_map2 igs_he_code_map_val.map2%TYPE,
215: p_map3 igs_he_code_map_val.map3%TYPE,
216: p_map4 igs_he_code_map_val.map5%TYPE ) IS
217: SELECT map1
218: FROM igs_he_code_map_val
219: WHERE association_code = p_assoc
220: AND map2 = p_map2

Line 218: FROM igs_he_code_map_val

214: p_map2 igs_he_code_map_val.map2%TYPE,
215: p_map3 igs_he_code_map_val.map3%TYPE,
216: p_map4 igs_he_code_map_val.map5%TYPE ) IS
217: SELECT map1
218: FROM igs_he_code_map_val
219: WHERE association_code = p_assoc
220: AND map2 = p_map2
221: AND map3 = p_map3
222: AND map4 = p_map4;

Line 228: PROCEDURE get_map_values_from_sql(p_he_code_map_val IN igs_he_code_map_val%ROWTYPE,

224:
225: l_found_map BOOLEAN;
226:
227:
228: PROCEDURE get_map_values_from_sql(p_he_code_map_val IN igs_he_code_map_val%ROWTYPE,
229: p_value_from IN VARCHAR2,
230: p_return_value OUT NOCOPY igs_he_code_map_val.map1%TYPE)
231: IS
232:

Line 230: p_return_value OUT NOCOPY igs_he_code_map_val.map1%TYPE)

226:
227:
228: PROCEDURE get_map_values_from_sql(p_he_code_map_val IN igs_he_code_map_val%ROWTYPE,
229: p_value_from IN VARCHAR2,
230: p_return_value OUT NOCOPY igs_he_code_map_val.map1%TYPE)
231: IS
232:
233: /******************************************************************************
234: Created By : JCHAKRAB

Line 274: ' FROM igs_he_code_map_val '||

270:
271: BEGIN
272:
273: l_sql_stmt := ' SELECT '||p_value_from ||
274: ' FROM igs_he_code_map_val '||
275: ' WHERE association_code = '''||p_he_code_map_val.association_code ||'''';
276:
277: If p_he_code_map_val.map1 IS NOT NULL
278: THEN