APPS.IGS_RU_GEN_003 dependencies on IGS_RU_ITEM

Line 83: p_item IN IGS_RU_ITEM.item%TYPE)

79: cascade delete IGS_RU_RULE items
80: */
81: PROCEDURE delete_rule_items(
82: p_rule_number IN IGS_RU_RULE.sequence_number%TYPE,
83: p_item IN IGS_RU_ITEM.item%TYPE)
84: IS
85: CURSOR Cur_Item_Del( r_item IGS_RU_ITEM.item%TYPE) IS
86: SELECT rowid
87: FROM IGS_RU_ITEM

Line 85: CURSOR Cur_Item_Del( r_item IGS_RU_ITEM.item%TYPE) IS

81: PROCEDURE delete_rule_items(
82: p_rule_number IN IGS_RU_RULE.sequence_number%TYPE,
83: p_item IN IGS_RU_ITEM.item%TYPE)
84: IS
85: CURSOR Cur_Item_Del( r_item IGS_RU_ITEM.item%TYPE) IS
86: SELECT rowid
87: FROM IGS_RU_ITEM
88: WHERE rul_sequence_number = p_rule_number
89: AND item = r_item;

Line 87: FROM IGS_RU_ITEM

83: p_item IN IGS_RU_ITEM.item%TYPE)
84: IS
85: CURSOR Cur_Item_Del( r_item IGS_RU_ITEM.item%TYPE) IS
86: SELECT rowid
87: FROM IGS_RU_ITEM
88: WHERE rul_sequence_number = p_rule_number
89: AND item = r_item;
90:
91: CURSOR Cur_Rule_Del(r_rule_number IGS_RU_ITEM.rule_number%TYPE) IS

Line 91: CURSOR Cur_Rule_Del(r_rule_number IGS_RU_ITEM.rule_number%TYPE) IS

87: FROM IGS_RU_ITEM
88: WHERE rul_sequence_number = p_rule_number
89: AND item = r_item;
90:
91: CURSOR Cur_Rule_Del(r_rule_number IGS_RU_ITEM.rule_number%TYPE) IS
92: SELECT rowid
93: FROM IGS_RU_RULE
94: WHERE sequence_number = r_rule_number;
95:

Line 96: CURSOR Cur_Set_Mem_Del(r_set_number IGS_RU_ITEM.set_number%TYPE) IS

92: SELECT rowid
93: FROM IGS_RU_RULE
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:

Line 101: CURSOR Cur_Set_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
103: FROM IGS_RU_SET
104: WHERE sequence_number = r_set_number;
105:

Line 112: FROM IGS_RU_ITEM

108: FOR rule_items IN (
109: SELECT item,
110: rule_number,
111: set_number
112: FROM IGS_RU_ITEM
113: WHERE rul_sequence_number = p_rule_number
114: AND item >= p_item )
115: LOOP
116:

Line 118: IGS_RU_ITEM_PKG.DELETE_ROW(

114: AND item >= p_item )
115: LOOP
116:
117: for item_rec in Cur_Item_Del(rule_items.item) loop
118: IGS_RU_ITEM_PKG.DELETE_ROW(
119: X_ROWID => item_rec.rowid
120: );
121: end loop;
122: