APPS.IEC_G_REP_CONF_PARAMS_VALS_PKG dependencies on IEC_G_REP_CONF_PARAMS_VALS

Line 1: package body IEC_G_REP_CONF_PARAMS_VALS_PKG as

1: package body IEC_G_REP_CONF_PARAMS_VALS_PKG as
2: /* $Header: IECREPFB.pls 115.0 2004/03/24 05:11:22 anayak noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 18: from IEC_G_REP_CONF_PARAMS_VALS

14: X_LAST_UPDATE_LOGIN in NUMBER,
15: X_OBJECT_VERSION_NUMBER in NUMBER
16: ) is
17: cursor C is select ROWID
18: from IEC_G_REP_CONF_PARAMS_VALS
19: where
20: VALUE_ID = X_VALUE_ID
21: and NAME = X_NAME
22: and VALUE = X_VALUE

Line 26: insert into iec_g_rep_conf_params_vals

22: and VALUE = X_VALUE
23: and PARAM_ID = X_PARAM_ID;
24:
25: begin
26: insert into iec_g_rep_conf_params_vals
27: ( VALUE_ID,
28: NAME,
29: VALUE,
30: PARAM_ID,

Line 70: from IEC_G_REP_CONF_PARAMS_VALS

66: NAME,
67: VALUE,
68: PARAM_ID,
69: OBJECT_VERSION_NUMBER
70: from IEC_G_REP_CONF_PARAMS_VALS
71: where VALUE_ID = X_VALUE_ID
72: for update of NAME, VALUE, PARAM_ID,OBJECT_VERSION_NUMBER nowait;
73: recinfo c%rowtype;
74: begin

Line 108: update iec_g_rep_conf_params_vals

104: X_OBJECT_VERSION_NUMBER in NUMBER
105: ) is
106: begin
107:
108: update iec_g_rep_conf_params_vals
109: set LAST_UPDATED_BY = X_LAST_UPDATED_BY,
110: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
111: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
112: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 128: delete from iec_g_rep_conf_params_vals

124: procedure DELETE_ROW (
125: X_VALUE_ID in NUMBER
126: ) is
127: begin
128: delete from iec_g_rep_conf_params_vals
129: where VALUE_ID = X_VALUE_ID;
130:
131: if (sql%notfound) then
132: raise no_data_found;

Line 159: end IEC_G_REP_CONF_PARAMS_VALS_PKG;

155: INSERT_ROW (ROW_ID, X_VALUE_ID, X_NAME, X_VALUE, X_PARAM_ID, 0, SYSDATE, USER_ID, SYSDATE, USER_ID, 0);
156:
157: end LOAD_ROW;
158:
159: end IEC_G_REP_CONF_PARAMS_VALS_PKG;