APPS.GHR_API dependencies on PER_POSITION_EXTRA_INFO

Line 363: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

359: ,exception_retire_pay_ind per_people_extra_info.pei_information11%type);
360: --
361: type pos_valid_grade_type is record
362: (pos_valid_grade_flag varchar2(1)
363: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
364: ,object_version_number per_position_extra_info.object_version_number%type
365: ,valid_grade per_position_extra_info.poei_information3%type
366: ,target_grade per_position_extra_info.poei_information4%type
367: ,pay_table_id per_position_extra_info.poei_information5%type

Line 364: ,object_version_number per_position_extra_info.object_version_number%type

360: --
361: type pos_valid_grade_type is record
362: (pos_valid_grade_flag varchar2(1)
363: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
364: ,object_version_number per_position_extra_info.object_version_number%type
365: ,valid_grade per_position_extra_info.poei_information3%type
366: ,target_grade per_position_extra_info.poei_information4%type
367: ,pay_table_id per_position_extra_info.poei_information5%type
368: ,pay_basis per_position_extra_info.poei_information6%type

Line 365: ,valid_grade per_position_extra_info.poei_information3%type

361: type pos_valid_grade_type is record
362: (pos_valid_grade_flag varchar2(1)
363: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
364: ,object_version_number per_position_extra_info.object_version_number%type
365: ,valid_grade per_position_extra_info.poei_information3%type
366: ,target_grade per_position_extra_info.poei_information4%type
367: ,pay_table_id per_position_extra_info.poei_information5%type
368: ,pay_basis per_position_extra_info.poei_information6%type
369: ,employment_category_group per_position_extra_info.poei_information7%type);

Line 366: ,target_grade per_position_extra_info.poei_information4%type

362: (pos_valid_grade_flag varchar2(1)
363: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
364: ,object_version_number per_position_extra_info.object_version_number%type
365: ,valid_grade per_position_extra_info.poei_information3%type
366: ,target_grade per_position_extra_info.poei_information4%type
367: ,pay_table_id per_position_extra_info.poei_information5%type
368: ,pay_basis per_position_extra_info.poei_information6%type
369: ,employment_category_group per_position_extra_info.poei_information7%type);
370: --

Line 367: ,pay_table_id per_position_extra_info.poei_information5%type

363: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
364: ,object_version_number per_position_extra_info.object_version_number%type
365: ,valid_grade per_position_extra_info.poei_information3%type
366: ,target_grade per_position_extra_info.poei_information4%type
367: ,pay_table_id per_position_extra_info.poei_information5%type
368: ,pay_basis per_position_extra_info.poei_information6%type
369: ,employment_category_group per_position_extra_info.poei_information7%type);
370: --
371: type pos_grp1_type is record

Line 368: ,pay_basis per_position_extra_info.poei_information6%type

364: ,object_version_number per_position_extra_info.object_version_number%type
365: ,valid_grade per_position_extra_info.poei_information3%type
366: ,target_grade per_position_extra_info.poei_information4%type
367: ,pay_table_id per_position_extra_info.poei_information5%type
368: ,pay_basis per_position_extra_info.poei_information6%type
369: ,employment_category_group per_position_extra_info.poei_information7%type);
370: --
371: type pos_grp1_type is record
372: (pos_grp1_flag varchar2(1)

Line 369: ,employment_category_group per_position_extra_info.poei_information7%type);

365: ,valid_grade per_position_extra_info.poei_information3%type
366: ,target_grade per_position_extra_info.poei_information4%type
367: ,pay_table_id per_position_extra_info.poei_information5%type
368: ,pay_basis per_position_extra_info.poei_information6%type
369: ,employment_category_group per_position_extra_info.poei_information7%type);
370: --
371: type pos_grp1_type is record
372: (pos_grp1_flag varchar2(1)
373: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

Line 373: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

369: ,employment_category_group per_position_extra_info.poei_information7%type);
370: --
371: type pos_grp1_type is record
372: (pos_grp1_flag varchar2(1)
373: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
374: ,object_version_number per_position_extra_info.object_version_number%type
375: ,personnel_office_id per_position_extra_info.poei_information3%type
376: ,office_symbol per_position_extra_info.poei_information4%type
377: ,organization_structure_id per_position_extra_info.poei_information5%type

Line 374: ,object_version_number per_position_extra_info.object_version_number%type

370: --
371: type pos_grp1_type is record
372: (pos_grp1_flag varchar2(1)
373: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
374: ,object_version_number per_position_extra_info.object_version_number%type
375: ,personnel_office_id per_position_extra_info.poei_information3%type
376: ,office_symbol per_position_extra_info.poei_information4%type
377: ,organization_structure_id per_position_extra_info.poei_information5%type
378: ,occupation_category_code per_position_extra_info.poei_information6%type

Line 375: ,personnel_office_id per_position_extra_info.poei_information3%type

371: type pos_grp1_type is record
372: (pos_grp1_flag varchar2(1)
373: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
374: ,object_version_number per_position_extra_info.object_version_number%type
375: ,personnel_office_id per_position_extra_info.poei_information3%type
376: ,office_symbol per_position_extra_info.poei_information4%type
377: ,organization_structure_id per_position_extra_info.poei_information5%type
378: ,occupation_category_code per_position_extra_info.poei_information6%type
379: ,flsa_category per_position_extra_info.poei_information7%type

Line 376: ,office_symbol per_position_extra_info.poei_information4%type

372: (pos_grp1_flag varchar2(1)
373: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
374: ,object_version_number per_position_extra_info.object_version_number%type
375: ,personnel_office_id per_position_extra_info.poei_information3%type
376: ,office_symbol per_position_extra_info.poei_information4%type
377: ,organization_structure_id per_position_extra_info.poei_information5%type
378: ,occupation_category_code per_position_extra_info.poei_information6%type
379: ,flsa_category per_position_extra_info.poei_information7%type
380: ,bargaining_unit_status per_position_extra_info.poei_information8%type

Line 377: ,organization_structure_id per_position_extra_info.poei_information5%type

373: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
374: ,object_version_number per_position_extra_info.object_version_number%type
375: ,personnel_office_id per_position_extra_info.poei_information3%type
376: ,office_symbol per_position_extra_info.poei_information4%type
377: ,organization_structure_id per_position_extra_info.poei_information5%type
378: ,occupation_category_code per_position_extra_info.poei_information6%type
379: ,flsa_category per_position_extra_info.poei_information7%type
380: ,bargaining_unit_status per_position_extra_info.poei_information8%type
381: ,competitive_level per_position_extra_info.poei_information9%type

Line 378: ,occupation_category_code per_position_extra_info.poei_information6%type

374: ,object_version_number per_position_extra_info.object_version_number%type
375: ,personnel_office_id per_position_extra_info.poei_information3%type
376: ,office_symbol per_position_extra_info.poei_information4%type
377: ,organization_structure_id per_position_extra_info.poei_information5%type
378: ,occupation_category_code per_position_extra_info.poei_information6%type
379: ,flsa_category per_position_extra_info.poei_information7%type
380: ,bargaining_unit_status per_position_extra_info.poei_information8%type
381: ,competitive_level per_position_extra_info.poei_information9%type
382: ,work_schedule per_position_extra_info.poei_information10%type

Line 379: ,flsa_category per_position_extra_info.poei_information7%type

375: ,personnel_office_id per_position_extra_info.poei_information3%type
376: ,office_symbol per_position_extra_info.poei_information4%type
377: ,organization_structure_id per_position_extra_info.poei_information5%type
378: ,occupation_category_code per_position_extra_info.poei_information6%type
379: ,flsa_category per_position_extra_info.poei_information7%type
380: ,bargaining_unit_status per_position_extra_info.poei_information8%type
381: ,competitive_level per_position_extra_info.poei_information9%type
382: ,work_schedule per_position_extra_info.poei_information10%type
383: ,functional_class per_position_extra_info.poei_information11%type

Line 380: ,bargaining_unit_status per_position_extra_info.poei_information8%type

376: ,office_symbol per_position_extra_info.poei_information4%type
377: ,organization_structure_id per_position_extra_info.poei_information5%type
378: ,occupation_category_code per_position_extra_info.poei_information6%type
379: ,flsa_category per_position_extra_info.poei_information7%type
380: ,bargaining_unit_status per_position_extra_info.poei_information8%type
381: ,competitive_level per_position_extra_info.poei_information9%type
382: ,work_schedule per_position_extra_info.poei_information10%type
383: ,functional_class per_position_extra_info.poei_information11%type
384: ,position_working_title per_position_extra_info.poei_information12%type

Line 381: ,competitive_level per_position_extra_info.poei_information9%type

377: ,organization_structure_id per_position_extra_info.poei_information5%type
378: ,occupation_category_code per_position_extra_info.poei_information6%type
379: ,flsa_category per_position_extra_info.poei_information7%type
380: ,bargaining_unit_status per_position_extra_info.poei_information8%type
381: ,competitive_level per_position_extra_info.poei_information9%type
382: ,work_schedule per_position_extra_info.poei_information10%type
383: ,functional_class per_position_extra_info.poei_information11%type
384: ,position_working_title per_position_extra_info.poei_information12%type
385: ,position_sensitivity per_position_extra_info.poei_information13%type

Line 382: ,work_schedule per_position_extra_info.poei_information10%type

378: ,occupation_category_code per_position_extra_info.poei_information6%type
379: ,flsa_category per_position_extra_info.poei_information7%type
380: ,bargaining_unit_status per_position_extra_info.poei_information8%type
381: ,competitive_level per_position_extra_info.poei_information9%type
382: ,work_schedule per_position_extra_info.poei_information10%type
383: ,functional_class per_position_extra_info.poei_information11%type
384: ,position_working_title per_position_extra_info.poei_information12%type
385: ,position_sensitivity per_position_extra_info.poei_information13%type
386: ,security_access per_position_extra_info.poei_information14%type

Line 383: ,functional_class per_position_extra_info.poei_information11%type

379: ,flsa_category per_position_extra_info.poei_information7%type
380: ,bargaining_unit_status per_position_extra_info.poei_information8%type
381: ,competitive_level per_position_extra_info.poei_information9%type
382: ,work_schedule per_position_extra_info.poei_information10%type
383: ,functional_class per_position_extra_info.poei_information11%type
384: ,position_working_title per_position_extra_info.poei_information12%type
385: ,position_sensitivity per_position_extra_info.poei_information13%type
386: ,security_access per_position_extra_info.poei_information14%type
387: ,prp_sci per_position_extra_info.poei_information15%type

Line 384: ,position_working_title per_position_extra_info.poei_information12%type

380: ,bargaining_unit_status per_position_extra_info.poei_information8%type
381: ,competitive_level per_position_extra_info.poei_information9%type
382: ,work_schedule per_position_extra_info.poei_information10%type
383: ,functional_class per_position_extra_info.poei_information11%type
384: ,position_working_title per_position_extra_info.poei_information12%type
385: ,position_sensitivity per_position_extra_info.poei_information13%type
386: ,security_access per_position_extra_info.poei_information14%type
387: ,prp_sci per_position_extra_info.poei_information15%type
388: ,supervisory_status per_position_extra_info.poei_information16%type

Line 385: ,position_sensitivity per_position_extra_info.poei_information13%type

381: ,competitive_level per_position_extra_info.poei_information9%type
382: ,work_schedule per_position_extra_info.poei_information10%type
383: ,functional_class per_position_extra_info.poei_information11%type
384: ,position_working_title per_position_extra_info.poei_information12%type
385: ,position_sensitivity per_position_extra_info.poei_information13%type
386: ,security_access per_position_extra_info.poei_information14%type
387: ,prp_sci per_position_extra_info.poei_information15%type
388: ,supervisory_status per_position_extra_info.poei_information16%type
389: ,type_employee_supervised per_position_extra_info.poei_information17%type

Line 386: ,security_access per_position_extra_info.poei_information14%type

382: ,work_schedule per_position_extra_info.poei_information10%type
383: ,functional_class per_position_extra_info.poei_information11%type
384: ,position_working_title per_position_extra_info.poei_information12%type
385: ,position_sensitivity per_position_extra_info.poei_information13%type
386: ,security_access per_position_extra_info.poei_information14%type
387: ,prp_sci per_position_extra_info.poei_information15%type
388: ,supervisory_status per_position_extra_info.poei_information16%type
389: ,type_employee_supervised per_position_extra_info.poei_information17%type
390: ,payroll_office_id per_position_extra_info.poei_information18%type

Line 387: ,prp_sci per_position_extra_info.poei_information15%type

383: ,functional_class per_position_extra_info.poei_information11%type
384: ,position_working_title per_position_extra_info.poei_information12%type
385: ,position_sensitivity per_position_extra_info.poei_information13%type
386: ,security_access per_position_extra_info.poei_information14%type
387: ,prp_sci per_position_extra_info.poei_information15%type
388: ,supervisory_status per_position_extra_info.poei_information16%type
389: ,type_employee_supervised per_position_extra_info.poei_information17%type
390: ,payroll_office_id per_position_extra_info.poei_information18%type
391: ,timekeeper per_position_extra_info.poei_information19%type

Line 388: ,supervisory_status per_position_extra_info.poei_information16%type

384: ,position_working_title per_position_extra_info.poei_information12%type
385: ,position_sensitivity per_position_extra_info.poei_information13%type
386: ,security_access per_position_extra_info.poei_information14%type
387: ,prp_sci per_position_extra_info.poei_information15%type
388: ,supervisory_status per_position_extra_info.poei_information16%type
389: ,type_employee_supervised per_position_extra_info.poei_information17%type
390: ,payroll_office_id per_position_extra_info.poei_information18%type
391: ,timekeeper per_position_extra_info.poei_information19%type
392: ,competitive_area per_position_extra_info.poei_information20%type

Line 389: ,type_employee_supervised per_position_extra_info.poei_information17%type

385: ,position_sensitivity per_position_extra_info.poei_information13%type
386: ,security_access per_position_extra_info.poei_information14%type
387: ,prp_sci per_position_extra_info.poei_information15%type
388: ,supervisory_status per_position_extra_info.poei_information16%type
389: ,type_employee_supervised per_position_extra_info.poei_information17%type
390: ,payroll_office_id per_position_extra_info.poei_information18%type
391: ,timekeeper per_position_extra_info.poei_information19%type
392: ,competitive_area per_position_extra_info.poei_information20%type
393: ,positions_organization per_position_extra_info.poei_information21%type

Line 390: ,payroll_office_id per_position_extra_info.poei_information18%type

386: ,security_access per_position_extra_info.poei_information14%type
387: ,prp_sci per_position_extra_info.poei_information15%type
388: ,supervisory_status per_position_extra_info.poei_information16%type
389: ,type_employee_supervised per_position_extra_info.poei_information17%type
390: ,payroll_office_id per_position_extra_info.poei_information18%type
391: ,timekeeper per_position_extra_info.poei_information19%type
392: ,competitive_area per_position_extra_info.poei_information20%type
393: ,positions_organization per_position_extra_info.poei_information21%type
394: ,oct_report_flag per_position_extra_info.poei_information22%type

Line 391: ,timekeeper per_position_extra_info.poei_information19%type

387: ,prp_sci per_position_extra_info.poei_information15%type
388: ,supervisory_status per_position_extra_info.poei_information16%type
389: ,type_employee_supervised per_position_extra_info.poei_information17%type
390: ,payroll_office_id per_position_extra_info.poei_information18%type
391: ,timekeeper per_position_extra_info.poei_information19%type
392: ,competitive_area per_position_extra_info.poei_information20%type
393: ,positions_organization per_position_extra_info.poei_information21%type
394: ,oct_report_flag per_position_extra_info.poei_information22%type
395: ,part_time_hours per_position_extra_info.poei_information23%type);

Line 392: ,competitive_area per_position_extra_info.poei_information20%type

388: ,supervisory_status per_position_extra_info.poei_information16%type
389: ,type_employee_supervised per_position_extra_info.poei_information17%type
390: ,payroll_office_id per_position_extra_info.poei_information18%type
391: ,timekeeper per_position_extra_info.poei_information19%type
392: ,competitive_area per_position_extra_info.poei_information20%type
393: ,positions_organization per_position_extra_info.poei_information21%type
394: ,oct_report_flag per_position_extra_info.poei_information22%type
395: ,part_time_hours per_position_extra_info.poei_information23%type);
396: --

Line 393: ,positions_organization per_position_extra_info.poei_information21%type

389: ,type_employee_supervised per_position_extra_info.poei_information17%type
390: ,payroll_office_id per_position_extra_info.poei_information18%type
391: ,timekeeper per_position_extra_info.poei_information19%type
392: ,competitive_area per_position_extra_info.poei_information20%type
393: ,positions_organization per_position_extra_info.poei_information21%type
394: ,oct_report_flag per_position_extra_info.poei_information22%type
395: ,part_time_hours per_position_extra_info.poei_information23%type);
396: --
397: type pos_grp2_type is record

Line 394: ,oct_report_flag per_position_extra_info.poei_information22%type

390: ,payroll_office_id per_position_extra_info.poei_information18%type
391: ,timekeeper per_position_extra_info.poei_information19%type
392: ,competitive_area per_position_extra_info.poei_information20%type
393: ,positions_organization per_position_extra_info.poei_information21%type
394: ,oct_report_flag per_position_extra_info.poei_information22%type
395: ,part_time_hours per_position_extra_info.poei_information23%type);
396: --
397: type pos_grp2_type is record
398: (pos_grp2_flag varchar2(1)

Line 395: ,part_time_hours per_position_extra_info.poei_information23%type);

391: ,timekeeper per_position_extra_info.poei_information19%type
392: ,competitive_area per_position_extra_info.poei_information20%type
393: ,positions_organization per_position_extra_info.poei_information21%type
394: ,oct_report_flag per_position_extra_info.poei_information22%type
395: ,part_time_hours per_position_extra_info.poei_information23%type);
396: --
397: type pos_grp2_type is record
398: (pos_grp2_flag varchar2(1)
399: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

Line 399: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

395: ,part_time_hours per_position_extra_info.poei_information23%type);
396: --
397: type pos_grp2_type is record
398: (pos_grp2_flag varchar2(1)
399: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
400: ,object_version_number per_position_extra_info.object_version_number%type
401: ,position_occupied per_position_extra_info.poei_information3%type
402: ,organization_function_code per_position_extra_info.poei_information4%type
403: ,date_position_classified per_position_extra_info.poei_information5%type

Line 400: ,object_version_number per_position_extra_info.object_version_number%type

396: --
397: type pos_grp2_type is record
398: (pos_grp2_flag varchar2(1)
399: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
400: ,object_version_number per_position_extra_info.object_version_number%type
401: ,position_occupied per_position_extra_info.poei_information3%type
402: ,organization_function_code per_position_extra_info.poei_information4%type
403: ,date_position_classified per_position_extra_info.poei_information5%type
404: ,date_last_position_audit per_position_extra_info.poei_information6%type

Line 401: ,position_occupied per_position_extra_info.poei_information3%type

397: type pos_grp2_type is record
398: (pos_grp2_flag varchar2(1)
399: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
400: ,object_version_number per_position_extra_info.object_version_number%type
401: ,position_occupied per_position_extra_info.poei_information3%type
402: ,organization_function_code per_position_extra_info.poei_information4%type
403: ,date_position_classified per_position_extra_info.poei_information5%type
404: ,date_last_position_audit per_position_extra_info.poei_information6%type
405: ,classification_official per_position_extra_info.poei_information7%type

Line 402: ,organization_function_code per_position_extra_info.poei_information4%type

398: (pos_grp2_flag varchar2(1)
399: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
400: ,object_version_number per_position_extra_info.object_version_number%type
401: ,position_occupied per_position_extra_info.poei_information3%type
402: ,organization_function_code per_position_extra_info.poei_information4%type
403: ,date_position_classified per_position_extra_info.poei_information5%type
404: ,date_last_position_audit per_position_extra_info.poei_information6%type
405: ,classification_official per_position_extra_info.poei_information7%type
406: ,language_required per_position_extra_info.poei_information8%type

Line 403: ,date_position_classified per_position_extra_info.poei_information5%type

399: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
400: ,object_version_number per_position_extra_info.object_version_number%type
401: ,position_occupied per_position_extra_info.poei_information3%type
402: ,organization_function_code per_position_extra_info.poei_information4%type
403: ,date_position_classified per_position_extra_info.poei_information5%type
404: ,date_last_position_audit per_position_extra_info.poei_information6%type
405: ,classification_official per_position_extra_info.poei_information7%type
406: ,language_required per_position_extra_info.poei_information8%type
407: ,drug_test per_position_extra_info.poei_information9%type

Line 404: ,date_last_position_audit per_position_extra_info.poei_information6%type

400: ,object_version_number per_position_extra_info.object_version_number%type
401: ,position_occupied per_position_extra_info.poei_information3%type
402: ,organization_function_code per_position_extra_info.poei_information4%type
403: ,date_position_classified per_position_extra_info.poei_information5%type
404: ,date_last_position_audit per_position_extra_info.poei_information6%type
405: ,classification_official per_position_extra_info.poei_information7%type
406: ,language_required per_position_extra_info.poei_information8%type
407: ,drug_test per_position_extra_info.poei_information9%type
408: ,financial_statement per_position_extra_info.poei_information10%type

Line 405: ,classification_official per_position_extra_info.poei_information7%type

401: ,position_occupied per_position_extra_info.poei_information3%type
402: ,organization_function_code per_position_extra_info.poei_information4%type
403: ,date_position_classified per_position_extra_info.poei_information5%type
404: ,date_last_position_audit per_position_extra_info.poei_information6%type
405: ,classification_official per_position_extra_info.poei_information7%type
406: ,language_required per_position_extra_info.poei_information8%type
407: ,drug_test per_position_extra_info.poei_information9%type
408: ,financial_statement per_position_extra_info.poei_information10%type
409: ,training_program_id per_position_extra_info.poei_information11%type

Line 406: ,language_required per_position_extra_info.poei_information8%type

402: ,organization_function_code per_position_extra_info.poei_information4%type
403: ,date_position_classified per_position_extra_info.poei_information5%type
404: ,date_last_position_audit per_position_extra_info.poei_information6%type
405: ,classification_official per_position_extra_info.poei_information7%type
406: ,language_required per_position_extra_info.poei_information8%type
407: ,drug_test per_position_extra_info.poei_information9%type
408: ,financial_statement per_position_extra_info.poei_information10%type
409: ,training_program_id per_position_extra_info.poei_information11%type
410: ,key_emergency_essential per_position_extra_info.poei_information12%type

Line 407: ,drug_test per_position_extra_info.poei_information9%type

403: ,date_position_classified per_position_extra_info.poei_information5%type
404: ,date_last_position_audit per_position_extra_info.poei_information6%type
405: ,classification_official per_position_extra_info.poei_information7%type
406: ,language_required per_position_extra_info.poei_information8%type
407: ,drug_test per_position_extra_info.poei_information9%type
408: ,financial_statement per_position_extra_info.poei_information10%type
409: ,training_program_id per_position_extra_info.poei_information11%type
410: ,key_emergency_essential per_position_extra_info.poei_information12%type
411: ,appropriation_code1 per_position_extra_info.poei_information13%type

Line 408: ,financial_statement per_position_extra_info.poei_information10%type

404: ,date_last_position_audit per_position_extra_info.poei_information6%type
405: ,classification_official per_position_extra_info.poei_information7%type
406: ,language_required per_position_extra_info.poei_information8%type
407: ,drug_test per_position_extra_info.poei_information9%type
408: ,financial_statement per_position_extra_info.poei_information10%type
409: ,training_program_id per_position_extra_info.poei_information11%type
410: ,key_emergency_essential per_position_extra_info.poei_information12%type
411: ,appropriation_code1 per_position_extra_info.poei_information13%type
412: ,appropriation_code2 per_position_extra_info.poei_information14%type

Line 409: ,training_program_id per_position_extra_info.poei_information11%type

405: ,classification_official per_position_extra_info.poei_information7%type
406: ,language_required per_position_extra_info.poei_information8%type
407: ,drug_test per_position_extra_info.poei_information9%type
408: ,financial_statement per_position_extra_info.poei_information10%type
409: ,training_program_id per_position_extra_info.poei_information11%type
410: ,key_emergency_essential per_position_extra_info.poei_information12%type
411: ,appropriation_code1 per_position_extra_info.poei_information13%type
412: ,appropriation_code2 per_position_extra_info.poei_information14%type
413: ,intelligence_position_ind per_position_extra_info.poei_information15%type

Line 410: ,key_emergency_essential per_position_extra_info.poei_information12%type

406: ,language_required per_position_extra_info.poei_information8%type
407: ,drug_test per_position_extra_info.poei_information9%type
408: ,financial_statement per_position_extra_info.poei_information10%type
409: ,training_program_id per_position_extra_info.poei_information11%type
410: ,key_emergency_essential per_position_extra_info.poei_information12%type
411: ,appropriation_code1 per_position_extra_info.poei_information13%type
412: ,appropriation_code2 per_position_extra_info.poei_information14%type
413: ,intelligence_position_ind per_position_extra_info.poei_information15%type
414: ,leo_position_indicator per_position_extra_info.poei_information16%type);

Line 411: ,appropriation_code1 per_position_extra_info.poei_information13%type

407: ,drug_test per_position_extra_info.poei_information9%type
408: ,financial_statement per_position_extra_info.poei_information10%type
409: ,training_program_id per_position_extra_info.poei_information11%type
410: ,key_emergency_essential per_position_extra_info.poei_information12%type
411: ,appropriation_code1 per_position_extra_info.poei_information13%type
412: ,appropriation_code2 per_position_extra_info.poei_information14%type
413: ,intelligence_position_ind per_position_extra_info.poei_information15%type
414: ,leo_position_indicator per_position_extra_info.poei_information16%type);
415: --

Line 412: ,appropriation_code2 per_position_extra_info.poei_information14%type

408: ,financial_statement per_position_extra_info.poei_information10%type
409: ,training_program_id per_position_extra_info.poei_information11%type
410: ,key_emergency_essential per_position_extra_info.poei_information12%type
411: ,appropriation_code1 per_position_extra_info.poei_information13%type
412: ,appropriation_code2 per_position_extra_info.poei_information14%type
413: ,intelligence_position_ind per_position_extra_info.poei_information15%type
414: ,leo_position_indicator per_position_extra_info.poei_information16%type);
415: --
416: -- type pos_of8_type is record

Line 413: ,intelligence_position_ind per_position_extra_info.poei_information15%type

409: ,training_program_id per_position_extra_info.poei_information11%type
410: ,key_emergency_essential per_position_extra_info.poei_information12%type
411: ,appropriation_code1 per_position_extra_info.poei_information13%type
412: ,appropriation_code2 per_position_extra_info.poei_information14%type
413: ,intelligence_position_ind per_position_extra_info.poei_information15%type
414: ,leo_position_indicator per_position_extra_info.poei_information16%type);
415: --
416: -- type pos_of8_type is record
417: -- (pos_of8_flag varchar2(1)

Line 414: ,leo_position_indicator per_position_extra_info.poei_information16%type);

410: ,key_emergency_essential per_position_extra_info.poei_information12%type
411: ,appropriation_code1 per_position_extra_info.poei_information13%type
412: ,appropriation_code2 per_position_extra_info.poei_information14%type
413: ,intelligence_position_ind per_position_extra_info.poei_information15%type
414: ,leo_position_indicator per_position_extra_info.poei_information16%type);
415: --
416: -- type pos_of8_type is record
417: -- (pos_of8_flag varchar2(1)
418: -- ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

Line 418: -- ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

414: ,leo_position_indicator per_position_extra_info.poei_information16%type);
415: --
416: -- type pos_of8_type is record
417: -- (pos_of8_flag varchar2(1)
418: -- ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
419: -- ,object_version_number per_position_extra_info.object_version_number%type
420: -- ,reason_for_submission per_position_extra_info.poei_information3%type
421: -- ,service_location per_position_extra_info.poei_information4%type
422: -- ,cs_certification_number per_position_extra_info.poei_information5%type

Line 419: -- ,object_version_number per_position_extra_info.object_version_number%type

415: --
416: -- type pos_of8_type is record
417: -- (pos_of8_flag varchar2(1)
418: -- ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
419: -- ,object_version_number per_position_extra_info.object_version_number%type
420: -- ,reason_for_submission per_position_extra_info.poei_information3%type
421: -- ,service_location per_position_extra_info.poei_information4%type
422: -- ,cs_certification_number per_position_extra_info.poei_information5%type
423: -- ,classified_grade_by per_position_extra_info.poei_information6%type

Line 420: -- ,reason_for_submission per_position_extra_info.poei_information3%type

416: -- type pos_of8_type is record
417: -- (pos_of8_flag varchar2(1)
418: -- ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
419: -- ,object_version_number per_position_extra_info.object_version_number%type
420: -- ,reason_for_submission per_position_extra_info.poei_information3%type
421: -- ,service_location per_position_extra_info.poei_information4%type
422: -- ,cs_certification_number per_position_extra_info.poei_information5%type
423: -- ,classified_grade_by per_position_extra_info.poei_information6%type
424: -- ,classification_standard_used per_position_extra_info.poei_information7%type

Line 421: -- ,service_location per_position_extra_info.poei_information4%type

417: -- (pos_of8_flag varchar2(1)
418: -- ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
419: -- ,object_version_number per_position_extra_info.object_version_number%type
420: -- ,reason_for_submission per_position_extra_info.poei_information3%type
421: -- ,service_location per_position_extra_info.poei_information4%type
422: -- ,cs_certification_number per_position_extra_info.poei_information5%type
423: -- ,classified_grade_by per_position_extra_info.poei_information6%type
424: -- ,classification_standard_used per_position_extra_info.poei_information7%type
425: -- ,classification_standard_date per_position_extra_info.poei_information8%type

Line 422: -- ,cs_certification_number per_position_extra_info.poei_information5%type

418: -- ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
419: -- ,object_version_number per_position_extra_info.object_version_number%type
420: -- ,reason_for_submission per_position_extra_info.poei_information3%type
421: -- ,service_location per_position_extra_info.poei_information4%type
422: -- ,cs_certification_number per_position_extra_info.poei_information5%type
423: -- ,classified_grade_by per_position_extra_info.poei_information6%type
424: -- ,classification_standard_used per_position_extra_info.poei_information7%type
425: -- ,classification_standard_date per_position_extra_info.poei_information8%type
426: -- ,subject_to_ia_action per_position_extra_info.poei_information9%type);

Line 423: -- ,classified_grade_by per_position_extra_info.poei_information6%type

419: -- ,object_version_number per_position_extra_info.object_version_number%type
420: -- ,reason_for_submission per_position_extra_info.poei_information3%type
421: -- ,service_location per_position_extra_info.poei_information4%type
422: -- ,cs_certification_number per_position_extra_info.poei_information5%type
423: -- ,classified_grade_by per_position_extra_info.poei_information6%type
424: -- ,classification_standard_used per_position_extra_info.poei_information7%type
425: -- ,classification_standard_date per_position_extra_info.poei_information8%type
426: -- ,subject_to_ia_action per_position_extra_info.poei_information9%type);
427: --

Line 424: -- ,classification_standard_used per_position_extra_info.poei_information7%type

420: -- ,reason_for_submission per_position_extra_info.poei_information3%type
421: -- ,service_location per_position_extra_info.poei_information4%type
422: -- ,cs_certification_number per_position_extra_info.poei_information5%type
423: -- ,classified_grade_by per_position_extra_info.poei_information6%type
424: -- ,classification_standard_used per_position_extra_info.poei_information7%type
425: -- ,classification_standard_date per_position_extra_info.poei_information8%type
426: -- ,subject_to_ia_action per_position_extra_info.poei_information9%type);
427: --
428: type pos_oblig_type is record

Line 425: -- ,classification_standard_date per_position_extra_info.poei_information8%type

421: -- ,service_location per_position_extra_info.poei_information4%type
422: -- ,cs_certification_number per_position_extra_info.poei_information5%type
423: -- ,classified_grade_by per_position_extra_info.poei_information6%type
424: -- ,classification_standard_used per_position_extra_info.poei_information7%type
425: -- ,classification_standard_date per_position_extra_info.poei_information8%type
426: -- ,subject_to_ia_action per_position_extra_info.poei_information9%type);
427: --
428: type pos_oblig_type is record
429: (pos_oblig_flag varchar2(1)

Line 426: -- ,subject_to_ia_action per_position_extra_info.poei_information9%type);

422: -- ,cs_certification_number per_position_extra_info.poei_information5%type
423: -- ,classified_grade_by per_position_extra_info.poei_information6%type
424: -- ,classification_standard_used per_position_extra_info.poei_information7%type
425: -- ,classification_standard_date per_position_extra_info.poei_information8%type
426: -- ,subject_to_ia_action per_position_extra_info.poei_information9%type);
427: --
428: type pos_oblig_type is record
429: (pos_oblig_flag varchar2(1)
430: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

Line 430: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

426: -- ,subject_to_ia_action per_position_extra_info.poei_information9%type);
427: --
428: type pos_oblig_type is record
429: (pos_oblig_flag varchar2(1)
430: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
431: ,object_version_number per_position_extra_info.object_version_number%type
432: ,expiration_date per_position_extra_info.poei_information3%type
433: ,obligation_type per_position_extra_info.poei_information4%type
434: ,employee_ssn per_position_extra_info.poei_information5%type);

Line 431: ,object_version_number per_position_extra_info.object_version_number%type

427: --
428: type pos_oblig_type is record
429: (pos_oblig_flag varchar2(1)
430: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
431: ,object_version_number per_position_extra_info.object_version_number%type
432: ,expiration_date per_position_extra_info.poei_information3%type
433: ,obligation_type per_position_extra_info.poei_information4%type
434: ,employee_ssn per_position_extra_info.poei_information5%type);
435: --

Line 432: ,expiration_date per_position_extra_info.poei_information3%type

428: type pos_oblig_type is record
429: (pos_oblig_flag varchar2(1)
430: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
431: ,object_version_number per_position_extra_info.object_version_number%type
432: ,expiration_date per_position_extra_info.poei_information3%type
433: ,obligation_type per_position_extra_info.poei_information4%type
434: ,employee_ssn per_position_extra_info.poei_information5%type);
435: --
436: type pos_car_prog_type is record

Line 433: ,obligation_type per_position_extra_info.poei_information4%type

429: (pos_oblig_flag varchar2(1)
430: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
431: ,object_version_number per_position_extra_info.object_version_number%type
432: ,expiration_date per_position_extra_info.poei_information3%type
433: ,obligation_type per_position_extra_info.poei_information4%type
434: ,employee_ssn per_position_extra_info.poei_information5%type);
435: --
436: type pos_car_prog_type is record
437: (pos_car_prog_flag varchar2(1)

Line 434: ,employee_ssn per_position_extra_info.poei_information5%type);

430: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
431: ,object_version_number per_position_extra_info.object_version_number%type
432: ,expiration_date per_position_extra_info.poei_information3%type
433: ,obligation_type per_position_extra_info.poei_information4%type
434: ,employee_ssn per_position_extra_info.poei_information5%type);
435: --
436: type pos_car_prog_type is record
437: (pos_car_prog_flag varchar2(1)
438: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

Line 438: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

434: ,employee_ssn per_position_extra_info.poei_information5%type);
435: --
436: type pos_car_prog_type is record
437: (pos_car_prog_flag varchar2(1)
438: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
439: ,object_version_number per_position_extra_info.object_version_number%type
440: ,career_program_id per_position_extra_info.poei_information3%type
441: ,career_program_type per_position_extra_info.poei_information4%type
442: ,change_reasons per_position_extra_info.poei_information5%type

Line 439: ,object_version_number per_position_extra_info.object_version_number%type

435: --
436: type pos_car_prog_type is record
437: (pos_car_prog_flag varchar2(1)
438: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
439: ,object_version_number per_position_extra_info.object_version_number%type
440: ,career_program_id per_position_extra_info.poei_information3%type
441: ,career_program_type per_position_extra_info.poei_information4%type
442: ,change_reasons per_position_extra_info.poei_information5%type
443: ,career_field_id per_position_extra_info.poei_information6%type

Line 440: ,career_program_id per_position_extra_info.poei_information3%type

436: type pos_car_prog_type is record
437: (pos_car_prog_flag varchar2(1)
438: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
439: ,object_version_number per_position_extra_info.object_version_number%type
440: ,career_program_id per_position_extra_info.poei_information3%type
441: ,career_program_type per_position_extra_info.poei_information4%type
442: ,change_reasons per_position_extra_info.poei_information5%type
443: ,career_field_id per_position_extra_info.poei_information6%type
444: ,career_program_code per_position_extra_info.poei_information7%type

Line 441: ,career_program_type per_position_extra_info.poei_information4%type

437: (pos_car_prog_flag varchar2(1)
438: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
439: ,object_version_number per_position_extra_info.object_version_number%type
440: ,career_program_id per_position_extra_info.poei_information3%type
441: ,career_program_type per_position_extra_info.poei_information4%type
442: ,change_reasons per_position_extra_info.poei_information5%type
443: ,career_field_id per_position_extra_info.poei_information6%type
444: ,career_program_code per_position_extra_info.poei_information7%type
445: ,acteds_key_position per_position_extra_info.poei_information8%type);

Line 442: ,change_reasons per_position_extra_info.poei_information5%type

438: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
439: ,object_version_number per_position_extra_info.object_version_number%type
440: ,career_program_id per_position_extra_info.poei_information3%type
441: ,career_program_type per_position_extra_info.poei_information4%type
442: ,change_reasons per_position_extra_info.poei_information5%type
443: ,career_field_id per_position_extra_info.poei_information6%type
444: ,career_program_code per_position_extra_info.poei_information7%type
445: ,acteds_key_position per_position_extra_info.poei_information8%type);
446: --

Line 443: ,career_field_id per_position_extra_info.poei_information6%type

439: ,object_version_number per_position_extra_info.object_version_number%type
440: ,career_program_id per_position_extra_info.poei_information3%type
441: ,career_program_type per_position_extra_info.poei_information4%type
442: ,change_reasons per_position_extra_info.poei_information5%type
443: ,career_field_id per_position_extra_info.poei_information6%type
444: ,career_program_code per_position_extra_info.poei_information7%type
445: ,acteds_key_position per_position_extra_info.poei_information8%type);
446: --
447: type personal_info_type is record

Line 444: ,career_program_code per_position_extra_info.poei_information7%type

440: ,career_program_id per_position_extra_info.poei_information3%type
441: ,career_program_type per_position_extra_info.poei_information4%type
442: ,change_reasons per_position_extra_info.poei_information5%type
443: ,career_field_id per_position_extra_info.poei_information6%type
444: ,career_program_code per_position_extra_info.poei_information7%type
445: ,acteds_key_position per_position_extra_info.poei_information8%type);
446: --
447: type personal_info_type is record
448: (p_national_identifier per_people_f.national_identifier%type

Line 445: ,acteds_key_position per_position_extra_info.poei_information8%type);

441: ,career_program_type per_position_extra_info.poei_information4%type
442: ,change_reasons per_position_extra_info.poei_information5%type
443: ,career_field_id per_position_extra_info.poei_information6%type
444: ,career_program_code per_position_extra_info.poei_information7%type
445: ,acteds_key_position per_position_extra_info.poei_information8%type);
446: --
447: type personal_info_type is record
448: (p_national_identifier per_people_f.national_identifier%type
449: ,p_date_of_birth per_people_f.date_of_birth%type

Line 461: ,pay_basis per_position_extra_info.poei_information6%type

457: ,occ_code per_job_definitions.segment1%type
458: ,grade_or_level per_grade_definitions.segment2%type
459: ,step_or_rate per_assignment_extra_info.aei_information3%type
460: ,total_salary number
461: ,pay_basis per_position_extra_info.poei_information6%type
462: ,basic_pay number
463: ,locality_adj number
464: ,adj_basic_pay number
465: ,other_pay number

Line 614: ( career_category per_position_extra_info.poei_information8%type

610: ,object_version_number per_person_analyses.object_version_number%type );
611:
612:
613: type civ_position_acquisition is record
614: ( career_category per_position_extra_info.poei_information8%type
615: ,critical_position per_position_extra_info.poei_information5%type
616: ,civ_func_acct_shred per_position_extra_info.poei_information7%type
617: ,psn_status_ind per_position_extra_info.poei_information4%type
618: );

Line 615: ,critical_position per_position_extra_info.poei_information5%type

611:
612:
613: type civ_position_acquisition is record
614: ( career_category per_position_extra_info.poei_information8%type
615: ,critical_position per_position_extra_info.poei_information5%type
616: ,civ_func_acct_shred per_position_extra_info.poei_information7%type
617: ,psn_status_ind per_position_extra_info.poei_information4%type
618: );
619:

Line 616: ,civ_func_acct_shred per_position_extra_info.poei_information7%type

612:
613: type civ_position_acquisition is record
614: ( career_category per_position_extra_info.poei_information8%type
615: ,critical_position per_position_extra_info.poei_information5%type
616: ,civ_func_acct_shred per_position_extra_info.poei_information7%type
617: ,psn_status_ind per_position_extra_info.poei_information4%type
618: );
619:
620: type civ_position_army_appr_ln is record

Line 617: ,psn_status_ind per_position_extra_info.poei_information4%type

613: type civ_position_acquisition is record
614: ( career_category per_position_extra_info.poei_information8%type
615: ,critical_position per_position_extra_info.poei_information5%type
616: ,civ_func_acct_shred per_position_extra_info.poei_information7%type
617: ,psn_status_ind per_position_extra_info.poei_information4%type
618: );
619:
620: type civ_position_army_appr_ln is record
621: (

Line 622: amscd per_position_extra_info.poei_information11%type

618: );
619:
620: type civ_position_army_appr_ln is record
621: (
622: amscd per_position_extra_info.poei_information11%type
623: ,ar_tda_line_num per_position_extra_info.poei_information3%type
624: ,competitive_area per_position_extra_info.poei_information4%type
625: ,duty_stn_st per_position_extra_info.poei_information16%type
626: ,func_desc per_position_extra_info.poei_information2%type

Line 623: ,ar_tda_line_num per_position_extra_info.poei_information3%type

619:
620: type civ_position_army_appr_ln is record
621: (
622: amscd per_position_extra_info.poei_information11%type
623: ,ar_tda_line_num per_position_extra_info.poei_information3%type
624: ,competitive_area per_position_extra_info.poei_information4%type
625: ,duty_stn_st per_position_extra_info.poei_information16%type
626: ,func_desc per_position_extra_info.poei_information2%type
627: ,tda_para_num per_position_extra_info.poei_information5%type

Line 624: ,competitive_area per_position_extra_info.poei_information4%type

620: type civ_position_army_appr_ln is record
621: (
622: amscd per_position_extra_info.poei_information11%type
623: ,ar_tda_line_num per_position_extra_info.poei_information3%type
624: ,competitive_area per_position_extra_info.poei_information4%type
625: ,duty_stn_st per_position_extra_info.poei_information16%type
626: ,func_desc per_position_extra_info.poei_information2%type
627: ,tda_para_num per_position_extra_info.poei_information5%type
628: );

Line 625: ,duty_stn_st per_position_extra_info.poei_information16%type

621: (
622: amscd per_position_extra_info.poei_information11%type
623: ,ar_tda_line_num per_position_extra_info.poei_information3%type
624: ,competitive_area per_position_extra_info.poei_information4%type
625: ,duty_stn_st per_position_extra_info.poei_information16%type
626: ,func_desc per_position_extra_info.poei_information2%type
627: ,tda_para_num per_position_extra_info.poei_information5%type
628: );
629:

Line 626: ,func_desc per_position_extra_info.poei_information2%type

622: amscd per_position_extra_info.poei_information11%type
623: ,ar_tda_line_num per_position_extra_info.poei_information3%type
624: ,competitive_area per_position_extra_info.poei_information4%type
625: ,duty_stn_st per_position_extra_info.poei_information16%type
626: ,func_desc per_position_extra_info.poei_information2%type
627: ,tda_para_num per_position_extra_info.poei_information5%type
628: );
629:
630: type civ_position_naf is record

Line 627: ,tda_para_num per_position_extra_info.poei_information5%type

623: ,ar_tda_line_num per_position_extra_info.poei_information3%type
624: ,competitive_area per_position_extra_info.poei_information4%type
625: ,duty_stn_st per_position_extra_info.poei_information16%type
626: ,func_desc per_position_extra_info.poei_information2%type
627: ,tda_para_num per_position_extra_info.poei_information5%type
628: );
629:
630: type civ_position_naf is record
631: (

Line 632: med_ind per_position_extra_info.poei_information12%type

628: );
629:
630: type civ_position_naf is record
631: (
632: med_ind per_position_extra_info.poei_information12%type
633: ,nafi_psn_num per_position_extra_info.poei_information10%type
634: ,svc_offc_symbol per_position_extra_info.poei_information4%type
635: );
636:

Line 633: ,nafi_psn_num per_position_extra_info.poei_information10%type

629:
630: type civ_position_naf is record
631: (
632: med_ind per_position_extra_info.poei_information12%type
633: ,nafi_psn_num per_position_extra_info.poei_information10%type
634: ,svc_offc_symbol per_position_extra_info.poei_information4%type
635: );
636:
637: -- added by skutteti on 3-mar-98

Line 634: ,svc_offc_symbol per_position_extra_info.poei_information4%type

630: type civ_position_naf is record
631: (
632: med_ind per_position_extra_info.poei_information12%type
633: ,nafi_psn_num per_position_extra_info.poei_information10%type
634: ,svc_offc_symbol per_position_extra_info.poei_information4%type
635: );
636:
637: -- added by skutteti on 3-mar-98
638: type par_term_retained_grade_type is record