APPS.IGS_RU_VAL_RGI dependencies on IGS_RU_GROUP_SET

Line 9: Populate IGS_RU_GROUP_SET from IGS_RU_GROUP_ITEM

5: gv_description_number NUMBER(6,0);
6: gv_description_type VARCHAR2(10);
7:
8: /*
9: Populate IGS_RU_GROUP_SET from IGS_RU_GROUP_ITEM
10: */
11: PROCEDURE rulp_ins_rgi
12: IS
13: v_rowid_gs1 VARCHAR2(25);

Line 18: FROM IGS_RU_GROUP_SET

14: v_rowid_gs2 VARCHAR2(25);
15:
16: CURSOR Cur_Gs_Del(r_rug_sequence_number gv_rug_sequence_number%TYPE) IS
17: SELECT rowid
18: FROM IGS_RU_GROUP_SET
19: WHERE rug_sequence_number = r_rug_sequence_number
20: FOR UPDATE;
21:
22: CURSOR Cur_Gi(r_rug_sequence_number gv_rug_sequence_number%TYPE) IS

Line 30: insert into IGS_RU_GROUP_SET all RUD's and expanded RUG's

26: AND description_type = 'RUD';
27:
28: /*
29: for the marked group
30: insert into IGS_RU_GROUP_SET all RUD's and expanded RUG's
31: cause parent groups to be expanded
32: NOTE this will cascade to all IGS_RU_RULE group ancestors
33: */
34: BEGIN

Line 37: delete all members of IGS_RU_GROUP_SET

33: */
34: BEGIN
35:
36: /*
37: delete all members of IGS_RU_GROUP_SET
38: */
39:
40: for Gs_rec in Cur_Gs_Del(gv_rug_sequence_number) loop
41: IGS_RU_GROUP_SET_PKG.DELETE_ROW(

Line 41: IGS_RU_GROUP_SET_PKG.DELETE_ROW(

37: delete all members of IGS_RU_GROUP_SET
38: */
39:
40: for Gs_rec in Cur_Gs_Del(gv_rug_sequence_number) loop
41: IGS_RU_GROUP_SET_PKG.DELETE_ROW(
42: X_ROWID => Gs_rec.rowid);
43: end loop;
44: /*
45: insert all items of type 'RUD'

Line 49: IGS_RU_GROUP_SET_PKG.Insert_Row(

45: insert all items of type 'RUD'
46: */
47:
48: for Gi_rec in Cur_Gi(gv_rug_sequence_number) loop
49: IGS_RU_GROUP_SET_PKG.Insert_Row(
50: x_rowid => v_rowid_gs1,
51: x_rug_sequence_number => Gi_rec.rug_sequence_number,
52: x_rud_sequence_number => Gi_rec.description_number,
53: x_mode => 'R'

Line 71: FROM IGS_RU_GROUP_SET

67: insert all members of this group
68: */
69: FOR rgs IN (
70: SELECT rud_sequence_number
71: FROM IGS_RU_GROUP_SET
72: WHERE rug_sequence_number = rgi.description_number )
73: LOOP
74: BEGIN
75: IGS_RU_GROUP_SET_PKG.Insert_Row(

Line 75: IGS_RU_GROUP_SET_PKG.Insert_Row(

71: FROM IGS_RU_GROUP_SET
72: WHERE rug_sequence_number = rgi.description_number )
73: LOOP
74: BEGIN
75: IGS_RU_GROUP_SET_PKG.Insert_Row(
76: x_rowid => v_rowid_gs2,
77: x_rug_sequence_number => gv_rug_sequence_number,
78: x_rud_sequence_number => rgs.rud_sequence_number,
79: x_mode => 'R'