APPS.IEC_O_ALG_DATA_DEFS_PKG dependencies on IEC_O_ALG_DATA_DEFS_B

Line 22: cursor C is select ROWID from IEC_O_ALG_DATA_DEFS_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_O_ALG_DATA_DEFS_B
23: where DATA_CODE = X_DATA_CODE
24: and OWNER_CODE = X_OWNER_CODE
25: and OWNER_TYPE_CODE = X_OWNER_TYPE_CODE
26: ;

Line 28: insert into IEC_O_ALG_DATA_DEFS_B (

24: and OWNER_CODE = X_OWNER_CODE
25: and OWNER_TYPE_CODE = X_OWNER_TYPE_CODE
26: ;
27: begin
28: insert into IEC_O_ALG_DATA_DEFS_B (
29: OBJECT_VERSION_NUMBER,
30: REF_NAME,
31: REF_VALUE,
32: REF_TABLE,

Line 129: from IEC_O_ALG_DATA_DEFS_B

125: REF_TABLE,
126: REF_WHERE,
127: DATA_TYPE,
128: IS_REF_FLAG
129: from IEC_O_ALG_DATA_DEFS_B
130: where DATA_CODE = X_DATA_CODE
131: and OWNER_CODE = X_OWNER_CODE
132: and OWNER_TYPE_CODE = X_OWNER_TYPE_CODE
133: for update of DATA_CODE nowait;

Line 204: update IEC_O_ALG_DATA_DEFS_B set

200: X_LAST_UPDATED_BY in NUMBER,
201: X_LAST_UPDATE_LOGIN in NUMBER
202: ) is
203: begin
204: update IEC_O_ALG_DATA_DEFS_B set
205: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
206: REF_NAME = X_REF_NAME,
207: REF_VALUE = X_REF_VALUE,
208: REF_TABLE = X_REF_TABLE,

Line 336: delete from IEC_O_ALG_DATA_DEFS_B

332: if (sql%notfound) then
333: raise no_data_found;
334: end if;
335:
336: delete from IEC_O_ALG_DATA_DEFS_B
337: where DATA_CODE = X_DATA_CODE
338: and OWNER_CODE = X_OWNER_CODE
339: and OWNER_TYPE_CODE = X_OWNER_TYPE_CODE;
340:

Line 352: from IEC_O_ALG_DATA_DEFS_B B

348: begin
349: delete from IEC_O_ALG_DATA_DEFS_TL T
350: where not exists
351: (select NULL
352: from IEC_O_ALG_DATA_DEFS_B B
353: where B.DATA_CODE = T.DATA_CODE
354: and B.OWNER_CODE = T.OWNER_CODE
355: and B.OWNER_TYPE_CODE = T.OWNER_TYPE_CODE
356: );