APPS.IGS_RU_GEN_003 dependencies on IGS_RU_DESCRIPTION

Line 261: FROM IGS_RU_DESCRIPTION

257: v_return_type IGS_RU_RET_TYPE.s_return_type%TYPE;
258: BEGIN
259: SELECT s_return_type
260: INTO v_return_type
261: FROM IGS_RU_DESCRIPTION
262: WHERE sequence_number = p_rud_sequence_number;
263: RETURN v_return_type;
264: END rulp_get_ret_type;
265:

Line 271: Expand description_number to IGS_RU_DESCRIPTION or group_name

267: p_description_number NUMBER ,
268: p_description_type VARCHAR2 )
269: RETURN VARCHAR2 IS
270: /*
271: Expand description_number to IGS_RU_DESCRIPTION or group_name
272: if invalid return NULL
273: */
274: v_message_name VARCHAR2(30);
275: BEGIN

Line 319: IGS_RU_DESCRIPTION

315: cp_rule_call_cd IGS_RU_CALL.s_rule_call_cd%TYPE ) IS
316: SELECT select_group,
317: s_return_type
318: FROM IGS_RU_CALL,
319: IGS_RU_DESCRIPTION
320: WHERE s_rule_call_cd = p_rule_call_cd
321: AND sequence_number = rud_sequence_number;
322: v_rule VARCHAR2(2000);
323: v_select_group IGS_RU_CALL.select_group%TYPE;