eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_QH_POPULATE dependencies on PER_ALL_ASSIGNMENTS_F

Line 305: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type

301: --
302: procedure get_bg_defaults
303: (p_business_group_id IN per_business_groups.business_group_id%type
304: ,p_defaulting IN varchar2
305: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type
306: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
307: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
308: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
309: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

Line 306: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type

302: procedure get_bg_defaults
303: (p_business_group_id IN per_business_groups.business_group_id%type
304: ,p_defaulting IN varchar2
305: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type
306: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
307: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
308: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
309: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
310: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

Line 307: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type

303: (p_business_group_id IN per_business_groups.business_group_id%type
304: ,p_defaulting IN varchar2
305: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type
306: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
307: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
308: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
309: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
310: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
311: ,p_location OUT NOCOPY hr_locations.location_code%type

Line 308: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type

304: ,p_defaulting IN varchar2
305: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type
306: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
307: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
308: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
309: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
310: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
311: ,p_location OUT NOCOPY hr_locations.location_code%type
312: ,p_gre OUT NOCOPY hr_soft_coding_keyflex.segment1%type

Line 310: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

306: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
307: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
308: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
309: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
310: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
311: ,p_location OUT NOCOPY hr_locations.location_code%type
312: ,p_gre OUT NOCOPY hr_soft_coding_keyflex.segment1%type
313: ) is
314: --

Line 317: l_location_id per_all_assignments_f.location_id%type;

313: ) is
314: --
315: l_proc varchar2(72) :=g_package||'get_bg_defaults';
316: l_normal_hours varchar2(150);
317: l_location_id per_all_assignments_f.location_id%type;
318: --
319: cursor get_work_day_information is
320: select org_information1
321: , org_information2

Line 384: (p_position_id IN per_all_assignments_f.position_id%type

380: -- |--------------------------< get_pos_defaults >----------------------------|
381: -- ----------------------------------------------------------------------------
382: --
383: procedure get_pos_defaults
384: (p_position_id IN per_all_assignments_f.position_id%type
385: ,p_effective_date IN date
386: ,p_defaulting IN varchar2
387: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
388: ,p_organization OUT NOCOPY hr_organization_units.name%type

Line 387: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type

383: procedure get_pos_defaults
384: (p_position_id IN per_all_assignments_f.position_id%type
385: ,p_effective_date IN date
386: ,p_defaulting IN varchar2
387: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
388: ,p_organization OUT NOCOPY hr_organization_units.name%type
389: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
390: ,p_job OUT NOCOPY per_jobs.name%type
391: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type

Line 389: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type

385: ,p_effective_date IN date
386: ,p_defaulting IN varchar2
387: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
388: ,p_organization OUT NOCOPY hr_organization_units.name%type
389: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
390: ,p_job OUT NOCOPY per_jobs.name%type
391: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
392: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
393: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type

Line 393: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type

389: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
390: ,p_job OUT NOCOPY per_jobs.name%type
391: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
392: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
393: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
394: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
395: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
396: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
397: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

Line 394: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type

390: ,p_job OUT NOCOPY per_jobs.name%type
391: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
392: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
393: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
394: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
395: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
396: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
397: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
398: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

Line 395: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type

391: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
392: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
393: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
394: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
395: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
396: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
397: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
398: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
399: ,p_location OUT NOCOPY hr_locations.location_code%type

Line 396: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type

392: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
393: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
394: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
395: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
396: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
397: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
398: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
399: ,p_location OUT NOCOPY hr_locations.location_code%type
400: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

Line 398: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

394: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
395: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
396: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
397: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
398: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
399: ,p_location OUT NOCOPY hr_locations.location_code%type
400: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
401: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
402: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type

Line 400: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

396: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
397: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
398: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
399: ,p_location OUT NOCOPY hr_locations.location_code%type
400: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
401: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
402: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
403: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
404: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type

Line 401: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type

397: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
398: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
399: ,p_location OUT NOCOPY hr_locations.location_code%type
400: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
401: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
402: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
403: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
404: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
405: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type

Line 403: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type

399: ,p_location OUT NOCOPY hr_locations.location_code%type
400: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
401: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
402: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
403: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
404: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
405: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
406: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
407: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

Line 407: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

403: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
404: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
405: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
406: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
407: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
408: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
409: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
410: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
411: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type

Line 409: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type

405: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
406: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
407: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
408: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
409: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
410: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
411: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
412: ,p_grade OUT NOCOPY per_grades.name%type
413: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type

Line 411: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type

407: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
408: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
409: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
410: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
411: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
412: ,p_grade OUT NOCOPY per_grades.name%type
413: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
414: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
415: ) is

Line 413: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type

409: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
410: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
411: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
412: ,p_grade OUT NOCOPY per_grades.name%type
413: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
414: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
415: ) is
416: --
417: l_proc varchar2(72) :=g_package||'get_pos_defaults';

Line 418: l_position_id per_all_assignments_f.position_id%type;

414: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
415: ) is
416: --
417: l_proc varchar2(72) :=g_package||'get_pos_defaults';
418: l_position_id per_all_assignments_f.position_id%type;
419: l_organization_id per_all_assignments_f.organization_id%type;
420: l_old_organization_id per_all_assignments_f.organization_id%type;
421: l_job_id per_all_assignments_f.job_id%type;
422: l_time_normal_start per_all_assignments_f.time_normal_start%type;

Line 419: l_organization_id per_all_assignments_f.organization_id%type;

415: ) is
416: --
417: l_proc varchar2(72) :=g_package||'get_pos_defaults';
418: l_position_id per_all_assignments_f.position_id%type;
419: l_organization_id per_all_assignments_f.organization_id%type;
420: l_old_organization_id per_all_assignments_f.organization_id%type;
421: l_job_id per_all_assignments_f.job_id%type;
422: l_time_normal_start per_all_assignments_f.time_normal_start%type;
423: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;

Line 420: l_old_organization_id per_all_assignments_f.organization_id%type;

416: --
417: l_proc varchar2(72) :=g_package||'get_pos_defaults';
418: l_position_id per_all_assignments_f.position_id%type;
419: l_organization_id per_all_assignments_f.organization_id%type;
420: l_old_organization_id per_all_assignments_f.organization_id%type;
421: l_job_id per_all_assignments_f.job_id%type;
422: l_time_normal_start per_all_assignments_f.time_normal_start%type;
423: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
424: l_normal_hours per_all_assignments_f.normal_hours%type;

Line 421: l_job_id per_all_assignments_f.job_id%type;

417: l_proc varchar2(72) :=g_package||'get_pos_defaults';
418: l_position_id per_all_assignments_f.position_id%type;
419: l_organization_id per_all_assignments_f.organization_id%type;
420: l_old_organization_id per_all_assignments_f.organization_id%type;
421: l_job_id per_all_assignments_f.job_id%type;
422: l_time_normal_start per_all_assignments_f.time_normal_start%type;
423: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
424: l_normal_hours per_all_assignments_f.normal_hours%type;
425: l_frequency per_all_assignments_f.frequency%type;

Line 422: l_time_normal_start per_all_assignments_f.time_normal_start%type;

418: l_position_id per_all_assignments_f.position_id%type;
419: l_organization_id per_all_assignments_f.organization_id%type;
420: l_old_organization_id per_all_assignments_f.organization_id%type;
421: l_job_id per_all_assignments_f.job_id%type;
422: l_time_normal_start per_all_assignments_f.time_normal_start%type;
423: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
424: l_normal_hours per_all_assignments_f.normal_hours%type;
425: l_frequency per_all_assignments_f.frequency%type;
426: l_location_id per_all_assignments_f.location_id%type;

Line 423: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;

419: l_organization_id per_all_assignments_f.organization_id%type;
420: l_old_organization_id per_all_assignments_f.organization_id%type;
421: l_job_id per_all_assignments_f.job_id%type;
422: l_time_normal_start per_all_assignments_f.time_normal_start%type;
423: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
424: l_normal_hours per_all_assignments_f.normal_hours%type;
425: l_frequency per_all_assignments_f.frequency%type;
426: l_location_id per_all_assignments_f.location_id%type;
427: l_probation_period per_all_assignments_f.probation_period%type;

Line 424: l_normal_hours per_all_assignments_f.normal_hours%type;

420: l_old_organization_id per_all_assignments_f.organization_id%type;
421: l_job_id per_all_assignments_f.job_id%type;
422: l_time_normal_start per_all_assignments_f.time_normal_start%type;
423: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
424: l_normal_hours per_all_assignments_f.normal_hours%type;
425: l_frequency per_all_assignments_f.frequency%type;
426: l_location_id per_all_assignments_f.location_id%type;
427: l_probation_period per_all_assignments_f.probation_period%type;
428: l_probation_unit per_all_assignments_f.probation_unit%type;

Line 425: l_frequency per_all_assignments_f.frequency%type;

421: l_job_id per_all_assignments_f.job_id%type;
422: l_time_normal_start per_all_assignments_f.time_normal_start%type;
423: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
424: l_normal_hours per_all_assignments_f.normal_hours%type;
425: l_frequency per_all_assignments_f.frequency%type;
426: l_location_id per_all_assignments_f.location_id%type;
427: l_probation_period per_all_assignments_f.probation_period%type;
428: l_probation_unit per_all_assignments_f.probation_unit%type;
429: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;

Line 426: l_location_id per_all_assignments_f.location_id%type;

422: l_time_normal_start per_all_assignments_f.time_normal_start%type;
423: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
424: l_normal_hours per_all_assignments_f.normal_hours%type;
425: l_frequency per_all_assignments_f.frequency%type;
426: l_location_id per_all_assignments_f.location_id%type;
427: l_probation_period per_all_assignments_f.probation_period%type;
428: l_probation_unit per_all_assignments_f.probation_unit%type;
429: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
430: l_payroll_id per_all_assignments_f.payroll_id%type;

Line 427: l_probation_period per_all_assignments_f.probation_period%type;

423: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
424: l_normal_hours per_all_assignments_f.normal_hours%type;
425: l_frequency per_all_assignments_f.frequency%type;
426: l_location_id per_all_assignments_f.location_id%type;
427: l_probation_period per_all_assignments_f.probation_period%type;
428: l_probation_unit per_all_assignments_f.probation_unit%type;
429: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
430: l_payroll_id per_all_assignments_f.payroll_id%type;
431: l_supervisor_id per_all_assignments_f.supervisor_id%type;

Line 428: l_probation_unit per_all_assignments_f.probation_unit%type;

424: l_normal_hours per_all_assignments_f.normal_hours%type;
425: l_frequency per_all_assignments_f.frequency%type;
426: l_location_id per_all_assignments_f.location_id%type;
427: l_probation_period per_all_assignments_f.probation_period%type;
428: l_probation_unit per_all_assignments_f.probation_unit%type;
429: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
430: l_payroll_id per_all_assignments_f.payroll_id%type;
431: l_supervisor_id per_all_assignments_f.supervisor_id%type;
432: l_grade_id per_all_assignments_f.grade_id%type;

Line 429: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;

425: l_frequency per_all_assignments_f.frequency%type;
426: l_location_id per_all_assignments_f.location_id%type;
427: l_probation_period per_all_assignments_f.probation_period%type;
428: l_probation_unit per_all_assignments_f.probation_unit%type;
429: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
430: l_payroll_id per_all_assignments_f.payroll_id%type;
431: l_supervisor_id per_all_assignments_f.supervisor_id%type;
432: l_grade_id per_all_assignments_f.grade_id%type;
433: l_frequency_meaning hr_lookups.meaning%type;

Line 430: l_payroll_id per_all_assignments_f.payroll_id%type;

426: l_location_id per_all_assignments_f.location_id%type;
427: l_probation_period per_all_assignments_f.probation_period%type;
428: l_probation_unit per_all_assignments_f.probation_unit%type;
429: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
430: l_payroll_id per_all_assignments_f.payroll_id%type;
431: l_supervisor_id per_all_assignments_f.supervisor_id%type;
432: l_grade_id per_all_assignments_f.grade_id%type;
433: l_frequency_meaning hr_lookups.meaning%type;
434: l_location hr_locations.location_code%type;

Line 431: l_supervisor_id per_all_assignments_f.supervisor_id%type;

427: l_probation_period per_all_assignments_f.probation_period%type;
428: l_probation_unit per_all_assignments_f.probation_unit%type;
429: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
430: l_payroll_id per_all_assignments_f.payroll_id%type;
431: l_supervisor_id per_all_assignments_f.supervisor_id%type;
432: l_grade_id per_all_assignments_f.grade_id%type;
433: l_frequency_meaning hr_lookups.meaning%type;
434: l_location hr_locations.location_code%type;
435: l_probation_unit_meaning hr_lookups.meaning%type;

Line 432: l_grade_id per_all_assignments_f.grade_id%type;

428: l_probation_unit per_all_assignments_f.probation_unit%type;
429: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
430: l_payroll_id per_all_assignments_f.payroll_id%type;
431: l_supervisor_id per_all_assignments_f.supervisor_id%type;
432: l_grade_id per_all_assignments_f.grade_id%type;
433: l_frequency_meaning hr_lookups.meaning%type;
434: l_location hr_locations.location_code%type;
435: l_probation_unit_meaning hr_lookups.meaning%type;
436: l_salary_basis per_pay_bases.name%type;

Line 630: (p_organization_id IN per_all_assignments_f.organization_id%type

626: -- |--------------------------< get_org_defaults >----------------------------|
627: -- ----------------------------------------------------------------------------
628: --
629: procedure get_org_defaults
630: (p_organization_id IN per_all_assignments_f.organization_id%type
631: ,p_defaulting IN varchar2
632: ,p_effective_date IN date
633: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
634: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type

Line 635: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type

631: ,p_defaulting IN varchar2
632: ,p_effective_date IN date
633: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
634: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
635: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
636: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
637: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
638: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
639: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

Line 636: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type

632: ,p_effective_date IN date
633: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
634: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
635: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
636: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
637: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
638: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
639: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
640: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

Line 637: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type

633: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
634: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
635: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
636: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
637: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
638: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
639: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
640: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
641: ,p_location OUT NOCOPY hr_locations.location_code%type

Line 638: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type

634: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
635: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
636: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
637: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
638: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
639: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
640: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
641: ,p_location OUT NOCOPY hr_locations.location_code%type
642: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

Line 640: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

636: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
637: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
638: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
639: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
640: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
641: ,p_location OUT NOCOPY hr_locations.location_code%type
642: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
643: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
644: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type

Line 642: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

638: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
639: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
640: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
641: ,p_location OUT NOCOPY hr_locations.location_code%type
642: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
643: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
644: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
645: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
646: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type

Line 643: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type

639: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
640: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
641: ,p_location OUT NOCOPY hr_locations.location_code%type
642: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
643: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
644: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
645: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
646: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
647: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type

Line 645: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type

641: ,p_location OUT NOCOPY hr_locations.location_code%type
642: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
643: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
644: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
645: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
646: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
647: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
648: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
649: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

Line 649: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

645: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
646: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
647: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
648: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
649: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
650: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
651: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
652: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
653: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type

Line 651: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type

647: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
648: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
649: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
650: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
651: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
652: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
653: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
654: ) is
655: --

Line 653: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type

649: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
650: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
651: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
652: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
653: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
654: ) is
655: --
656: l_proc varchar2(72) :=g_package||'get_org_defaults';
657: l_normal_hours varchar2(150);

Line 659: l_time_normal_start per_all_assignments_f.time_normal_start%type;

655: --
656: l_proc varchar2(72) :=g_package||'get_org_defaults';
657: l_normal_hours varchar2(150);
658: l_probation_period varchar2(150);
659: l_time_normal_start per_all_assignments_f.time_normal_start%type;
660: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
661: l_frequency per_all_assignments_f.frequency%type;
662: l_location_id per_all_assignments_f.location_id%type;
663: l_probation_unit per_all_assignments_f.probation_unit%type;

Line 660: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;

656: l_proc varchar2(72) :=g_package||'get_org_defaults';
657: l_normal_hours varchar2(150);
658: l_probation_period varchar2(150);
659: l_time_normal_start per_all_assignments_f.time_normal_start%type;
660: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
661: l_frequency per_all_assignments_f.frequency%type;
662: l_location_id per_all_assignments_f.location_id%type;
663: l_probation_unit per_all_assignments_f.probation_unit%type;
664: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;

Line 661: l_frequency per_all_assignments_f.frequency%type;

657: l_normal_hours varchar2(150);
658: l_probation_period varchar2(150);
659: l_time_normal_start per_all_assignments_f.time_normal_start%type;
660: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
661: l_frequency per_all_assignments_f.frequency%type;
662: l_location_id per_all_assignments_f.location_id%type;
663: l_probation_unit per_all_assignments_f.probation_unit%type;
664: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
665: l_payroll_id per_all_assignments_f.payroll_id%type;

Line 662: l_location_id per_all_assignments_f.location_id%type;

658: l_probation_period varchar2(150);
659: l_time_normal_start per_all_assignments_f.time_normal_start%type;
660: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
661: l_frequency per_all_assignments_f.frequency%type;
662: l_location_id per_all_assignments_f.location_id%type;
663: l_probation_unit per_all_assignments_f.probation_unit%type;
664: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
665: l_payroll_id per_all_assignments_f.payroll_id%type;
666: l_supervisor_id per_all_assignments_f.supervisor_id%type;

Line 663: l_probation_unit per_all_assignments_f.probation_unit%type;

659: l_time_normal_start per_all_assignments_f.time_normal_start%type;
660: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
661: l_frequency per_all_assignments_f.frequency%type;
662: l_location_id per_all_assignments_f.location_id%type;
663: l_probation_unit per_all_assignments_f.probation_unit%type;
664: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
665: l_payroll_id per_all_assignments_f.payroll_id%type;
666: l_supervisor_id per_all_assignments_f.supervisor_id%type;
667: l_grade_id per_all_assignments_f.grade_id%type;

Line 664: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;

660: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
661: l_frequency per_all_assignments_f.frequency%type;
662: l_location_id per_all_assignments_f.location_id%type;
663: l_probation_unit per_all_assignments_f.probation_unit%type;
664: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
665: l_payroll_id per_all_assignments_f.payroll_id%type;
666: l_supervisor_id per_all_assignments_f.supervisor_id%type;
667: l_grade_id per_all_assignments_f.grade_id%type;
668: l_organization_id per_all_assignments_f.organization_id%type;

Line 665: l_payroll_id per_all_assignments_f.payroll_id%type;

661: l_frequency per_all_assignments_f.frequency%type;
662: l_location_id per_all_assignments_f.location_id%type;
663: l_probation_unit per_all_assignments_f.probation_unit%type;
664: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
665: l_payroll_id per_all_assignments_f.payroll_id%type;
666: l_supervisor_id per_all_assignments_f.supervisor_id%type;
667: l_grade_id per_all_assignments_f.grade_id%type;
668: l_organization_id per_all_assignments_f.organization_id%type;
669: l_dummy number;

Line 666: l_supervisor_id per_all_assignments_f.supervisor_id%type;

662: l_location_id per_all_assignments_f.location_id%type;
663: l_probation_unit per_all_assignments_f.probation_unit%type;
664: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
665: l_payroll_id per_all_assignments_f.payroll_id%type;
666: l_supervisor_id per_all_assignments_f.supervisor_id%type;
667: l_grade_id per_all_assignments_f.grade_id%type;
668: l_organization_id per_all_assignments_f.organization_id%type;
669: l_dummy number;
670: --

Line 667: l_grade_id per_all_assignments_f.grade_id%type;

663: l_probation_unit per_all_assignments_f.probation_unit%type;
664: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
665: l_payroll_id per_all_assignments_f.payroll_id%type;
666: l_supervisor_id per_all_assignments_f.supervisor_id%type;
667: l_grade_id per_all_assignments_f.grade_id%type;
668: l_organization_id per_all_assignments_f.organization_id%type;
669: l_dummy number;
670: --
671: cursor get_work_day_information is

Line 668: l_organization_id per_all_assignments_f.organization_id%type;

664: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
665: l_payroll_id per_all_assignments_f.payroll_id%type;
666: l_supervisor_id per_all_assignments_f.supervisor_id%type;
667: l_grade_id per_all_assignments_f.grade_id%type;
668: l_organization_id per_all_assignments_f.organization_id%type;
669: l_dummy number;
670: --
671: cursor get_work_day_information is
672: select org_information1

Line 822: (p_vacancy_id IN per_all_assignments_f.vacancy_id%type

818: -- |--------------------------< get_vac_defaults >----------------------------|
819: -- ----------------------------------------------------------------------------
820: --
821: procedure get_vac_defaults
822: (p_vacancy_id IN per_all_assignments_f.vacancy_id%type
823: ,p_defaulting IN varchar2
824: ,p_effective_date IN date
825: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
826: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type

Line 825: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type

821: procedure get_vac_defaults
822: (p_vacancy_id IN per_all_assignments_f.vacancy_id%type
823: ,p_defaulting IN varchar2
824: ,p_effective_date IN date
825: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
826: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
827: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
828: ,p_grade OUT NOCOPY per_grades.name%type
829: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type

Line 827: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type

823: ,p_defaulting IN varchar2
824: ,p_effective_date IN date
825: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
826: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
827: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
828: ,p_grade OUT NOCOPY per_grades.name%type
829: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
830: ,p_position OUT NOCOPY hr_all_positions_f.name%type
831: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type

Line 829: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type

825: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
826: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
827: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
828: ,p_grade OUT NOCOPY per_grades.name%type
829: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
830: ,p_position OUT NOCOPY hr_all_positions_f.name%type
831: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
832: ,p_job OUT NOCOPY per_jobs.name%type
833: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

Line 831: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type

827: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
828: ,p_grade OUT NOCOPY per_grades.name%type
829: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
830: ,p_position OUT NOCOPY hr_all_positions_f.name%type
831: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
832: ,p_job OUT NOCOPY per_jobs.name%type
833: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
834: ,p_location OUT NOCOPY hr_locations.location_code%type
835: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type

Line 833: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

829: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
830: ,p_position OUT NOCOPY hr_all_positions_f.name%type
831: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
832: ,p_job OUT NOCOPY per_jobs.name%type
833: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
834: ,p_location OUT NOCOPY hr_locations.location_code%type
835: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
836: ,p_organization OUT NOCOPY hr_organization_units.name%type
837: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type

Line 835: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type

831: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
832: ,p_job OUT NOCOPY per_jobs.name%type
833: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
834: ,p_location OUT NOCOPY hr_locations.location_code%type
835: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
836: ,p_organization OUT NOCOPY hr_organization_units.name%type
837: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
838: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
839: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type

Line 837: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type

833: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
834: ,p_location OUT NOCOPY hr_locations.location_code%type
835: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
836: ,p_organization OUT NOCOPY hr_organization_units.name%type
837: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
838: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
839: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
840: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
841: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

Line 838: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type

834: ,p_location OUT NOCOPY hr_locations.location_code%type
835: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
836: ,p_organization OUT NOCOPY hr_organization_units.name%type
837: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
838: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
839: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
840: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
841: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
842: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

Line 839: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type

835: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
836: ,p_organization OUT NOCOPY hr_organization_units.name%type
837: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
838: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
839: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
840: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
841: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
842: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
843: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type

Line 840: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type

836: ,p_organization OUT NOCOPY hr_organization_units.name%type
837: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
838: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
839: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
840: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
841: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
842: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
843: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
844: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type

Line 842: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

838: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
839: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
840: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
841: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
842: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
843: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
844: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
845: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
846: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type

Line 843: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type

839: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
840: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
841: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
842: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
843: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
844: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
845: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
846: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
847: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type

Line 845: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type

841: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
842: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
843: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
844: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
845: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
846: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
847: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
848: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
849: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

Line 849: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

845: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
846: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
847: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
848: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
849: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
850: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
851: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
852: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
853: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type

Line 851: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type

847: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
848: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
849: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
850: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
851: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
852: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
853: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
854: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
855: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type

Line 853: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type

849: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
850: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
851: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
852: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
853: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
854: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
855: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type
856: ,p_pgp_segment1 OUT NOCOPY pay_people_groups.segment1%type
857: ,p_pgp_segment2 OUT NOCOPY pay_people_groups.segment2%type

Line 855: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type

851: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
852: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
853: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
854: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
855: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type
856: ,p_pgp_segment1 OUT NOCOPY pay_people_groups.segment1%type
857: ,p_pgp_segment2 OUT NOCOPY pay_people_groups.segment2%type
858: ,p_pgp_segment3 OUT NOCOPY pay_people_groups.segment3%type
859: ,p_pgp_segment4 OUT NOCOPY pay_people_groups.segment4%type

Line 889: l_recruiter_id per_all_assignments_f.recruiter_id%type;

885: ,p_pgp_segment30 OUT NOCOPY pay_people_groups.segment30%type
886: ) is
887: --
888: l_proc varchar2(72) :=g_package||'get_vac_defaults';
889: l_recruiter_id per_all_assignments_f.recruiter_id%type;
890: l_grade_id per_all_assignments_f.grade_id%type;
891: l_position_id per_all_assignments_f.position_id%type;
892: l_old_position_id per_all_assignments_f.position_id%type;
893: l_job_id per_all_assignments_f.job_id%type;

Line 890: l_grade_id per_all_assignments_f.grade_id%type;

886: ) is
887: --
888: l_proc varchar2(72) :=g_package||'get_vac_defaults';
889: l_recruiter_id per_all_assignments_f.recruiter_id%type;
890: l_grade_id per_all_assignments_f.grade_id%type;
891: l_position_id per_all_assignments_f.position_id%type;
892: l_old_position_id per_all_assignments_f.position_id%type;
893: l_job_id per_all_assignments_f.job_id%type;
894: l_location_id per_all_assignments_f.location_id%type;

Line 891: l_position_id per_all_assignments_f.position_id%type;

887: --
888: l_proc varchar2(72) :=g_package||'get_vac_defaults';
889: l_recruiter_id per_all_assignments_f.recruiter_id%type;
890: l_grade_id per_all_assignments_f.grade_id%type;
891: l_position_id per_all_assignments_f.position_id%type;
892: l_old_position_id per_all_assignments_f.position_id%type;
893: l_job_id per_all_assignments_f.job_id%type;
894: l_location_id per_all_assignments_f.location_id%type;
895: l_organization_id per_all_assignments_f.organization_id%type;

Line 892: l_old_position_id per_all_assignments_f.position_id%type;

888: l_proc varchar2(72) :=g_package||'get_vac_defaults';
889: l_recruiter_id per_all_assignments_f.recruiter_id%type;
890: l_grade_id per_all_assignments_f.grade_id%type;
891: l_position_id per_all_assignments_f.position_id%type;
892: l_old_position_id per_all_assignments_f.position_id%type;
893: l_job_id per_all_assignments_f.job_id%type;
894: l_location_id per_all_assignments_f.location_id%type;
895: l_organization_id per_all_assignments_f.organization_id%type;
896: l_people_group_id per_all_assignments_f.people_group_id%type;

Line 893: l_job_id per_all_assignments_f.job_id%type;

889: l_recruiter_id per_all_assignments_f.recruiter_id%type;
890: l_grade_id per_all_assignments_f.grade_id%type;
891: l_position_id per_all_assignments_f.position_id%type;
892: l_old_position_id per_all_assignments_f.position_id%type;
893: l_job_id per_all_assignments_f.job_id%type;
894: l_location_id per_all_assignments_f.location_id%type;
895: l_organization_id per_all_assignments_f.organization_id%type;
896: l_people_group_id per_all_assignments_f.people_group_id%type;
897: l_pgp_rec pay_people_groups%rowtype;

Line 894: l_location_id per_all_assignments_f.location_id%type;

890: l_grade_id per_all_assignments_f.grade_id%type;
891: l_position_id per_all_assignments_f.position_id%type;
892: l_old_position_id per_all_assignments_f.position_id%type;
893: l_job_id per_all_assignments_f.job_id%type;
894: l_location_id per_all_assignments_f.location_id%type;
895: l_organization_id per_all_assignments_f.organization_id%type;
896: l_people_group_id per_all_assignments_f.people_group_id%type;
897: l_pgp_rec pay_people_groups%rowtype;
898: l_vacancy_id per_vacancies.vacancy_id%type;

Line 895: l_organization_id per_all_assignments_f.organization_id%type;

891: l_position_id per_all_assignments_f.position_id%type;
892: l_old_position_id per_all_assignments_f.position_id%type;
893: l_job_id per_all_assignments_f.job_id%type;
894: l_location_id per_all_assignments_f.location_id%type;
895: l_organization_id per_all_assignments_f.organization_id%type;
896: l_people_group_id per_all_assignments_f.people_group_id%type;
897: l_pgp_rec pay_people_groups%rowtype;
898: l_vacancy_id per_vacancies.vacancy_id%type;
899: l_vacancy per_vacancies.name%type;

Line 896: l_people_group_id per_all_assignments_f.people_group_id%type;

892: l_old_position_id per_all_assignments_f.position_id%type;
893: l_job_id per_all_assignments_f.job_id%type;
894: l_location_id per_all_assignments_f.location_id%type;
895: l_organization_id per_all_assignments_f.organization_id%type;
896: l_people_group_id per_all_assignments_f.people_group_id%type;
897: l_pgp_rec pay_people_groups%rowtype;
898: l_vacancy_id per_vacancies.vacancy_id%type;
899: l_vacancy per_vacancies.name%type;
900: l_dummy number;