APPS.IGS_RU_GEN_006 dependencies on IGS_RU_NAMED_RULE

Line 235: SELECT rowid,IGS_RU_NAMED_RULE.*

231: SELECT rowid,IGS_RU_DESCRIPTION.*
232: FROM IGS_RU_DESCRIPTION
233: WHERE sequence_number = r_description_number;
234: CURSOR Cur_Nr(r_description_number NUMBER) IS
235: SELECT rowid,IGS_RU_NAMED_RULE.*
236: FROM IGS_RU_NAMED_RULE
237: WHERE rud_sequence_number = r_description_number;
238:
239: BEGIN

Line 236: FROM IGS_RU_NAMED_RULE

232: FROM IGS_RU_DESCRIPTION
233: WHERE sequence_number = r_description_number;
234: CURSOR Cur_Nr(r_description_number NUMBER) IS
235: SELECT rowid,IGS_RU_NAMED_RULE.*
236: FROM IGS_RU_NAMED_RULE
237: WHERE rud_sequence_number = r_description_number;
238:
239: BEGIN
240: IF p_return_type IS NOT NULL AND

Line 293: FROM IGS_RU_NAMED_RULE

289: find existing IGS_RU_RULE number
290: */
291: SELECT rul_sequence_number
292: INTO v_rule_number
293: FROM IGS_RU_NAMED_RULE
294: WHERE rud_sequence_number = p_description_number;
295: EXCEPTION
296: WHEN NO_DATA_FOUND THEN
297: v_rule_number := NULL;

Line 306: FROM IGS_RU_NAMED_RULE

302: p_rule_description,
303: p_rule_text);
304: SELECT COUNT(*)
305: INTO v_count
306: FROM IGS_RU_NAMED_RULE
307: WHERE rud_sequence_number = v_description_number;
308: IF v_count = 0
309: THEN
310: /*

Line 313: IGS_RU_NAMED_RULE_PKG.Insert_Row(

309: THEN
310: /*
311: add named IGS_RU_RULE
312: */
313: IGS_RU_NAMED_RULE_PKG.Insert_Row(
314: x_rowid => v_rowid_nr,
315: x_rul_sequence_number => v_rule_number,
316: x_rud_sequence_number => v_description_number,
317: x_message_rule => NULL,

Line 364: FROM IGS_RU_NAMED_RULE

360: find existing message IGS_RU_RULE number
361: */
362: SELECT message_rule
363: INTO v_rule_number
364: FROM IGS_RU_NAMED_RULE
365: WHERE rud_sequence_number = p_description_number;
366: /*
367: get the IGS_RU_RULE description of the owner IGS_RU_RULE
368: */

Line 382: IGS_RU_NAMED_RULE_PKG.Update_Row(

378: date the message number
379: */
380: for Nr_Rec in Cur_Nr(p_description_number) loop
381: Nr_Rec.message_rule := v_rule_number;
382: IGS_RU_NAMED_RULE_PKG.Update_Row(
383: x_rowid => Nr_Rec.rowid,
384: x_rul_sequence_number => Nr_Rec.rul_sequence_number,
385: x_rud_sequence_number => Nr_Rec.rud_sequence_number,
386: x_message_rule => Nr_Rec.message_rule,

Line 557: FROM IGS_RU_NAMED_RULE nr,

553: SELECT rud.rule_description,
554: rud.parenthesis_ind
555: INTO v_rule_description,
556: v_parenthesis_ind
557: FROM IGS_RU_NAMED_RULE nr,
558: IGS_RU_DESCRIPTION rud
559: WHERE nr.rul_sequence_number = rule_items.named_rule
560: AND rud.sequence_number = nr.rud_sequence_number;
561: IF v_parenthesis_ind = 'Y'