DBA Data[Home] [Help]

APPS.IEC_G_REP_CONF_VALIDATORS_PKG dependencies on IEC_G_REP_CONF_VLDTRS

Line 17: from iec_g_rep_conf_vldtrs

13: X_LAST_UPDATE_LOGIN in NUMBER,
14: X_OBJECT_VERSION_NUMBER in NUMBER
15: ) is
16: cursor C is select ROWID
17: from iec_g_rep_conf_vldtrs
18: where
19: VALIDATOR_ID = X_VALIDATOR_ID
20: and VALIDATOR_CLASS = X_VALIDATOR_CLASS
21: and FORMAT = X_FORMAT;

Line 25: insert into iec_g_rep_conf_vldtrs

21: and FORMAT = X_FORMAT;
22:
23: begin
24:
25: insert into iec_g_rep_conf_vldtrs
26: ( VALIDATOR_ID,
27: VALIDATOR_CLASS,
28: FORMAT,
29: CREATED_BY,

Line 65: from iec_g_rep_conf_vldtrs

61: cursor c is select
62: VALIDATOR_CLASS,
63: FORMAT,
64: OBJECT_VERSION_NUMBER
65: from iec_g_rep_conf_vldtrs
66: where VALIDATOR_ID = X_VALIDATOR_ID
67: for update of VALIDATOR_CLASS, FORMAT, OBJECT_VERSION_NUMBER nowait;
68: recinfo c%rowtype;
69: begin

Line 101: update iec_g_rep_conf_vldtrs

97: X_OBJECT_VERSION_NUMBER in NUMBER
98: ) is
99: begin
100:
101: update iec_g_rep_conf_vldtrs
102: set LAST_UPDATED_BY = X_LAST_UPDATED_BY,
103: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
104: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
105: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 120: delete from iec_g_rep_conf_vldtrs

116: procedure DELETE_ROW (
117: X_VALIDATOR_ID in NUMBER
118: ) is
119: begin
120: delete from iec_g_rep_conf_vldtrs
121: where VALIDATOR_ID = X_VALIDATOR_ID;
122:
123: if (sql%notfound) then
124: raise no_data_found;