APPS.IEC_P_RES_GRP_PARAMS_PKG dependencies on IEC_P_RES_GRP_PARAMS_B

Line 22: cursor C is select ROWID from IEC_P_RES_GRP_PARAMS_B

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from IEC_P_RES_GRP_PARAMS_B
23: where RES_GROUP_PARAM_ID = X_RES_GROUP_PARAM_ID
24: ;
25: begin
26: insert into IEC_P_RES_GRP_PARAMS_B (

Line 26: insert into IEC_P_RES_GRP_PARAMS_B (

22: cursor C is select ROWID from IEC_P_RES_GRP_PARAMS_B
23: where RES_GROUP_PARAM_ID = X_RES_GROUP_PARAM_ID
24: ;
25: begin
26: insert into IEC_P_RES_GRP_PARAMS_B (
27: RES_GROUP_PARAM_ID,
28: OBJECT_VERSION_NUMBER,
29: VDU_TYPE_ID,
30: PARAM_CODE,

Line 120: from IEC_P_RES_GRP_PARAMS_B

116: VALUE_TYPE,
117: VALUE_LENGTH,
118: REQUIRED,
119: DEFAULT_VALUE
120: from IEC_P_RES_GRP_PARAMS_B
121: where RES_GROUP_PARAM_ID = X_RES_GROUP_PARAM_ID
122: for update of RES_GROUP_PARAM_ID nowait;
123: recinfo c%rowtype;
124:

Line 196: update IEC_P_RES_GRP_PARAMS_B set

192: X_LAST_UPDATED_BY in NUMBER,
193: X_LAST_UPDATE_LOGIN in NUMBER
194: ) is
195: begin
196: update IEC_P_RES_GRP_PARAMS_B set
197: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
198: VDU_TYPE_ID = X_VDU_TYPE_ID,
199: PARAM_CODE = X_PARAM_CODE,
200: LOOKUP_TYPE = X_LOOKUP_TYPE,

Line 240: delete from IEC_P_RES_GRP_PARAMS_B

236: if (sql%notfound) then
237: raise no_data_found;
238: end if;
239:
240: delete from IEC_P_RES_GRP_PARAMS_B
241: where RES_GROUP_PARAM_ID = X_RES_GROUP_PARAM_ID;
242:
243: if (sql%notfound) then
244: raise no_data_found;

Line 254: from IEC_P_RES_GRP_PARAMS_B B

250: begin
251: delete from IEC_P_RES_GRP_PARAMS_TL T
252: where not exists
253: (select NULL
254: from IEC_P_RES_GRP_PARAMS_B B
255: where B.RES_GROUP_PARAM_ID = T.RES_GROUP_PARAM_ID
256: );
257:
258: update IEC_P_RES_GRP_PARAMS_TL T set (