APPS.IBC_LABELS_PKG dependencies on IBC_LABELS_TL

Line 54: INSERT INTO IBC_LABELS_TL (

50: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
51: NULL, FND_GLOBAL.login_id, p_last_update_login)
52: );
53:
54: INSERT INTO IBC_LABELS_TL (
55: LABEL_CODE,
56: LABEL_NAME,
57: DESCRIPTION,
58: CREATION_DATE,

Line 85: FROM IBC_LABELS_TL T

81: FROM FND_LANGUAGES L
82: WHERE L.INSTALLED_FLAG IN ('I', 'B')
83: AND NOT EXISTS
84: (SELECT NULL
85: FROM IBC_LABELS_TL T
86: WHERE T.LABEL_CODE = p_LABEL_CODE
87: AND T.LANGUAGE = L.LANGUAGE_CODE);
88:
89: OPEN c;

Line 116: FROM IBC_LABELS_TL

112: CURSOR c1 IS SELECT
113: LABEL_NAME,
114: DESCRIPTION,
115: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
116: FROM IBC_LABELS_TL
117: WHERE LABEL_CODE = p_LABEL_CODE
118: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
119: FOR UPDATE OF LABEL_CODE NOWAIT;
120: BEGIN

Line 183: UPDATE IBC_LABELS_TL SET

179: IF (SQL%NOTFOUND) THEN
180: RAISE NO_DATA_FOUND;
181: END IF;
182:
183: UPDATE IBC_LABELS_TL SET
184: LABEL_NAME = DECODE(p_LABEL_NAME,FND_API.G_MISS_CHAR,NULL,NULL,LABEL_NAME,p_LABEL_NAME),
185: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,NULL,DESCRIPTION,p_DESCRIPTION),
186: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
187: NULL, SYSDATE, p_last_update_date),

Line 207: DELETE FROM IBC_LABELS_TL

203: PROCEDURE DELETE_ROW (
204: p_LABEL_CODE IN VARCHAR2
205: ) IS
206: BEGIN
207: DELETE FROM IBC_LABELS_TL
208: WHERE LABEL_CODE = p_LABEL_CODE;
209:
210: IF (SQL%NOTFOUND) THEN
211: RAISE NO_DATA_FOUND;

Line 225: DELETE FROM IBC_LABELS_TL T

221:
222: PROCEDURE ADD_LANGUAGE
223: IS
224: BEGIN
225: DELETE FROM IBC_LABELS_TL T
226: WHERE NOT EXISTS
227: (SELECT NULL
228: FROM IBC_LABELS_B B
229: WHERE B.LABEL_CODE = T.LABEL_CODE

Line 232: UPDATE IBC_LABELS_TL T SET (

228: FROM IBC_LABELS_B B
229: WHERE B.LABEL_CODE = T.LABEL_CODE
230: );
231:
232: UPDATE IBC_LABELS_TL T SET (
233: LABEL_NAME,
234: DESCRIPTION
235: ) = (SELECT
236: B.LABEL_NAME,

Line 238: FROM IBC_LABELS_TL B

234: DESCRIPTION
235: ) = (SELECT
236: B.LABEL_NAME,
237: B.DESCRIPTION
238: FROM IBC_LABELS_TL B
239: WHERE B.LABEL_CODE = T.LABEL_CODE
240: AND B.LANGUAGE = T.SOURCE_LANG)
241: WHERE (
242: T.LABEL_CODE,

Line 247: FROM IBC_LABELS_TL SUBB, IBC_LABELS_TL SUBT

243: T.LANGUAGE
244: ) IN (SELECT
245: SUBT.LABEL_CODE,
246: SUBT.LANGUAGE
247: FROM IBC_LABELS_TL SUBB, IBC_LABELS_TL SUBT
248: WHERE SUBB.LABEL_CODE = SUBT.LABEL_CODE
249: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
250: AND (SUBB.LABEL_NAME <> SUBT.LABEL_NAME
251: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 256: INSERT INTO IBC_LABELS_TL (

252: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
253: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
254: ));
255:
256: INSERT INTO IBC_LABELS_TL (
257: LABEL_CODE,
258: LABEL_NAME,
259: DESCRIPTION,
260: CREATED_BY,

Line 278: FROM IBC_LABELS_TL B, FND_LANGUAGES L

274: B.LAST_UPDATE_DATE,
275: B.LAST_UPDATE_LOGIN,
276: L.LANGUAGE_CODE,
277: B.SOURCE_LANG
278: FROM IBC_LABELS_TL B, FND_LANGUAGES L
279: WHERE L.INSTALLED_FLAG IN ('I', 'B')
280: AND B.LANGUAGE = USERENV('LANG')
281: AND NOT EXISTS
282: (SELECT NULL

Line 283: FROM IBC_LABELS_TL T

279: WHERE L.INSTALLED_FLAG IN ('I', 'B')
280: AND B.LANGUAGE = USERENV('LANG')
281: AND NOT EXISTS
282: (SELECT NULL
283: FROM IBC_LABELS_TL T
284: WHERE T.LABEL_CODE = B.LABEL_CODE
285: AND T.LANGUAGE = L.LANGUAGE_CODE);
286: END ADD_LANGUAGE;
287:

Line 359: UPDATE IBC_LABELS_TL

355: l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);
356:
357:
358: -- Only update rows which have not been altered by user
359: UPDATE IBC_LABELS_TL
360: SET description = p_DESCRIPTION,
361: LABEL_NAME = p_LABEL_NAME,
362: source_lang = USERENV('LANG'),
363: last_update_date = sysdate,