eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_RU_GEN_006 dependencies on IGS_RU_DESCRIPTION

Line 13: --Purpose: Expand description_number to IGS_RU_DESCRIPTION or group_name

9: ------------------------------------------------------------------
10: --Created by : nsinha, Oracle India
11: --Date created: 12-Mar-2002
12: --
13: --Purpose: Expand description_number to IGS_RU_DESCRIPTION or group_name
14: -- if invalid set message number and return NULL
15: --
16: --Known limitations/enhancements and/or remarks:
17: --

Line 23: v_description igs_ru_description.rule_description%TYPE;

19: --Who When What
20: --nsinha 12-Mar-2002 Bug# 2233951: Moved the function from Igs_ru_gen_004.
21: --
22: -------------------------------------------------------------------
23: v_description igs_ru_description.rule_description%TYPE;
24: BEGIN
25: IF p_description_type = 'RUD'
26: THEN
27: BEGIN

Line 30: FROM IGS_RU_DESCRIPTION

26: THEN
27: BEGIN
28: SELECT rule_description
29: INTO v_description
30: FROM IGS_RU_DESCRIPTION
31: WHERE sequence_number = p_description_number;
32: EXCEPTION
33: WHEN NO_DATA_FOUND THEN
34: p_message_name := 'IGS_GE_RULE_DESCR_NOT_EXISTS';

Line 113: insert/update IGS_RU_DESCRIPTION

109: RETURN v_rule_number;
110: END make_rule;
111:
112: /*
113: insert/update IGS_RU_DESCRIPTION
114: */
115: FUNCTION insert_rule_description
116: RETURN NUMBER IS
117: ------------------------------------------------------------------

Line 132: -- nsinha 10/9/2003 Bug#: 3193855 : Change the reference of igs_ru_set with igs_ru_description.

128: --nsinha 12-Mar-2002 Bug# 2233951: Modified the logic to
129: -- SELECT the next value of the sequence number
130: -- differently when the data is for SEED DB.
131: --
132: -- nsinha 10/9/2003 Bug#: 3193855 : Change the reference of igs_ru_set with igs_ru_description.
133: -- for CURSOR cur_max_plus_one.
134: -------------------------------------------------------------------
135: v_rud_sequence_number NUMBER;
136: v_count NUMBER DEFAULT 0;

Line 139: SELECT rowid,IGS_RU_DESCRIPTION.*

135: v_rud_sequence_number NUMBER;
136: v_count NUMBER DEFAULT 0;
137: v_rowid VARCHAR2(25);
138: CURSOR Cur_Desc(r_rud_sequence_number NUMBER) IS
139: SELECT rowid,IGS_RU_DESCRIPTION.*
140: FROM IGS_RU_DESCRIPTION
141: WHERE sequence_number = r_rud_sequence_number;
142:
143: CURSOR Cur_Desc_Count(cp_rud_sequence_number NUMBER) IS

Line 140: FROM IGS_RU_DESCRIPTION

136: v_count NUMBER DEFAULT 0;
137: v_rowid VARCHAR2(25);
138: CURSOR Cur_Desc(r_rud_sequence_number NUMBER) IS
139: SELECT rowid,IGS_RU_DESCRIPTION.*
140: FROM IGS_RU_DESCRIPTION
141: WHERE sequence_number = r_rud_sequence_number;
142:
143: CURSOR Cur_Desc_Count(cp_rud_sequence_number NUMBER) IS
144: SELECT COUNT(*)

Line 145: FROM IGS_RU_DESCRIPTION

141: WHERE sequence_number = r_rud_sequence_number;
142:
143: CURSOR Cur_Desc_Count(cp_rud_sequence_number NUMBER) IS
144: SELECT COUNT(*)
145: FROM IGS_RU_DESCRIPTION
146: WHERE sequence_number = cp_rud_sequence_number;
147:
148: CURSOR cur_max_plus_one IS
149: SELECT (sequence_number + 1) sequence_number

Line 150: FROM igs_ru_description

146: WHERE sequence_number = cp_rud_sequence_number;
147:
148: CURSOR cur_max_plus_one IS
149: SELECT (sequence_number + 1) sequence_number
150: FROM igs_ru_description
151: WHERE sequence_number =
152: (SELECT MAX (sequence_number)
153: FROM igs_ru_description -- Changed By: Navin.Sinha On: 10/9/2003 Fix: Change the reference of igs_ru_set with igs_ru_description.
154: WHERE sequence_number < 499999)

Line 153: FROM igs_ru_description -- Changed By: Navin.Sinha On: 10/9/2003 Fix: Change the reference of igs_ru_set with igs_ru_description.

149: SELECT (sequence_number + 1) sequence_number
150: FROM igs_ru_description
151: WHERE sequence_number =
152: (SELECT MAX (sequence_number)
153: FROM igs_ru_description -- Changed By: Navin.Sinha On: 10/9/2003 Fix: Change the reference of igs_ru_set with igs_ru_description.
154: WHERE sequence_number < 499999)
155: FOR UPDATE OF sequence_number NOWAIT;
156: BEGIN
157: IF p_description_number IS NULL THEN

Line 170: SELECT igs_ru_description_seq_num_s.nextval

166: OPEN cur_max_plus_one;
167: FETCH cur_max_plus_one INTO v_rud_sequence_number;
168: CLOSE cur_max_plus_one;
169: ELSE
170: SELECT igs_ru_description_seq_num_s.nextval
171: INTO v_rud_sequence_number
172: FROM dual;
173: END IF;
174: ELSE

Line 185: -- insert IGS_RU_DESCRIPTION

181:
182: IF v_count = 0
183: THEN
184: --
185: -- insert IGS_RU_DESCRIPTION
186: --
187: IGS_RU_DESCRIPTION_PKG.Insert_Row(
188: x_rowid => v_rowid,
189: x_sequence_number => v_rud_sequence_number,

Line 187: IGS_RU_DESCRIPTION_PKG.Insert_Row(

183: THEN
184: --
185: -- insert IGS_RU_DESCRIPTION
186: --
187: IGS_RU_DESCRIPTION_PKG.Insert_Row(
188: x_rowid => v_rowid,
189: x_sequence_number => v_rud_sequence_number,
190: x_s_return_type => p_return_type,
191: x_rule_description => p_rule_description,

Line 199: -- update IGS_RU_DESCRIPTION

195: x_mode => 'R'
196: );
197: ELSE
198: --
199: -- update IGS_RU_DESCRIPTION
200: --
201: for Desc_Rec in Cur_Desc(v_rud_sequence_number) loop
202: Desc_Rec.s_return_type := p_return_type;
203: Desc_Rec.rule_description := p_rule_description;

Line 205: IGS_RU_DESCRIPTION_PKG.Update_Row(

201: for Desc_Rec in Cur_Desc(v_rud_sequence_number) loop
202: Desc_Rec.s_return_type := p_return_type;
203: Desc_Rec.rule_description := p_rule_description;
204: Desc_Rec.description := p_description_text;
205: IGS_RU_DESCRIPTION_PKG.Update_Row(
206: x_rowid => Desc_Rec.rowid,
207: x_sequence_number => Desc_Rec.sequence_number,
208: x_s_return_type => Desc_Rec.s_return_type,
209: x_rule_description => Desc_Rec.rule_description,

Line 228: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;

224: v_rowid_rgi VARCHAR2(25);
225: v_rule_number NUMBER;
226: v_description_number NUMBER;
227: v_count NUMBER;
228: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
229:
230: CURSOR Cur_Desc(r_description_number NUMBER) IS
231: SELECT rowid,IGS_RU_DESCRIPTION.*
232: FROM IGS_RU_DESCRIPTION

Line 231: SELECT rowid,IGS_RU_DESCRIPTION.*

227: v_count NUMBER;
228: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
229:
230: CURSOR Cur_Desc(r_description_number NUMBER) IS
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.*

Line 232: FROM IGS_RU_DESCRIPTION

228: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
229:
230: CURSOR Cur_Desc(r_description_number NUMBER) IS
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

Line 267: IGS_RU_DESCRIPTION_PKG.Update_Row(

263: END IF;
264:
265: for Desc_Rec in Cur_Desc(v_description_number) loop
266: Desc_Rec.s_turin_function := p_turing_function;
267: IGS_RU_DESCRIPTION_PKG.Update_Row(
268: x_rowid => Desc_Rec.rowid,
269: x_sequence_number => Desc_Rec.sequence_number,
270: x_s_return_type => Desc_Rec.s_return_type,
271: x_rule_description => Desc_Rec.rule_description,

Line 371: FROM IGS_RU_DESCRIPTION

367: get the IGS_RU_RULE description of the owner IGS_RU_RULE
368: */
369: SELECT rule_description
370: INTO v_rule_description
371: FROM IGS_RU_DESCRIPTION
372: WHERE sequence_number = p_description_number;
373: v_rule_number := make_rule(v_rule_number,
374: 'STRING',
375: v_rule_description,

Line 453: p_display IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE,

449: and remainder of description
450: return FALSE if description is NULL
451: */
452: FUNCTION breakdown_desc (
453: p_display IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE,
454: p_action IN OUT NOCOPY IGS_RU_DESCRIPTION.s_return_type%TYPE,
455: p_description IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE )
456: RETURN BOOLEAN IS
457: BEGIN DECLARE

Line 454: p_action IN OUT NOCOPY IGS_RU_DESCRIPTION.s_return_type%TYPE,

450: return FALSE if description is NULL
451: */
452: FUNCTION breakdown_desc (
453: p_display IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE,
454: p_action IN OUT NOCOPY IGS_RU_DESCRIPTION.s_return_type%TYPE,
455: p_description IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE )
456: RETURN BOOLEAN IS
457: BEGIN DECLARE
458: v_hash NUMBER;

Line 455: p_description IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE )

451: */
452: FUNCTION breakdown_desc (
453: p_display IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE,
454: p_action IN OUT NOCOPY IGS_RU_DESCRIPTION.s_return_type%TYPE,
455: p_description IN OUT NOCOPY IGS_RU_DESCRIPTION.rule_description%TYPE )
456: RETURN BOOLEAN IS
457: BEGIN DECLARE
458: v_hash NUMBER;
459: BEGIN

Line 503: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;

499: RETURN VARCHAR2 IS
500: BEGIN DECLARE
501: v_rule VARCHAR2(2000);
502: v_rule_item IGS_RU_ITEM.item%TYPE;
503: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
504: v_parenthesis_ind IGS_RU_DESCRIPTION.parenthesis_ind%TYPE;
505: v_action IGS_RU_DESCRIPTION.s_return_type%TYPE;
506: v_display IGS_RU_DESCRIPTION.rule_description%TYPE;
507: BEGIN

Line 504: v_parenthesis_ind IGS_RU_DESCRIPTION.parenthesis_ind%TYPE;

500: BEGIN DECLARE
501: v_rule VARCHAR2(2000);
502: v_rule_item IGS_RU_ITEM.item%TYPE;
503: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
504: v_parenthesis_ind IGS_RU_DESCRIPTION.parenthesis_ind%TYPE;
505: v_action IGS_RU_DESCRIPTION.s_return_type%TYPE;
506: v_display IGS_RU_DESCRIPTION.rule_description%TYPE;
507: BEGIN
508: FOR rule_items IN (

Line 505: v_action IGS_RU_DESCRIPTION.s_return_type%TYPE;

501: v_rule VARCHAR2(2000);
502: v_rule_item IGS_RU_ITEM.item%TYPE;
503: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
504: v_parenthesis_ind IGS_RU_DESCRIPTION.parenthesis_ind%TYPE;
505: v_action IGS_RU_DESCRIPTION.s_return_type%TYPE;
506: v_display IGS_RU_DESCRIPTION.rule_description%TYPE;
507: BEGIN
508: FOR rule_items IN (
509: SELECT rul_sequence_number,

Line 506: v_display IGS_RU_DESCRIPTION.rule_description%TYPE;

502: v_rule_item IGS_RU_ITEM.item%TYPE;
503: v_rule_description IGS_RU_DESCRIPTION.rule_description%TYPE;
504: v_parenthesis_ind IGS_RU_DESCRIPTION.parenthesis_ind%TYPE;
505: v_action IGS_RU_DESCRIPTION.s_return_type%TYPE;
506: v_display IGS_RU_DESCRIPTION.rule_description%TYPE;
507: BEGIN
508: FOR rule_items IN (
509: SELECT rul_sequence_number,
510: item,

Line 530: IGS_RU_DESCRIPTION rud

526: rud.parenthesis_ind
527: INTO v_rule_description,
528: v_parenthesis_ind
529: FROM IGS_RU_TURIN_FNC stf,
530: IGS_RU_DESCRIPTION rud
531: WHERE stf.s_turin_function = rule_items.turin_function
532: AND rud.sequence_number = stf.rud_sequence_number;
533: IF v_parenthesis_ind = 'Y'
534: THEN

Line 558: IGS_RU_DESCRIPTION rud

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'
562: THEN

Line 587: FROM IGS_RU_DESCRIPTION

583: ELSIF rule_items.derived_rule IS NOT NULL
584: THEN
585: SELECT rule_description
586: INTO v_rule_description
587: FROM IGS_RU_DESCRIPTION
588: WHERE sequence_number = rule_items.derived_rule;
589: WHILE breakdown_desc(v_display,
590: v_action,
591: v_rule_description)