APPS.IMC_THREE_SIXTY_COLS_PKG dependencies on IMC_THREE_SIXTY_COLS_TL

Line 80: insert into IMC_THREE_SIXTY_COLS_TL (

76: X_LAST_UPDATE_LOGIN,
77: 1
78: );
79:
80: insert into IMC_THREE_SIXTY_COLS_TL (
81: COLUMN_ID,
82: COLUMN_LABEL,
83: CREATED_BY,
84: CREATION_DATE,

Line 106: from IMC_THREE_SIXTY_COLS_TL T

102: from FND_LANGUAGES L
103: where L.INSTALLED_FLAG in ('I', 'B')
104: and not exists
105: (select NULL
106: from IMC_THREE_SIXTY_COLS_TL T
107: where T.COLUMN_ID = X_COLUMN_ID
108: and T.LANGUAGE = L.LANGUAGE_CODE);
109:
110: end INSERT_ROW;

Line 150: from IMC_THREE_SIXTY_COLS_TL

146:
147: cursor c1 is select
148: COLUMN_LABEL,
149: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
150: from IMC_THREE_SIXTY_COLS_TL
151: where COLUMN_ID = X_COLUMN_ID
152: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
153: for update of COLUMN_ID nowait;
154: begin

Line 244: update IMC_THREE_SIXTY_COLS_TL set

240: if (sql%notfound) then
241: raise no_data_found;
242: end if;
243:
244: update IMC_THREE_SIXTY_COLS_TL set
245: COLUMN_LABEL = X_COLUMN_LABEL,
246: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
247: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
248: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 262: delete from IMC_THREE_SIXTY_COLS_TL

258: procedure DELETE_ROW (
259: X_COLUMN_ID in NUMBER
260: ) is
261: begin
262: delete from IMC_THREE_SIXTY_COLS_TL
263: where COLUMN_ID = X_COLUMN_ID;
264:
265: if (sql%notfound) then
266: raise no_data_found;

Line 280: delete from IMC_THREE_SIXTY_COLS_TL T

276:
277: procedure ADD_LANGUAGE
278: is
279: begin
280: delete from IMC_THREE_SIXTY_COLS_TL T
281: where not exists
282: (select NULL
283: from IMC_THREE_SIXTY_COLS_B B
284: where B.COLUMN_ID = T.COLUMN_ID

Line 287: update IMC_THREE_SIXTY_COLS_TL T set (

283: from IMC_THREE_SIXTY_COLS_B B
284: where B.COLUMN_ID = T.COLUMN_ID
285: );
286:
287: update IMC_THREE_SIXTY_COLS_TL T set (
288: COLUMN_LABEL
289: ) = (select
290: B.COLUMN_LABEL
291: from IMC_THREE_SIXTY_COLS_TL B

Line 291: from IMC_THREE_SIXTY_COLS_TL B

287: update IMC_THREE_SIXTY_COLS_TL T set (
288: COLUMN_LABEL
289: ) = (select
290: B.COLUMN_LABEL
291: from IMC_THREE_SIXTY_COLS_TL B
292: where B.COLUMN_ID = T.COLUMN_ID
293: and B.LANGUAGE = T.SOURCE_LANG)
294: where (
295: T.COLUMN_ID,

Line 300: from IMC_THREE_SIXTY_COLS_TL SUBB, IMC_THREE_SIXTY_COLS_TL SUBT

296: T.LANGUAGE
297: ) in (select
298: SUBT.COLUMN_ID,
299: SUBT.LANGUAGE
300: from IMC_THREE_SIXTY_COLS_TL SUBB, IMC_THREE_SIXTY_COLS_TL SUBT
301: where SUBB.COLUMN_ID = SUBT.COLUMN_ID
302: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
303: and (SUBB.COLUMN_LABEL <> SUBT.COLUMN_LABEL
304: ));

Line 306: insert into IMC_THREE_SIXTY_COLS_TL (

302: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
303: and (SUBB.COLUMN_LABEL <> SUBT.COLUMN_LABEL
304: ));
305:
306: insert into IMC_THREE_SIXTY_COLS_TL (
307: COLUMN_ID,
308: COLUMN_LABEL,
309: CREATED_BY,
310: CREATION_DATE,

Line 328: from IMC_THREE_SIXTY_COLS_TL B, FND_LANGUAGES L

324: B.LAST_UPDATED_BY,
325: B.OBJECT_VERSION_NUMBER,
326: L.LANGUAGE_CODE,
327: B.SOURCE_LANG
328: from IMC_THREE_SIXTY_COLS_TL B, FND_LANGUAGES L
329: where L.INSTALLED_FLAG in ('I', 'B')
330: and B.LANGUAGE = userenv('LANG')
331: and not exists
332: (select NULL

Line 333: from IMC_THREE_SIXTY_COLS_TL T

329: where L.INSTALLED_FLAG in ('I', 'B')
330: and B.LANGUAGE = userenv('LANG')
331: and not exists
332: (select NULL
333: from IMC_THREE_SIXTY_COLS_TL T
334: where T.COLUMN_ID = B.COLUMN_ID
335: and T.LANGUAGE = L.LANGUAGE_CODE);
336: end ADD_LANGUAGE;
337:

Line 345: update IMC_THREE_SIXTY_COLS_TL set

341: X_OWNER in VARCHAR2) IS
342:
343: BEGIN
344: -- only update rows that have not been altered by user
345: update IMC_THREE_SIXTY_COLS_TL set
346: COLUMN_LABEL= X_COLUMN_LABEL,
347: source_lang = userenv('LANG'),
348: last_update_date = sysdate,
349: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),