APPS.IEC_O_ALG_EXPR_OP_DEFS_PKG dependencies on IEC_O_ALG_EXPR_OP_DEFS

Line 1: package body IEC_O_ALG_EXPR_OP_DEFS_PKG as

1: package body IEC_O_ALG_EXPR_OP_DEFS_PKG as
2: /* $Header: IECHEODB.pls 120.1 2005/07/20 13:22:58 appldev noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 18: cursor C is select ROWID from IEC_O_ALG_EXPR_OP_DEFS

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from IEC_O_ALG_EXPR_OP_DEFS
19: where EXPR_CODE = X_EXPR_CODE and OPERATOR_CODE = X_OPERATOR_CODE and
20: OPERATOR_VAR = X_OPERATOR_VAR;
21: begin
22: insert into IEC_O_ALG_EXPR_OP_DEFS (

Line 22: insert into IEC_O_ALG_EXPR_OP_DEFS (

18: cursor C is select ROWID from IEC_O_ALG_EXPR_OP_DEFS
19: where EXPR_CODE = X_EXPR_CODE and OPERATOR_CODE = X_OPERATOR_CODE and
20: OPERATOR_VAR = X_OPERATOR_VAR;
21: begin
22: insert into IEC_O_ALG_EXPR_OP_DEFS (
23: EXPR_CODE,
24: OPERATOR_VAR,
25: OPERATOR_CODE,
26: INACTIVE_DATA_NAME,

Line 70: from IEC_O_ALG_EXPR_OP_DEFS

66: cursor c is select
67: INACTIVE_DATA_NAME,
68: INACTIVE_DATA_FLAG,
69: OBJECT_VERSION_NUMBER
70: from IEC_O_ALG_EXPR_OP_DEFS
71: where EXPR_CODE = X_EXPR_CODE and OPERATOR_CODE = X_OPERATOR_CODE and
72: OPERATOR_VAR = X_OPERATOR_VAR
73: for update of EXPR_CODE,OPERATOR_CODE,OPERATOR_VAR nowait;
74: recinfo c%rowtype;

Line 109: update IEC_O_ALG_EXPR_OP_DEFS

105: X_LAST_UPDATED_BY in NUMBER,
106: X_LAST_UPDATE_LOGIN in NUMBER
107: ) is
108: begin
109: update IEC_O_ALG_EXPR_OP_DEFS
110: set
111: INACTIVE_DATA_NAME = X_INACTIVE_DATA_NAME,
112: INACTIVE_DATA_FLAG = X_INACTIVE_DATA_FLAG,
113: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 132: delete from IEC_O_ALG_EXPR_OP_DEFS

128: X_OPERATOR_VAR in VARCHAR2,
129: X_OPERATOR_CODE in VARCHAR2
130: ) is
131: begin
132: delete from IEC_O_ALG_EXPR_OP_DEFS
133: where EXPR_CODE = X_EXPR_CODE and OPERATOR_CODE = X_OPERATOR_CODE and
134: OPERATOR_VAR = X_OPERATOR_VAR;
135:
136:

Line 178: IEC_O_ALG_EXPR_OP_DEFS_PKG.LOAD_ROW (

174: begin
175: if(X_upload_mode='NLS') then
176: NULL;
177: else
178: IEC_O_ALG_EXPR_OP_DEFS_PKG.LOAD_ROW (
179: X_EXPR_CODE,
180: X_OPERATOR_VAR,
181: X_OPERATOR_CODE,
182: X_INACTIVE_DATA_NAME,

Line 189: end IEC_O_ALG_EXPR_OP_DEFS_PKG;

185: end if;
186:
187: end LOAD_SEED_ROW;
188:
189: end IEC_O_ALG_EXPR_OP_DEFS_PKG;