APPS.CSF_SKILLS_PKG dependencies on CSF_RATING_SCALES_TL

Line 1080: from csf_rating_scales_tl a, csf_rating_scales_b b

1076:
1077: -- cursor to check for duplicate scale names
1078: cursor c_dup_scale_type is
1079: select 1
1080: from csf_rating_scales_tl a, csf_rating_scales_b b
1081: where a.rating_scale_id = b.rating_scale_id
1082: and upper (rtrim (ltrim (name))) = upper (rtrim (ltrim (x_name)))
1083: and language = userenv ('lang');
1084:

Line 1177: insert into csf_rating_scales_tl

1173: , sysdate
1174: , g_user_id
1175: , g_login_id );
1176:
1177: insert into csf_rating_scales_tl
1178: ( rating_scale_id
1179: , name
1180: , description
1181: , creation_date

Line 1202: from csf_rating_scales_tl t

1198: from fnd_languages l
1199: where l.installed_flag in ('I', 'B')
1200: and not exists
1201: ( select null
1202: from csf_rating_scales_tl t
1203: where t.rating_scale_id = x_rating_scale_id
1204: and t.language = l.language_code );
1205:
1206: open c_rowid;

Line 1236: from csf_rating_scales_tl

1232: is
1233: select name
1234: , description
1235: , decode(language, userenv('LANG'), 'Y', 'N') baselang
1236: from csf_rating_scales_tl
1237: where rating_scale_id = x_rating_scale_id
1238: and userenv('LANG') in (language, source_lang)
1239: for update of rating_scale_id nowait;
1240:

Line 1305: from csf_rating_scales_tl a, csf_rating_scales_b b

1301: IS
1302: -- cursor to check for duplicate scale names
1303: cursor c_dup_scale_type is
1304: select 1
1305: from csf_rating_scales_tl a, csf_rating_scales_b b
1306: where a.rating_scale_id = b.rating_scale_id
1307: and upper (rtrim (ltrim (name))) = upper (rtrim (ltrim (x_name)))
1308: and language = userenv ('lang')
1309: and b.rating_scale_id <> x_rating_scale_id;

Line 1358: update csf_rating_scales_tl

1354: then
1355: raise no_data_found;
1356: end if;
1357:
1358: update csf_rating_scales_tl
1359: set name = x_name
1360: , description = x_description
1361: , last_update_date = sysdate
1362: , last_updated_by = g_user_id

Line 1378: delete from csf_rating_scales_tl

1374:
1375: PROCEDURE delete_rating_scale ( x_rating_scale_id in number )
1376: IS
1377: BEGIN
1378: delete from csf_rating_scales_tl
1379: where rating_scale_id = x_rating_scale_id;
1380:
1381: if sql%notfound
1382: then

Line 1397: delete from csf_rating_scales_tl t

1393:
1394: PROCEDURE add_rating_scale_language
1395: IS
1396: BEGIN
1397: delete from csf_rating_scales_tl t
1398: where not exists
1399: ( select null
1400: from csf_rating_scales_b b
1401: where b.rating_scale_id = t.rating_scale_id );

Line 1403: update csf_rating_scales_tl t

1399: ( select null
1400: from csf_rating_scales_b b
1401: where b.rating_scale_id = t.rating_scale_id );
1402:
1403: update csf_rating_scales_tl t
1404: set ( name
1405: , description ) = ( select b.name
1406: , b.description
1407: from csf_rating_scales_tl b

Line 1407: from csf_rating_scales_tl b

1403: update csf_rating_scales_tl t
1404: set ( name
1405: , description ) = ( select b.name
1406: , b.description
1407: from csf_rating_scales_tl b
1408: where b.rating_scale_id = t.rating_scale_id
1409: and b.language = t.source_lang )
1410: where ( t.rating_scale_id, t.language ) in
1411: ( select subt.rating_scale_id

Line 1413: from csf_rating_scales_tl subb

1409: and b.language = t.source_lang )
1410: where ( t.rating_scale_id, t.language ) in
1411: ( select subt.rating_scale_id
1412: , subt.language
1413: from csf_rating_scales_tl subb
1414: , csf_rating_scales_tl subt
1415: where subb.rating_scale_id = subt.rating_scale_id
1416: and subb.language = subt.source_lang
1417: and ( subb.name <> subt.name

Line 1414: , csf_rating_scales_tl subt

1410: where ( t.rating_scale_id, t.language ) in
1411: ( select subt.rating_scale_id
1412: , subt.language
1413: from csf_rating_scales_tl subb
1414: , csf_rating_scales_tl subt
1415: where subb.rating_scale_id = subt.rating_scale_id
1416: and subb.language = subt.source_lang
1417: and ( subb.name <> subt.name
1418: or subb.description <> subt.description

Line 1422: insert into csf_rating_scales_tl

1418: or subb.description <> subt.description
1419: or (subb.description is null and subt.description is not null)
1420: or (subb.description is not null and subt.description is null)));
1421:
1422: insert into csf_rating_scales_tl
1423: ( rating_scale_id
1424: , name
1425: , description
1426: , created_by

Line 1443: from csf_rating_scales_tl b

1439: , b.last_update_date
1440: , b.last_update_login
1441: , l.language_code
1442: , b.source_lang
1443: from csf_rating_scales_tl b
1444: , fnd_languages l
1445: where l.installed_flag in ('I', 'B')
1446: and b.language = userenv('LANG')
1447: and not exists

Line 1449: from csf_rating_scales_tl t

1445: where l.installed_flag in ('I', 'B')
1446: and b.language = userenv('LANG')
1447: and not exists
1448: ( select null
1449: from csf_rating_scales_tl t
1450: where t.rating_scale_id = b.rating_scale_id
1451: and t.language = l.language_code );
1452: END add_rating_scale_language;
1453:

Line 2515: update csf_rating_scales_tl

2511: , p_name in varchar2
2512: , p_description in varchar2)
2513: IS
2514: BEGIN
2515: update csf_rating_scales_tl
2516: set name = p_name,
2517: description = p_description,
2518: last_update_date = sysdate,
2519: last_updated_by = decode(p_owner, 'SEED', 1, 0),