APPS.GHR_API dependencies on PER_POSITION_EXTRA_INFO

Line 332: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

328: ,exception_retire_pay_ind per_people_extra_info.pei_information11%type);
329: --
330: type pos_valid_grade_type is record
331: (pos_valid_grade_flag varchar2(1)
332: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
333: ,object_version_number per_position_extra_info.object_version_number%type
334: ,valid_grade per_position_extra_info.poei_information3%type
335: ,target_grade per_position_extra_info.poei_information4%type
336: ,pay_table_id per_position_extra_info.poei_information5%type

Line 333: ,object_version_number per_position_extra_info.object_version_number%type

329: --
330: type pos_valid_grade_type is record
331: (pos_valid_grade_flag varchar2(1)
332: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
333: ,object_version_number per_position_extra_info.object_version_number%type
334: ,valid_grade per_position_extra_info.poei_information3%type
335: ,target_grade per_position_extra_info.poei_information4%type
336: ,pay_table_id per_position_extra_info.poei_information5%type
337: ,pay_basis per_position_extra_info.poei_information6%type

Line 334: ,valid_grade per_position_extra_info.poei_information3%type

330: type pos_valid_grade_type is record
331: (pos_valid_grade_flag varchar2(1)
332: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
333: ,object_version_number per_position_extra_info.object_version_number%type
334: ,valid_grade per_position_extra_info.poei_information3%type
335: ,target_grade per_position_extra_info.poei_information4%type
336: ,pay_table_id per_position_extra_info.poei_information5%type
337: ,pay_basis per_position_extra_info.poei_information6%type
338: ,employment_category_group per_position_extra_info.poei_information7%type);

Line 335: ,target_grade per_position_extra_info.poei_information4%type

331: (pos_valid_grade_flag varchar2(1)
332: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
333: ,object_version_number per_position_extra_info.object_version_number%type
334: ,valid_grade per_position_extra_info.poei_information3%type
335: ,target_grade per_position_extra_info.poei_information4%type
336: ,pay_table_id per_position_extra_info.poei_information5%type
337: ,pay_basis per_position_extra_info.poei_information6%type
338: ,employment_category_group per_position_extra_info.poei_information7%type);
339: --

Line 336: ,pay_table_id per_position_extra_info.poei_information5%type

332: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
333: ,object_version_number per_position_extra_info.object_version_number%type
334: ,valid_grade per_position_extra_info.poei_information3%type
335: ,target_grade per_position_extra_info.poei_information4%type
336: ,pay_table_id per_position_extra_info.poei_information5%type
337: ,pay_basis per_position_extra_info.poei_information6%type
338: ,employment_category_group per_position_extra_info.poei_information7%type);
339: --
340: type pos_grp1_type is record

Line 337: ,pay_basis per_position_extra_info.poei_information6%type

333: ,object_version_number per_position_extra_info.object_version_number%type
334: ,valid_grade per_position_extra_info.poei_information3%type
335: ,target_grade per_position_extra_info.poei_information4%type
336: ,pay_table_id per_position_extra_info.poei_information5%type
337: ,pay_basis per_position_extra_info.poei_information6%type
338: ,employment_category_group per_position_extra_info.poei_information7%type);
339: --
340: type pos_grp1_type is record
341: (pos_grp1_flag varchar2(1)

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

334: ,valid_grade per_position_extra_info.poei_information3%type
335: ,target_grade per_position_extra_info.poei_information4%type
336: ,pay_table_id per_position_extra_info.poei_information5%type
337: ,pay_basis per_position_extra_info.poei_information6%type
338: ,employment_category_group per_position_extra_info.poei_information7%type);
339: --
340: type pos_grp1_type is record
341: (pos_grp1_flag varchar2(1)
342: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

Line 342: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

338: ,employment_category_group per_position_extra_info.poei_information7%type);
339: --
340: type pos_grp1_type is record
341: (pos_grp1_flag varchar2(1)
342: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
343: ,object_version_number per_position_extra_info.object_version_number%type
344: ,personnel_office_id per_position_extra_info.poei_information3%type
345: ,office_symbol per_position_extra_info.poei_information4%type
346: ,organization_structure_id per_position_extra_info.poei_information5%type

Line 343: ,object_version_number per_position_extra_info.object_version_number%type

339: --
340: type pos_grp1_type is record
341: (pos_grp1_flag varchar2(1)
342: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
343: ,object_version_number per_position_extra_info.object_version_number%type
344: ,personnel_office_id per_position_extra_info.poei_information3%type
345: ,office_symbol per_position_extra_info.poei_information4%type
346: ,organization_structure_id per_position_extra_info.poei_information5%type
347: ,occupation_category_code per_position_extra_info.poei_information6%type

Line 344: ,personnel_office_id per_position_extra_info.poei_information3%type

340: type pos_grp1_type is record
341: (pos_grp1_flag varchar2(1)
342: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
343: ,object_version_number per_position_extra_info.object_version_number%type
344: ,personnel_office_id per_position_extra_info.poei_information3%type
345: ,office_symbol per_position_extra_info.poei_information4%type
346: ,organization_structure_id per_position_extra_info.poei_information5%type
347: ,occupation_category_code per_position_extra_info.poei_information6%type
348: ,flsa_category per_position_extra_info.poei_information7%type

Line 345: ,office_symbol per_position_extra_info.poei_information4%type

341: (pos_grp1_flag varchar2(1)
342: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
343: ,object_version_number per_position_extra_info.object_version_number%type
344: ,personnel_office_id per_position_extra_info.poei_information3%type
345: ,office_symbol per_position_extra_info.poei_information4%type
346: ,organization_structure_id per_position_extra_info.poei_information5%type
347: ,occupation_category_code per_position_extra_info.poei_information6%type
348: ,flsa_category per_position_extra_info.poei_information7%type
349: ,bargaining_unit_status per_position_extra_info.poei_information8%type

Line 346: ,organization_structure_id per_position_extra_info.poei_information5%type

342: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
343: ,object_version_number per_position_extra_info.object_version_number%type
344: ,personnel_office_id per_position_extra_info.poei_information3%type
345: ,office_symbol per_position_extra_info.poei_information4%type
346: ,organization_structure_id per_position_extra_info.poei_information5%type
347: ,occupation_category_code per_position_extra_info.poei_information6%type
348: ,flsa_category per_position_extra_info.poei_information7%type
349: ,bargaining_unit_status per_position_extra_info.poei_information8%type
350: ,competitive_level per_position_extra_info.poei_information9%type

Line 347: ,occupation_category_code per_position_extra_info.poei_information6%type

343: ,object_version_number per_position_extra_info.object_version_number%type
344: ,personnel_office_id per_position_extra_info.poei_information3%type
345: ,office_symbol per_position_extra_info.poei_information4%type
346: ,organization_structure_id per_position_extra_info.poei_information5%type
347: ,occupation_category_code per_position_extra_info.poei_information6%type
348: ,flsa_category per_position_extra_info.poei_information7%type
349: ,bargaining_unit_status per_position_extra_info.poei_information8%type
350: ,competitive_level per_position_extra_info.poei_information9%type
351: ,work_schedule per_position_extra_info.poei_information10%type

Line 348: ,flsa_category per_position_extra_info.poei_information7%type

344: ,personnel_office_id per_position_extra_info.poei_information3%type
345: ,office_symbol per_position_extra_info.poei_information4%type
346: ,organization_structure_id per_position_extra_info.poei_information5%type
347: ,occupation_category_code per_position_extra_info.poei_information6%type
348: ,flsa_category per_position_extra_info.poei_information7%type
349: ,bargaining_unit_status per_position_extra_info.poei_information8%type
350: ,competitive_level per_position_extra_info.poei_information9%type
351: ,work_schedule per_position_extra_info.poei_information10%type
352: ,functional_class per_position_extra_info.poei_information11%type

Line 349: ,bargaining_unit_status per_position_extra_info.poei_information8%type

345: ,office_symbol per_position_extra_info.poei_information4%type
346: ,organization_structure_id per_position_extra_info.poei_information5%type
347: ,occupation_category_code per_position_extra_info.poei_information6%type
348: ,flsa_category per_position_extra_info.poei_information7%type
349: ,bargaining_unit_status per_position_extra_info.poei_information8%type
350: ,competitive_level per_position_extra_info.poei_information9%type
351: ,work_schedule per_position_extra_info.poei_information10%type
352: ,functional_class per_position_extra_info.poei_information11%type
353: ,position_working_title per_position_extra_info.poei_information12%type

Line 350: ,competitive_level per_position_extra_info.poei_information9%type

346: ,organization_structure_id per_position_extra_info.poei_information5%type
347: ,occupation_category_code per_position_extra_info.poei_information6%type
348: ,flsa_category per_position_extra_info.poei_information7%type
349: ,bargaining_unit_status per_position_extra_info.poei_information8%type
350: ,competitive_level per_position_extra_info.poei_information9%type
351: ,work_schedule per_position_extra_info.poei_information10%type
352: ,functional_class per_position_extra_info.poei_information11%type
353: ,position_working_title per_position_extra_info.poei_information12%type
354: ,position_sensitivity per_position_extra_info.poei_information13%type

Line 351: ,work_schedule per_position_extra_info.poei_information10%type

347: ,occupation_category_code per_position_extra_info.poei_information6%type
348: ,flsa_category per_position_extra_info.poei_information7%type
349: ,bargaining_unit_status per_position_extra_info.poei_information8%type
350: ,competitive_level per_position_extra_info.poei_information9%type
351: ,work_schedule per_position_extra_info.poei_information10%type
352: ,functional_class per_position_extra_info.poei_information11%type
353: ,position_working_title per_position_extra_info.poei_information12%type
354: ,position_sensitivity per_position_extra_info.poei_information13%type
355: ,security_access per_position_extra_info.poei_information14%type

Line 352: ,functional_class per_position_extra_info.poei_information11%type

348: ,flsa_category per_position_extra_info.poei_information7%type
349: ,bargaining_unit_status per_position_extra_info.poei_information8%type
350: ,competitive_level per_position_extra_info.poei_information9%type
351: ,work_schedule per_position_extra_info.poei_information10%type
352: ,functional_class per_position_extra_info.poei_information11%type
353: ,position_working_title per_position_extra_info.poei_information12%type
354: ,position_sensitivity per_position_extra_info.poei_information13%type
355: ,security_access per_position_extra_info.poei_information14%type
356: ,prp_sci per_position_extra_info.poei_information15%type

Line 353: ,position_working_title per_position_extra_info.poei_information12%type

349: ,bargaining_unit_status per_position_extra_info.poei_information8%type
350: ,competitive_level per_position_extra_info.poei_information9%type
351: ,work_schedule per_position_extra_info.poei_information10%type
352: ,functional_class per_position_extra_info.poei_information11%type
353: ,position_working_title per_position_extra_info.poei_information12%type
354: ,position_sensitivity per_position_extra_info.poei_information13%type
355: ,security_access per_position_extra_info.poei_information14%type
356: ,prp_sci per_position_extra_info.poei_information15%type
357: ,supervisory_status per_position_extra_info.poei_information16%type

Line 354: ,position_sensitivity per_position_extra_info.poei_information13%type

350: ,competitive_level per_position_extra_info.poei_information9%type
351: ,work_schedule per_position_extra_info.poei_information10%type
352: ,functional_class per_position_extra_info.poei_information11%type
353: ,position_working_title per_position_extra_info.poei_information12%type
354: ,position_sensitivity per_position_extra_info.poei_information13%type
355: ,security_access per_position_extra_info.poei_information14%type
356: ,prp_sci per_position_extra_info.poei_information15%type
357: ,supervisory_status per_position_extra_info.poei_information16%type
358: ,type_employee_supervised per_position_extra_info.poei_information17%type

Line 355: ,security_access per_position_extra_info.poei_information14%type

351: ,work_schedule per_position_extra_info.poei_information10%type
352: ,functional_class per_position_extra_info.poei_information11%type
353: ,position_working_title per_position_extra_info.poei_information12%type
354: ,position_sensitivity per_position_extra_info.poei_information13%type
355: ,security_access per_position_extra_info.poei_information14%type
356: ,prp_sci per_position_extra_info.poei_information15%type
357: ,supervisory_status per_position_extra_info.poei_information16%type
358: ,type_employee_supervised per_position_extra_info.poei_information17%type
359: ,payroll_office_id per_position_extra_info.poei_information18%type

Line 356: ,prp_sci per_position_extra_info.poei_information15%type

352: ,functional_class per_position_extra_info.poei_information11%type
353: ,position_working_title per_position_extra_info.poei_information12%type
354: ,position_sensitivity per_position_extra_info.poei_information13%type
355: ,security_access per_position_extra_info.poei_information14%type
356: ,prp_sci per_position_extra_info.poei_information15%type
357: ,supervisory_status per_position_extra_info.poei_information16%type
358: ,type_employee_supervised per_position_extra_info.poei_information17%type
359: ,payroll_office_id per_position_extra_info.poei_information18%type
360: ,timekeeper per_position_extra_info.poei_information19%type

Line 357: ,supervisory_status per_position_extra_info.poei_information16%type

353: ,position_working_title per_position_extra_info.poei_information12%type
354: ,position_sensitivity per_position_extra_info.poei_information13%type
355: ,security_access per_position_extra_info.poei_information14%type
356: ,prp_sci per_position_extra_info.poei_information15%type
357: ,supervisory_status per_position_extra_info.poei_information16%type
358: ,type_employee_supervised per_position_extra_info.poei_information17%type
359: ,payroll_office_id per_position_extra_info.poei_information18%type
360: ,timekeeper per_position_extra_info.poei_information19%type
361: ,competitive_area per_position_extra_info.poei_information20%type

Line 358: ,type_employee_supervised per_position_extra_info.poei_information17%type

354: ,position_sensitivity per_position_extra_info.poei_information13%type
355: ,security_access per_position_extra_info.poei_information14%type
356: ,prp_sci per_position_extra_info.poei_information15%type
357: ,supervisory_status per_position_extra_info.poei_information16%type
358: ,type_employee_supervised per_position_extra_info.poei_information17%type
359: ,payroll_office_id per_position_extra_info.poei_information18%type
360: ,timekeeper per_position_extra_info.poei_information19%type
361: ,competitive_area per_position_extra_info.poei_information20%type
362: ,positions_organization per_position_extra_info.poei_information21%type

Line 359: ,payroll_office_id per_position_extra_info.poei_information18%type

355: ,security_access per_position_extra_info.poei_information14%type
356: ,prp_sci per_position_extra_info.poei_information15%type
357: ,supervisory_status per_position_extra_info.poei_information16%type
358: ,type_employee_supervised per_position_extra_info.poei_information17%type
359: ,payroll_office_id per_position_extra_info.poei_information18%type
360: ,timekeeper per_position_extra_info.poei_information19%type
361: ,competitive_area per_position_extra_info.poei_information20%type
362: ,positions_organization per_position_extra_info.poei_information21%type
363: ,oct_report_flag per_position_extra_info.poei_information22%type

Line 360: ,timekeeper per_position_extra_info.poei_information19%type

356: ,prp_sci per_position_extra_info.poei_information15%type
357: ,supervisory_status per_position_extra_info.poei_information16%type
358: ,type_employee_supervised per_position_extra_info.poei_information17%type
359: ,payroll_office_id per_position_extra_info.poei_information18%type
360: ,timekeeper per_position_extra_info.poei_information19%type
361: ,competitive_area per_position_extra_info.poei_information20%type
362: ,positions_organization per_position_extra_info.poei_information21%type
363: ,oct_report_flag per_position_extra_info.poei_information22%type
364: ,part_time_hours per_position_extra_info.poei_information23%type);

Line 361: ,competitive_area per_position_extra_info.poei_information20%type

357: ,supervisory_status per_position_extra_info.poei_information16%type
358: ,type_employee_supervised per_position_extra_info.poei_information17%type
359: ,payroll_office_id per_position_extra_info.poei_information18%type
360: ,timekeeper per_position_extra_info.poei_information19%type
361: ,competitive_area per_position_extra_info.poei_information20%type
362: ,positions_organization per_position_extra_info.poei_information21%type
363: ,oct_report_flag per_position_extra_info.poei_information22%type
364: ,part_time_hours per_position_extra_info.poei_information23%type);
365: --

Line 362: ,positions_organization per_position_extra_info.poei_information21%type

358: ,type_employee_supervised per_position_extra_info.poei_information17%type
359: ,payroll_office_id per_position_extra_info.poei_information18%type
360: ,timekeeper per_position_extra_info.poei_information19%type
361: ,competitive_area per_position_extra_info.poei_information20%type
362: ,positions_organization per_position_extra_info.poei_information21%type
363: ,oct_report_flag per_position_extra_info.poei_information22%type
364: ,part_time_hours per_position_extra_info.poei_information23%type);
365: --
366: type pos_grp2_type is record

Line 363: ,oct_report_flag per_position_extra_info.poei_information22%type

359: ,payroll_office_id per_position_extra_info.poei_information18%type
360: ,timekeeper per_position_extra_info.poei_information19%type
361: ,competitive_area per_position_extra_info.poei_information20%type
362: ,positions_organization per_position_extra_info.poei_information21%type
363: ,oct_report_flag per_position_extra_info.poei_information22%type
364: ,part_time_hours per_position_extra_info.poei_information23%type);
365: --
366: type pos_grp2_type is record
367: (pos_grp2_flag varchar2(1)

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

360: ,timekeeper per_position_extra_info.poei_information19%type
361: ,competitive_area per_position_extra_info.poei_information20%type
362: ,positions_organization per_position_extra_info.poei_information21%type
363: ,oct_report_flag per_position_extra_info.poei_information22%type
364: ,part_time_hours per_position_extra_info.poei_information23%type);
365: --
366: type pos_grp2_type is record
367: (pos_grp2_flag varchar2(1)
368: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

Line 368: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

364: ,part_time_hours per_position_extra_info.poei_information23%type);
365: --
366: type pos_grp2_type is record
367: (pos_grp2_flag varchar2(1)
368: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
369: ,object_version_number per_position_extra_info.object_version_number%type
370: ,position_occupied per_position_extra_info.poei_information3%type
371: ,organization_function_code per_position_extra_info.poei_information4%type
372: ,date_position_classified per_position_extra_info.poei_information5%type

Line 369: ,object_version_number per_position_extra_info.object_version_number%type

365: --
366: type pos_grp2_type is record
367: (pos_grp2_flag varchar2(1)
368: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
369: ,object_version_number per_position_extra_info.object_version_number%type
370: ,position_occupied per_position_extra_info.poei_information3%type
371: ,organization_function_code per_position_extra_info.poei_information4%type
372: ,date_position_classified per_position_extra_info.poei_information5%type
373: ,date_last_position_audit per_position_extra_info.poei_information6%type

Line 370: ,position_occupied per_position_extra_info.poei_information3%type

366: type pos_grp2_type is record
367: (pos_grp2_flag varchar2(1)
368: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
369: ,object_version_number per_position_extra_info.object_version_number%type
370: ,position_occupied per_position_extra_info.poei_information3%type
371: ,organization_function_code per_position_extra_info.poei_information4%type
372: ,date_position_classified per_position_extra_info.poei_information5%type
373: ,date_last_position_audit per_position_extra_info.poei_information6%type
374: ,classification_official per_position_extra_info.poei_information7%type

Line 371: ,organization_function_code per_position_extra_info.poei_information4%type

367: (pos_grp2_flag varchar2(1)
368: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
369: ,object_version_number per_position_extra_info.object_version_number%type
370: ,position_occupied per_position_extra_info.poei_information3%type
371: ,organization_function_code per_position_extra_info.poei_information4%type
372: ,date_position_classified per_position_extra_info.poei_information5%type
373: ,date_last_position_audit per_position_extra_info.poei_information6%type
374: ,classification_official per_position_extra_info.poei_information7%type
375: ,language_required per_position_extra_info.poei_information8%type

Line 372: ,date_position_classified per_position_extra_info.poei_information5%type

368: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
369: ,object_version_number per_position_extra_info.object_version_number%type
370: ,position_occupied per_position_extra_info.poei_information3%type
371: ,organization_function_code per_position_extra_info.poei_information4%type
372: ,date_position_classified per_position_extra_info.poei_information5%type
373: ,date_last_position_audit per_position_extra_info.poei_information6%type
374: ,classification_official per_position_extra_info.poei_information7%type
375: ,language_required per_position_extra_info.poei_information8%type
376: ,drug_test per_position_extra_info.poei_information9%type

Line 373: ,date_last_position_audit per_position_extra_info.poei_information6%type

369: ,object_version_number per_position_extra_info.object_version_number%type
370: ,position_occupied per_position_extra_info.poei_information3%type
371: ,organization_function_code per_position_extra_info.poei_information4%type
372: ,date_position_classified per_position_extra_info.poei_information5%type
373: ,date_last_position_audit per_position_extra_info.poei_information6%type
374: ,classification_official per_position_extra_info.poei_information7%type
375: ,language_required per_position_extra_info.poei_information8%type
376: ,drug_test per_position_extra_info.poei_information9%type
377: ,financial_statement per_position_extra_info.poei_information10%type

Line 374: ,classification_official per_position_extra_info.poei_information7%type

370: ,position_occupied per_position_extra_info.poei_information3%type
371: ,organization_function_code per_position_extra_info.poei_information4%type
372: ,date_position_classified per_position_extra_info.poei_information5%type
373: ,date_last_position_audit per_position_extra_info.poei_information6%type
374: ,classification_official per_position_extra_info.poei_information7%type
375: ,language_required per_position_extra_info.poei_information8%type
376: ,drug_test per_position_extra_info.poei_information9%type
377: ,financial_statement per_position_extra_info.poei_information10%type
378: ,training_program_id per_position_extra_info.poei_information11%type

Line 375: ,language_required per_position_extra_info.poei_information8%type

371: ,organization_function_code per_position_extra_info.poei_information4%type
372: ,date_position_classified per_position_extra_info.poei_information5%type
373: ,date_last_position_audit per_position_extra_info.poei_information6%type
374: ,classification_official per_position_extra_info.poei_information7%type
375: ,language_required per_position_extra_info.poei_information8%type
376: ,drug_test per_position_extra_info.poei_information9%type
377: ,financial_statement per_position_extra_info.poei_information10%type
378: ,training_program_id per_position_extra_info.poei_information11%type
379: ,key_emergency_essential per_position_extra_info.poei_information12%type

Line 376: ,drug_test per_position_extra_info.poei_information9%type

372: ,date_position_classified per_position_extra_info.poei_information5%type
373: ,date_last_position_audit per_position_extra_info.poei_information6%type
374: ,classification_official per_position_extra_info.poei_information7%type
375: ,language_required per_position_extra_info.poei_information8%type
376: ,drug_test per_position_extra_info.poei_information9%type
377: ,financial_statement per_position_extra_info.poei_information10%type
378: ,training_program_id per_position_extra_info.poei_information11%type
379: ,key_emergency_essential per_position_extra_info.poei_information12%type
380: ,appropriation_code1 per_position_extra_info.poei_information13%type

Line 377: ,financial_statement per_position_extra_info.poei_information10%type

373: ,date_last_position_audit per_position_extra_info.poei_information6%type
374: ,classification_official per_position_extra_info.poei_information7%type
375: ,language_required per_position_extra_info.poei_information8%type
376: ,drug_test per_position_extra_info.poei_information9%type
377: ,financial_statement per_position_extra_info.poei_information10%type
378: ,training_program_id per_position_extra_info.poei_information11%type
379: ,key_emergency_essential per_position_extra_info.poei_information12%type
380: ,appropriation_code1 per_position_extra_info.poei_information13%type
381: ,appropriation_code2 per_position_extra_info.poei_information14%type

Line 378: ,training_program_id per_position_extra_info.poei_information11%type

374: ,classification_official per_position_extra_info.poei_information7%type
375: ,language_required per_position_extra_info.poei_information8%type
376: ,drug_test per_position_extra_info.poei_information9%type
377: ,financial_statement per_position_extra_info.poei_information10%type
378: ,training_program_id per_position_extra_info.poei_information11%type
379: ,key_emergency_essential per_position_extra_info.poei_information12%type
380: ,appropriation_code1 per_position_extra_info.poei_information13%type
381: ,appropriation_code2 per_position_extra_info.poei_information14%type
382: ,intelligence_position_ind per_position_extra_info.poei_information15%type

Line 379: ,key_emergency_essential per_position_extra_info.poei_information12%type

375: ,language_required per_position_extra_info.poei_information8%type
376: ,drug_test per_position_extra_info.poei_information9%type
377: ,financial_statement per_position_extra_info.poei_information10%type
378: ,training_program_id per_position_extra_info.poei_information11%type
379: ,key_emergency_essential per_position_extra_info.poei_information12%type
380: ,appropriation_code1 per_position_extra_info.poei_information13%type
381: ,appropriation_code2 per_position_extra_info.poei_information14%type
382: ,intelligence_position_ind per_position_extra_info.poei_information15%type
383: ,leo_position_indicator per_position_extra_info.poei_information16%type);

Line 380: ,appropriation_code1 per_position_extra_info.poei_information13%type

376: ,drug_test per_position_extra_info.poei_information9%type
377: ,financial_statement per_position_extra_info.poei_information10%type
378: ,training_program_id per_position_extra_info.poei_information11%type
379: ,key_emergency_essential per_position_extra_info.poei_information12%type
380: ,appropriation_code1 per_position_extra_info.poei_information13%type
381: ,appropriation_code2 per_position_extra_info.poei_information14%type
382: ,intelligence_position_ind per_position_extra_info.poei_information15%type
383: ,leo_position_indicator per_position_extra_info.poei_information16%type);
384: --

Line 381: ,appropriation_code2 per_position_extra_info.poei_information14%type

377: ,financial_statement per_position_extra_info.poei_information10%type
378: ,training_program_id per_position_extra_info.poei_information11%type
379: ,key_emergency_essential per_position_extra_info.poei_information12%type
380: ,appropriation_code1 per_position_extra_info.poei_information13%type
381: ,appropriation_code2 per_position_extra_info.poei_information14%type
382: ,intelligence_position_ind per_position_extra_info.poei_information15%type
383: ,leo_position_indicator per_position_extra_info.poei_information16%type);
384: --
385: -- type pos_of8_type is record

Line 382: ,intelligence_position_ind per_position_extra_info.poei_information15%type

378: ,training_program_id per_position_extra_info.poei_information11%type
379: ,key_emergency_essential per_position_extra_info.poei_information12%type
380: ,appropriation_code1 per_position_extra_info.poei_information13%type
381: ,appropriation_code2 per_position_extra_info.poei_information14%type
382: ,intelligence_position_ind per_position_extra_info.poei_information15%type
383: ,leo_position_indicator per_position_extra_info.poei_information16%type);
384: --
385: -- type pos_of8_type is record
386: -- (pos_of8_flag varchar2(1)

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

379: ,key_emergency_essential per_position_extra_info.poei_information12%type
380: ,appropriation_code1 per_position_extra_info.poei_information13%type
381: ,appropriation_code2 per_position_extra_info.poei_information14%type
382: ,intelligence_position_ind per_position_extra_info.poei_information15%type
383: ,leo_position_indicator per_position_extra_info.poei_information16%type);
384: --
385: -- type pos_of8_type is record
386: -- (pos_of8_flag varchar2(1)
387: -- ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

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

383: ,leo_position_indicator per_position_extra_info.poei_information16%type);
384: --
385: -- type pos_of8_type is record
386: -- (pos_of8_flag varchar2(1)
387: -- ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
388: -- ,object_version_number per_position_extra_info.object_version_number%type
389: -- ,reason_for_submission per_position_extra_info.poei_information3%type
390: -- ,service_location per_position_extra_info.poei_information4%type
391: -- ,cs_certification_number per_position_extra_info.poei_information5%type

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

384: --
385: -- type pos_of8_type is record
386: -- (pos_of8_flag varchar2(1)
387: -- ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
388: -- ,object_version_number per_position_extra_info.object_version_number%type
389: -- ,reason_for_submission per_position_extra_info.poei_information3%type
390: -- ,service_location per_position_extra_info.poei_information4%type
391: -- ,cs_certification_number per_position_extra_info.poei_information5%type
392: -- ,classified_grade_by per_position_extra_info.poei_information6%type

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

385: -- type pos_of8_type is record
386: -- (pos_of8_flag varchar2(1)
387: -- ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
388: -- ,object_version_number per_position_extra_info.object_version_number%type
389: -- ,reason_for_submission per_position_extra_info.poei_information3%type
390: -- ,service_location per_position_extra_info.poei_information4%type
391: -- ,cs_certification_number per_position_extra_info.poei_information5%type
392: -- ,classified_grade_by per_position_extra_info.poei_information6%type
393: -- ,classification_standard_used per_position_extra_info.poei_information7%type

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

386: -- (pos_of8_flag varchar2(1)
387: -- ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
388: -- ,object_version_number per_position_extra_info.object_version_number%type
389: -- ,reason_for_submission per_position_extra_info.poei_information3%type
390: -- ,service_location per_position_extra_info.poei_information4%type
391: -- ,cs_certification_number per_position_extra_info.poei_information5%type
392: -- ,classified_grade_by per_position_extra_info.poei_information6%type
393: -- ,classification_standard_used per_position_extra_info.poei_information7%type
394: -- ,classification_standard_date per_position_extra_info.poei_information8%type

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

387: -- ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
388: -- ,object_version_number per_position_extra_info.object_version_number%type
389: -- ,reason_for_submission per_position_extra_info.poei_information3%type
390: -- ,service_location per_position_extra_info.poei_information4%type
391: -- ,cs_certification_number per_position_extra_info.poei_information5%type
392: -- ,classified_grade_by per_position_extra_info.poei_information6%type
393: -- ,classification_standard_used per_position_extra_info.poei_information7%type
394: -- ,classification_standard_date per_position_extra_info.poei_information8%type
395: -- ,subject_to_ia_action per_position_extra_info.poei_information9%type);

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

388: -- ,object_version_number per_position_extra_info.object_version_number%type
389: -- ,reason_for_submission per_position_extra_info.poei_information3%type
390: -- ,service_location per_position_extra_info.poei_information4%type
391: -- ,cs_certification_number per_position_extra_info.poei_information5%type
392: -- ,classified_grade_by per_position_extra_info.poei_information6%type
393: -- ,classification_standard_used per_position_extra_info.poei_information7%type
394: -- ,classification_standard_date per_position_extra_info.poei_information8%type
395: -- ,subject_to_ia_action per_position_extra_info.poei_information9%type);
396: --

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

389: -- ,reason_for_submission per_position_extra_info.poei_information3%type
390: -- ,service_location per_position_extra_info.poei_information4%type
391: -- ,cs_certification_number per_position_extra_info.poei_information5%type
392: -- ,classified_grade_by per_position_extra_info.poei_information6%type
393: -- ,classification_standard_used per_position_extra_info.poei_information7%type
394: -- ,classification_standard_date per_position_extra_info.poei_information8%type
395: -- ,subject_to_ia_action per_position_extra_info.poei_information9%type);
396: --
397: type pos_oblig_type is record

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

390: -- ,service_location per_position_extra_info.poei_information4%type
391: -- ,cs_certification_number per_position_extra_info.poei_information5%type
392: -- ,classified_grade_by per_position_extra_info.poei_information6%type
393: -- ,classification_standard_used per_position_extra_info.poei_information7%type
394: -- ,classification_standard_date per_position_extra_info.poei_information8%type
395: -- ,subject_to_ia_action per_position_extra_info.poei_information9%type);
396: --
397: type pos_oblig_type is record
398: (pos_oblig_flag varchar2(1)

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

391: -- ,cs_certification_number per_position_extra_info.poei_information5%type
392: -- ,classified_grade_by per_position_extra_info.poei_information6%type
393: -- ,classification_standard_used per_position_extra_info.poei_information7%type
394: -- ,classification_standard_date per_position_extra_info.poei_information8%type
395: -- ,subject_to_ia_action per_position_extra_info.poei_information9%type);
396: --
397: type pos_oblig_type is record
398: (pos_oblig_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: -- ,subject_to_ia_action per_position_extra_info.poei_information9%type);
396: --
397: type pos_oblig_type is record
398: (pos_oblig_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: ,expiration_date per_position_extra_info.poei_information3%type
402: ,obligation_type per_position_extra_info.poei_information4%type
403: ,employee_ssn per_position_extra_info.poei_information5%type);

Line 400: ,object_version_number per_position_extra_info.object_version_number%type

396: --
397: type pos_oblig_type is record
398: (pos_oblig_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: ,expiration_date per_position_extra_info.poei_information3%type
402: ,obligation_type per_position_extra_info.poei_information4%type
403: ,employee_ssn per_position_extra_info.poei_information5%type);
404: --

Line 401: ,expiration_date per_position_extra_info.poei_information3%type

397: type pos_oblig_type is record
398: (pos_oblig_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: ,expiration_date per_position_extra_info.poei_information3%type
402: ,obligation_type per_position_extra_info.poei_information4%type
403: ,employee_ssn per_position_extra_info.poei_information5%type);
404: --
405: type pos_car_prog_type is record

Line 402: ,obligation_type per_position_extra_info.poei_information4%type

398: (pos_oblig_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: ,expiration_date per_position_extra_info.poei_information3%type
402: ,obligation_type per_position_extra_info.poei_information4%type
403: ,employee_ssn per_position_extra_info.poei_information5%type);
404: --
405: type pos_car_prog_type is record
406: (pos_car_prog_flag varchar2(1)

Line 403: ,employee_ssn 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: ,expiration_date per_position_extra_info.poei_information3%type
402: ,obligation_type per_position_extra_info.poei_information4%type
403: ,employee_ssn per_position_extra_info.poei_information5%type);
404: --
405: type pos_car_prog_type is record
406: (pos_car_prog_flag varchar2(1)
407: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

Line 407: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type

403: ,employee_ssn per_position_extra_info.poei_information5%type);
404: --
405: type pos_car_prog_type is record
406: (pos_car_prog_flag varchar2(1)
407: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
408: ,object_version_number per_position_extra_info.object_version_number%type
409: ,career_program_id per_position_extra_info.poei_information3%type
410: ,career_program_type per_position_extra_info.poei_information4%type
411: ,change_reasons per_position_extra_info.poei_information5%type

Line 408: ,object_version_number per_position_extra_info.object_version_number%type

404: --
405: type pos_car_prog_type is record
406: (pos_car_prog_flag varchar2(1)
407: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
408: ,object_version_number per_position_extra_info.object_version_number%type
409: ,career_program_id per_position_extra_info.poei_information3%type
410: ,career_program_type per_position_extra_info.poei_information4%type
411: ,change_reasons per_position_extra_info.poei_information5%type
412: ,career_field_id per_position_extra_info.poei_information6%type

Line 409: ,career_program_id per_position_extra_info.poei_information3%type

405: type pos_car_prog_type is record
406: (pos_car_prog_flag varchar2(1)
407: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
408: ,object_version_number per_position_extra_info.object_version_number%type
409: ,career_program_id per_position_extra_info.poei_information3%type
410: ,career_program_type per_position_extra_info.poei_information4%type
411: ,change_reasons per_position_extra_info.poei_information5%type
412: ,career_field_id per_position_extra_info.poei_information6%type
413: ,career_program_code per_position_extra_info.poei_information7%type

Line 410: ,career_program_type per_position_extra_info.poei_information4%type

406: (pos_car_prog_flag varchar2(1)
407: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
408: ,object_version_number per_position_extra_info.object_version_number%type
409: ,career_program_id per_position_extra_info.poei_information3%type
410: ,career_program_type per_position_extra_info.poei_information4%type
411: ,change_reasons per_position_extra_info.poei_information5%type
412: ,career_field_id per_position_extra_info.poei_information6%type
413: ,career_program_code per_position_extra_info.poei_information7%type
414: ,acteds_key_position per_position_extra_info.poei_information8%type);

Line 411: ,change_reasons per_position_extra_info.poei_information5%type

407: ,position_extra_info_id per_position_extra_info.position_extra_info_id%type
408: ,object_version_number per_position_extra_info.object_version_number%type
409: ,career_program_id per_position_extra_info.poei_information3%type
410: ,career_program_type per_position_extra_info.poei_information4%type
411: ,change_reasons per_position_extra_info.poei_information5%type
412: ,career_field_id per_position_extra_info.poei_information6%type
413: ,career_program_code per_position_extra_info.poei_information7%type
414: ,acteds_key_position per_position_extra_info.poei_information8%type);
415: --

Line 412: ,career_field_id per_position_extra_info.poei_information6%type

408: ,object_version_number per_position_extra_info.object_version_number%type
409: ,career_program_id per_position_extra_info.poei_information3%type
410: ,career_program_type per_position_extra_info.poei_information4%type
411: ,change_reasons per_position_extra_info.poei_information5%type
412: ,career_field_id per_position_extra_info.poei_information6%type
413: ,career_program_code per_position_extra_info.poei_information7%type
414: ,acteds_key_position per_position_extra_info.poei_information8%type);
415: --
416: type personal_info_type is record

Line 413: ,career_program_code per_position_extra_info.poei_information7%type

409: ,career_program_id per_position_extra_info.poei_information3%type
410: ,career_program_type per_position_extra_info.poei_information4%type
411: ,change_reasons per_position_extra_info.poei_information5%type
412: ,career_field_id per_position_extra_info.poei_information6%type
413: ,career_program_code per_position_extra_info.poei_information7%type
414: ,acteds_key_position per_position_extra_info.poei_information8%type);
415: --
416: type personal_info_type is record
417: (p_national_identifier per_people_f.national_identifier%type

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

410: ,career_program_type per_position_extra_info.poei_information4%type
411: ,change_reasons per_position_extra_info.poei_information5%type
412: ,career_field_id per_position_extra_info.poei_information6%type
413: ,career_program_code per_position_extra_info.poei_information7%type
414: ,acteds_key_position per_position_extra_info.poei_information8%type);
415: --
416: type personal_info_type is record
417: (p_national_identifier per_people_f.national_identifier%type
418: ,p_date_of_birth per_people_f.date_of_birth%type

Line 430: ,pay_basis per_position_extra_info.poei_information6%type

426: ,occ_code per_job_definitions.segment1%type
427: ,grade_or_level per_grade_definitions.segment2%type
428: ,step_or_rate per_assignment_extra_info.aei_information3%type
429: ,total_salary number
430: ,pay_basis per_position_extra_info.poei_information6%type
431: ,basic_pay number
432: ,locality_adj number
433: ,adj_basic_pay number
434: ,other_pay number

Line 583: ( career_category per_position_extra_info.poei_information8%type

579: ,object_version_number per_person_analyses.object_version_number%type );
580:
581:
582: type civ_position_acquisition is record
583: ( career_category per_position_extra_info.poei_information8%type
584: ,critical_position per_position_extra_info.poei_information5%type
585: ,civ_func_acct_shred per_position_extra_info.poei_information7%type
586: ,psn_status_ind per_position_extra_info.poei_information4%type
587: );

Line 584: ,critical_position per_position_extra_info.poei_information5%type

580:
581:
582: type civ_position_acquisition is record
583: ( career_category per_position_extra_info.poei_information8%type
584: ,critical_position per_position_extra_info.poei_information5%type
585: ,civ_func_acct_shred per_position_extra_info.poei_information7%type
586: ,psn_status_ind per_position_extra_info.poei_information4%type
587: );
588:

Line 585: ,civ_func_acct_shred per_position_extra_info.poei_information7%type

581:
582: type civ_position_acquisition is record
583: ( career_category per_position_extra_info.poei_information8%type
584: ,critical_position per_position_extra_info.poei_information5%type
585: ,civ_func_acct_shred per_position_extra_info.poei_information7%type
586: ,psn_status_ind per_position_extra_info.poei_information4%type
587: );
588:
589: type civ_position_army_appr_ln is record

Line 586: ,psn_status_ind per_position_extra_info.poei_information4%type

582: type civ_position_acquisition is record
583: ( career_category per_position_extra_info.poei_information8%type
584: ,critical_position per_position_extra_info.poei_information5%type
585: ,civ_func_acct_shred per_position_extra_info.poei_information7%type
586: ,psn_status_ind per_position_extra_info.poei_information4%type
587: );
588:
589: type civ_position_army_appr_ln is record
590: (

Line 591: amscd per_position_extra_info.poei_information11%type

587: );
588:
589: type civ_position_army_appr_ln is record
590: (
591: amscd per_position_extra_info.poei_information11%type
592: ,ar_tda_line_num per_position_extra_info.poei_information3%type
593: ,competitive_area per_position_extra_info.poei_information4%type
594: ,duty_stn_st per_position_extra_info.poei_information16%type
595: ,func_desc per_position_extra_info.poei_information2%type

Line 592: ,ar_tda_line_num per_position_extra_info.poei_information3%type

588:
589: type civ_position_army_appr_ln is record
590: (
591: amscd per_position_extra_info.poei_information11%type
592: ,ar_tda_line_num per_position_extra_info.poei_information3%type
593: ,competitive_area per_position_extra_info.poei_information4%type
594: ,duty_stn_st per_position_extra_info.poei_information16%type
595: ,func_desc per_position_extra_info.poei_information2%type
596: ,tda_para_num per_position_extra_info.poei_information5%type

Line 593: ,competitive_area per_position_extra_info.poei_information4%type

589: type civ_position_army_appr_ln is record
590: (
591: amscd per_position_extra_info.poei_information11%type
592: ,ar_tda_line_num per_position_extra_info.poei_information3%type
593: ,competitive_area per_position_extra_info.poei_information4%type
594: ,duty_stn_st per_position_extra_info.poei_information16%type
595: ,func_desc per_position_extra_info.poei_information2%type
596: ,tda_para_num per_position_extra_info.poei_information5%type
597: );

Line 594: ,duty_stn_st per_position_extra_info.poei_information16%type

590: (
591: amscd per_position_extra_info.poei_information11%type
592: ,ar_tda_line_num per_position_extra_info.poei_information3%type
593: ,competitive_area per_position_extra_info.poei_information4%type
594: ,duty_stn_st per_position_extra_info.poei_information16%type
595: ,func_desc per_position_extra_info.poei_information2%type
596: ,tda_para_num per_position_extra_info.poei_information5%type
597: );
598:

Line 595: ,func_desc per_position_extra_info.poei_information2%type

591: amscd per_position_extra_info.poei_information11%type
592: ,ar_tda_line_num per_position_extra_info.poei_information3%type
593: ,competitive_area per_position_extra_info.poei_information4%type
594: ,duty_stn_st per_position_extra_info.poei_information16%type
595: ,func_desc per_position_extra_info.poei_information2%type
596: ,tda_para_num per_position_extra_info.poei_information5%type
597: );
598:
599: type civ_position_naf is record

Line 596: ,tda_para_num per_position_extra_info.poei_information5%type

592: ,ar_tda_line_num per_position_extra_info.poei_information3%type
593: ,competitive_area per_position_extra_info.poei_information4%type
594: ,duty_stn_st per_position_extra_info.poei_information16%type
595: ,func_desc per_position_extra_info.poei_information2%type
596: ,tda_para_num per_position_extra_info.poei_information5%type
597: );
598:
599: type civ_position_naf is record
600: (

Line 601: med_ind per_position_extra_info.poei_information12%type

597: );
598:
599: type civ_position_naf is record
600: (
601: med_ind per_position_extra_info.poei_information12%type
602: ,nafi_psn_num per_position_extra_info.poei_information10%type
603: ,svc_offc_symbol per_position_extra_info.poei_information4%type
604: );
605:

Line 602: ,nafi_psn_num per_position_extra_info.poei_information10%type

598:
599: type civ_position_naf is record
600: (
601: med_ind per_position_extra_info.poei_information12%type
602: ,nafi_psn_num per_position_extra_info.poei_information10%type
603: ,svc_offc_symbol per_position_extra_info.poei_information4%type
604: );
605:
606: -- added by skutteti on 3-mar-98

Line 603: ,svc_offc_symbol per_position_extra_info.poei_information4%type

599: type civ_position_naf is record
600: (
601: med_ind per_position_extra_info.poei_information12%type
602: ,nafi_psn_num per_position_extra_info.poei_information10%type
603: ,svc_offc_symbol per_position_extra_info.poei_information4%type
604: );
605:
606: -- added by skutteti on 3-mar-98
607: type par_term_retained_grade_type is record