APPS.IGS_RU_GEN_006 dependencies on IGS_RU_GROUP

Line 42: FROM IGS_RU_GROUP

38: THEN
39: BEGIN
40: SELECT group_name
41: INTO v_description
42: FROM IGS_RU_GROUP
43: WHERE sequence_number = p_description_number;
44: EXCEPTION
45: WHEN NO_DATA_FOUND THEN
46: p_message_name := 'IGS_GE_RULE_GROUP_NOT_EXISTS';

Line 121: --Purpose: Calls the before_dml of igs_ru_group_item_pkg

117: ------------------------------------------------------------------
118: --Created by : nsinha, Oracle India
119: --Date created: 12-Mar-2002
120: --
121: --Purpose: Calls the before_dml of igs_ru_group_item_pkg
122: --
123: --
124: --Known limitations/enhancements and/or remarks:
125: --

Line 338: FROM IGS_RU_GROUP_ITEM

334: check/insert into group
335: */
336: SELECT COUNT(*)
337: INTO v_count
338: FROM IGS_RU_GROUP_ITEM
339: WHERE rug_sequence_number = p_group
340: AND description_number = v_description_number
341: AND description_type = 'RUD';
342: IF v_count = 0

Line 344: IGS_RU_GROUP_ITEM_PKG.Insert_Row(

340: AND description_number = v_description_number
341: AND description_type = 'RUD';
342: IF v_count = 0
343: THEN
344: IGS_RU_GROUP_ITEM_PKG.Insert_Row(
345: x_rowid => v_rowid_rgi,
346: x_rug_sequence_number => p_group,
347: x_description_number => v_description_number,
348: x_description_type => 'RUD',