APPS.CSF_SKILLS_PKG dependencies on CSF_SKILL_TYPES_B

Line 48: from csf_skill_types_b

44: , p_description in varchar2 )
45: IS
46: cursor skillType_cur (b_skill_type_id number) is
47: select skill_type_id, last_update_date
48: from csf_skill_types_b
49: where skill_type_id = b_skill_type_id;
50:
51: l_skill_type_id number;
52: l_last_update_date date;

Line 93: update csf_skill_types_b

89: , p_name
90: , p_description);
91: else
92: if p_last_update_date >= l_last_update_date then
93: update csf_skill_types_b
94: set rating_scale_id = p_rating_scale_id
95: , start_date_active = p_start_date_active
96: , end_date_active = p_end_date_active
97: , seeded_flag = p_seeded_flag

Line 177: from csf_skill_types_b

173: IS
174: cursor c_rowid
175: is
176: select rowid
177: from csf_skill_types_b
178: where skill_type_id = x_skill_type_id;
179:
180: -- cursor to check for duplicate skill type
181: cursor c_dup_task_type is

Line 183: from csf_skill_types_tl a, csf_skill_types_b b

179:
180: -- cursor to check for duplicate skill type
181: cursor c_dup_task_type is
182: select 1
183: from csf_skill_types_tl a, csf_skill_types_b b
184: where a.skill_type_id = b.skill_type_id
185: and upper (rtrim (ltrim (name))) = upper (rtrim (ltrim (x_name)))
186: and language = userenv ('lang');
187:

Line 201: select csf_skill_types_b_s1.nextval

197:
198: BEGIN
199: if x_skill_type_id is null
200: then
201: select csf_skill_types_b_s1.nextval
202: into x_skill_type_id
203: from dual;
204: else
205: -- Checks if record to be inserted already exists.

Line 279: insert into csf_skill_types_b

275: else
276: l_order_by_clause := x_order_by_clause;
277: end if;
278:
279: insert into csf_skill_types_b
280: ( skill_type_id
281: , rating_scale_id
282: , start_date_active
283: , end_date_active

Line 396: from csf_skill_types_b

392: IS
393: cursor c_ovn
394: is
395: select object_version_number
396: from csf_skill_types_b
397: where skill_type_id = x_skill_type_id
398: for update of skill_type_id nowait;
399:
400: l_rec c_ovn%rowtype;

Line 477: from csf_skill_types_tl a, csf_skill_types_b b

473: IS
474: -- cursor to check for duplicate skill type
475: cursor c_dup_task_type is
476: select 1
477: from csf_skill_types_tl a, csf_skill_types_b b
478: where a.skill_type_id = b.skill_type_id
479: and upper (rtrim (ltrim (name))) = upper (rtrim (ltrim (x_name)))
480: and language = userenv ('lang')
481: and a.skill_type_id <> x_skill_type_id;

Line 498: update csf_skill_types_b

494: end if;
495:
496: close c_dup_task_type;
497:
498: update csf_skill_types_b
499: set rating_scale_id = x_rating_scale_id
500: , start_date_active = x_start_date_active
501: , end_date_active = x_end_date_active
502: , seeded_flag = nvl(x_seeded_flag, 'N')

Line 559: delete from csf_skill_types_b

555: then
556: raise no_data_found;
557: end if;
558:
559: delete from csf_skill_types_b
560: where skill_type_id = x_skill_type_id;
561:
562: if sql%notfound then
563: raise no_data_found;

Line 573: from csf_skill_types_b b

569: BEGIN
570: delete from csf_skill_types_tl t
571: where not exists
572: ( select null
573: from csf_skill_types_b b
574: where b.skill_type_id = t.skill_type_id );
575:
576: update csf_skill_types_tl t
577: set ( name, description ) = ( select b.name