APPS.PQH_RBC_LOAD_OBJECTS dependencies on PQH_CRITERIA_RATE_DEFN_TL

Line 891: UPDATE pqh_criteria_rate_defn_tl

887: Where criteria_rate_defn_id = l_criteria_rate_defn_id;
888:
889: if (sql%found) then
890:
891: UPDATE pqh_criteria_rate_defn_tl
892: SET name = p_name,
893: last_updated_by = l_last_updated_by,
894: last_update_date = l_last_update_date,
895: last_update_login = l_last_update_login,

Line 904: insert into pqh_criteria_rate_defn_tl

900: If (sql%notfound) then
901: -- no row in TL table so insert row
902:
903: --
904: insert into pqh_criteria_rate_defn_tl
905: ( criteria_rate_defn_id,
906: name,
907: language,
908: source_lang,

Line 928: from pqh_criteria_rate_defn_tl crl

924: l_last_update_login
925: from fnd_languages l
926: where l.installed_flag in ('I','B')
927: and not exists (select null
928: from pqh_criteria_rate_defn_tl crl
929: where crl.criteria_rate_defn_id = l_criteria_rate_defn_id
930: and crl.language = l.language_code );
931: --
932: End if;

Line 994: insert into pqh_criteria_rate_defn_tl

990: ,l_last_update_login
991: ,l_ovn
992: );
993:
994: insert into pqh_criteria_rate_defn_tl
995: ( criteria_rate_defn_id,
996: name,
997: language,
998: source_lang,

Line 1018: from pqh_criteria_rate_defn_tl crl

1014: l_last_update_login
1015: from fnd_languages l
1016: where l.installed_flag in ('I','B')
1017: and not exists (select null
1018: from pqh_criteria_rate_defn_tl crl
1019: where crl.criteria_rate_defn_id = l_criteria_rate_defn_id
1020: and crl.language = l.language_code );
1021:
1022: End if;

Line 1885: delete from PQH_CRITERIA_RATE_DEFN_TL T

1881:
1882: Procedure ADD_LANGUAGE
1883: is
1884: begin
1885: delete from PQH_CRITERIA_RATE_DEFN_TL T
1886: where not exists
1887: (select NULL
1888: from PQH_CRITERIA_RATE_DEFN B
1889: where B.CRITERIA_RATE_DEFN_ID = T.CRITERIA_RATE_DEFN_ID

Line 1892: update PQH_CRITERIA_RATE_DEFN_TL T set (

1888: from PQH_CRITERIA_RATE_DEFN B
1889: where B.CRITERIA_RATE_DEFN_ID = T.CRITERIA_RATE_DEFN_ID
1890: );
1891:
1892: update PQH_CRITERIA_RATE_DEFN_TL T set (
1893: NAME
1894: ) = (select
1895: B.NAME
1896: from PQH_CRITERIA_RATE_DEFN_TL B

Line 1896: from PQH_CRITERIA_RATE_DEFN_TL B

1892: update PQH_CRITERIA_RATE_DEFN_TL T set (
1893: NAME
1894: ) = (select
1895: B.NAME
1896: from PQH_CRITERIA_RATE_DEFN_TL B
1897: where B.CRITERIA_RATE_DEFN_ID = T.CRITERIA_RATE_DEFN_ID
1898: and B.LANGUAGE = T.SOURCE_LANG)
1899: where (
1900: T.CRITERIA_RATE_DEFN_ID,

Line 1905: from PQH_CRITERIA_RATE_DEFN_TL SUBB, PQH_CRITERIA_RATE_DEFN_TL SUBT

1901: T.LANGUAGE
1902: ) in (select
1903: SUBT.CRITERIA_RATE_DEFN_ID,
1904: SUBT.LANGUAGE
1905: from PQH_CRITERIA_RATE_DEFN_TL SUBB, PQH_CRITERIA_RATE_DEFN_TL SUBT
1906: where SUBB.CRITERIA_RATE_DEFN_ID = SUBT.CRITERIA_RATE_DEFN_ID
1907: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1908: and (SUBB.NAME <> SUBT.NAME
1909: ));

Line 1911: insert into PQH_CRITERIA_RATE_DEFN_TL (

1907: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1908: and (SUBB.NAME <> SUBT.NAME
1909: ));
1910:
1911: insert into PQH_CRITERIA_RATE_DEFN_TL (
1912: CRITERIA_RATE_DEFN_ID,
1913: NAME,
1914: LAST_UPDATE_DATE,
1915: CREATION_DATE,

Line 1931: from PQH_CRITERIA_RATE_DEFN_TL B, FND_LANGUAGES L

1927: B.LAST_UPDATE_LOGIN,
1928: B.LAST_UPDATED_BY,
1929: L.LANGUAGE_CODE,
1930: B.SOURCE_LANG
1931: from PQH_CRITERIA_RATE_DEFN_TL B, FND_LANGUAGES L
1932: where L.INSTALLED_FLAG in ('I', 'B')
1933: and B.LANGUAGE = userenv('LANG')
1934: and not exists
1935: (select NULL

Line 1936: from PQH_CRITERIA_RATE_DEFN_TL T

1932: where L.INSTALLED_FLAG in ('I', 'B')
1933: and B.LANGUAGE = userenv('LANG')
1934: and not exists
1935: (select NULL
1936: from PQH_CRITERIA_RATE_DEFN_TL T
1937: where T.CRITERIA_RATE_DEFN_ID = B.CRITERIA_RATE_DEFN_ID
1938: and T.LANGUAGE = L.LANGUAGE_CODE);
1939: end ADD_LANGUAGE;
1940: -- --