APPS.IGS_EN_LGCY_PRC dependencies on IGS_LOOKUP_VALUES

Line 29: CURSOR gc_lkups (cp_lookup_code igs_lookup_values.lookup_code%TYPE,

25: smaddali 10-apr-06 Modified for bug#5091858 BUILD EN324
26: ******************************************************************************/
27:
28: -- cursor for find the lookup meaning for a given lookup code and type
29: CURSOR gc_lkups (cp_lookup_code igs_lookup_values.lookup_code%TYPE,
30: cp_lookup_type igs_lookup_values.lookup_type%TYPE) IS
31: SELECT meaning
32: FROM igs_lookup_values
33: WHERE lookup_code = cp_lookup_code

Line 30: cp_lookup_type igs_lookup_values.lookup_type%TYPE) IS

26: ******************************************************************************/
27:
28: -- cursor for find the lookup meaning for a given lookup code and type
29: CURSOR gc_lkups (cp_lookup_code igs_lookup_values.lookup_code%TYPE,
30: cp_lookup_type igs_lookup_values.lookup_type%TYPE) IS
31: SELECT meaning
32: FROM igs_lookup_values
33: WHERE lookup_code = cp_lookup_code
34: AND lookup_type = cp_lookup_type;

Line 32: FROM igs_lookup_values

28: -- cursor for find the lookup meaning for a given lookup code and type
29: CURSOR gc_lkups (cp_lookup_code igs_lookup_values.lookup_code%TYPE,
30: cp_lookup_type igs_lookup_values.lookup_type%TYPE) IS
31: SELECT meaning
32: FROM igs_lookup_values
33: WHERE lookup_code = cp_lookup_code
34: AND lookup_type = cp_lookup_type;
35:
36: -- Table Constants

Line 161: l_table_meaning igs_lookup_values.meaning%TYPE;

157: END;
158: -------------------------------------------------------------------------------
159: PROCEDURE log_resource_busy(p_int_table_code IN VARCHAR2) AS
160: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
161: l_table_meaning igs_lookup_values.meaning%TYPE;
162: l_meaning igs_lookup_values.meaning%TYPE;
163: BEGIN
164:
165: FND_MESSAGE.SET_NAME('FND','FND_LOCK_RECORD_ERROR');

Line 162: l_meaning igs_lookup_values.meaning%TYPE;

158: -------------------------------------------------------------------------------
159: PROCEDURE log_resource_busy(p_int_table_code IN VARCHAR2) AS
160: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
161: l_table_meaning igs_lookup_values.meaning%TYPE;
162: l_meaning igs_lookup_values.meaning%TYPE;
163: BEGIN
164:
165: FND_MESSAGE.SET_NAME('FND','FND_LOCK_RECORD_ERROR');
166: l_msg_text := FND_MESSAGE.GET;

Line 196: l_table_meaning igs_lookup_values.meaning%TYPE;

192: PROCEDURE log_headers(
193: p_int_table_code IN VARCHAR2
194: ) AS
195: l_msg_text5 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
196: l_table_meaning igs_lookup_values.meaning%TYPE;
197:
198: l_msg_text1 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
199: l_msg_text2 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
200: l_msg_text3 FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

Line 247: l_meaning igs_lookup_values.meaning%TYPE;

243: PROCEDURE log_suc_message(
244: P_int_table_id IN NUMBER
245: ) AS
246: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
247: l_meaning igs_lookup_values.meaning%TYPE;
248: BEGIN
249:
250: FND_MESSAGE.SET_NAME('IGS','IGS_EN_LGCY_SUCCESS');
251: l_msg_text := FND_MESSAGE.GET;

Line 284: l_status_mean igs_lookup_values.meaning%TYPE;

280: l_program_id NUMBER;
281: l_program_application_id NUMBER;
282: l_program_update_date DATE;
283:
284: l_status_mean igs_lookup_values.meaning%TYPE;
285: l_msg_ret_status VARCHAR2(1);
286: BEGIN
287:
288: IF p_msg_ret_status = 'W' THEN