APPS.IBC_DIRECTORY_NODES_PKG dependencies on IBC_DIRECTORY_NODES_TL

Line 96: INSERT INTO IBC_DIRECTORY_NODES_TL (

92: DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
93: NULL, FND_GLOBAL.login_id, p_last_update_login)
94: );
95:
96: INSERT INTO IBC_DIRECTORY_NODES_TL (
97: DIRECTORY_NODE_ID,
98: DIRECTORY_NODE_NAME,
99: DESCRIPTION,
100: CREATED_BY,

Line 127: FROM IBC_DIRECTORY_NODES_TL T

123: FROM FND_LANGUAGES L
124: WHERE L.INSTALLED_FLAG IN ('I', 'B')
125: AND NOT EXISTS
126: (SELECT NULL
127: FROM IBC_DIRECTORY_NODES_TL T
128: WHERE T.DIRECTORY_NODE_ID = px_DIRECTORY_NODE_ID
129: AND T.LANGUAGE = L.LANGUAGE_CODE);
130:
131: OPEN c;

Line 259: FROM IBC_DIRECTORY_NODES_TL

255: CURSOR c1 IS SELECT
256: DIRECTORY_NODE_NAME,
257: DESCRIPTION,
258: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
259: FROM IBC_DIRECTORY_NODES_TL
260: WHERE DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID
261: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
262: FOR UPDATE OF DIRECTORY_NODE_ID NOWAIT;
263: BEGIN

Line 410: UPDATE IBC_DIRECTORY_NODES_TL SET

406: IF (SQL%NOTFOUND) THEN
407: RAISE NO_DATA_FOUND;
408: END IF;
409:
410: UPDATE IBC_DIRECTORY_NODES_TL SET
411: DIRECTORY_NODE_NAME = DECODE(p_DIRECTORY_NODE_NAME,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_NODE_NAME,p_DIRECTORY_NODE_NAME),
412: DESCRIPTION = DECODE(p_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,p_DESCRIPTION),
413: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
414: NULL, SYSDATE, p_last_update_date),

Line 470: DELETE FROM IBC_DIRECTORY_NODES_TL

466: PROCEDURE DELETE_ROW (
467: p_DIRECTORY_NODE_ID IN NUMBER
468: ) IS
469: BEGIN
470: DELETE FROM IBC_DIRECTORY_NODES_TL
471: WHERE DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID;
472:
473: IF (SQL%NOTFOUND) THEN
474: RAISE NO_DATA_FOUND;

Line 497: DELETE FROM IBC_DIRECTORY_NODES_TL T

493:
494: PROCEDURE ADD_LANGUAGE
495: IS
496: BEGIN
497: DELETE FROM IBC_DIRECTORY_NODES_TL T
498: WHERE NOT EXISTS
499: (SELECT NULL
500: FROM IBC_DIRECTORY_NODES_B B
501: WHERE B.DIRECTORY_NODE_ID = T.DIRECTORY_NODE_ID

Line 504: UPDATE IBC_DIRECTORY_NODES_TL T SET (

500: FROM IBC_DIRECTORY_NODES_B B
501: WHERE B.DIRECTORY_NODE_ID = T.DIRECTORY_NODE_ID
502: );
503:
504: UPDATE IBC_DIRECTORY_NODES_TL T SET (
505: DIRECTORY_NODE_NAME,
506: DESCRIPTION
507: ) = (SELECT
508: B.DIRECTORY_NODE_NAME,

Line 510: FROM IBC_DIRECTORY_NODES_TL B

506: DESCRIPTION
507: ) = (SELECT
508: B.DIRECTORY_NODE_NAME,
509: B.DESCRIPTION
510: FROM IBC_DIRECTORY_NODES_TL B
511: WHERE B.DIRECTORY_NODE_ID = T.DIRECTORY_NODE_ID
512: AND B.LANGUAGE = T.SOURCE_LANG)
513: WHERE (
514: T.DIRECTORY_NODE_ID,

Line 519: FROM IBC_DIRECTORY_NODES_TL SUBB, IBC_DIRECTORY_NODES_TL SUBT

515: T.LANGUAGE
516: ) IN (SELECT
517: SUBT.DIRECTORY_NODE_ID,
518: SUBT.LANGUAGE
519: FROM IBC_DIRECTORY_NODES_TL SUBB, IBC_DIRECTORY_NODES_TL SUBT
520: WHERE SUBB.DIRECTORY_NODE_ID = SUBT.DIRECTORY_NODE_ID
521: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
522: AND (SUBB.DIRECTORY_NODE_NAME <> SUBT.DIRECTORY_NODE_NAME
523: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 528: INSERT INTO IBC_DIRECTORY_NODES_TL (

524: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
525: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
526: ));
527:
528: INSERT INTO IBC_DIRECTORY_NODES_TL (
529: DIRECTORY_NODE_ID,
530: DIRECTORY_NODE_NAME,
531: DESCRIPTION,
532: CREATED_BY,

Line 550: FROM IBC_DIRECTORY_NODES_TL B, FND_LANGUAGES L

546: B.LAST_UPDATE_DATE,
547: B.LAST_UPDATE_LOGIN,
548: L.LANGUAGE_CODE,
549: B.SOURCE_LANG
550: FROM IBC_DIRECTORY_NODES_TL B, FND_LANGUAGES L
551: WHERE L.INSTALLED_FLAG IN ('I', 'B')
552: AND B.LANGUAGE = USERENV('LANG')
553: AND NOT EXISTS
554: (SELECT NULL

Line 555: FROM IBC_DIRECTORY_NODES_TL T

551: WHERE L.INSTALLED_FLAG IN ('I', 'B')
552: AND B.LANGUAGE = USERENV('LANG')
553: AND NOT EXISTS
554: (SELECT NULL
555: FROM IBC_DIRECTORY_NODES_TL T
556: WHERE T.DIRECTORY_NODE_ID = B.DIRECTORY_NODE_ID
557: AND T.LANGUAGE = L.LANGUAGE_CODE);
558: END ADD_LANGUAGE;
559:

Line 672: FROM ibc_directory_nodes_tl

668: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
669:
670: -- get updatedby and update_date values if existing in db
671: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
672: FROM ibc_directory_nodes_tl
673: WHERE DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID
674: AND USERENV('LANG') IN (LANGUAGE, source_lang);
675:
676: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,

Line 680: UPDATE ibc_directory_nodes_tl t SET

676: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
677: db_user_id, db_last_update_date, p_upload_mode )) THEN
678:
679: -- Only update rows which have not been altered by user
680: UPDATE ibc_directory_nodes_tl t SET
681: DIRECTORY_NODE_NAME = p_DIRECTORY_NODE_NAME,
682: description = p_description,
683: source_lang = USERENV('LANG'),
684: last_update_date = l_last_update_date,