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