APPS.IGS_RU_DESCRIPTION_PKG dependencies on IGS_RU_NAMED_RULE

Line 119: v_rule_text IGS_RU_NAMED_RULE.rule_text%TYPE;

115: --
116: PROCEDURE do_rule_text (
117: p_rule_number NUMBER )
118: as
119: v_rule_text IGS_RU_NAMED_RULE.rule_text%TYPE;
120: BEGIN
121: FOR nr IN (
122: SELECT rule_text
123: FROM IGS_RU_NAMED_RULE

Line 123: FROM IGS_RU_NAMED_RULE

119: v_rule_text IGS_RU_NAMED_RULE.rule_text%TYPE;
120: BEGIN
121: FOR nr IN (
122: SELECT rule_text
123: FROM IGS_RU_NAMED_RULE
124: WHERE rul_sequence_number = p_rule_number )
125: LOOP
126: -- if named IGS_RU_RULE then update IGS_RU_RULE text
127: v_rule_text := IGS_RU_GEN_006.RULP_GET_RULE(p_rule_number);-- Changed IGS_RU_GEN_003 to IGS_RU_GEN_006 As part of Seed Migration Build Bug :2233951. This approach is taken to resolve the release issues .

Line 128: UPDATE IGS_RU_NAMED_RULE

124: WHERE rul_sequence_number = p_rule_number )
125: LOOP
126: -- if named IGS_RU_RULE then update IGS_RU_RULE text
127: v_rule_text := IGS_RU_GEN_006.RULP_GET_RULE(p_rule_number);-- Changed IGS_RU_GEN_003 to IGS_RU_GEN_006 As part of Seed Migration Build Bug :2233951. This approach is taken to resolve the release issues .
128: UPDATE IGS_RU_NAMED_RULE
129: SET rule_text = v_rule_text
130: WHERE rul_sequence_number = p_rule_number;
131: RETURN;
132: END LOOP;

Line 163: FROM IGS_RU_NAMED_RULE nr,

159: -- find all rules which call this named IGS_RU_RULE
160: FOR nr IN (
161: SELECT UNIQUE
162: rui.rul_sequence_number
163: FROM IGS_RU_NAMED_RULE nr,
164: IGS_RU_ITEM rui
165: WHERE nr.rud_sequence_number = New_References.sequence_number
166: AND rui.named_rule = nr.rul_sequence_number )
167: LOOP

Line 261: IGS_RU_NAMED_RULE_PKG.GET_FK_IGS_RU_DESCRIPTION (

257:
258: PROCEDURE Check_Child_Existance as
259: BEGIN
260:
261: IGS_RU_NAMED_RULE_PKG.GET_FK_IGS_RU_DESCRIPTION (
262: old_references.sequence_number
263: );
264:
265: IGS_RU_GROUP_SET_PKG.GET_FK_IGS_RU_DESCRIPTION (