APPS.CSF_SKILLS_PKG dependencies on CSF_SKILL_LEVELS_TL

Line 1492: from csf_skill_levels_b a, csf_skill_levels_tl b

1488:
1489: -- cursor to check for duplicate level name
1490: cursor c_dup_name is
1491: select 1
1492: from csf_skill_levels_b a, csf_skill_levels_tl b
1493: where a.skill_level_id = b.skill_level_id
1494: and (upper (rtrim (ltrim (b.name))) = upper (rtrim (ltrim (x_name)))
1495: )
1496: and a.rating_scale_id = x_rating_scale_id

Line 1502: from csf_skill_levels_b a, csf_skill_levels_tl b

1498:
1499: -- cursor to check for duplicate level order
1500: cursor c_dup_order is
1501: select 1
1502: from csf_skill_levels_b a, csf_skill_levels_tl b
1503: where a.skill_level_id = b.skill_level_id
1504: and a.step_value in (
1505: select c.step_value
1506: from csf_skill_levels_b c

Line 1622: insert into csf_skill_levels_tl

1618: , sysdate
1619: , g_user_id
1620: , g_login_id );
1621:
1622: insert into csf_skill_levels_tl
1623: ( skill_level_id
1624: , name
1625: , description
1626: , creation_date

Line 1647: from csf_skill_levels_tl t

1643: from fnd_languages l
1644: where l.installed_flag in ('I', 'B')
1645: and not exists
1646: ( select null
1647: from csf_skill_levels_tl t
1648: where t.skill_level_id = x_skill_level_id
1649: and t.language = l.language_code );
1650:
1651: open c_rowid;

Line 1681: from csf_skill_levels_tl

1677: is
1678: select name
1679: , description
1680: , decode(language, userenv('LANG'), 'Y', 'N') baselang
1681: from csf_skill_levels_tl
1682: where skill_level_id = x_skill_level_id
1683: and userenv('LANG') in (language, source_lang)
1684: for update of skill_level_id nowait;
1685:

Line 1753: from csf_skill_levels_b a, csf_skill_levels_tl b

1749: IS
1750: -- cursor to check for duplicate level name
1751: cursor c_dup_name is
1752: select 1
1753: from csf_skill_levels_b a, csf_skill_levels_tl b
1754: where a.skill_level_id = b.skill_level_id
1755: and (upper (rtrim (ltrim (b.name))) = upper (rtrim (ltrim (x_name)))
1756: )
1757: and a.rating_scale_id = x_rating_scale_id

Line 1764: from csf_skill_levels_b a, csf_skill_levels_tl b

1760:
1761: -- cursor to check for duplicate level order
1762: cursor c_dup_order is
1763: select 1
1764: from csf_skill_levels_b a, csf_skill_levels_tl b
1765: where a.skill_level_id = b.skill_level_id
1766: and a.step_value in (
1767: select c.step_value
1768: from csf_skill_levels_b c

Line 1837: update csf_skill_levels_tl

1833: then
1834: raise no_data_found;
1835: end if;
1836:
1837: update csf_skill_levels_tl
1838: set name = x_name
1839: , description = x_description
1840: , last_update_date = sysdate
1841: , last_updated_by = g_user_id

Line 1857: delete from csf_skill_levels_tl

1853:
1854: PROCEDURE delete_skill_level ( x_skill_level_id in number )
1855: IS
1856: BEGIN
1857: delete from csf_skill_levels_tl
1858: where skill_level_id = x_skill_level_id;
1859:
1860: if sql%notfound
1861: then

Line 1876: delete from csf_skill_levels_tl t

1872:
1873: PROCEDURE add_skill_level_language
1874: IS
1875: BEGIN
1876: delete from csf_skill_levels_tl t
1877: where not exists
1878: ( select null
1879: from csf_skill_levels_b b
1880: where b.skill_level_id = t.skill_level_id );

Line 1882: update csf_skill_levels_tl t

1878: ( select null
1879: from csf_skill_levels_b b
1880: where b.skill_level_id = t.skill_level_id );
1881:
1882: update csf_skill_levels_tl t
1883: set ( name
1884: , description ) = ( select b.name
1885: , b.description
1886: from csf_skill_levels_tl b

Line 1886: from csf_skill_levels_tl b

1882: update csf_skill_levels_tl t
1883: set ( name
1884: , description ) = ( select b.name
1885: , b.description
1886: from csf_skill_levels_tl b
1887: where b.skill_level_id = t.skill_level_id
1888: and b.language = t.source_lang )
1889: where ( t.skill_level_id, t.language ) in
1890: ( select subt.skill_level_id

Line 1892: from csf_skill_levels_tl subb

1888: and b.language = t.source_lang )
1889: where ( t.skill_level_id, t.language ) in
1890: ( select subt.skill_level_id
1891: , subt.language
1892: from csf_skill_levels_tl subb
1893: , csf_skill_levels_tl subt
1894: where subb.skill_level_id = subt.skill_level_id
1895: and subb.language = subt.source_lang
1896: and ( subb.name <> subt.name

Line 1893: , csf_skill_levels_tl subt

1889: where ( t.skill_level_id, t.language ) in
1890: ( select subt.skill_level_id
1891: , subt.language
1892: from csf_skill_levels_tl subb
1893: , csf_skill_levels_tl subt
1894: where subb.skill_level_id = subt.skill_level_id
1895: and subb.language = subt.source_lang
1896: and ( subb.name <> subt.name
1897: or subb.description <> subt.description

Line 1901: insert into csf_skill_levels_tl

1897: or subb.description <> subt.description
1898: or (subb.description is null and subt.description is not null)
1899: or (subb.description is not null and subt.description is null)));
1900:
1901: insert into csf_skill_levels_tl
1902: ( skill_level_id
1903: , name
1904: , description
1905: , created_by

Line 1922: from csf_skill_levels_tl b

1918: , b.last_update_date
1919: , b.last_update_login
1920: , l.language_code
1921: , b.source_lang
1922: from csf_skill_levels_tl b
1923: , fnd_languages l
1924: where l.installed_flag in ('I', 'B')
1925: and b.language = userenv('LANG')
1926: and not exists

Line 1928: from csf_skill_levels_tl t

1924: where l.installed_flag in ('I', 'B')
1925: and b.language = userenv('LANG')
1926: and not exists
1927: ( select null
1928: from csf_skill_levels_tl t
1929: where t.skill_level_id = b.skill_level_id
1930: and t.language = l.language_code );
1931: END add_skill_level_language;
1932:

Line 2554: update csf_skill_levels_tl

2550: , p_name in varchar2
2551: , p_description in varchar2)
2552: IS
2553: BEGIN
2554: update csf_skill_levels_tl
2555: set name = p_name,
2556: description = p_description,
2557: last_update_date = sysdate,
2558: last_updated_by = decode(p_owner, 'SEED', 1, 0),