APPS.BIS_RL_PKG dependencies on BIS_CUSTOM_RELATED_LINKS_TL

Line 783: INSERT INTO bis_custom_related_links_tl

779: plast_update_login
780: );
781:
782: -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links - insert into TL table
783: INSERT INTO bis_custom_related_links_tl
784: ( related_link_id,
785: user_link_name,
786: language,
787: source_lang,

Line 808: from bis_custom_related_links_tl

804: from fnd_languages l
805: where L.INSTALLED_FLAG in ('I', 'B')
806: and not exists
807: (select null
808: from bis_custom_related_links_tl
809: where related_link_id = l_related_link_id
810: and language = l.language_code);
811:
812:

Line 1428: UPDATE BIS_CUSTOM_RELATED_LINKS_TL SET USER_LINK_NAME=p_related_link_name

1424: BEGIN
1425:
1426: if (p_isPreseed = 'N') then
1427: IF (p_user_url = null) THEN
1428: UPDATE BIS_CUSTOM_RELATED_LINKS_TL SET USER_LINK_NAME=p_related_link_name
1429: where RELATED_LINK_ID=p_related_link_id and language=userenv('LANG');
1430: ELSE
1431: UPDATE BIS_CUSTOM_RELATED_LINKS SET USER_URL=p_user_url WHERE RELATED_LINK_ID=p_related_link_id;
1432: UPDATE BIS_CUSTOM_RELATED_LINKS_TL SET USER_LINK_NAME=p_related_link_name

Line 1432: UPDATE BIS_CUSTOM_RELATED_LINKS_TL SET USER_LINK_NAME=p_related_link_name

1428: UPDATE BIS_CUSTOM_RELATED_LINKS_TL SET USER_LINK_NAME=p_related_link_name
1429: where RELATED_LINK_ID=p_related_link_id and language=userenv('LANG');
1430: ELSE
1431: UPDATE BIS_CUSTOM_RELATED_LINKS SET USER_URL=p_user_url WHERE RELATED_LINK_ID=p_related_link_id;
1432: UPDATE BIS_CUSTOM_RELATED_LINKS_TL SET USER_LINK_NAME=p_related_link_name
1433: WHERE RELATED_LINK_ID=p_related_link_id and language=userenv('LANG');
1434: END IF;
1435: else
1436: IF (p_user_url = null) THEN

Line 1757: INSERT INTO bis_custom_related_links_tl

1753: SYSDATE,
1754: p_user_id,
1755: p_user_id);
1756:
1757: INSERT INTO bis_custom_related_links_tl
1758: ( related_link_id,
1759: user_link_name,
1760: language,
1761: source_lang,

Line 1782: from bis_custom_related_links_tl

1778: from fnd_languages l
1779: where L.INSTALLED_FLAG in ('I', 'B')
1780: and not exists
1781: (select null
1782: from bis_custom_related_links_tl
1783: where related_link_id = p_related_link_id
1784: and language = l.language_code);
1785:
1786: END insertCustomLinks;

Line 1928: delete bis_custom_related_links_tl

1924: -- mdamle 06/29/2004 - Don't delete customized links
1925: /*
1926: for l in cr_customlinks loop
1927: begin
1928: delete bis_custom_related_links_tl
1929: where related_link_id = l.related_link_id;
1930: exception
1931: when others then null;
1932: end;

Line 3092: UPDATE BIS_CUSTOM_RELATED_LINKS_TL T SET (

3088: WHERE T.RELATED_LINK_ID = B.RELATED_LINK_ID
3089: AND T.LANGUAGE = L.LANGUAGE_CODE
3090: );
3091:
3092: UPDATE BIS_CUSTOM_RELATED_LINKS_TL T SET (
3093: USER_LINK_NAME
3094: ) = (SELECT
3095: B.USER_LINK_NAME
3096: FROM BIS_CUSTOM_RELATED_LINKS_TL B

Line 3096: FROM BIS_CUSTOM_RELATED_LINKS_TL B

3092: UPDATE BIS_CUSTOM_RELATED_LINKS_TL T SET (
3093: USER_LINK_NAME
3094: ) = (SELECT
3095: B.USER_LINK_NAME
3096: FROM BIS_CUSTOM_RELATED_LINKS_TL B
3097: WHERE B.RELATED_LINK_ID = T.RELATED_LINK_ID
3098: AND B.LANGUAGE = T.SOURCE_LANG)
3099: WHERE (
3100: T.RELATED_LINK_ID,

Line 3105: FROM BIS_CUSTOM_RELATED_LINKS_TL SUBB, BIS_CUSTOM_RELATED_LINKS_TL SUBT

3101: T.LANGUAGE
3102: ) IN (SELECT
3103: SUBT.RELATED_LINK_ID,
3104: SUBT.LANGUAGE
3105: FROM BIS_CUSTOM_RELATED_LINKS_TL SUBB, BIS_CUSTOM_RELATED_LINKS_TL SUBT
3106: WHERE SUBB.RELATED_LINK_ID = SUBT.RELATED_LINK_ID
3107: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
3108: AND (SUBB.USER_LINK_NAME <> SUBT.USER_LINK_NAME
3109: ));

Line 3111: INSERT INTO BIS_CUSTOM_RELATED_LINKS_TL

3107: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
3108: AND (SUBB.USER_LINK_NAME <> SUBT.USER_LINK_NAME
3109: ));
3110:
3111: INSERT INTO BIS_CUSTOM_RELATED_LINKS_TL
3112: (
3113: RELATED_LINK_ID,
3114: LANGUAGE,
3115: USER_LINK_NAME,

Line 3133: FROM BIS_CUSTOM_RELATED_LINKS_TL B, FND_LANGUAGES L

3129: B.CREATED_BY,
3130: B.LAST_UPDATE_DATE,
3131: B.LAST_UPDATED_BY,
3132: B.LAST_UPDATE_LOGIN
3133: FROM BIS_CUSTOM_RELATED_LINKS_TL B, FND_LANGUAGES L
3134: WHERE L.INSTALLED_FLAG IN ('I', 'B')
3135: AND B.LANGUAGE = USERENV('LANG')
3136: AND NOT EXISTS
3137: (

Line 3139: FROM BIS_CUSTOM_RELATED_LINKS_TL T

3135: AND B.LANGUAGE = USERENV('LANG')
3136: AND NOT EXISTS
3137: (
3138: SELECT NULL
3139: FROM BIS_CUSTOM_RELATED_LINKS_TL T
3140: WHERE T.RELATED_LINK_ID = B.RELATED_LINK_ID
3141: AND T.LANGUAGE = L.LANGUAGE_CODE
3142: );
3143: