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.GHR_MASS_AWARDS_ELIG dependencies on HR_API

Line 31: l_sit ghr_api.special_information_type;

27: l_pos_id number;
28: l_job_id number;
29: l_loc_id number;
30: l_grd_id number;
31: l_sit ghr_api.special_information_type;
32: l_asg_select long;
33: l_numrows number;
34: l_numrows_kff number;
35: l_numrows_pos_grp1 number;

Line 297: (nvl(l_curr_name,hr_api.g_varchar2) <> nvl(l_old_name,hr_api.g_varchar2))

293: -- l_pos_kff_exists := true;
294:
295:
296: If
297: (nvl(l_curr_name,hr_api.g_varchar2) <> nvl(l_old_name,hr_api.g_varchar2))
298: or
299: l_operator = ' <> ' or l_old_operator is null or l_old_operator = ' <> ' then
300: l_old_name := l_curr_name;
301: If l_curr_name = 'Position Title' then

Line 303: l_col_name := 'ghr_api.get_position_title_pos';

299: l_operator = ' <> ' or l_old_operator is null or l_old_operator = ' <> ' then
300: l_old_name := l_curr_name;
301: If l_curr_name = 'Position Title' then
302: l_pos_exists := true;
303: l_col_name := 'ghr_api.get_position_title_pos';
304:
305: Elsif l_curr_name = 'Agency/Subelement Code' then
306: l_pos_exists := true;
307: l_col_name := 'ghr_api.get_position_agency_code_pos';

Line 307: l_col_name := 'ghr_api.get_position_agency_code_pos';

303: l_col_name := 'ghr_api.get_position_title_pos';
304:
305: Elsif l_curr_name = 'Agency/Subelement Code' then
306: l_pos_exists := true;
307: l_col_name := 'ghr_api.get_position_agency_code_pos';
308:
309: /*Elsif l_curr_name = 'Agency Code' then
310: l_pos_exists := true;
311: l_col_name := 'substr(ghr_api.get_position_agency_code_pos,1,2)';

Line 311: l_col_name := 'substr(ghr_api.get_position_agency_code_pos,1,2)';

307: l_col_name := 'ghr_api.get_position_agency_code_pos';
308:
309: /*Elsif l_curr_name = 'Agency Code' then
310: l_pos_exists := true;
311: l_col_name := 'substr(ghr_api.get_position_agency_code_pos,1,2)';
312: */
313: Elsif l_curr_name = 'Occupational Series' then
314: l_job_exists := true;
315: l_col_name := 'ghr_api.get_job_occ_series_job';

Line 315: l_col_name := 'ghr_api.get_job_occ_series_job';

311: l_col_name := 'substr(ghr_api.get_position_agency_code_pos,1,2)';
312: */
313: Elsif l_curr_name = 'Occupational Series' then
314: l_job_exists := true;
315: l_col_name := 'ghr_api.get_job_occ_series_job';
316: End if;
317: If l_table_name = 'POSITION_KFF' then
318: l_pos_exists := true;
319: If l_curr_name = 'Agency Code' then

Line 322: || 'substr(ghr_api.get_position_agency_code_pos('

318: l_pos_exists := true;
319: If l_curr_name = 'Agency Code' then
320: l_pos_exists := true;
321: l_select := l_select || ' ) ' || ' and ( '
322: || 'substr(ghr_api.get_position_agency_code_pos('
323: || ':pos_id'
324: || ',' || ':business_group_id'
325: || ',' || ':effective_date'
326: || '),1,2 )'

Line 349: || 'substr(ghr_api.get_position_agency_code_pos('

345: l_pos_exists := true;
346: If l_curr_name = 'Agency Code' then
347: l_pos_exists := true;
348: l_select := l_select || ' or '
349: || 'substr(ghr_api.get_position_agency_code_pos('
350: || ':pos_id'
351: || ', ' || ':business_group_id'
352: || ', '
353: || ' :effective_date' ||'),1,2 )'

Line 429: (nvl(l_curr_name,hr_api.g_varchar2) <> nvl(l_old_name,hr_api.g_varchar2))

425: );
426:
427: l_curr_name := pos_grp2_rec.column_name;
428: If
429: (nvl(l_curr_name,hr_api.g_varchar2) <> nvl(l_old_name,hr_api.g_varchar2))
430: or l_old_operator is null or l_operator = ' <> ' or l_old_operator = ' <> ' then
431: l_old_name := l_curr_name;
432: If l_curr_name = 'Position Occupied' then
433: p_poc_exists := TRUE;

Line 503: (nvl(l_curr_name,hr_api.g_varchar2) <> nvl(l_old_name,hr_api.g_varchar2))

499: p_suffix => l_suf
500: );
501: l_curr_name := pos_grp1_rec.column_name;
502: If
503: (nvl(l_curr_name,hr_api.g_varchar2) <> nvl(l_old_name,hr_api.g_varchar2))
504: or nvl(l_old_operator,' <> ' ) = ' <> ' or l_operator = ' <> ' then
505: l_old_name := l_curr_name;
506: If l_curr_name = 'Personnel Office ID' then
507: p_poi_exists := TRUE;

Line 598: (nvl(l_curr_name,hr_api.g_varchar2) <> nvl(l_old_name,hr_api.g_varchar2))

594:
595: l_curr_name := pos_grp1_rec.column_name;
596: l_old_operator := Null;
597: If
598: (nvl(l_curr_name,hr_api.g_varchar2) <> nvl(l_old_name,hr_api.g_varchar2))
599: or
600: l_operator = ' <> ' and nvl(l_old_operator,hr_api.g_varchar2) = ' <> ' then
601:
602: l_old_name := l_curr_name;

Line 600: l_operator = ' <> ' and nvl(l_old_operator,hr_api.g_varchar2) = ' <> ' then

596: l_old_operator := Null;
597: If
598: (nvl(l_curr_name,hr_api.g_varchar2) <> nvl(l_old_name,hr_api.g_varchar2))
599: or
600: l_operator = ' <> ' and nvl(l_old_operator,hr_api.g_varchar2) = ' <> ' then
601:
602: l_old_name := l_curr_name;
603: If l_curr_name = 'Pay Plan' then
604: p_pay_plan_exists := TRUE;

Line 947: DBMS_SQL.bind_variable(l_cursor_pos_grd_id,'PP',hr_api.g_varchar2);

943: p_date_effective => l_effective_date,
944: p_pos_ei_data => l_pos_ei_data
945: );
946: If l_pay_plan_exists then
947: DBMS_SQL.bind_variable(l_cursor_pos_grd_id,'PP',hr_api.g_varchar2);
948: End if;
949: If l_grade_exists then
950: DBMS_SQL.bind_variable(l_cursor_pos_grd_id,'GRD',hr_api.g_varchar2);
951: End if;

Line 950: DBMS_SQL.bind_variable(l_cursor_pos_grd_id,'GRD',hr_api.g_varchar2);

946: If l_pay_plan_exists then
947: DBMS_SQL.bind_variable(l_cursor_pos_grd_id,'PP',hr_api.g_varchar2);
948: End if;
949: If l_grade_exists then
950: DBMS_SQL.bind_variable(l_cursor_pos_grd_id,'GRD',hr_api.g_varchar2);
951: End if;
952:
953: If l_pos_ei_data.poei_information3 is not null then
954: For grade_kff_rec in c_grade_kff(to_number(l_pos_ei_data.poei_information3)) loop

Line 994: ghr_api.return_special_information

990: l_cursor_rating_id := DBMS_SQL.OPEN_CURSOR;
991: DBMS_SQL.PARSE(l_cursor_rating_id,l_rating_select,DBMS_SQL.NATIVE);
992: If l_rating_exists then
993: --get rating record
994: ghr_api.return_special_information
995: (p_person_id => l_per_id,
996: p_structure_name => 'US Fed Perf Appraisal',
997: p_effective_date => l_effective_date,
998: p_special_info => l_sit