DBA Data[Home] [Help]

APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on HR_SUIT_MATCH_UTILITY_WEB

Line 1: PACKAGE BODY hr_suit_match_utility_web AS

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

Line 4: g_package constant varchar2(31) := 'hr_suit_match_utility_web.';

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;

Line 21: IF p_mode = hr_suit_match_utility_web.g_select_people_work_mode THEN

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

Line 23: ELSIF p_mode = hr_suit_match_utility_web.g_match_peope_role_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

Line 25: ELSIF p_mode = hr_suit_match_utility_web.g_match_successors_pos_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

Line 27: ELSIF p_mode = hr_suit_match_utility_web.g_match_applicants_van_mode 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

Line 29: ELSIF p_mode = hr_suit_match_utility_web.g_work_vacancies_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

Line 31: ELSIF p_mode = hr_suit_match_utility_web.g_work_successions_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

Line 33: ELSIF p_mode = hr_suit_match_utility_web.g_work_deployments_fast_path 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

Line 35: ELSIF p_mode = hr_suit_match_utility_web.g_match_work_mode THEN

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;

Line 151: hr_suit_match_utility_web.get_step_value

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));

Line 154: hr_suit_match_utility_web.get_step_value

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;

Line 199: l_dynamic_sql := hr_suit_match_utility_web.build_sql

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

Line 202: hr_suit_match_utility_web.get_id_name

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);

Line 508: l_dynamic_sql := hr_suit_match_utility_web.build_sql

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

Line 518: hr_suit_match_utility_web.get_id_name

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);

Line 895: l_filter_clause := hr_suit_match_utility_web.process_filter

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

Line 1396: l_dynamic_sql := hr_suit_match_utility_web.build_sql

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

Line 1405: hr_suit_match_utility_web.get_id_name

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);

Line 1417: hr_suit_match_utility_web.get_id_name

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);

Line 3512: END hr_suit_match_utility_web;

3508:
3509: END get_rating_scale_by_competence;
3510: ------------------------------------------------------------------------------
3511:
3512: END hr_suit_match_utility_web;