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.HR_COMP_PROFILE_SS dependencies on HR_COMP_PROFILE_SS

Line 1: PACKAGE BODY HR_COMP_PROFILE_SS AS

1: PACKAGE BODY HR_COMP_PROFILE_SS AS
2: /* $Header: hrcprwrs.pkb 120.1.12000000.2 2007/02/19 14:25:36 kgowripe ship $ */
3: --
4: -- Private globals
5: g_package varchar2(30) := 'HR_COMP_PROFILE_SS';

Line 5: g_package varchar2(30) := 'HR_COMP_PROFILE_SS';

1: PACKAGE BODY HR_COMP_PROFILE_SS AS
2: /* $Header: hrcprwrs.pkb 120.1.12000000.2 2007/02/19 14:25:36 kgowripe ship $ */
3: --
4: -- Private globals
5: g_package varchar2(30) := 'HR_COMP_PROFILE_SS';
6: g_person_id per_all_people_f.person_id%type;
7: g_business_group_id per_all_people_f.business_group_id%type;
8: g_language_code varchar2(5) default null;
9: g_invalid_entry exception;

Line 338: where ts.api_name = 'HR_COMP_PROFILE_SS.PROCESS_API'

334: and a.name = 'P_COMPETENCE_ID' and a.number_value = p_competence_id
335: and b.name = 'P_PERSON_ID' and b.number_value = p_person_id
336: union
337: select 'F' status from hr_api_transaction_steps ts, hr_api_transactions t
338: where ts.api_name = 'HR_COMP_PROFILE_SS.PROCESS_API'
339: and ts.transaction_id = t.transaction_id
340: and t.selected_person_id = p_person_id and t.status = 'Y'
341: and exists (Select 'e' From hr_api_transaction_values c
342: Where c.transaction_step_id = ts.transaction_step_id

Line 493: raise hr_comp_profile_ss.g_fatal_error;

489: open g_csr_get_preupd_cmptnce_rec(p_competence_element_id);
490: Fetch g_csr_get_preupd_cmptnce_rec into l_preupd_cmptnce_row;
491: IF g_csr_get_preupd_cmptnce_rec%notfound THEN
492: close g_csr_get_preupd_cmptnce_rec;
493: raise hr_comp_profile_ss.g_fatal_error;
494: END IF;
495: hr_utility.set_location(l_proc,60);
496: close g_csr_get_preupd_cmptnce_rec;
497: writeTo_transTbl(p_item_type => p_item_type

Line 561: ELSIF p_change_mode = hr_comp_profile_ss.g_upd_mode THEN

557: ,p_sys_generated => 'N'
558: ,p_upg_from_rec_id => p_competence_element_id
559: ,p_prev_status => null
560: ,p_status => p_competence_status);
561: ELSIF p_change_mode = hr_comp_profile_ss.g_upd_mode THEN
562: hr_utility.set_location(l_proc,70);
563: writeTo_transTbl(p_item_type => p_item_type
564: ,p_item_key => p_item_key
565: ,p_actid => to_number(p_actid)

Line 689: WHEN hr_comp_profile_ss.g_data_err THEN

685: EXCEPTION
686: When g_invalid_entry then
687: hr_utility.set_location(' Leaving:' || l_proc,555);
688: raise g_invalid_entry;
689: WHEN hr_comp_profile_ss.g_data_err THEN
690: hr_utility.set_location(' Leaving:' || l_proc,560);
691: raise hr_utility.hr_error;
692: WHEN hr_comp_profile_ss.g_access_violation_err THEN
693: hr_utility.set_location(' Leaving:' || l_proc,565);

Line 692: WHEN hr_comp_profile_ss.g_access_violation_err THEN

688: raise g_invalid_entry;
689: WHEN hr_comp_profile_ss.g_data_err THEN
690: hr_utility.set_location(' Leaving:' || l_proc,560);
691: raise hr_utility.hr_error;
692: WHEN hr_comp_profile_ss.g_access_violation_err THEN
693: hr_utility.set_location(' Leaving:' || l_proc,565);
694: raise hr_utility.hr_error;
695: When others THEN
696: hr_utility.set_location(' Leaving:' || l_proc,570);

Line 739: l_trans_tbl hr_comp_profile_ss.transaction_table1;

735: l_transaction_id number default null;
736: l_transaction_step_id number default null;
737: l_trans_obj_vers_num number default null;
738: l_result varchar2(100) default null;
739: l_trans_tbl hr_comp_profile_ss.transaction_table1;
740: l_user_date_format varchar2(200) default null;
741: l_preupd_date_to date default null;
742: l_eff_date_from date default null;
743: l_eff_date_to date default null;

Line 778: raise hr_comp_profile_ss.g_fatal_error;

774: FETCH get_prev_start_date into l_prev_date;
775: IF get_prev_start_date%notfound THEN
776: hr_utility.set_location(l_proc,30);
777: close get_comp_name;
778: raise hr_comp_profile_ss.g_fatal_error;
779: END IF;
780: close get_prev_start_date;
781: l_prev_start_date := l_prev_date;
782: hr_utility.set_location(l_proc,35);

Line 841: raise hr_comp_profile_ss.g_fatal_error;

837: Fetch g_csr_get_preupd_cmptnce_rec into l_preupd_cmptnce_row;
838: IF g_csr_get_preupd_cmptnce_rec%notfound THEN
839: hr_utility.set_location(l_proc,80);
840: close g_csr_get_preupd_cmptnce_rec;
841: raise hr_comp_profile_ss.g_fatal_error;
842: END IF;
843: --
844: close g_csr_get_preupd_cmptnce_rec;
845: hr_utility.set_location(l_proc,85);

Line 987: WHEN hr_comp_profile_ss.g_data_err THEN

983: END IF;
984: hr_utility.set_location(' Leaving:' || l_proc,105);
985: --
986: EXCEPTION
987: WHEN hr_comp_profile_ss.g_data_err THEN
988: hr_utility.set_location(' Leaving:' || l_proc,555);
989: raise hr_utility.hr_error;
990: --
991: WHEN hr_comp_profile_ss.g_access_violation_err THEN

Line 991: WHEN hr_comp_profile_ss.g_access_violation_err THEN

987: WHEN hr_comp_profile_ss.g_data_err THEN
988: hr_utility.set_location(' Leaving:' || l_proc,555);
989: raise hr_utility.hr_error;
990: --
991: WHEN hr_comp_profile_ss.g_access_violation_err THEN
992: hr_utility.set_location(' Leaving:' || l_proc,560);
993: raise hr_utility.hr_error;
994: --
995: When others THEN

Line 1373: AND s.api_name = 'HR_COMP_PROFILE_SS.PROCESS_API'

1369: WHERE
1370: s.item_type = p_item_type
1371: and s.item_key = p_item_key
1372: and s.activity_id = p_activity_id
1373: AND s.api_name = 'HR_COMP_PROFILE_SS.PROCESS_API'
1374: and c.transaction_step_id = s.transaction_step_id
1375: and d.transaction_step_id = s.transaction_step_id
1376: and e.transaction_step_id = s.transaction_step_id
1377: and f.transaction_step_id = s.transaction_step_id

Line 1400: hr_comp_profile_ss.check_if_cmptnce_rec_changed

1396: p_transaction_step_id := Null;
1397: ENd IF;
1398: IF (p_competence_element_id is not NULL) THEN
1399: hr_utility.set_location(l_proc,15);
1400: hr_comp_profile_ss.check_if_cmptnce_rec_changed
1401: (p_competence_element_id => p_competence_element_id
1402: ,p_competence_id => p_competence_id
1403: ,p_proficiency_level_id => p_proficiency_level_id
1404: ,p_eff_date_from => to_date(p_eff_date_from,g_date_format)

Line 1450: raise hr_comp_profile_ss.g_fatal_error;

1446: FETCH get_comp_name into c_name;
1447: IF get_comp_name%notfound THEN
1448: hr_utility.set_location(l_proc,50);
1449: close get_comp_name;
1450: raise hr_comp_profile_ss.g_fatal_error;
1451: END IF;
1452: close get_comp_name;
1453: p_competence_name := c_name;
1454: hr_utility.set_location(l_proc,55);

Line 1460: raise hr_comp_profile_ss.g_fatal_error;

1456: FETCH get_comp_alias into c_comp_alias;
1457: IF get_comp_alias%notfound THEN
1458: hr_utility.set_location(l_proc,60);
1459: close get_comp_name;
1460: raise hr_comp_profile_ss.g_fatal_error;
1461: END IF;
1462: close get_comp_alias;
1463: p_competence_alias := c_comp_alias;
1464: hr_utility.set_location(l_proc,65);

Line 1530: raise hr_comp_profile_ss.g_fatal_error;

1526: FETCH get_prev_start_date into l_prev_date;
1527: IF get_prev_start_date%notfound THEN
1528: hr_utility.set_location(l_proc,140);
1529: close get_comp_name;
1530: raise hr_comp_profile_ss.g_fatal_error;
1531: END IF;
1532: close get_prev_start_date;
1533: hr_utility.set_location(l_proc,145);
1534: l_prev_start_date := l_prev_date;

Line 1869: l_trans_tbl hr_comp_profile_ss.transaction_table1;

1865: ,transaction_step_id in number ) is
1866: l_proc varchar2(200) := g_package || 'process_save_update_details';
1867: l_eff_date_from date default null;
1868: l_count number default 0;
1869: l_trans_tbl hr_comp_profile_ss.transaction_table1;
1870: l_action_person_id number;
1871: l_transaction_step_id number;
1872: l_prev_step_value number := null;
1873: BEGIN

Line 1956: l_trans_tbl hr_comp_profile_ss.transaction_table1;

1952: l_prev_step_value number default null;
1953: l_prev_step_val number default null;
1954: --------------
1955: l_object_version_number number default null;
1956: l_trans_tbl hr_comp_profile_ss.transaction_table1;
1957: l_count number default 0;
1958: l_action_person_id number default null;
1959: -------------
1960: begin

Line 1982: raise hr_comp_profile_ss.g_fatal_error;

1978: FETCH get_prev_start_date into l_prev_date;
1979: IF get_prev_start_date%notfound THEN
1980: hr_utility.set_location(l_proc,25);
1981: close get_comp_name;
1982: raise hr_comp_profile_ss.g_fatal_error;
1983: ELSE
1984: hr_utility.set_location(l_proc,30);
1985: CLOSE get_prev_start_date;
1986: END IF;

Line 2121: l_trans_tbl hr_comp_profile_ss.transaction_table1;

2117: ,p_transaction_step_id in number
2118: ,p_competence_status IN VARCHAR2 ) is
2119: l_proc varchar2(200) := g_package || 'final_update_save';
2120: l_eff_date_from date ;
2121: l_trans_tbl hr_comp_profile_ss.transaction_table1;
2122: l_action_person_id number;
2123: l_count number default 0;
2124: l_transaction_step_id number;
2125: l_prev_date date;

Line 2145: raise hr_comp_profile_ss.g_fatal_error;

2141: FETCH get_prev_start_date into l_prev_date;
2142: IF get_prev_start_date%notfound THEN
2143: hr_utility.set_location(l_proc,10);
2144: close get_comp_name;
2145: raise hr_comp_profile_ss.g_fatal_error;
2146: END IF;
2147: close get_prev_start_date;
2148: l_prev_start_date := l_prev_date;
2149: update hr_api_transaction_values val

Line 2327: l_trans_tbl hr_comp_profile_ss.transaction_table1;

2323: x_competence_id number default null;
2324: x_prof_level_id number default null;
2325: x_step_value number default null;
2326: l_transaction_id number default null;
2327: l_trans_tbl hr_comp_profile_ss.transaction_table1;
2328: l_user_date_format varchar2(200) default null;
2329: l_eff_date_from date default null;
2330: l_eff_date_to date default null;
2331: l_certification_date date default null;

Line 2677: where ts.api_name = 'HR_COMP_PROFILE_SS.PROCESS_API'

2673: and b.name = 'P_PERSON_ID' and b.number_value = p_person_id
2674: and d.name = 'P_CHANGE_MODE' and d.varchar2_value <> 'ADD'
2675: union
2676: select 'F' status from hr_api_transaction_steps ts, hr_api_transactions t
2677: where ts.api_name = 'HR_COMP_PROFILE_SS.PROCESS_API'
2678: and ts.transaction_id = t.transaction_id
2679: and t.selected_person_id = p_person_id and t.status = 'Y'
2680: and exists (Select 'e' From hr_api_transaction_values c
2681: Where c.transaction_step_id = ts.transaction_step_id

Line 3011: l_trans_tbl hr_comp_profile_ss.transaction_table1;

3007: and activity_id = p_activity_id;
3008: l_step_values c1%rowtype;
3009: l_index number;
3010: l_count number := 0;
3011: l_trans_tbl hr_comp_profile_ss.transaction_table1;
3012: l_transaction_step_id number;
3013: begin
3014: hr_utility.set_location(' Entering:' || l_proc,5);
3015: l_index := 0;

Line 3203: IF upper(p_change_mode) = hr_comp_profile_ss.g_upgrade_proficiency_mode THEN

3199: goto finish_processing;
3200: END IF;
3201: --
3202: -- UPGRADE
3203: IF upper(p_change_mode) = hr_comp_profile_ss.g_upgrade_proficiency_mode THEN
3204: hr_utility.set_location(l_proc,85);
3205: l_preupd_date_to := l_eff_date_from - 1;
3206: l_object_version_number := p_preupd_obj_vers_num;
3207: --

Line 3231: ELSIF upper(p_change_mode) = hr_comp_profile_ss.g_upd_mode THEN

3227: ,p_next_certification_date => l_next_certification_date
3228: ,p_status => p_competence_status
3229: ,p_effective_date => trunc(sysdate));
3230: -- CORRECT
3231: ELSIF upper(p_change_mode) = hr_comp_profile_ss.g_upd_mode THEN
3232: hr_utility.set_location(l_proc,90);
3233: l_object_version_number := p_preupd_obj_vers_num;
3234: per_cel_upd.upd(p_validate => false
3235: ,p_competence_element_id => p_competence_element_id

Line 3339: hr_comp_profile_ss.g_upgrade_proficiency_mode

3335: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3336: ELSIF hr_message.last_message_name = 'HR_51647_CEL_DATES_INVL' THEN
3337: hr_utility.set_location(' Leaving:' || l_proc,620);
3338: IF upper(p_change_mode) =
3339: hr_comp_profile_ss.g_upgrade_proficiency_mode
3340: and (p_eff_date_to is null or
3341: to_date(p_eff_date_from, l_user_date_format) <=
3342: to_date(p_eff_date_to, l_user_date_format))THEN
3343: hr_utility.set_location(' Leaving:' || l_proc,625);

Line 3470: raise hr_comp_profile_ss.g_fatal_error;

3466: hr_utility.set_location( l_proc , 15);
3467: null;
3468: ELSE
3469: hr_utility.set_location( l_proc , 20);
3470: raise hr_comp_profile_ss.g_fatal_error;
3471: END IF;
3472: --
3473: IF nvl(l_preupd_rec.proficiency_level_id,'-99') = nvl(p_proficiency_level_id,'-99') THEN
3474: hr_utility.set_location( l_proc , 25);

Line 3848: End hr_comp_profile_ss;

3844: End If;
3845: Return l_return;
3846: End;
3847: --
3848: End hr_comp_profile_ss;