APPS.IGS_RU_GEN_004 dependencies on IGS_RU_DESCRIPTION

Line 19: --Purpose: Expand description_number to IGS_RU_DESCRIPTION or group_name

15: ------------------------------------------------------------------
16: --Created by : nsinha, Oracle India
17: --Date created: 12-Mar-2001
18: --
19: --Purpose: Expand description_number to IGS_RU_DESCRIPTION or group_name
20: -- if invalid set message number and return NULL
21: --
22: --Known limitations/enhancements and/or remarks:
23: --

Line 330: --Purpose: Expand description_number to IGS_RU_DESCRIPTION or group_name

326: ------------------------------------------------------------------
327: --Created by : nsinha, Oracle India
328: --Date created: 12-Mar-2001
329: --
330: --Purpose: Expand description_number to IGS_RU_DESCRIPTION or group_name
331: -- if invalid set message number and return NULL
332: --
333: --Known limitations/enhancements and/or remarks:
334: --

Line 342: v_description igs_ru_description.rule_description%TYPE;

338: -- function in Igs_ru_gen_006.Rulp_Val_Desc_Rgi
339: -- and called it from there.
340: --
341: -------------------------------------------------------------------
342: v_description igs_ru_description.rule_description%TYPE;
343: l_message_name VARCHAR2(255);
344: BEGIN
345: v_description := Igs_ru_gen_006.Rulp_Val_Desc_Rgi(
346: p_description_number,

Line 398: FROM IGS_RU_DESCRIPTION RUD,

394: v_message_text VARCHAR2(2000);
395: BEGIN
396: SELECT NR.rul_sequence_number
397: INTO v_rule_number
398: FROM IGS_RU_DESCRIPTION RUD,
399: IGS_RU_NAMED_RULE NR
400: WHERE RUD.s_return_type = p_return_type
401: AND RUD.rule_description = p_rule_name
402: AND NR.rud_sequence_number = RUD.sequence_number;