APPS.IEC_O_ALG_ACTION_DEFS_PKG dependencies on IEC_O_ALG_ACTION_DEFS_B

Line 16: cursor C is select ROWID from IEC_O_ALG_ACTION_DEFS_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from IEC_O_ALG_ACTION_DEFS_B
17: where ACTION_CODE = X_ACTION_CODE
18: ;
19: begin
20: insert into IEC_O_ALG_ACTION_DEFS_B (

Line 20: insert into IEC_O_ALG_ACTION_DEFS_B (

16: cursor C is select ROWID from IEC_O_ALG_ACTION_DEFS_B
17: where ACTION_CODE = X_ACTION_CODE
18: ;
19: begin
20: insert into IEC_O_ALG_ACTION_DEFS_B (
21: ACTION_CODE,
22: ACTION_TYPE_CODE,
23: OBJECT_VERSION_NUMBER,
24: CREATION_DATE,

Line 91: from IEC_O_ALG_ACTION_DEFS_B

87: X_SUBST_TEXT in VARCHAR2
88: ) is
89: cursor c is select
90: OBJECT_VERSION_NUMBER
91: from IEC_O_ALG_ACTION_DEFS_B
92: where ACTION_CODE = X_ACTION_CODE
93: for update of ACTION_CODE nowait;
94: recinfo c%rowtype;
95:

Line 146: update IEC_O_ALG_ACTION_DEFS_B set

142: X_LAST_UPDATED_BY in NUMBER,
143: X_LAST_UPDATE_LOGIN in NUMBER
144: ) is
145: begin
146: update IEC_O_ALG_ACTION_DEFS_B set
147: ACTION_TYPE_CODE = X_ACTION_TYPE_CODE,
148: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
149: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
150: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 244: delete from IEC_O_ALG_ACTION_DEFS_B

240: if (sql%notfound) then
241: raise no_data_found;
242: end if;
243:
244: delete from IEC_O_ALG_ACTION_DEFS_B
245: where ACTION_CODE = X_ACTION_CODE;
246:
247: if (sql%notfound) then
248: raise no_data_found;

Line 258: from IEC_O_ALG_ACTION_DEFS_B B

254: begin
255: delete from IEC_O_ALG_ACTION_DEFS_TL T
256: where not exists
257: (select NULL
258: from IEC_O_ALG_ACTION_DEFS_B B
259: where B.ACTION_CODE = T.ACTION_CODE
260: );
261:
262: update IEC_O_ALG_ACTION_DEFS_TL T set (