eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_SKILLS_PKG dependencies on CSF_SKILL_TYPES_TL

Line 126: update csf_skill_types_tl

122: , last_updated_by = g_user_id
123: , last_update_login = g_login_id
124: where skill_type_id = l_skill_type_id;
125:
126: update csf_skill_types_tl
127: set name = p_name
128: , description = p_description
129: , last_update_date = p_last_update_date
130: , last_updated_by = g_user_id

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 348: insert into csf_skill_types_tl

344: , sysdate
345: , g_user_id
346: , g_login_id );
347:
348: insert into csf_skill_types_tl
349: ( skill_type_id
350: , name
351: , description
352: , creation_date

Line 373: from csf_skill_types_tl t

369: from fnd_languages l
370: where l.installed_flag in ('I', 'B')
371: and not exists
372: ( select null
373: from csf_skill_types_tl t
374: where t.skill_type_id = x_skill_type_id
375: and t.language = l.language_code );
376:
377: open c_rowid;

Line 407: from csf_skill_types_tl

403: is
404: select name
405: , description
406: , decode(language, userenv('LANG'), 'Y', 'N') baselang
407: from csf_skill_types_tl
408: where skill_type_id = x_skill_type_id
409: and userenv('LANG') in (language, source_lang)
410: for update of skill_type_id nowait;
411:

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 531: update csf_skill_types_tl

527: then
528: raise no_data_found;
529: end if;
530:
531: update csf_skill_types_tl
532: set name = x_name
533: , description = x_description
534: , last_update_date = sysdate
535: , last_updated_by = g_user_id

Line 551: delete from csf_skill_types_tl

547:
548: PROCEDURE delete_skill_type ( x_skill_type_id in number )
549: IS
550: BEGIN
551: delete from csf_skill_types_tl
552: where skill_type_id = x_skill_type_id;
553:
554: if sql%notfound
555: then

Line 570: delete from csf_skill_types_tl t

566:
567: PROCEDURE add_skill_type_language
568: IS
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 );

Line 576: update csf_skill_types_tl t

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
578: , b.description
579: from csf_skill_types_tl b
580: where b.skill_type_id = t.skill_type_id

Line 579: from csf_skill_types_tl b

575:
576: update csf_skill_types_tl t
577: set ( name, description ) = ( select b.name
578: , b.description
579: from csf_skill_types_tl b
580: where b.skill_type_id = t.skill_type_id
581: and b.language = t.source_lang )
582: where ( t.skill_type_id, t.language ) in
583: ( select subt.skill_type_id

Line 585: from csf_skill_types_tl subb

581: and b.language = t.source_lang )
582: where ( t.skill_type_id, t.language ) in
583: ( select subt.skill_type_id
584: , subt.language
585: from csf_skill_types_tl subb
586: , csf_skill_types_tl subt
587: where subb.skill_type_id = subt.skill_type_id
588: and subb.language = subt.source_lang
589: and ( subb.name <> subt.name

Line 586: , csf_skill_types_tl subt

582: where ( t.skill_type_id, t.language ) in
583: ( select subt.skill_type_id
584: , subt.language
585: from csf_skill_types_tl subb
586: , csf_skill_types_tl subt
587: where subb.skill_type_id = subt.skill_type_id
588: and subb.language = subt.source_lang
589: and ( subb.name <> subt.name
590: or subb.description <> subt.description

Line 594: insert into csf_skill_types_tl

590: or subb.description <> subt.description
591: or (subb.description is null and subt.description is not null)
592: or (subb.description is not null and subt.description is null)));
593:
594: insert into csf_skill_types_tl
595: ( skill_type_id
596: , name
597: , description
598: , created_by

Line 615: from csf_skill_types_tl b

611: , b.last_update_date
612: , b.last_update_login
613: , l.language_code
614: , b.source_lang
615: from csf_skill_types_tl b
616: , fnd_languages l
617: where l.installed_flag in ('I', 'B')
618: and b.language = userenv('LANG')
619: and not exists

Line 621: from csf_skill_types_tl t

617: where l.installed_flag in ('I', 'B')
618: and b.language = userenv('LANG')
619: and not exists
620: ( select null
621: from csf_skill_types_tl t
622: where t.skill_type_id = b.skill_type_id
623: and t.language = l.language_code );
624: END add_skill_type_language;
625:

Line 2570: update csf_skill_types_tl

2566: , p_name in varchar2
2567: , p_description in varchar2)
2568: IS
2569: BEGIN
2570: update csf_skill_types_tl
2571: set name = p_name,
2572: description = p_description,
2573: last_update_date = sysdate,
2574: last_updated_by = decode(p_owner, 'SEED', 1, 0),