APPS.CSF_SKILLS_PKG dependencies on CSF_RATING_SCALES_B

Line 1074: from csf_rating_scales_b

1070: IS
1071: cursor c_rowid
1072: is
1073: select rowid
1074: from csf_rating_scales_b
1075: where rating_scale_id = x_rating_scale_id;
1076:
1077: -- cursor to check for duplicate scale names
1078: cursor c_dup_scale_type is

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 1089: select csf_rating_scales_b_s1.nextval

1085: l_dummy_var number;
1086: BEGIN
1087: if x_rating_scale_id is null
1088: then
1089: select csf_rating_scales_b_s1.nextval
1090: into x_rating_scale_id
1091: from dual;
1092: else
1093: -- Checks if record to be inserted already exists.

Line 1122: insert into csf_rating_scales_b

1118: then
1119: x_object_version_number := 1;
1120: end if;
1121:
1122: insert into csf_rating_scales_b
1123: ( rating_scale_id
1124: , start_date_active
1125: , end_date_active
1126: , seeded_flag

Line 1225: from csf_rating_scales_b

1221: IS
1222: cursor c_ovn
1223: is
1224: select object_version_number
1225: from csf_rating_scales_b
1226: where rating_scale_id = x_rating_scale_id
1227: for update of rating_scale_id nowait;
1228:
1229: l_rec c_ovn%rowtype;

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 1326: update csf_rating_scales_b

1322: end if;
1323:
1324: close c_dup_scale_type;
1325:
1326: update csf_rating_scales_b
1327: set start_date_active = x_start_date_active
1328: , end_date_active = x_end_date_active
1329: , seeded_flag = nvl(x_seeded_flag, 'N')
1330: , object_version_number = object_version_number + 1

Line 1386: delete from csf_rating_scales_b

1382: then
1383: raise no_data_found;
1384: end if;
1385:
1386: delete from csf_rating_scales_b
1387: where rating_scale_id = x_rating_scale_id;
1388:
1389: if sql%notfound then
1390: raise no_data_found;

Line 1400: from csf_rating_scales_b b

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 );
1402:
1403: update csf_rating_scales_tl t
1404: set ( name