APPS.IEC_G_REP_COLS_PKG dependencies on IEC_G_REP_COLS_TL

Line 41: insert into IEC_G_REP_COLS_TL (

37: X_LAST_UPDATED_BY,
38: X_LAST_UPDATE_LOGIN
39: );
40:
41: insert into IEC_G_REP_COLS_TL (
42: VALUE,
43: NAME,
44: INTERNAL_COLUMN_NAME,
45: COLUMN_ID,

Line 71: from IEC_G_REP_COLS_TL T

67: from FND_LANGUAGES L
68: where L.INSTALLED_FLAG in ('I', 'B')
69: and not exists
70: (select NULL
71: from IEC_G_REP_COLS_TL T
72: where T.COLUMN_ID = X_COLUMN_ID
73: and T.LANGUAGE = L.LANGUAGE_CODE);
74:
75: open c;

Line 104: from IEC_G_REP_COLS_TL

100: VALUE,
101: NAME,
102: INTERNAL_COLUMN_NAME,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from IEC_G_REP_COLS_TL
105: where COLUMN_ID = X_COLUMN_ID
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of COLUMN_ID nowait;
108: begin

Line 164: update IEC_G_REP_COLS_TL set

160: if (sql%notfound) then
161: raise no_data_found;
162: end if;
163:
164: update IEC_G_REP_COLS_TL set
165: VALUE = X_VALUE,
166: NAME = X_NAME,
167: INTERNAL_COLUMN_NAME = X_INTERNAL_COLUMN_NAME,
168: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 184: delete from IEC_G_REP_COLS_TL

180: procedure DELETE_ROW (
181: X_COLUMN_ID in NUMBER
182: ) is
183: begin
184: delete from IEC_G_REP_COLS_TL
185: where COLUMN_ID = X_COLUMN_ID;
186:
187: if (sql%notfound) then
188: raise no_data_found;

Line 202: delete from IEC_G_REP_COLS_TL T

198:
199: procedure ADD_LANGUAGE
200: is
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

Line 209: update IEC_G_REP_COLS_TL T set (

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 (
210: VALUE,
211: NAME,
212: INTERNAL_COLUMN_NAME
213: ) = (select

Line 217: from IEC_G_REP_COLS_TL B

213: ) = (select
214: B.VALUE,
215: B.NAME,
216: B.INTERNAL_COLUMN_NAME
217: from IEC_G_REP_COLS_TL B
218: where B.COLUMN_ID = T.COLUMN_ID
219: and B.LANGUAGE = T.SOURCE_LANG)
220: where (
221: T.COLUMN_ID,

Line 226: from IEC_G_REP_COLS_TL SUBB, IEC_G_REP_COLS_TL SUBT

222: T.LANGUAGE
223: ) in (select
224: SUBT.COLUMN_ID,
225: SUBT.LANGUAGE
226: from IEC_G_REP_COLS_TL SUBB, IEC_G_REP_COLS_TL SUBT
227: where SUBB.COLUMN_ID = SUBT.COLUMN_ID
228: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
229: and (SUBB.VALUE <> SUBT.VALUE
230: or (SUBB.VALUE is null and SUBT.VALUE is not null)

Line 238: insert into IEC_G_REP_COLS_TL (

234: or (SUBB.NAME is not null and SUBT.NAME is null)
235: or SUBB.INTERNAL_COLUMN_NAME <> SUBT.INTERNAL_COLUMN_NAME
236: ));
237:
238: insert into IEC_G_REP_COLS_TL (
239: VALUE,
240: NAME,
241: INTERNAL_COLUMN_NAME,
242: COLUMN_ID,

Line 264: from IEC_G_REP_COLS_TL B, FND_LANGUAGES L

260: B.LAST_UPDATE_LOGIN,
261: B.OBJECT_VERSION_NUMBER,
262: L.LANGUAGE_CODE,
263: B.SOURCE_LANG
264: from IEC_G_REP_COLS_TL B, FND_LANGUAGES L
265: where L.INSTALLED_FLAG in ('I', 'B')
266: and B.LANGUAGE = userenv('LANG')
267: and not exists
268: (select NULL

Line 269: from IEC_G_REP_COLS_TL T

265: where L.INSTALLED_FLAG in ('I', 'B')
266: and B.LANGUAGE = userenv('LANG')
267: and not exists
268: (select NULL
269: from IEC_G_REP_COLS_TL T
270: where T.COLUMN_ID = B.COLUMN_ID
271: and T.LANGUAGE = L.LANGUAGE_CODE);
272: end ADD_LANGUAGE;
273:

Line 309: update IEC_G_REP_COLS_TL set

305: begin
306:
307: -- only UPDATE rows that have not been altered by user
308:
309: update IEC_G_REP_COLS_TL set
310: VALUE = X_VALUE,
311: SOURCE_LANG = userenv('LANG'),
312: NAME = X_NAME,
313: INTERNAL_COLUMN_NAME = X_INTERNAL_COLUMN_NAME,