APPS.BIS_RL_PKG dependencies on BIS_RELATED_LINKS_TL

Line 880: INSERT INTO bis_related_links_tl

876: plast_update_login
877: );
878:
879: -- mdamle 03/12/04 - Enh 3503753 - Site level custom. for links - insert into TL table
880: INSERT INTO bis_related_links_tl
881: ( related_link_id,
882: user_link_name,
883: language,
884: source_lang,

Line 905: from bis_related_links_tl

901: from fnd_languages l
902: where L.INSTALLED_FLAG in ('I', 'B')
903: and not exists
904: (select null
905: from bis_related_links_tl
906: where related_link_id = l_related_link_id
907: and language = l.language_code);
908:
909:

Line 1437: UPDATE BIS_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
1437: UPDATE BIS_RELATED_LINKS_TL SET USER_LINK_NAME=p_related_link_name
1438: where RELATED_LINK_ID=p_related_link_id and language=userenv('LANG');
1439: ELSE
1440: UPDATE BIS_RELATED_LINKS SET USER_URL=p_user_url WHERE RELATED_LINK_ID=p_related_link_id;
1441: UPDATE BIS_RELATED_LINKS_TL SET USER_LINK_NAME=p_related_link_name

Line 1441: UPDATE BIS_RELATED_LINKS_TL SET USER_LINK_NAME=p_related_link_name

1437: UPDATE BIS_RELATED_LINKS_TL SET USER_LINK_NAME=p_related_link_name
1438: where RELATED_LINK_ID=p_related_link_id and language=userenv('LANG');
1439: ELSE
1440: UPDATE BIS_RELATED_LINKS SET USER_URL=p_user_url WHERE RELATED_LINK_ID=p_related_link_id;
1441: UPDATE BIS_RELATED_LINKS_TL SET USER_LINK_NAME=p_related_link_name
1442: WHERE RELATED_LINK_ID=p_related_link_id and language=userenv('LANG');
1443: END IF;
1444: end if;
1445:

Line 1917: delete bis_related_links_tl

1913: END IF;
1914:
1915: for l in cr_seedlinks loop
1916: begin
1917: delete bis_related_links_tl
1918: where related_link_id = l.related_link_id;
1919: exception
1920: when others then null;
1921: end;

Line 2039: INSERT INTO bis_related_links_tl

2035: p_resp_app_id,
2036: p_display_sequence
2037: FROM DUAL;
2038:
2039: INSERT INTO bis_related_links_tl
2040: (related_link_id,
2041: user_link_name,
2042: language,
2043: source_lang,

Line 2064: from bis_related_links_tl

2060: from fnd_languages l
2061: where L.INSTALLED_FLAG in ('I', 'B')
2062: and not exists
2063: (select null
2064: from bis_related_links_tl
2065: where related_link_id = l_related_link_id
2066: and language = l.language_code);
2067: EXCEPTION
2068: WHEN FND_API.G_EXC_ERROR THEN

Line 2117: update bis_related_links_tl

2113: end;
2114:
2115: if l_related_link_id is not null then
2116: begin
2117: update bis_related_links_tl
2118: set user_link_name = p_user_link_name,
2119: last_update_date = sysdate,
2120: last_updated_by = p_user_id,
2121: last_update_login = p_login_id,

Line 3040: UPDATE BIS_RELATED_LINKS_TL T SET (

3036: PROCEDURE Add_Language IS
3037:
3038: BEGIN
3039:
3040: UPDATE BIS_RELATED_LINKS_TL T SET (
3041: USER_LINK_NAME
3042: ) = (SELECT
3043: B.USER_LINK_NAME
3044: FROM BIS_RELATED_LINKS_TL B

Line 3044: FROM BIS_RELATED_LINKS_TL B

3040: UPDATE BIS_RELATED_LINKS_TL T SET (
3041: USER_LINK_NAME
3042: ) = (SELECT
3043: B.USER_LINK_NAME
3044: FROM BIS_RELATED_LINKS_TL B
3045: WHERE B.RELATED_LINK_ID = T.RELATED_LINK_ID
3046: AND B.LANGUAGE = T.SOURCE_LANG)
3047: WHERE (
3048: T.RELATED_LINK_ID,

Line 3053: FROM BIS_RELATED_LINKS_TL SUBB, BIS_RELATED_LINKS_TL SUBT

3049: T.LANGUAGE
3050: ) IN (SELECT
3051: SUBT.RELATED_LINK_ID,
3052: SUBT.LANGUAGE
3053: FROM BIS_RELATED_LINKS_TL SUBB, BIS_RELATED_LINKS_TL SUBT
3054: WHERE SUBB.RELATED_LINK_ID = SUBT.RELATED_LINK_ID
3055: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
3056: AND (SUBB.USER_LINK_NAME <> SUBT.USER_LINK_NAME
3057: ));

Line 3059: INSERT INTO BIS_RELATED_LINKS_TL

3055: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
3056: AND (SUBB.USER_LINK_NAME <> SUBT.USER_LINK_NAME
3057: ));
3058:
3059: INSERT INTO BIS_RELATED_LINKS_TL
3060: (
3061: RELATED_LINK_ID,
3062: LANGUAGE,
3063: USER_LINK_NAME,

Line 3081: FROM BIS_RELATED_LINKS_TL B, FND_LANGUAGES L

3077: B.CREATED_BY,
3078: B.LAST_UPDATE_DATE,
3079: B.LAST_UPDATED_BY,
3080: B.LAST_UPDATE_LOGIN
3081: FROM BIS_RELATED_LINKS_TL B, FND_LANGUAGES L
3082: WHERE L.INSTALLED_FLAG IN ('I', 'B')
3083: AND B.LANGUAGE = USERENV('LANG')
3084: AND NOT EXISTS
3085: (

Line 3087: FROM BIS_RELATED_LINKS_TL T

3083: AND B.LANGUAGE = USERENV('LANG')
3084: AND NOT EXISTS
3085: (
3086: SELECT NULL
3087: FROM BIS_RELATED_LINKS_TL T
3088: WHERE T.RELATED_LINK_ID = B.RELATED_LINK_ID
3089: AND T.LANGUAGE = L.LANGUAGE_CODE
3090: );
3091: