1: PACKAGE BODY hr_suit_match_utility_web AS
2: /* $Header: hrsmutlw.pkb 120.3 2005/12/13 13:44:26 svittal noship $ */
3:
4: g_package constant varchar2(31) := 'hr_suit_match_utility_web.';
5: g_region_application_id constant integer
1: PACKAGE BODY hr_suit_match_utility_web AS
2: /* $Header: hrsmutlw.pkb 120.3 2005/12/13 13:44:26 svittal noship $ */
3:
4: g_package constant varchar2(31) := 'hr_suit_match_utility_web.';
5: g_region_application_id constant integer
6: := hr_util_misc_web.g_region_application_id;
7:
8: c_title hr_util_misc_web.g_title%TYPE;
17: -- ---------------------------------------------------------------------------
18: FUNCTION get_option_header(p_mode in varchar2)
19: RETURN varchar2 IS
20: BEGIN
21: IF p_mode = hr_suit_match_utility_web.g_select_people_work_mode THEN
22: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_1');
23: ELSIF p_mode = hr_suit_match_utility_web.g_match_peope_role_mode THEN
24: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_2');
25: ELSIF p_mode = hr_suit_match_utility_web.g_match_successors_pos_mode THEN
19: RETURN varchar2 IS
20: BEGIN
21: IF p_mode = hr_suit_match_utility_web.g_select_people_work_mode THEN
22: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_1');
23: ELSIF p_mode = hr_suit_match_utility_web.g_match_peope_role_mode THEN
24: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_2');
25: ELSIF p_mode = hr_suit_match_utility_web.g_match_successors_pos_mode THEN
26: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_3');
27: ELSIF p_mode = hr_suit_match_utility_web.g_match_applicants_van_mode THEN
21: IF p_mode = hr_suit_match_utility_web.g_select_people_work_mode THEN
22: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_1');
23: ELSIF p_mode = hr_suit_match_utility_web.g_match_peope_role_mode THEN
24: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_2');
25: ELSIF p_mode = hr_suit_match_utility_web.g_match_successors_pos_mode THEN
26: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_3');
27: ELSIF p_mode = hr_suit_match_utility_web.g_match_applicants_van_mode THEN
28: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_4');
29: ELSIF p_mode = hr_suit_match_utility_web.g_work_vacancies_fast_path THEN
23: ELSIF p_mode = hr_suit_match_utility_web.g_match_peope_role_mode THEN
24: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_2');
25: ELSIF p_mode = hr_suit_match_utility_web.g_match_successors_pos_mode THEN
26: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_3');
27: ELSIF p_mode = hr_suit_match_utility_web.g_match_applicants_van_mode THEN
28: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_4');
29: ELSIF p_mode = hr_suit_match_utility_web.g_work_vacancies_fast_path THEN
30: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_5');
31: ELSIF p_mode = hr_suit_match_utility_web.g_work_successions_fast_path THEN
25: ELSIF p_mode = hr_suit_match_utility_web.g_match_successors_pos_mode THEN
26: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_3');
27: ELSIF p_mode = hr_suit_match_utility_web.g_match_applicants_van_mode THEN
28: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_4');
29: ELSIF p_mode = hr_suit_match_utility_web.g_work_vacancies_fast_path THEN
30: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_5');
31: ELSIF p_mode = hr_suit_match_utility_web.g_work_successions_fast_path THEN
32: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_6');
33: ELSIF p_mode = hr_suit_match_utility_web.g_work_deployments_fast_path THEN
27: ELSIF p_mode = hr_suit_match_utility_web.g_match_applicants_van_mode THEN
28: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_4');
29: ELSIF p_mode = hr_suit_match_utility_web.g_work_vacancies_fast_path THEN
30: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_5');
31: ELSIF p_mode = hr_suit_match_utility_web.g_work_successions_fast_path THEN
32: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_6');
33: ELSIF p_mode = hr_suit_match_utility_web.g_work_deployments_fast_path THEN
34: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_7');
35: ELSIF p_mode = hr_suit_match_utility_web.g_match_work_mode THEN
29: ELSIF p_mode = hr_suit_match_utility_web.g_work_vacancies_fast_path THEN
30: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_5');
31: ELSIF p_mode = hr_suit_match_utility_web.g_work_successions_fast_path THEN
32: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_6');
33: ELSIF p_mode = hr_suit_match_utility_web.g_work_deployments_fast_path THEN
34: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_7');
35: ELSIF p_mode = hr_suit_match_utility_web.g_match_work_mode THEN
36: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_8');
37: ELSE
31: ELSIF p_mode = hr_suit_match_utility_web.g_work_successions_fast_path THEN
32: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_6');
33: ELSIF p_mode = hr_suit_match_utility_web.g_work_deployments_fast_path THEN
34: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_7');
35: ELSIF p_mode = hr_suit_match_utility_web.g_match_work_mode THEN
36: fnd_message.set_name('PER', 'HR_WEB_SM_MENU_8');
37: ELSE
38: RETURN null;
39: END IF;
147: p_competence_table(i).competence_name := p_competence_name(i);
148: p_competence_table(i).low_rating_level_id := p_low_rating_level_id(i);
149: p_competence_table(i).high_rating_level_id := p_high_rating_level_id(i);
150: p_competence_table(i).low_step_value :=
151: hr_suit_match_utility_web.get_step_value
152: (p_rating_level_id => p_low_rating_level_id(i));
153: p_competence_table(i).high_step_value :=
154: hr_suit_match_utility_web.get_step_value
155: (p_rating_level_id => p_high_rating_level_id(i));
150: p_competence_table(i).low_step_value :=
151: hr_suit_match_utility_web.get_step_value
152: (p_rating_level_id => p_low_rating_level_id(i));
153: p_competence_table(i).high_step_value :=
154: hr_suit_match_utility_web.get_step_value
155: (p_rating_level_id => p_high_rating_level_id(i));
156: p_competence_table(i).mandatory := p_mandatory(i);
157: IF p_mandatory(i) = 'Y' THEN
158: p_essential_count := p_essential_count + 1;
195: l_name hr_util_misc_web.g_varchar2_tab_type;
196: l_count number default 0;
197:
198: BEGIN
199: l_dynamic_sql := hr_suit_match_utility_web.build_sql
200: (p_search_type => p_search_type
201: ,p_ids => p_search_id);
202: hr_suit_match_utility_web.get_id_name
203: (p_dynamic_sql => l_dynamic_sql
198: BEGIN
199: l_dynamic_sql := hr_suit_match_utility_web.build_sql
200: (p_search_type => p_search_type
201: ,p_ids => p_search_id);
202: hr_suit_match_utility_web.get_id_name
203: (p_dynamic_sql => l_dynamic_sql
204: ,p_id => l_id
205: ,p_name => l_name
206: ,p_count => l_count);
504: l_count number default 0;
505:
506: BEGIN
507:
508: l_dynamic_sql := hr_suit_match_utility_web.build_sql
509: (p_mode => p_mode
510: ,p_person_type_id => p_person_type_id
511: ,p_assignment_type => p_assignment_type
512: ,p_pre_search_type => p_pre_search_type
514: ,p_search_type => p_search_type
515: ,p_filer_match => p_filer_match
516: ,p_search_criteria => p_search_criteria);
517:
518: hr_suit_match_utility_web.get_id_name
519: (p_dynamic_sql => l_dynamic_sql
520: ,p_id => l_id
521: ,p_name => l_name
522: ,p_count => l_count);
891: BEGIN
892:
893: l_business_group := hr_util_misc_web.get_business_group_id;
894:
895: l_filter_clause := hr_suit_match_utility_web.process_filter
896: (p_filter_match => p_filer_match
897: ,p_search_criteria => p_search_criteria);
898:
899: keyflex_select_where_clause
1392: IF p_search_type IS null THEN
1393: return;
1394: END IF;
1395:
1396: l_dynamic_sql := hr_suit_match_utility_web.build_sql
1397: (p_search_type => p_search_type
1398: ,p_ids => p_id);
1399:
1400: IF p_search_type = g_organization_type THEN
1401: OPEN csr_org_info;
1402: FETCH csr_org_info INTO p_name, p_location_code;
1403: CLOSE csr_org_info;
1404: ELSIF p_search_type = g_position_type THEN
1405: hr_suit_match_utility_web.get_id_name
1406: (p_dynamic_sql => l_dynamic_sql
1407: ,p_id => l_id
1408: ,p_name => l_name
1409: ,p_count => l_count);
1413: FETCH csr_pos_info INTO p_org_name, p_location_code;
1414: CLOSE csr_pos_info;
1415: END IF;
1416: ELSIF p_search_type = g_job_type THEN
1417: hr_suit_match_utility_web.get_id_name
1418: (p_dynamic_sql => l_dynamic_sql
1419: ,p_id => l_id
1420: ,p_name => l_name
1421: ,p_count => l_count);
3508:
3509: END get_rating_scale_by_competence;
3510: ------------------------------------------------------------------------------
3511:
3512: END hr_suit_match_utility_web;