APPS.MTL_CROSS_REFERENCES_PKG dependencies on MTL_CROSS_REFERENCES_TL

Line 134: INSERT INTO MTL_CROSS_REFERENCES_TL (

130: ,P_PROGRAM_ID
131: ,P_PROGRAM_UPDATE_DATE)
132: RETURNING CROSS_REFERENCE_ID INTO X_CROSS_REFERENCE_ID ;
133:
134: INSERT INTO MTL_CROSS_REFERENCES_TL (
135: LAST_UPDATE_LOGIN
136: ,DESCRIPTION
137: ,CREATION_DATE
138: ,CREATED_BY

Line 157: FROM MTL_CROSS_REFERENCES_TL T

153: USERENV('LANG')
154: FROM FND_LANGUAGES L
155: WHERE L.INSTALLED_FLAG in ('I', 'B')
156: AND NOT EXISTS (SELECT NULL
157: FROM MTL_CROSS_REFERENCES_TL T
158: WHERE T.CROSS_REFERENCE_ID = X_CROSS_REFERENCE_ID
159: AND T.LANGUAGE = L.LANGUAGE_CODE);
160:
161: OPEN C_CHECK_INSERT;

Line 241: FROM MTL_CROSS_REFERENCES_TL

237: CURSOR C_CROSS_REF_TL IS
238: SELECT
239: DESCRIPTION
240: ,DECODE(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
241: FROM MTL_CROSS_REFERENCES_TL
242: WHERE CROSS_REFERENCE_ID = P_CROSS_REFERENCE_ID
243: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
244: FOR UPDATE OF CROSS_REFERENCE_ID NOWAIT;
245:

Line 406: UPDATE MTL_CROSS_REFERENCES_TL

402: IF (SQL%NOTFOUND) THEN
403: RAISE NO_DATA_FOUND;
404: END IF;
405:
406: UPDATE MTL_CROSS_REFERENCES_TL
407: SET DESCRIPTION = P_DESCRIPTION,
408: LAST_UPDATE_DATE = NVL(P_LAST_UPDATE_DATE,SYSDATE),
409: LAST_UPDATED_BY = NVL(P_LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID),
410: LAST_UPDATE_LOGIN = NVL(P_LAST_UPDATED_BY,FND_GLOBAL.LOGIN_ID),

Line 424: DELETE FROM MTL_CROSS_REFERENCES_TL

420:
421: PROCEDURE DELETE_ROW (P_CROSS_REFERENCE_ID IN NUMBER) IS
422: BEGIN
423:
424: DELETE FROM MTL_CROSS_REFERENCES_TL
425: WHERE CROSS_REFERENCE_ID = P_CROSS_REFERENCE_ID;
426:
427: IF (SQL%NOTFOUND) THEN
428: RAISE NO_DATA_FOUND;

Line 442: DELETE MTL_CROSS_REFERENCES_TL T

438: END DELETE_ROW;
439:
440: PROCEDURE ADD_LANGUAGE IS
441: BEGIN
442: DELETE MTL_CROSS_REFERENCES_TL T
443: WHERE NOT EXISTS (SELECT NULL
444: FROM MTL_CROSS_REFERENCES_B B
445: WHERE B.CROSS_REFERENCE_ID = T.CROSS_REFERENCE_ID);
446:

Line 447: UPDATE MTL_CROSS_REFERENCES_TL T

443: WHERE NOT EXISTS (SELECT NULL
444: FROM MTL_CROSS_REFERENCES_B B
445: WHERE B.CROSS_REFERENCE_ID = T.CROSS_REFERENCE_ID);
446:
447: UPDATE MTL_CROSS_REFERENCES_TL T
448: SET (DESCRIPTION) = (SELECT B.DESCRIPTION
449: FROM MTL_CROSS_REFERENCES_TL B
450: WHERE B.CROSS_REFERENCE_ID = T.CROSS_REFERENCE_ID
451: AND B.LANGUAGE = T.SOURCE_LANG)

Line 449: FROM MTL_CROSS_REFERENCES_TL B

445: WHERE B.CROSS_REFERENCE_ID = T.CROSS_REFERENCE_ID);
446:
447: UPDATE MTL_CROSS_REFERENCES_TL T
448: SET (DESCRIPTION) = (SELECT B.DESCRIPTION
449: FROM MTL_CROSS_REFERENCES_TL B
450: WHERE B.CROSS_REFERENCE_ID = T.CROSS_REFERENCE_ID
451: AND B.LANGUAGE = T.SOURCE_LANG)
452: WHERE (T.CROSS_REFERENCE_ID,T.LANGUAGE) IN
453: (SELECT SUBT.CROSS_REFERENCE_ID

Line 455: FROM MTL_CROSS_REFERENCES_TL SUBB,

451: AND B.LANGUAGE = T.SOURCE_LANG)
452: WHERE (T.CROSS_REFERENCE_ID,T.LANGUAGE) IN
453: (SELECT SUBT.CROSS_REFERENCE_ID
454: ,SUBT.LANGUAGE
455: FROM MTL_CROSS_REFERENCES_TL SUBB,
456: MTL_CROSS_REFERENCES_TL SUBT
457: WHERE SUBB.CROSS_REFERENCE_ID = SUBT.CROSS_REFERENCE_ID
458: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
459: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 456: MTL_CROSS_REFERENCES_TL SUBT

452: WHERE (T.CROSS_REFERENCE_ID,T.LANGUAGE) IN
453: (SELECT SUBT.CROSS_REFERENCE_ID
454: ,SUBT.LANGUAGE
455: FROM MTL_CROSS_REFERENCES_TL SUBB,
456: MTL_CROSS_REFERENCES_TL SUBT
457: WHERE SUBB.CROSS_REFERENCE_ID = SUBT.CROSS_REFERENCE_ID
458: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
459: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
460: OR (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 463: INSERT INTO MTL_CROSS_REFERENCES_TL (

459: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
460: OR (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
461: OR (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)));
462:
463: INSERT INTO MTL_CROSS_REFERENCES_TL (
464: LAST_UPDATE_LOGIN
465: ,DESCRIPTION
466: ,CREATION_DATE
467: ,CREATED_BY

Line 483: FROM MTL_CROSS_REFERENCES_TL B,

479: ,B.LAST_UPDATED_BY
480: ,B.CROSS_REFERENCE_ID
481: ,L.LANGUAGE_CODE
482: ,B.SOURCE_LANG
483: FROM MTL_CROSS_REFERENCES_TL B,
484: FND_LANGUAGES L
485: WHERE L.INSTALLED_FLAG in ('I', 'B')
486: AND B.LANGUAGE = USERENV('LANG')
487: AND NOT EXISTS (SELECT NULL

Line 488: FROM MTL_CROSS_REFERENCES_TL T

484: FND_LANGUAGES L
485: WHERE L.INSTALLED_FLAG in ('I', 'B')
486: AND B.LANGUAGE = USERENV('LANG')
487: AND NOT EXISTS (SELECT NULL
488: FROM MTL_CROSS_REFERENCES_TL T
489: WHERE T.CROSS_REFERENCE_ID = B.CROSS_REFERENCE_ID
490: AND T.LANGUAGE = L.LANGUAGE_CODE);
491: END ADD_LANGUAGE;
492: