APPS.IEC_O_ALG_OP_DEFS_PKG dependencies on IEC_O_ALG_OP_DEFS_B

Line 16: cursor C is select ROWID from IEC_O_ALG_OP_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_OP_DEFS_B
17: where OPERATOR_CODE = X_OPERATOR_CODE
18: ;
19: begin
20: insert into IEC_O_ALG_OP_DEFS_B (

Line 20: insert into IEC_O_ALG_OP_DEFS_B (

16: cursor C is select ROWID from IEC_O_ALG_OP_DEFS_B
17: where OPERATOR_CODE = X_OPERATOR_CODE
18: ;
19: begin
20: insert into IEC_O_ALG_OP_DEFS_B (
21: OPERATOR_CODE,
22: IS_UNARY_FLAG,
23: SQL_OPERATOR,
24: OBJECT_VERSION_NUMBER,

Line 93: from IEC_O_ALG_OP_DEFS_B

89: cursor c is select
90: IS_UNARY_FLAG,
91: SQL_OPERATOR,
92: OBJECT_VERSION_NUMBER
93: from IEC_O_ALG_OP_DEFS_B
94: where OPERATOR_CODE = X_OPERATOR_CODE
95: for update of OPERATOR_CODE nowait;
96: recinfo c%rowtype;
97:

Line 150: update IEC_O_ALG_OP_DEFS_B set

146: X_LAST_UPDATED_BY in NUMBER,
147: X_LAST_UPDATE_LOGIN in NUMBER
148: ) is
149: begin
150: update IEC_O_ALG_OP_DEFS_B set
151: IS_UNARY_FLAG = X_IS_UNARY_FLAG,
152: SQL_OPERATOR = X_SQL_OPERATOR,
153: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
154: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 188: delete from IEC_O_ALG_OP_DEFS_B

184: if (sql%notfound) then
185: raise no_data_found;
186: end if;
187:
188: delete from IEC_O_ALG_OP_DEFS_B
189: where OPERATOR_CODE = X_OPERATOR_CODE;
190:
191: if (sql%notfound) then
192: raise no_data_found;

Line 202: from IEC_O_ALG_OP_DEFS_B B

198: begin
199: delete from IEC_O_ALG_OP_DEFS_TL T
200: where not exists
201: (select NULL
202: from IEC_O_ALG_OP_DEFS_B B
203: where B.OPERATOR_CODE = T.OPERATOR_CODE
204: );
205:
206: update IEC_O_ALG_OP_DEFS_TL T set (