APPS.IGS_RU_GEN_003 dependencies on IGS_RU_SET

Line 98: FROM IGS_RU_SET_MEMBER

94: WHERE sequence_number = r_rule_number;
95:
96: CURSOR Cur_Set_Mem_Del(r_set_number IGS_RU_ITEM.set_number%TYPE) IS
97: SELECT rowid
98: FROM IGS_RU_SET_MEMBER
99: WHERE rs_sequence_number = r_set_number;
100:
101: CURSOR Cur_Set_Del(r_set_number IGS_RU_ITEM.set_number%TYPE) IS
102: SELECT rowid

Line 103: FROM IGS_RU_SET

99: WHERE rs_sequence_number = r_set_number;
100:
101: CURSOR Cur_Set_Del(r_set_number IGS_RU_ITEM.set_number%TYPE) IS
102: SELECT rowid
103: FROM IGS_RU_SET
104: WHERE sequence_number = r_set_number;
105:
106:
107: BEGIN

Line 146: IGS_RU_SET_MEMBER_PKG.DELETE_ROW(

142: /*
143: remove set members
144: */
145: for set_mem_rec in Cur_Set_Mem_Del( rule_items.set_number) loop
146: IGS_RU_SET_MEMBER_PKG.DELETE_ROW(
147: X_ROWID => set_mem_rec.rowid
148: );
149: end loop;
150: /*

Line 154: IGS_RU_SET_PKG.DELETE_ROW(

150: /*
151: remove set
152: */
153: for set_rec in Cur_Set_Del( rule_items.set_number) loop
154: IGS_RU_SET_PKG.DELETE_ROW(
155: X_ROWID => set_rec.rowid
156: );
157: end loop;
158: END IF;