APPS.IEC_P_VDU_PORT_PARAMS_PKG dependencies on IEC_P_VDU_PORT_PARAMS_B

Line 21: cursor C is select ROWID from IEC_P_VDU_PORT_PARAMS_B

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from IEC_P_VDU_PORT_PARAMS_B
22: where VDU_PORT_PARAM_ID = X_VDU_PORT_PARAM_ID
23: ;
24: begin
25: insert into IEC_P_VDU_PORT_PARAMS_B (

Line 25: insert into IEC_P_VDU_PORT_PARAMS_B (

21: cursor C is select ROWID from IEC_P_VDU_PORT_PARAMS_B
22: where VDU_PORT_PARAM_ID = X_VDU_PORT_PARAM_ID
23: ;
24: begin
25: insert into IEC_P_VDU_PORT_PARAMS_B (
26: VDU_PORT_PARAM_ID,
27: OBJECT_VERSION_NUMBER,
28: VDU_TYPE_ID,
29: MIDDLEWARE_TYPE_ID,

Line 115: from IEC_P_VDU_PORT_PARAMS_B

111: PARAM_CODE,
112: VALUE_TYPE,
113: VALUE_LENGTH,
114: AUTO_GEN_FLAG
115: from IEC_P_VDU_PORT_PARAMS_B
116: where VDU_PORT_PARAM_ID = X_VDU_PORT_PARAM_ID
117: for update of VDU_PORT_PARAM_ID nowait;
118: recinfo c%rowtype;
119:

Line 187: update IEC_P_VDU_PORT_PARAMS_B set

183: X_LAST_UPDATED_BY in NUMBER,
184: X_LAST_UPDATE_LOGIN in NUMBER
185: ) is
186: begin
187: update IEC_P_VDU_PORT_PARAMS_B set
188: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
189: VDU_TYPE_ID = X_VDU_TYPE_ID,
190: MIDDLEWARE_TYPE_ID = X_MIDDLEWARE_TYPE_ID,
191: PARAM_CODE = X_PARAM_CODE,

Line 230: delete from IEC_P_VDU_PORT_PARAMS_B

226: if (sql%notfound) then
227: raise no_data_found;
228: end if;
229:
230: delete from IEC_P_VDU_PORT_PARAMS_B
231: where VDU_PORT_PARAM_ID = X_VDU_PORT_PARAM_ID;
232:
233: if (sql%notfound) then
234: raise no_data_found;

Line 244: from IEC_P_VDU_PORT_PARAMS_B B

240: begin
241: delete from IEC_P_VDU_PORT_PARAMS_TL T
242: where not exists
243: (select NULL
244: from IEC_P_VDU_PORT_PARAMS_B B
245: where B.VDU_PORT_PARAM_ID = T.VDU_PORT_PARAM_ID
246: );
247:
248: update IEC_P_VDU_PORT_PARAMS_TL T set (