APPS.IEC_G_REP_COLS_PKG dependencies on IEC_G_REP_COLS_B

Line 17: cursor C is select ROWID from IEC_G_REP_COLS_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from IEC_G_REP_COLS_B
18: where COLUMN_ID = X_COLUMN_ID
19: ;
20: begin
21: x_rowid := NULL;

Line 23: insert into IEC_G_REP_COLS_B (

19: ;
20: begin
21: x_rowid := NULL;
22:
23: insert into IEC_G_REP_COLS_B (
24: COLUMN_ID,
25: OBJECT_VERSION_NUMBER,
26: CREATION_DATE,
27: CREATED_BY,

Line 94: from IEC_G_REP_COLS_B

90: X_INTERNAL_COLUMN_NAME in VARCHAR2
91: ) is
92: cursor c is select
93: OBJECT_VERSION_NUMBER
94: from IEC_G_REP_COLS_B
95: where COLUMN_ID = X_COLUMN_ID
96: for update of COLUMN_ID nowait;
97: recinfo c%rowtype;
98:

Line 153: update IEC_G_REP_COLS_B set

149: X_LAST_UPDATED_BY in NUMBER,
150: X_LAST_UPDATE_LOGIN in NUMBER
151: ) is
152: begin
153: update IEC_G_REP_COLS_B set
154: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
155: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
156: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
157: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 191: delete from IEC_G_REP_COLS_B

187: if (sql%notfound) then
188: raise no_data_found;
189: end if;
190:
191: delete from IEC_G_REP_COLS_B
192: where COLUMN_ID = X_COLUMN_ID;
193:
194: if (sql%notfound) then
195: raise no_data_found;

Line 205: from IEC_G_REP_COLS_B B

201: begin
202: delete from IEC_G_REP_COLS_TL T
203: where not exists
204: (select NULL
205: from IEC_G_REP_COLS_B B
206: where B.COLUMN_ID = T.COLUMN_ID
207: );
208:
209: update IEC_G_REP_COLS_TL T set (