APPS.IGS_RU_VAL_RGI dependencies on IGS_RU_GROUP_ITEM

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 24: FROM IGS_RU_GROUP_ITEM

20: FOR UPDATE;
21:
22: CURSOR Cur_Gi(r_rug_sequence_number gv_rug_sequence_number%TYPE) IS
23: SELECT rug_sequence_number, description_number
24: FROM IGS_RU_GROUP_ITEM
25: WHERE rug_sequence_number = r_rug_sequence_number
26: AND description_type = 'RUD';
27:
28: /*

Line 62: FROM IGS_RU_GROUP_ITEM

58: get all items of type 'RUG'
59: */
60: FOR rgi IN (
61: SELECT description_number
62: FROM IGS_RU_GROUP_ITEM
63: WHERE rug_sequence_number = gv_rug_sequence_number
64: AND description_type = 'RUG' )
65: LOOP
66: /*

Line 96: FROM IGS_RU_GROUP_ITEM srgi

92: force trigger on groups containing the current updated group
93: */
94: FOR rgi IN (
95: SELECT ROWID, srgi.*
96: FROM IGS_RU_GROUP_ITEM srgi
97: WHERE description_number = gv_rug_sequence_number
98: AND description_type = 'RUG' )
99: LOOP
100: /*

Line 105: IGS_RU_GROUP_ITEM_PKG.UPDATE_ROW (

101: IGS_GE_NOTE: gv_rug_sequence_number is volatile, changed by this update
102: update these records one at a time
103: */
104:
105: IGS_RU_GROUP_ITEM_PKG.UPDATE_ROW (
106: X_ROWID => RGI.ROWID,
107: X_RUG_SEQUENCE_NUMBER => RGI.RUG_SEQUENCE_NUMBER,
108: X_DESCRIPTION_NUMBER => RGI.DESCRIPTION_NUMBER,
109: X_DESCRIPTION_TYPE => RGI.DESCRIPTION_TYPE );

Line 160: FROM IGS_RU_GROUP_ITEM

156: for all parent groups of current group
157: */
158: FOR parent IN (
159: SELECT rug_sequence_number
160: FROM IGS_RU_GROUP_ITEM
161: WHERE description_number = p_current_group
162: AND description_type = 'RUG' )
163: LOOP
164: /*