APPS.IBY_FNDCPT_MLSUTL_PVT dependencies on IBY_FNDCPT_SYS_DC_PF_TL

Line 1839: insert into IBY_FNDCPT_SYS_DC_PF_TL (

1835: X_LAST_UPDATED_BY,
1836: X_LAST_UPDATE_LOGIN
1837: );
1838:
1839: insert into IBY_FNDCPT_SYS_DC_PF_TL (
1840: SYS_DC_PROFILE_CODE,
1841: SYS_DC_PROFILE_NAME,
1842: CREATED_BY,
1843: CREATION_DATE,

Line 1865: from IBY_FNDCPT_SYS_DC_PF_TL T

1861: from FND_LANGUAGES L
1862: where L.INSTALLED_FLAG in ('I', 'B')
1863: and not exists
1864: (select NULL
1865: from IBY_FNDCPT_SYS_DC_PF_TL T
1866: where T.SYS_DC_PROFILE_CODE = X_SYS_DC_PROFILE_CODE
1867: and T.LANGUAGE = L.LANGUAGE_CODE);
1868:
1869: open c;

Line 1923: update IBY_FNDCPT_SYS_DC_PF_TL set

1919: if (sql%notfound) then
1920: raise no_data_found;
1921: end if;
1922:
1923: update IBY_FNDCPT_SYS_DC_PF_TL set
1924: SYS_DC_PROFILE_NAME = X_SYS_DC_PROFILE_NAME,
1925: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1926: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1927: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 1941: delete from IBY_FNDCPT_SYS_DC_PF_TL

1937: procedure SYS_DC_PROF_DELETE_ROW (
1938: X_SYS_DC_PROFILE_CODE in VARCHAR2
1939: ) is
1940: begin
1941: delete from IBY_FNDCPT_SYS_DC_PF_TL
1942: where SYS_DC_PROFILE_CODE = X_SYS_DC_PROFILE_CODE;
1943:
1944: if (sql%notfound) then
1945: raise no_data_found;

Line 1959: delete from IBY_FNDCPT_SYS_DC_PF_TL T

1955:
1956: procedure SYS_DC_PROF_ADD_LANGUAGE
1957: is
1958: begin
1959: delete from IBY_FNDCPT_SYS_DC_PF_TL T
1960: where not exists
1961: (select NULL
1962: from IBY_FNDCPT_SYS_DC_PF_B B
1963: where B.SYS_DC_PROFILE_CODE = T.SYS_DC_PROFILE_CODE

Line 1966: update IBY_FNDCPT_SYS_DC_PF_TL T set (

1962: from IBY_FNDCPT_SYS_DC_PF_B B
1963: where B.SYS_DC_PROFILE_CODE = T.SYS_DC_PROFILE_CODE
1964: );
1965:
1966: update IBY_FNDCPT_SYS_DC_PF_TL T set (
1967: SYS_DC_PROFILE_NAME
1968: ) = (select
1969: B.SYS_DC_PROFILE_NAME
1970: from IBY_FNDCPT_SYS_DC_PF_TL B

Line 1970: from IBY_FNDCPT_SYS_DC_PF_TL B

1966: update IBY_FNDCPT_SYS_DC_PF_TL T set (
1967: SYS_DC_PROFILE_NAME
1968: ) = (select
1969: B.SYS_DC_PROFILE_NAME
1970: from IBY_FNDCPT_SYS_DC_PF_TL B
1971: where B.SYS_DC_PROFILE_CODE = T.SYS_DC_PROFILE_CODE
1972: and B.LANGUAGE = T.SOURCE_LANG)
1973: where (
1974: T.SYS_DC_PROFILE_CODE,

Line 1979: from IBY_FNDCPT_SYS_DC_PF_TL SUBB, IBY_FNDCPT_SYS_DC_PF_TL SUBT

1975: T.LANGUAGE
1976: ) in (select
1977: SUBT.SYS_DC_PROFILE_CODE,
1978: SUBT.LANGUAGE
1979: from IBY_FNDCPT_SYS_DC_PF_TL SUBB, IBY_FNDCPT_SYS_DC_PF_TL SUBT
1980: where SUBB.SYS_DC_PROFILE_CODE = SUBT.SYS_DC_PROFILE_CODE
1981: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1982: and (SUBB.SYS_DC_PROFILE_NAME <> SUBT.SYS_DC_PROFILE_NAME
1983: ));

Line 1985: insert into IBY_FNDCPT_SYS_DC_PF_TL (

1981: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1982: and (SUBB.SYS_DC_PROFILE_NAME <> SUBT.SYS_DC_PROFILE_NAME
1983: ));
1984:
1985: insert into IBY_FNDCPT_SYS_DC_PF_TL (
1986: SYS_DC_PROFILE_CODE,
1987: SYS_DC_PROFILE_NAME,
1988: CREATED_BY,
1989: CREATION_DATE,

Line 2007: from IBY_FNDCPT_SYS_DC_PF_TL B, FND_LANGUAGES L

2003: B.LAST_UPDATE_LOGIN,
2004: B.OBJECT_VERSION_NUMBER,
2005: L.LANGUAGE_CODE,
2006: B.SOURCE_LANG
2007: from IBY_FNDCPT_SYS_DC_PF_TL B, FND_LANGUAGES L
2008: where L.INSTALLED_FLAG in ('I', 'B')
2009: and B.LANGUAGE = userenv('LANG')
2010: and not exists
2011: (select NULL

Line 2012: from IBY_FNDCPT_SYS_DC_PF_TL T

2008: where L.INSTALLED_FLAG in ('I', 'B')
2009: and B.LANGUAGE = userenv('LANG')
2010: and not exists
2011: (select NULL
2012: from IBY_FNDCPT_SYS_DC_PF_TL T
2013: where T.SYS_DC_PROFILE_CODE = B.SYS_DC_PROFILE_CODE
2014: and T.LANGUAGE = L.LANGUAGE_CODE);
2015: end SYS_DC_PROF_ADD_LANGUAGE;
2016:

Line 2091: update iby_fndcpt_sys_dc_pf_tl set

2087: X_LAST_UPDATE_DATE in DATE,
2088: X_OWNER in VARCHAR2)
2089: is
2090: begin
2091: update iby_fndcpt_sys_dc_pf_tl set
2092: SYS_DC_PROFILE_NAME = X_SYS_DC_PROFILE_NAME,
2093: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
2094: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
2095: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,