APPS.IGS_RU_GEN_003 dependencies on IGS_RU_RULE

Line 79: cascade delete IGS_RU_RULE items

75: Procedure Rulp_Del_Rule(
76: p_rule_number IN NUMBER )
77: IS
78: /*
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)

Line 82: p_rule_number IN IGS_RU_RULE.sequence_number%TYPE,

78: /*
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

Line 93: FROM IGS_RU_RULE

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:
96: CURSOR Cur_Set_Mem_Del(r_set_number IGS_RU_ITEM.set_number%TYPE) IS
97: SELECT rowid

Line 127: remove all items of this IGS_RU_RULE

123:
124: IF rule_items.rule_number IS NOT NULL
125: THEN
126: /*
127: remove all items of this IGS_RU_RULE
128: */
129: delete_rule_items(rule_items.rule_number,0);
130: /*
131: remove IGS_RU_RULE

Line 131: remove IGS_RU_RULE

127: remove all items of this IGS_RU_RULE
128: */
129: delete_rule_items(rule_items.rule_number,0);
130: /*
131: remove IGS_RU_RULE
132: */
133:
134: for rule_rec in Cur_Rule_Del( rule_items.rule_number) loop
135: IGS_RU_RULE_PKG.DELETE_ROW(

Line 135: IGS_RU_RULE_PKG.DELETE_ROW(

131: remove IGS_RU_RULE
132: */
133:
134: for rule_rec in Cur_Rule_Del( rule_items.rule_number) loop
135: IGS_RU_RULE_PKG.DELETE_ROW(
136: X_ROWID => rule_rec.rowid
137: );
138: end loop;
139:

Line 196: FROM IGS_RU_RULE

192: s_rule_call_cd = r_s_rule_call_cd;
193:
194: CURSOR Cur_Rule_Del(r_sequence_number IGS_PS_UNIT_RU.rul_sequence_number%TYPE) IS
195: SELECT rowid
196: FROM IGS_RU_RULE
197: WHERE sequence_number = r_sequence_number;
198:
199: BEGIN
200: p_message_name := Null;

Line 210: - This module deletes a IGS_PS_UNIT_RU and associated IGS_RU_RULE.

206: p_message_name := 'IGS_GE_INVALID_VALUE';
207: RETURN FALSE;
208: END IF;
209: /*
210: - This module deletes a IGS_PS_UNIT_RU and associated IGS_RU_RULE.
211: */
212: OPEN c_unit_rule(p_unit_cd,
213: p_s_rule_call_cd);
214:

Line 232: Delete associated IGS_RU_RULE

228: );
229: end loop;
230:
231: /*
232: Delete associated IGS_RU_RULE
233: */
234:
235: for rule_rec in Cur_Rule_Del( v_ur_rec.rul_sequence_number) loop
236: IGS_RU_RULE_PKG.DELETE_ROW(

Line 236: IGS_RU_RULE_PKG.DELETE_ROW(

232: Delete associated IGS_RU_RULE
233: */
234:
235: for rule_rec in Cur_Rule_Del( v_ur_rec.rul_sequence_number) loop
236: IGS_RU_RULE_PKG.DELETE_ROW(
237: X_ROWID => rule_rec.rowid
238: );
239: end loop;
240:

Line 288: --Purpose: Get text version of IGS_RU_RULE

284: ------------------------------------------------------------------
285: --Created by : nsinha, Oracle India
286: --Date created: 12-Mar-2001
287: --
288: --Purpose: Get text version of IGS_RU_RULE
289: --
290: --Known limitations/enhancements and/or remarks:
291: --
292: --Change History:

Line 310: Copy a derived IGS_RU_RULE to a new IGS_RU_RULE

306: p_rule_call_cd VARCHAR2 ,
307: p_rule_number IN NUMBER )
308: RETURN NUMBER IS
309: /*
310: Copy a derived IGS_RU_RULE to a new IGS_RU_RULE
311: RETURN IGS_RU_RULE number
312: on error raise exception
313: */
314: CURSOR c_get_rule_dtls (

Line 311: RETURN IGS_RU_RULE number

307: p_rule_number IN NUMBER )
308: RETURN NUMBER IS
309: /*
310: Copy a derived IGS_RU_RULE to a new IGS_RU_RULE
311: RETURN IGS_RU_RULE number
312: on error raise exception
313: */
314: CURSOR c_get_rule_dtls (
315: cp_rule_call_cd IGS_RU_CALL.s_rule_call_cd%TYPE ) IS

Line 326: v_rule_number IGS_RU_RULE.sequence_number%TYPE;

322: v_rule VARCHAR2(2000);
323: v_select_group IGS_RU_CALL.select_group%TYPE;
324: v_return_type IGS_RU_RET_TYPE.s_return_type%TYPE;
325: v_unprocessed VARCHAR2(2000);
326: v_rule_number IGS_RU_RULE.sequence_number%TYPE;
327: v_lov_number IGS_RU_LOV.sequence_number%TYPE;
328: v_other_details VARCHAR2(255);
329: e_parser_error EXCEPTION;
330: BEGIN

Line 332: get text version of IGS_RU_RULE

328: v_other_details VARCHAR2(255);
329: e_parser_error EXCEPTION;
330: BEGIN
331: /*
332: get text version of IGS_RU_RULE
333: */
334: v_rule := rulp_get_rule(p_rule_number);
335: /*
336: get select group and return type