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_SUIT_MATCH_UTILITY_WEB dependencies on HR_UTIL_MISC_WEB

Line 6: := hr_util_misc_web.g_region_application_id;

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;
9: g_prompts hr_util_misc_web.g_prompts%TYPE;
10: c_person_id per_people_f.person_id%type;

Line 8: c_title hr_util_misc_web.g_title%TYPE;

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;
9: g_prompts hr_util_misc_web.g_prompts%TYPE;
10: c_person_id per_people_f.person_id%type;
11: c_language_code varchar2(5);
12: c_legislation_code varchar2(5);

Line 9: g_prompts hr_util_misc_web.g_prompts%TYPE;

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;
9: g_prompts hr_util_misc_web.g_prompts%TYPE;
10: c_person_id per_people_f.person_id%type;
11: c_language_code varchar2(5);
12: c_legislation_code varchar2(5);
13: g_person_rec per_people_f%ROWTYPE;

Line 86: (p_competence_id in hr_util_misc_web.g_varchar2_tab_type)

82: -- get_max_step_value
83: -- ---------------------------------------------------------------------------
84:
85: FUNCTION get_max_step_value
86: (p_competence_id in hr_util_misc_web.g_varchar2_tab_type)
87:
88: RETURN number IS
89:
90: l_dynamic_sql varchar2(32000);

Line 133: (p_competence_id in hr_util_misc_web.g_varchar2_tab_type

129: -- ---------------------------------------------------------------------------
130: -- encode_competence_table
131: -- ---------------------------------------------------------------------------
132: PROCEDURE encode_competence_table
133: (p_competence_id in hr_util_misc_web.g_varchar2_tab_type
134: ,p_competence_name in hr_util_misc_web.g_varchar2_tab_type
135: ,p_low_rating_level_id in hr_util_misc_web.g_varchar2_tab_type
136: ,p_high_rating_level_id in hr_util_misc_web.g_varchar2_tab_type
137: ,p_mandatory in hr_util_misc_web.g_varchar2_tab_type

Line 134: ,p_competence_name in hr_util_misc_web.g_varchar2_tab_type

130: -- encode_competence_table
131: -- ---------------------------------------------------------------------------
132: PROCEDURE encode_competence_table
133: (p_competence_id in hr_util_misc_web.g_varchar2_tab_type
134: ,p_competence_name in hr_util_misc_web.g_varchar2_tab_type
135: ,p_low_rating_level_id in hr_util_misc_web.g_varchar2_tab_type
136: ,p_high_rating_level_id in hr_util_misc_web.g_varchar2_tab_type
137: ,p_mandatory in hr_util_misc_web.g_varchar2_tab_type
138: ,p_competence_table out nocopy g_competence_table

Line 135: ,p_low_rating_level_id in hr_util_misc_web.g_varchar2_tab_type

131: -- ---------------------------------------------------------------------------
132: PROCEDURE encode_competence_table
133: (p_competence_id in hr_util_misc_web.g_varchar2_tab_type
134: ,p_competence_name in hr_util_misc_web.g_varchar2_tab_type
135: ,p_low_rating_level_id in hr_util_misc_web.g_varchar2_tab_type
136: ,p_high_rating_level_id in hr_util_misc_web.g_varchar2_tab_type
137: ,p_mandatory in hr_util_misc_web.g_varchar2_tab_type
138: ,p_competence_table out nocopy g_competence_table
139: ,p_essential_count out nocopy number

Line 136: ,p_high_rating_level_id in hr_util_misc_web.g_varchar2_tab_type

132: PROCEDURE encode_competence_table
133: (p_competence_id in hr_util_misc_web.g_varchar2_tab_type
134: ,p_competence_name in hr_util_misc_web.g_varchar2_tab_type
135: ,p_low_rating_level_id in hr_util_misc_web.g_varchar2_tab_type
136: ,p_high_rating_level_id in hr_util_misc_web.g_varchar2_tab_type
137: ,p_mandatory in hr_util_misc_web.g_varchar2_tab_type
138: ,p_competence_table out nocopy g_competence_table
139: ,p_essential_count out nocopy number
140: ,p_desirable_count out nocopy number) IS

Line 137: ,p_mandatory in hr_util_misc_web.g_varchar2_tab_type

133: (p_competence_id in hr_util_misc_web.g_varchar2_tab_type
134: ,p_competence_name in hr_util_misc_web.g_varchar2_tab_type
135: ,p_low_rating_level_id in hr_util_misc_web.g_varchar2_tab_type
136: ,p_high_rating_level_id in hr_util_misc_web.g_varchar2_tab_type
137: ,p_mandatory in hr_util_misc_web.g_varchar2_tab_type
138: ,p_competence_table out nocopy g_competence_table
139: ,p_essential_count out nocopy number
140: ,p_desirable_count out nocopy number) IS
141: BEGIN

Line 169: ,p_competence_id out nocopy hr_util_misc_web.g_varchar2_tab_type

165: -- decode_competence_table
166: -- ---------------------------------------------------------------------------
167: PROCEDURE decode_competence_table
168: (p_competence_table in g_competence_table
169: ,p_competence_id out nocopy hr_util_misc_web.g_varchar2_tab_type
170: ,p_competence_name out nocopy hr_util_misc_web.g_varchar2_tab_type
171: ,p_low_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
172: ,p_high_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
173: ,p_mandatory out nocopy hr_util_misc_web.g_varchar2_tab_type) IS

Line 170: ,p_competence_name out nocopy hr_util_misc_web.g_varchar2_tab_type

166: -- ---------------------------------------------------------------------------
167: PROCEDURE decode_competence_table
168: (p_competence_table in g_competence_table
169: ,p_competence_id out nocopy hr_util_misc_web.g_varchar2_tab_type
170: ,p_competence_name out nocopy hr_util_misc_web.g_varchar2_tab_type
171: ,p_low_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
172: ,p_high_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
173: ,p_mandatory out nocopy hr_util_misc_web.g_varchar2_tab_type) IS
174: BEGIN

Line 171: ,p_low_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type

167: PROCEDURE decode_competence_table
168: (p_competence_table in g_competence_table
169: ,p_competence_id out nocopy hr_util_misc_web.g_varchar2_tab_type
170: ,p_competence_name out nocopy hr_util_misc_web.g_varchar2_tab_type
171: ,p_low_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
172: ,p_high_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
173: ,p_mandatory out nocopy hr_util_misc_web.g_varchar2_tab_type) IS
174: BEGIN
175: FOR i IN 1..NVL(p_competence_table.count,0) LOOP

Line 172: ,p_high_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type

168: (p_competence_table in g_competence_table
169: ,p_competence_id out nocopy hr_util_misc_web.g_varchar2_tab_type
170: ,p_competence_name out nocopy hr_util_misc_web.g_varchar2_tab_type
171: ,p_low_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
172: ,p_high_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
173: ,p_mandatory out nocopy hr_util_misc_web.g_varchar2_tab_type) IS
174: BEGIN
175: FOR i IN 1..NVL(p_competence_table.count,0) LOOP
176: p_competence_id(i) := p_competence_table(i).competence_id;

Line 173: ,p_mandatory out nocopy hr_util_misc_web.g_varchar2_tab_type) IS

169: ,p_competence_id out nocopy hr_util_misc_web.g_varchar2_tab_type
170: ,p_competence_name out nocopy hr_util_misc_web.g_varchar2_tab_type
171: ,p_low_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
172: ,p_high_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
173: ,p_mandatory out nocopy hr_util_misc_web.g_varchar2_tab_type) IS
174: BEGIN
175: FOR i IN 1..NVL(p_competence_table.count,0) LOOP
176: p_competence_id(i) := p_competence_table(i).competence_id;
177: p_competence_name(i) := p_competence_table(i).competence_name;

Line 194: l_id hr_util_misc_web.g_varchar2_tab_type;

190: ,p_search_id in varchar2)
191: RETURN varchar2 IS
192:
193: l_dynamic_sql varchar2(32000);
194: l_id hr_util_misc_web.g_varchar2_tab_type;
195: l_name hr_util_misc_web.g_varchar2_tab_type;
196: l_count number default 0;
197:
198: BEGIN

Line 195: l_name hr_util_misc_web.g_varchar2_tab_type;

191: RETURN varchar2 IS
192:
193: l_dynamic_sql varchar2(32000);
194: l_id hr_util_misc_web.g_varchar2_tab_type;
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

Line 222: l_id hr_util_misc_web.g_varchar2_tab_type;

218: PROCEDURE get_person_info
219: (p_id in number
220: ,p_person_table out nocopy g_person_table) IS
221:
222: l_id hr_util_misc_web.g_varchar2_tab_type;
223: l_count number;
224:
225: BEGIN
226:

Line 239: (p_id in hr_util_misc_web.g_varchar2_tab_type

235: -- get_people_info
236: -- ---------------------------------------------------------------------------
237:
238: PROCEDURE get_people_info
239: (p_id in hr_util_misc_web.g_varchar2_tab_type
240: ,p_person_table out nocopy g_person_table
241: ,p_count out nocopy number) IS
242:
243: l_dynamic_sql varchar2(32000);

Line 259: hr_util_misc_web.validate_session(p_person_id => c_person_id);

255: l_ids varchar2(32000);
256:
257: BEGIN
258:
259: hr_util_misc_web.validate_session(p_person_id => c_person_id);
260: c_legislation_code := hr_misc_web.get_legislation_code
261: (p_person_id => c_person_id);
262:
263:

Line 368: l_mapped_col_names hr_util_misc_web.g_varchar2_tab_type;

364: ,p_filter_clause in varchar2 default null
365: ,p_select_clause out nocopy varchar2
366: ,p_where_clause out nocopy varchar2) IS
367:
368: l_mapped_col_names hr_util_misc_web.g_varchar2_tab_type;
369: l_segment_separator varchar2(10);
370: l_count number;
371: l_table_short_name varchar2(10);
372:

Line 444: ,p_mapped_col_names out nocopy hr_util_misc_web.g_varchar2_tab_type

440: -- ---------------------------------------------------------------------------
441: PROCEDURE get_keyflex_mapped_column_name
442: (p_business_group_id in number
443: ,p_keyflex_code in varchar2
444: ,p_mapped_col_names out nocopy hr_util_misc_web.g_varchar2_tab_type
445: ,p_segment_separator out nocopy varchar2
446: ,p_count out nocopy number) IS
447:
448: l_mapped_col_name1 varchar2(60);

Line 502: l_id hr_util_misc_web.g_varchar2_tab_type;

498: ,p_search_criteria in varchar2)
499: RETURN number IS
500:
501: l_dynamic_sql varchar2(32000);
502: l_id hr_util_misc_web.g_varchar2_tab_type;
503: l_name hr_util_misc_web.g_varchar2_tab_type;
504: l_count number default 0;
505:
506: BEGIN

Line 503: l_name hr_util_misc_web.g_varchar2_tab_type;

499: RETURN number IS
500:
501: l_dynamic_sql varchar2(32000);
502: l_id hr_util_misc_web.g_varchar2_tab_type;
503: l_name hr_util_misc_web.g_varchar2_tab_type;
504: l_count number default 0;
505:
506: BEGIN
507:

Line 633: (p_id in hr_util_misc_web.g_varchar2_tab_type

629: -- build_items
630: -- ---------------------------------------------------------------------------
631:
632: FUNCTION build_items
633: (p_id in hr_util_misc_web.g_varchar2_tab_type
634: ,p_start_index in number default 1)
635: RETURN varchar2 IS
636: l_ids varchar2(32000);
637: l_index number;

Line 683: l_business_group := hr_util_misc_web.get_business_group_id;

679: l_business_group varchar2(2000);
680:
681: BEGIN
682:
683: l_business_group := hr_util_misc_web.get_business_group_id;
684:
685: keyflex_select_where_clause
686: (p_business_group_id => l_business_group
687: ,p_keyflex_code => 'GRD'

Line 730: hr_util_misc_web.validate_session(p_person_id => c_person_id);

726: l_business_group varchar2(2000);
727:
728: BEGIN
729:
730: hr_util_misc_web.validate_session(p_person_id => c_person_id);
731: c_legislation_code := hr_misc_web.get_legislation_code
732: (p_person_id => c_person_id);
733:
734: l_business_group := hr_util_misc_web.get_business_group_id;

Line 734: l_business_group := hr_util_misc_web.get_business_group_id;

730: hr_util_misc_web.validate_session(p_person_id => c_person_id);
731: c_legislation_code := hr_misc_web.get_legislation_code
732: (p_person_id => c_person_id);
733:
734: l_business_group := hr_util_misc_web.get_business_group_id;
735:
736: IF p_search_type = g_location_type THEN --location
737: l_dynamic_sql := 'SELECT location_id, location_code'
738: ||' FROM hr_locations_all'

Line 893: l_business_group := hr_util_misc_web.get_business_group_id;

889:
890:
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);

Line 1310: ,p_id out nocopy hr_util_misc_web.g_varchar2_tab_type

1306: -- ---------------------------------------------------------------------------
1307:
1308: PROCEDURE get_id_name
1309: (p_dynamic_sql in varchar2
1310: ,p_id out nocopy hr_util_misc_web.g_varchar2_tab_type
1311: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
1312: ,p_count out nocopy number) IS
1313:
1314: l_sql_cursor integer;

Line 1311: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

1307:
1308: PROCEDURE get_id_name
1309: (p_dynamic_sql in varchar2
1310: ,p_id out nocopy hr_util_misc_web.g_varchar2_tab_type
1311: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
1312: ,p_count out nocopy number) IS
1313:
1314: l_sql_cursor integer;
1315: l_rows integer;

Line 1386: l_id hr_util_misc_web.g_varchar2_tab_type;

1382: AND pv.organization_id = hou.organization_id(+)
1383: AND hou.location_id = hl.location_id(+);
1384:
1385: l_dynamic_sql varchar2(32000);
1386: l_id hr_util_misc_web.g_varchar2_tab_type;
1387: l_name hr_util_misc_web.g_varchar2_tab_type;
1388: l_count number;
1389:
1390: BEGIN

Line 1387: l_name hr_util_misc_web.g_varchar2_tab_type;

1383: AND hou.location_id = hl.location_id(+);
1384:
1385: l_dynamic_sql varchar2(32000);
1386: l_id hr_util_misc_web.g_varchar2_tab_type;
1387: l_name hr_util_misc_web.g_varchar2_tab_type;
1388: l_count number;
1389:
1390: BEGIN
1391:

Line 1585: l_business_group_id := hr_util_misc_web.get_business_group_id;

1581:
1582: BEGIN
1583:
1584: IF p_business_group_id IS null THEN
1585: l_business_group_id := hr_util_misc_web.get_business_group_id;
1586: ELSE
1587: l_business_group_id := p_business_group_id;
1588: END IF;
1589:

Line 2596: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type

2592:
2593: PROCEDURE get_people_by_vacancy
2594: (p_vacancy_id in number
2595: ,p_effective_date in date
2596: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2597: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2598: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
2599: ,p_count out nocopy number) IS
2600:

Line 2597: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type

2593: PROCEDURE get_people_by_vacancy
2594: (p_vacancy_id in number
2595: ,p_effective_date in date
2596: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2597: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2598: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
2599: ,p_count out nocopy number) IS
2600:
2601: CURSOR csr_people_by_vacancy IS

Line 2598: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type

2594: (p_vacancy_id in number
2595: ,p_effective_date in date
2596: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2597: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2598: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
2599: ,p_count out nocopy number) IS
2600:
2601: CURSOR csr_people_by_vacancy IS
2602: SELECT distinct(paf.person_id) person_id

Line 2637: hr_util_misc_web.validate_session(p_person_id => c_person_id);

2633: ORDER BY ppf.last_name, ppf.first_name;
2634:
2635: BEGIN
2636:
2637: hr_util_misc_web.validate_session(p_person_id => c_person_id);
2638: c_legislation_code := hr_misc_web.get_legislation_code
2639: (p_person_id => c_person_id);
2640:
2641: p_count := 0;

Line 2667: ,p_vacancy_id out nocopy hr_util_misc_web.g_varchar2_tab_type

2663:
2664: PROCEDURE get_vacancies_by_person
2665: (p_person_id in number
2666: ,p_effective_date in date
2667: ,p_vacancy_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2668: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2669: ,p_count out nocopy number) IS
2670:
2671: CURSOR csr_vacanies_by_person IS

Line 2668: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

2664: PROCEDURE get_vacancies_by_person
2665: (p_person_id in number
2666: ,p_effective_date in date
2667: ,p_vacancy_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2668: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2669: ,p_count out nocopy number) IS
2670:
2671: CURSOR csr_vacanies_by_person IS
2672: SELECT pasf.vacancy_id

Line 2705: ,p_position_id out nocopy hr_util_misc_web.g_varchar2_tab_type

2701:
2702: PROCEDURE get_succession_by_person
2703: (p_person_id in number
2704: ,p_effective_date in date default sysdate
2705: ,p_position_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2706: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2707: ,p_count out nocopy number) IS
2708:
2709: CURSOR csr_succession_by_person IS

Line 2706: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

2702: PROCEDURE get_succession_by_person
2703: (p_person_id in number
2704: ,p_effective_date in date default sysdate
2705: ,p_position_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2706: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2707: ,p_count out nocopy number) IS
2708:
2709: CURSOR csr_succession_by_person IS
2710: SELECT * FROM (

Line 2753: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type

2749:
2750: PROCEDURE get_deployment_by_person
2751: (p_person_id in number
2752: ,p_effective_date in date
2753: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2754: ,p_position_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2755: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2756: ,p_grade_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2757: ,p_count out nocopy number) IS

Line 2754: ,p_position_id out nocopy hr_util_misc_web.g_varchar2_tab_type

2750: PROCEDURE get_deployment_by_person
2751: (p_person_id in number
2752: ,p_effective_date in date
2753: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2754: ,p_position_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2755: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2756: ,p_grade_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2757: ,p_count out nocopy number) IS
2758:

Line 2755: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

2751: (p_person_id in number
2752: ,p_effective_date in date
2753: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2754: ,p_position_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2755: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2756: ,p_grade_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2757: ,p_count out nocopy number) IS
2758:
2759: CURSOR csr_deployment_by_person IS

Line 2756: ,p_grade_id out nocopy hr_util_misc_web.g_varchar2_tab_type

2752: ,p_effective_date in date
2753: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2754: ,p_position_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2755: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2756: ,p_grade_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2757: ,p_count out nocopy number) IS
2758:
2759: CURSOR csr_deployment_by_person IS
2760: SELECT pasf.assignment_id, pasf.position_id, pasf.grade_id, pp.name

Line 2797: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type

2793:
2794: PROCEDURE get_job_deployment_by_person
2795: (p_person_id in number
2796: ,p_effective_date in date
2797: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2798: ,p_job_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2799: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2800: ,p_grade_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2801: ,p_count out nocopy number) IS

Line 2798: ,p_job_id out nocopy hr_util_misc_web.g_varchar2_tab_type

2794: PROCEDURE get_job_deployment_by_person
2795: (p_person_id in number
2796: ,p_effective_date in date
2797: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2798: ,p_job_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2799: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2800: ,p_grade_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2801: ,p_count out nocopy number) IS
2802:

Line 2799: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

2795: (p_person_id in number
2796: ,p_effective_date in date
2797: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2798: ,p_job_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2799: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2800: ,p_grade_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2801: ,p_count out nocopy number) IS
2802:
2803: CURSOR csr_deployment_by_person IS

Line 2800: ,p_grade_id out nocopy hr_util_misc_web.g_varchar2_tab_type

2796: ,p_effective_date in date
2797: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2798: ,p_job_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2799: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2800: ,p_grade_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2801: ,p_count out nocopy number) IS
2802:
2803: CURSOR csr_deployment_by_person IS
2804: SELECT pasf.assignment_id, pasf.job_id, pasf.grade_id, pj.name

Line 2840: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type

2836:
2837: PROCEDURE get_org_deployment_by_person
2838: (p_person_id in number
2839: ,p_effective_date in date default sysdate
2840: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2841: ,p_org_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2842: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2843: ,p_count out nocopy number) IS
2844:

Line 2841: ,p_org_id out nocopy hr_util_misc_web.g_varchar2_tab_type

2837: PROCEDURE get_org_deployment_by_person
2838: (p_person_id in number
2839: ,p_effective_date in date default sysdate
2840: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2841: ,p_org_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2842: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2843: ,p_count out nocopy number) IS
2844:
2845: CURSOR csr_deployment_by_person IS

Line 2842: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

2838: (p_person_id in number
2839: ,p_effective_date in date default sysdate
2840: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2841: ,p_org_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2842: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2843: ,p_count out nocopy number) IS
2844:
2845: CURSOR csr_deployment_by_person IS
2846: SELECT pasf.assignment_id, pasf.organization_id, hou.name

Line 2881: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type

2877:
2878: PROCEDURE get_vac_deployment_by_person
2879: (p_person_id in number
2880: ,p_effective_date in date default sysdate
2881: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2882: ,p_vac_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2883: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2884: ,p_count out nocopy number) IS
2885:

Line 2882: ,p_vac_id out nocopy hr_util_misc_web.g_varchar2_tab_type

2878: PROCEDURE get_vac_deployment_by_person
2879: (p_person_id in number
2880: ,p_effective_date in date default sysdate
2881: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2882: ,p_vac_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2883: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2884: ,p_count out nocopy number) IS
2885:
2886: CURSOR csr_deployment_by_person IS

Line 2883: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

2879: (p_person_id in number
2880: ,p_effective_date in date default sysdate
2881: ,p_assignment_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2882: ,p_vac_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2883: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2884: ,p_count out nocopy number) IS
2885:
2886: CURSOR csr_deployment_by_person IS
2887: SELECT pasf.assignment_id

Line 2922: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type

2918:
2919: PROCEDURE get_succesors_by_position
2920: (p_pos_id in number
2921: ,p_effective_date in date default sysdate
2922: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2923: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2924: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
2925: ,p_count out nocopy number) IS
2926:

Line 2923: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type

2919: PROCEDURE get_succesors_by_position
2920: (p_pos_id in number
2921: ,p_effective_date in date default sysdate
2922: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2923: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2924: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
2925: ,p_count out nocopy number) IS
2926:
2927: -- Bug# 2447224.

Line 2924: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type

2920: (p_pos_id in number
2921: ,p_effective_date in date default sysdate
2922: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
2923: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
2924: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
2925: ,p_count out nocopy number) IS
2926:
2927: -- Bug# 2447224.
2928:

Line 3003: hr_util_misc_web.validate_session(p_person_id => c_person_id);

2999: ORDER BY last_name, first_name;
3000:
3001: BEGIN
3002:
3003: hr_util_misc_web.validate_session(p_person_id => c_person_id);
3004: c_legislation_code := hr_misc_web.get_legislation_code
3005: (p_person_id => c_person_id);
3006:
3007: p_count := 0;

Line 3036: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type

3032: ,p_pre_search_id in varchar2
3033: ,p_search_type in varchar2
3034: ,p_search_id in varchar2
3035: ,p_grade_id in number default null
3036: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3037: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3038: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
3039: ,p_count out nocopy number) IS
3040:

Line 3037: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type

3033: ,p_search_type in varchar2
3034: ,p_search_id in varchar2
3035: ,p_grade_id in number default null
3036: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3037: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3038: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
3039: ,p_count out nocopy number) IS
3040:
3041: l_dynamic_sql varchar2(32000);

Line 3038: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type

3034: ,p_search_id in varchar2
3035: ,p_grade_id in number default null
3036: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3037: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3038: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
3039: ,p_count out nocopy number) IS
3040:
3041: l_dynamic_sql varchar2(32000);
3042: l_business_group varchar2(2000);

Line 3054: hr_util_misc_web.validate_session(p_person_id => c_person_id);

3050: c_type varchar2(80);
3051:
3052: BEGIN
3053:
3054: hr_util_misc_web.validate_session(p_person_id => c_person_id);
3055: c_legislation_code := hr_misc_web.get_legislation_code
3056: (p_person_id => c_person_id);
3057:
3058: l_business_group := hr_util_misc_web.get_business_group_id;

Line 3058: l_business_group := hr_util_misc_web.get_business_group_id;

3054: hr_util_misc_web.validate_session(p_person_id => c_person_id);
3055: c_legislation_code := hr_misc_web.get_legislation_code
3056: (p_person_id => c_person_id);
3057:
3058: l_business_group := hr_util_misc_web.get_business_group_id;
3059:
3060: -- Bug# 2447224.
3061:
3062: l_dynamic_sql :=

Line 3185: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type

3181:
3182: PROCEDURE get_people_by_role_org
3183: (p_org_id in number
3184: ,p_effective_date in date
3185: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3186: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3187: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
3188: ,p_count out nocopy number) IS
3189:

Line 3186: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type

3182: PROCEDURE get_people_by_role_org
3183: (p_org_id in number
3184: ,p_effective_date in date
3185: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3186: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3187: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
3188: ,p_count out nocopy number) IS
3189:
3190: CURSOR csr_people_by_role_org IS

Line 3187: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type

3183: (p_org_id in number
3184: ,p_effective_date in date
3185: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3186: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3187: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
3188: ,p_count out nocopy number) IS
3189:
3190: CURSOR csr_people_by_role_org IS
3191: SELECT distinct(paf.person_id) person_id

Line 3227: hr_util_misc_web.validate_session(p_person_id => c_person_id);

3223: ORDER BY ppf.last_name, ppf.first_name;
3224:
3225: BEGIN
3226:
3227: hr_util_misc_web.validate_session(p_person_id => c_person_id);
3228: c_legislation_code := hr_misc_web.get_legislation_code
3229: (p_person_id => c_person_id);
3230:
3231: p_count := 0;

Line 3258: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type

3254: PROCEDURE get_people_by_role_job
3255: (p_job_id in number
3256: ,p_grade_id in number
3257: ,p_effective_date in date
3258: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3259: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3260: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
3261: ,p_count out nocopy number) IS
3262:

Line 3259: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type

3255: (p_job_id in number
3256: ,p_grade_id in number
3257: ,p_effective_date in date
3258: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3259: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3260: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
3261: ,p_count out nocopy number) IS
3262:
3263: CURSOR csr_people_by_role_job IS

Line 3260: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type

3256: ,p_grade_id in number
3257: ,p_effective_date in date
3258: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3259: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3260: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
3261: ,p_count out nocopy number) IS
3262:
3263: CURSOR csr_people_by_role_job IS
3264: SELECT distinct(paf.person_id) person_id

Line 3302: hr_util_misc_web.validate_session(p_person_id => c_person_id);

3298: ORDER BY ppf.last_name, ppf.first_name;
3299:
3300: BEGIN
3301:
3302: hr_util_misc_web.validate_session(p_person_id => c_person_id);
3303: c_legislation_code := hr_misc_web.get_legislation_code
3304: (p_person_id => c_person_id);
3305:
3306: p_count := 0;

Line 3333: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type

3329: PROCEDURE get_people_by_role_pos
3330: (p_pos_id in number
3331: ,p_grade_id in number
3332: ,p_effective_date in date
3333: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3334: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3335: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
3336: ,p_count out nocopy number) IS
3337:

Line 3334: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type

3330: (p_pos_id in number
3331: ,p_grade_id in number
3332: ,p_effective_date in date
3333: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3334: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3335: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
3336: ,p_count out nocopy number) IS
3337:
3338: CURSOR csr_people_by_role_pos IS

Line 3335: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type

3331: ,p_grade_id in number
3332: ,p_effective_date in date
3333: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3334: ,p_person_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3335: ,p_person_type out nocopy hr_util_misc_web.g_varchar2_tab_type
3336: ,p_count out nocopy number) IS
3337:
3338: CURSOR csr_people_by_role_pos IS
3339: SELECT distinct(paf.person_id) person_id

Line 3377: hr_util_misc_web.validate_session(p_person_id => c_person_id);

3373: ORDER BY ppf.last_name, ppf.first_name;
3374:
3375: BEGIN
3376:
3377: hr_util_misc_web.validate_session(p_person_id => c_person_id);
3378: c_legislation_code := hr_misc_web.get_legislation_code
3379: (p_person_id => c_person_id);
3380:
3381: p_count := 0;

Line 3406: ,p_activity_version_id out nocopy hr_util_misc_web.g_varchar2_tab_type

3402: -- ---------------------------------------------------------------------------
3403:
3404: PROCEDURE get_course_by_person
3405: (p_person_id in number
3406: ,p_activity_version_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3407: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3408: ,p_count out nocopy number) IS
3409:
3410: CURSOR csr_course_by_person IS

Line 3407: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

3403:
3404: PROCEDURE get_course_by_person
3405: (p_person_id in number
3406: ,p_activity_version_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3407: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3408: ,p_count out nocopy number) IS
3409:
3410: CURSOR csr_course_by_person IS
3411: SELECT distinct(oe.activity_version_id) activity_version_id

Line 3437: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type

3433: -- ---------------------------------------------------------------------------
3434:
3435: PROCEDURE get_people_by_course
3436: (p_activity_version_id in number
3437: ,p_person_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3438: ,p_count out nocopy number) IS
3439:
3440: CURSOR csr_people_by_course IS
3441: SELECT odb.delegate_person_id person_id

Line 3464: ,p_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type

3460: -- ---------------------------------------------------------------------------
3461:
3462: PROCEDURE get_rating_scale_by_competence
3463: (p_competence_id in number
3464: ,p_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3465: ,p_step_value out nocopy hr_util_misc_web.g_varchar2_tab_type
3466: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3467: ,p_count out nocopy number) IS
3468:

Line 3465: ,p_step_value out nocopy hr_util_misc_web.g_varchar2_tab_type

3461:
3462: PROCEDURE get_rating_scale_by_competence
3463: (p_competence_id in number
3464: ,p_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3465: ,p_step_value out nocopy hr_util_misc_web.g_varchar2_tab_type
3466: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3467: ,p_count out nocopy number) IS
3468:
3469: CURSOR csr_rating_level_by_scale IS

Line 3466: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type

3462: PROCEDURE get_rating_scale_by_competence
3463: (p_competence_id in number
3464: ,p_rating_level_id out nocopy hr_util_misc_web.g_varchar2_tab_type
3465: ,p_step_value out nocopy hr_util_misc_web.g_varchar2_tab_type
3466: ,p_name out nocopy hr_util_misc_web.g_varchar2_tab_type
3467: ,p_count out nocopy number) IS
3468:
3469: CURSOR csr_rating_level_by_scale IS
3470: SELECT prl.rating_level_id, prl.step_value, rtx.name