APPS.IEC_P_RES_GRP_TYPES_PKG dependencies on IEC_P_RES_GRP_TYPES_B

Line 17: cursor C is select ROWID from IEC_P_RES_GRP_TYPES_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from IEC_P_RES_GRP_TYPES_B
18: where RES_GROUP_TYPE_ID = X_RES_GROUP_TYPE_ID
19: ;
20: begin
21: insert into IEC_P_RES_GRP_TYPES_B (

Line 21: insert into IEC_P_RES_GRP_TYPES_B (

17: cursor C is select ROWID from IEC_P_RES_GRP_TYPES_B
18: where RES_GROUP_TYPE_ID = X_RES_GROUP_TYPE_ID
19: ;
20: begin
21: insert into IEC_P_RES_GRP_TYPES_B (
22: VDU_TYPE_ID,
23: PORTS_PER_GROUP,
24: RES_GROUP_TYPE_ID,
25: OBJECT_VERSION_NUMBER,

Line 95: from IEC_P_RES_GRP_TYPES_B

91: cursor c is select
92: VDU_TYPE_ID,
93: PORTS_PER_GROUP,
94: OBJECT_VERSION_NUMBER
95: from IEC_P_RES_GRP_TYPES_B
96: where RES_GROUP_TYPE_ID = X_RES_GROUP_TYPE_ID
97: for update of RES_GROUP_TYPE_ID nowait;
98: recinfo c%rowtype;
99:

Line 156: update IEC_P_RES_GRP_TYPES_B set

152: X_LAST_UPDATED_BY in NUMBER,
153: X_LAST_UPDATE_LOGIN in NUMBER
154: ) is
155: begin
156: update IEC_P_RES_GRP_TYPES_B set
157: VDU_TYPE_ID = X_VDU_TYPE_ID,
158: PORTS_PER_GROUP = X_PORTS_PER_GROUP,
159: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
160: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 195: delete from IEC_P_RES_GRP_TYPES_B

191: if (sql%notfound) then
192: raise no_data_found;
193: end if;
194:
195: delete from IEC_P_RES_GRP_TYPES_B
196: where RES_GROUP_TYPE_ID = X_RES_GROUP_TYPE_ID;
197:
198: if (sql%notfound) then
199: raise no_data_found;

Line 209: from IEC_P_RES_GRP_TYPES_B B

205: begin
206: delete from IEC_P_RES_GRP_TYPES_TL T
207: where not exists
208: (select NULL
209: from IEC_P_RES_GRP_TYPES_B B
210: where B.RES_GROUP_TYPE_ID = T.RES_GROUP_TYPE_ID
211: );
212:
213: update IEC_P_RES_GRP_TYPES_TL T set (