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 234: from per_all_assignments_f

230: and business_group_id = p_business_group_id; */
231:
232: cursor csr_super_assgn_num is
233: select assignment_number
234: from per_all_assignments_f
235: where assignment_id = p_supervisor_assgn_id;
236: -- and business_group_id = p_business_group_id;
237:
238: begin

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

308: --
309: procedure get_bg_defaults
310: (p_business_group_id IN per_business_groups.business_group_id%type
311: ,p_defaulting IN varchar2
312: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type
313: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
314: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
315: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
316: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

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

309: procedure get_bg_defaults
310: (p_business_group_id IN per_business_groups.business_group_id%type
311: ,p_defaulting IN varchar2
312: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type
313: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
314: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
315: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
316: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
317: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

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

310: (p_business_group_id IN per_business_groups.business_group_id%type
311: ,p_defaulting IN varchar2
312: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type
313: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
314: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
315: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
316: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
317: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
318: ,p_location OUT NOCOPY hr_locations.location_code%type

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

311: ,p_defaulting IN varchar2
312: ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type
313: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
314: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
315: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
316: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
317: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
318: ,p_location OUT NOCOPY hr_locations.location_code%type
319: ,p_gre OUT NOCOPY hr_soft_coding_keyflex.segment1%type

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

313: ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
314: ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
315: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
316: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
317: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
318: ,p_location OUT NOCOPY hr_locations.location_code%type
319: ,p_gre OUT NOCOPY hr_soft_coding_keyflex.segment1%type
320: ) is
321: --

Line 324: l_location_id per_all_assignments_f.location_id%type;

320: ) is
321: --
322: l_proc varchar2(72) :=g_package||'get_bg_defaults';
323: l_normal_hours varchar2(150);
324: l_location_id per_all_assignments_f.location_id%type;
325: --
326: cursor get_work_day_information is
327: select org_information1
328: , org_information2

Line 391: (p_position_id IN per_all_assignments_f.position_id%type

387: -- |--------------------------< get_pos_defaults >----------------------------|
388: -- ----------------------------------------------------------------------------
389: --
390: procedure get_pos_defaults
391: (p_position_id IN per_all_assignments_f.position_id%type
392: ,p_effective_date IN date
393: ,p_defaulting IN varchar2
394: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
395: ,p_organization OUT NOCOPY hr_organization_units.name%type

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

390: procedure get_pos_defaults
391: (p_position_id IN per_all_assignments_f.position_id%type
392: ,p_effective_date IN date
393: ,p_defaulting IN varchar2
394: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
395: ,p_organization OUT NOCOPY hr_organization_units.name%type
396: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
397: ,p_job OUT NOCOPY per_jobs.name%type
398: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type

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

392: ,p_effective_date IN date
393: ,p_defaulting IN varchar2
394: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
395: ,p_organization OUT NOCOPY hr_organization_units.name%type
396: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
397: ,p_job OUT NOCOPY per_jobs.name%type
398: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
399: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
400: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type

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

396: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
397: ,p_job OUT NOCOPY per_jobs.name%type
398: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
399: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
400: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
401: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
402: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
403: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
404: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

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

397: ,p_job OUT NOCOPY per_jobs.name%type
398: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
399: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
400: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
401: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
402: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
403: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
404: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
405: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

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

398: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
399: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
400: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
401: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
402: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
403: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
404: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
405: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
406: ,p_location OUT NOCOPY hr_locations.location_code%type

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

399: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
400: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
401: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
402: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
403: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
404: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
405: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
406: ,p_location OUT NOCOPY hr_locations.location_code%type
407: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

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

401: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
402: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
403: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
404: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
405: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
406: ,p_location OUT NOCOPY hr_locations.location_code%type
407: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
408: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
409: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type

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

403: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
404: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
405: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
406: ,p_location OUT NOCOPY hr_locations.location_code%type
407: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
408: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
409: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
410: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
411: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type

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

404: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
405: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
406: ,p_location OUT NOCOPY hr_locations.location_code%type
407: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
408: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
409: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
410: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
411: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
412: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type

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

406: ,p_location OUT NOCOPY hr_locations.location_code%type
407: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
408: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
409: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
410: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
411: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
412: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
413: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
414: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

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

410: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
411: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
412: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
413: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
414: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
415: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
416: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
417: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
418: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type

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

412: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
413: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
414: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
415: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
416: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
417: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
418: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
419: ,p_grade OUT NOCOPY per_grades.name%type
420: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type

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

414: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
415: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
416: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
417: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
418: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
419: ,p_grade OUT NOCOPY per_grades.name%type
420: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
421: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
422: ) is

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

416: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
417: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
418: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
419: ,p_grade OUT NOCOPY per_grades.name%type
420: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
421: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
422: ) is
423: --
424: l_proc varchar2(72) :=g_package||'get_pos_defaults';

Line 425: l_position_id per_all_assignments_f.position_id%type;

421: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
422: ) is
423: --
424: l_proc varchar2(72) :=g_package||'get_pos_defaults';
425: l_position_id per_all_assignments_f.position_id%type;
426: l_organization_id per_all_assignments_f.organization_id%type;
427: l_old_organization_id per_all_assignments_f.organization_id%type;
428: l_job_id per_all_assignments_f.job_id%type;
429: l_time_normal_start per_all_assignments_f.time_normal_start%type;

Line 426: l_organization_id per_all_assignments_f.organization_id%type;

422: ) is
423: --
424: l_proc varchar2(72) :=g_package||'get_pos_defaults';
425: l_position_id per_all_assignments_f.position_id%type;
426: l_organization_id per_all_assignments_f.organization_id%type;
427: l_old_organization_id per_all_assignments_f.organization_id%type;
428: l_job_id per_all_assignments_f.job_id%type;
429: l_time_normal_start per_all_assignments_f.time_normal_start%type;
430: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;

Line 427: l_old_organization_id per_all_assignments_f.organization_id%type;

423: --
424: l_proc varchar2(72) :=g_package||'get_pos_defaults';
425: l_position_id per_all_assignments_f.position_id%type;
426: l_organization_id per_all_assignments_f.organization_id%type;
427: l_old_organization_id per_all_assignments_f.organization_id%type;
428: l_job_id per_all_assignments_f.job_id%type;
429: l_time_normal_start per_all_assignments_f.time_normal_start%type;
430: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
431: l_normal_hours per_all_assignments_f.normal_hours%type;

Line 428: l_job_id per_all_assignments_f.job_id%type;

424: l_proc varchar2(72) :=g_package||'get_pos_defaults';
425: l_position_id per_all_assignments_f.position_id%type;
426: l_organization_id per_all_assignments_f.organization_id%type;
427: l_old_organization_id per_all_assignments_f.organization_id%type;
428: l_job_id per_all_assignments_f.job_id%type;
429: l_time_normal_start per_all_assignments_f.time_normal_start%type;
430: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
431: l_normal_hours per_all_assignments_f.normal_hours%type;
432: l_frequency per_all_assignments_f.frequency%type;

Line 429: l_time_normal_start per_all_assignments_f.time_normal_start%type;

425: l_position_id per_all_assignments_f.position_id%type;
426: l_organization_id per_all_assignments_f.organization_id%type;
427: l_old_organization_id per_all_assignments_f.organization_id%type;
428: l_job_id per_all_assignments_f.job_id%type;
429: l_time_normal_start per_all_assignments_f.time_normal_start%type;
430: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
431: l_normal_hours per_all_assignments_f.normal_hours%type;
432: l_frequency per_all_assignments_f.frequency%type;
433: l_location_id per_all_assignments_f.location_id%type;

Line 430: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;

426: l_organization_id per_all_assignments_f.organization_id%type;
427: l_old_organization_id per_all_assignments_f.organization_id%type;
428: l_job_id per_all_assignments_f.job_id%type;
429: l_time_normal_start per_all_assignments_f.time_normal_start%type;
430: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
431: l_normal_hours per_all_assignments_f.normal_hours%type;
432: l_frequency per_all_assignments_f.frequency%type;
433: l_location_id per_all_assignments_f.location_id%type;
434: l_probation_period per_all_assignments_f.probation_period%type;

Line 431: l_normal_hours per_all_assignments_f.normal_hours%type;

427: l_old_organization_id per_all_assignments_f.organization_id%type;
428: l_job_id per_all_assignments_f.job_id%type;
429: l_time_normal_start per_all_assignments_f.time_normal_start%type;
430: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
431: l_normal_hours per_all_assignments_f.normal_hours%type;
432: l_frequency per_all_assignments_f.frequency%type;
433: l_location_id per_all_assignments_f.location_id%type;
434: l_probation_period per_all_assignments_f.probation_period%type;
435: l_probation_unit per_all_assignments_f.probation_unit%type;

Line 432: l_frequency per_all_assignments_f.frequency%type;

428: l_job_id per_all_assignments_f.job_id%type;
429: l_time_normal_start per_all_assignments_f.time_normal_start%type;
430: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
431: l_normal_hours per_all_assignments_f.normal_hours%type;
432: l_frequency per_all_assignments_f.frequency%type;
433: l_location_id per_all_assignments_f.location_id%type;
434: l_probation_period per_all_assignments_f.probation_period%type;
435: l_probation_unit per_all_assignments_f.probation_unit%type;
436: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;

Line 433: l_location_id per_all_assignments_f.location_id%type;

429: l_time_normal_start per_all_assignments_f.time_normal_start%type;
430: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
431: l_normal_hours per_all_assignments_f.normal_hours%type;
432: l_frequency per_all_assignments_f.frequency%type;
433: l_location_id per_all_assignments_f.location_id%type;
434: l_probation_period per_all_assignments_f.probation_period%type;
435: l_probation_unit per_all_assignments_f.probation_unit%type;
436: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
437: l_payroll_id per_all_assignments_f.payroll_id%type;

Line 434: l_probation_period per_all_assignments_f.probation_period%type;

430: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
431: l_normal_hours per_all_assignments_f.normal_hours%type;
432: l_frequency per_all_assignments_f.frequency%type;
433: l_location_id per_all_assignments_f.location_id%type;
434: l_probation_period per_all_assignments_f.probation_period%type;
435: l_probation_unit per_all_assignments_f.probation_unit%type;
436: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
437: l_payroll_id per_all_assignments_f.payroll_id%type;
438: l_supervisor_id per_all_assignments_f.supervisor_id%type;

Line 435: l_probation_unit per_all_assignments_f.probation_unit%type;

431: l_normal_hours per_all_assignments_f.normal_hours%type;
432: l_frequency per_all_assignments_f.frequency%type;
433: l_location_id per_all_assignments_f.location_id%type;
434: l_probation_period per_all_assignments_f.probation_period%type;
435: l_probation_unit per_all_assignments_f.probation_unit%type;
436: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
437: l_payroll_id per_all_assignments_f.payroll_id%type;
438: l_supervisor_id per_all_assignments_f.supervisor_id%type;
439: l_grade_id per_all_assignments_f.grade_id%type;

Line 436: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;

432: l_frequency per_all_assignments_f.frequency%type;
433: l_location_id per_all_assignments_f.location_id%type;
434: l_probation_period per_all_assignments_f.probation_period%type;
435: l_probation_unit per_all_assignments_f.probation_unit%type;
436: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
437: l_payroll_id per_all_assignments_f.payroll_id%type;
438: l_supervisor_id per_all_assignments_f.supervisor_id%type;
439: l_grade_id per_all_assignments_f.grade_id%type;
440: l_frequency_meaning hr_lookups.meaning%type;

Line 437: l_payroll_id per_all_assignments_f.payroll_id%type;

433: l_location_id per_all_assignments_f.location_id%type;
434: l_probation_period per_all_assignments_f.probation_period%type;
435: l_probation_unit per_all_assignments_f.probation_unit%type;
436: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
437: l_payroll_id per_all_assignments_f.payroll_id%type;
438: l_supervisor_id per_all_assignments_f.supervisor_id%type;
439: l_grade_id per_all_assignments_f.grade_id%type;
440: l_frequency_meaning hr_lookups.meaning%type;
441: l_location hr_locations.location_code%type;

Line 438: l_supervisor_id per_all_assignments_f.supervisor_id%type;

434: l_probation_period per_all_assignments_f.probation_period%type;
435: l_probation_unit per_all_assignments_f.probation_unit%type;
436: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
437: l_payroll_id per_all_assignments_f.payroll_id%type;
438: l_supervisor_id per_all_assignments_f.supervisor_id%type;
439: l_grade_id per_all_assignments_f.grade_id%type;
440: l_frequency_meaning hr_lookups.meaning%type;
441: l_location hr_locations.location_code%type;
442: l_probation_unit_meaning hr_lookups.meaning%type;

Line 439: l_grade_id per_all_assignments_f.grade_id%type;

435: l_probation_unit per_all_assignments_f.probation_unit%type;
436: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
437: l_payroll_id per_all_assignments_f.payroll_id%type;
438: l_supervisor_id per_all_assignments_f.supervisor_id%type;
439: l_grade_id per_all_assignments_f.grade_id%type;
440: l_frequency_meaning hr_lookups.meaning%type;
441: l_location hr_locations.location_code%type;
442: l_probation_unit_meaning hr_lookups.meaning%type;
443: l_salary_basis per_pay_bases.name%type;

Line 637: (p_organization_id IN per_all_assignments_f.organization_id%type

633: -- |--------------------------< get_org_defaults >----------------------------|
634: -- ----------------------------------------------------------------------------
635: --
636: procedure get_org_defaults
637: (p_organization_id IN per_all_assignments_f.organization_id%type
638: ,p_defaulting IN varchar2
639: ,p_effective_date IN date
640: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
641: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type

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

638: ,p_defaulting IN varchar2
639: ,p_effective_date IN date
640: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
641: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
642: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
643: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
644: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
645: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
646: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

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

639: ,p_effective_date IN date
640: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
641: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
642: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
643: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
644: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
645: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
646: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
647: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

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

640: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
641: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
642: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
643: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
644: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
645: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
646: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
647: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
648: ,p_location OUT NOCOPY hr_locations.location_code%type

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

641: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
642: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
643: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
644: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
645: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
646: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
647: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
648: ,p_location OUT NOCOPY hr_locations.location_code%type
649: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

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

643: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
644: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
645: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
646: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
647: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
648: ,p_location OUT NOCOPY hr_locations.location_code%type
649: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
650: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
651: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type

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

645: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
646: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
647: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
648: ,p_location OUT NOCOPY hr_locations.location_code%type
649: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
650: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
651: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
652: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
653: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type

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

646: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
647: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
648: ,p_location OUT NOCOPY hr_locations.location_code%type
649: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
650: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
651: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
652: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
653: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
654: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type

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

648: ,p_location OUT NOCOPY hr_locations.location_code%type
649: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
650: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
651: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
652: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
653: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
654: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
655: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
656: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

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

652: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
653: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
654: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
655: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
656: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
657: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
658: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
659: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
660: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type

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

654: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
655: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
656: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
657: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
658: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
659: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
660: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
661: ) is
662: --

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

656: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
657: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
658: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
659: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
660: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
661: ) is
662: --
663: l_proc varchar2(72) :=g_package||'get_org_defaults';
664: l_normal_hours varchar2(150);

Line 666: l_time_normal_start per_all_assignments_f.time_normal_start%type;

662: --
663: l_proc varchar2(72) :=g_package||'get_org_defaults';
664: l_normal_hours varchar2(150);
665: l_probation_period varchar2(150);
666: l_time_normal_start per_all_assignments_f.time_normal_start%type;
667: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
668: l_frequency per_all_assignments_f.frequency%type;
669: l_location_id per_all_assignments_f.location_id%type;
670: l_probation_unit per_all_assignments_f.probation_unit%type;

Line 667: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;

663: l_proc varchar2(72) :=g_package||'get_org_defaults';
664: l_normal_hours varchar2(150);
665: l_probation_period varchar2(150);
666: l_time_normal_start per_all_assignments_f.time_normal_start%type;
667: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
668: l_frequency per_all_assignments_f.frequency%type;
669: l_location_id per_all_assignments_f.location_id%type;
670: l_probation_unit per_all_assignments_f.probation_unit%type;
671: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;

Line 668: l_frequency per_all_assignments_f.frequency%type;

664: l_normal_hours varchar2(150);
665: l_probation_period varchar2(150);
666: l_time_normal_start per_all_assignments_f.time_normal_start%type;
667: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
668: l_frequency per_all_assignments_f.frequency%type;
669: l_location_id per_all_assignments_f.location_id%type;
670: l_probation_unit per_all_assignments_f.probation_unit%type;
671: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
672: l_payroll_id per_all_assignments_f.payroll_id%type;

Line 669: l_location_id per_all_assignments_f.location_id%type;

665: l_probation_period varchar2(150);
666: l_time_normal_start per_all_assignments_f.time_normal_start%type;
667: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
668: l_frequency per_all_assignments_f.frequency%type;
669: l_location_id per_all_assignments_f.location_id%type;
670: l_probation_unit per_all_assignments_f.probation_unit%type;
671: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
672: l_payroll_id per_all_assignments_f.payroll_id%type;
673: l_supervisor_id per_all_assignments_f.supervisor_id%type;

Line 670: l_probation_unit per_all_assignments_f.probation_unit%type;

666: l_time_normal_start per_all_assignments_f.time_normal_start%type;
667: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
668: l_frequency per_all_assignments_f.frequency%type;
669: l_location_id per_all_assignments_f.location_id%type;
670: l_probation_unit per_all_assignments_f.probation_unit%type;
671: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
672: l_payroll_id per_all_assignments_f.payroll_id%type;
673: l_supervisor_id per_all_assignments_f.supervisor_id%type;
674: l_grade_id per_all_assignments_f.grade_id%type;

Line 671: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;

667: l_time_normal_finish per_all_assignments_f.time_normal_finish%type;
668: l_frequency per_all_assignments_f.frequency%type;
669: l_location_id per_all_assignments_f.location_id%type;
670: l_probation_unit per_all_assignments_f.probation_unit%type;
671: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
672: l_payroll_id per_all_assignments_f.payroll_id%type;
673: l_supervisor_id per_all_assignments_f.supervisor_id%type;
674: l_grade_id per_all_assignments_f.grade_id%type;
675: l_organization_id per_all_assignments_f.organization_id%type;

Line 672: l_payroll_id per_all_assignments_f.payroll_id%type;

668: l_frequency per_all_assignments_f.frequency%type;
669: l_location_id per_all_assignments_f.location_id%type;
670: l_probation_unit per_all_assignments_f.probation_unit%type;
671: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
672: l_payroll_id per_all_assignments_f.payroll_id%type;
673: l_supervisor_id per_all_assignments_f.supervisor_id%type;
674: l_grade_id per_all_assignments_f.grade_id%type;
675: l_organization_id per_all_assignments_f.organization_id%type;
676: l_dummy number;

Line 673: l_supervisor_id per_all_assignments_f.supervisor_id%type;

669: l_location_id per_all_assignments_f.location_id%type;
670: l_probation_unit per_all_assignments_f.probation_unit%type;
671: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
672: l_payroll_id per_all_assignments_f.payroll_id%type;
673: l_supervisor_id per_all_assignments_f.supervisor_id%type;
674: l_grade_id per_all_assignments_f.grade_id%type;
675: l_organization_id per_all_assignments_f.organization_id%type;
676: l_dummy number;
677: --

Line 674: l_grade_id per_all_assignments_f.grade_id%type;

670: l_probation_unit per_all_assignments_f.probation_unit%type;
671: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
672: l_payroll_id per_all_assignments_f.payroll_id%type;
673: l_supervisor_id per_all_assignments_f.supervisor_id%type;
674: l_grade_id per_all_assignments_f.grade_id%type;
675: l_organization_id per_all_assignments_f.organization_id%type;
676: l_dummy number;
677: --
678: cursor get_work_day_information is

Line 675: l_organization_id per_all_assignments_f.organization_id%type;

671: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
672: l_payroll_id per_all_assignments_f.payroll_id%type;
673: l_supervisor_id per_all_assignments_f.supervisor_id%type;
674: l_grade_id per_all_assignments_f.grade_id%type;
675: l_organization_id per_all_assignments_f.organization_id%type;
676: l_dummy number;
677: --
678: cursor get_work_day_information is
679: select org_information1

Line 829: (p_vacancy_id IN per_all_assignments_f.vacancy_id%type

825: -- |--------------------------< get_vac_defaults >----------------------------|
826: -- ----------------------------------------------------------------------------
827: --
828: procedure get_vac_defaults
829: (p_vacancy_id IN per_all_assignments_f.vacancy_id%type
830: ,p_defaulting IN varchar2
831: ,p_effective_date IN date
832: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
833: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type

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

828: procedure get_vac_defaults
829: (p_vacancy_id IN per_all_assignments_f.vacancy_id%type
830: ,p_defaulting IN varchar2
831: ,p_effective_date IN date
832: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
833: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
834: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
835: ,p_grade OUT NOCOPY per_grades.name%type
836: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type

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

830: ,p_defaulting IN varchar2
831: ,p_effective_date IN date
832: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
833: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
834: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
835: ,p_grade OUT NOCOPY per_grades.name%type
836: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
837: ,p_position OUT NOCOPY hr_all_positions_f.name%type
838: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type

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

832: ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
833: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
834: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
835: ,p_grade OUT NOCOPY per_grades.name%type
836: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
837: ,p_position OUT NOCOPY hr_all_positions_f.name%type
838: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
839: ,p_job OUT NOCOPY per_jobs.name%type
840: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type

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

834: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
835: ,p_grade OUT NOCOPY per_grades.name%type
836: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
837: ,p_position OUT NOCOPY hr_all_positions_f.name%type
838: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
839: ,p_job OUT NOCOPY per_jobs.name%type
840: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
841: ,p_location OUT NOCOPY hr_locations.location_code%type
842: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type

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

836: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
837: ,p_position OUT NOCOPY hr_all_positions_f.name%type
838: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
839: ,p_job OUT NOCOPY per_jobs.name%type
840: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
841: ,p_location OUT NOCOPY hr_locations.location_code%type
842: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
843: ,p_organization OUT NOCOPY hr_organization_units.name%type
844: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type

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

838: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
839: ,p_job OUT NOCOPY per_jobs.name%type
840: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
841: ,p_location OUT NOCOPY hr_locations.location_code%type
842: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
843: ,p_organization OUT NOCOPY hr_organization_units.name%type
844: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
845: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
846: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type

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

840: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
841: ,p_location OUT NOCOPY hr_locations.location_code%type
842: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
843: ,p_organization OUT NOCOPY hr_organization_units.name%type
844: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
845: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
846: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
847: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
848: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type

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

841: ,p_location OUT NOCOPY hr_locations.location_code%type
842: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
843: ,p_organization OUT NOCOPY hr_organization_units.name%type
844: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
845: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
846: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
847: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
848: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
849: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type

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

842: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
843: ,p_organization OUT NOCOPY hr_organization_units.name%type
844: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
845: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
846: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
847: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
848: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
849: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
850: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type

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

843: ,p_organization OUT NOCOPY hr_organization_units.name%type
844: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
845: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
846: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
847: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
848: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
849: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
850: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
851: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type

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

845: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
846: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
847: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
848: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
849: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
850: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
851: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
852: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
853: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type

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

846: ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
847: ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
848: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
849: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
850: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
851: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
852: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
853: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
854: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type

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

848: ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
849: ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
850: ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
851: ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
852: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
853: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
854: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
855: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
856: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type

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

852: ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
853: ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
854: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
855: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
856: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
857: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
858: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
859: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
860: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type

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

854: ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
855: ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
856: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
857: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
858: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
859: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
860: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
861: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
862: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type

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

856: ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
857: ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
858: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
859: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
860: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
861: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
862: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type
863: ,p_pgp_segment1 OUT NOCOPY pay_people_groups.segment1%type
864: ,p_pgp_segment2 OUT NOCOPY pay_people_groups.segment2%type

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

858: ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
859: ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
860: ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
861: ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
862: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type
863: ,p_pgp_segment1 OUT NOCOPY pay_people_groups.segment1%type
864: ,p_pgp_segment2 OUT NOCOPY pay_people_groups.segment2%type
865: ,p_pgp_segment3 OUT NOCOPY pay_people_groups.segment3%type
866: ,p_pgp_segment4 OUT NOCOPY pay_people_groups.segment4%type

Line 896: l_recruiter_id per_all_assignments_f.recruiter_id%type;

892: ,p_pgp_segment30 OUT NOCOPY pay_people_groups.segment30%type
893: ) is
894: --
895: l_proc varchar2(72) :=g_package||'get_vac_defaults';
896: l_recruiter_id per_all_assignments_f.recruiter_id%type;
897: l_grade_id per_all_assignments_f.grade_id%type;
898: l_position_id per_all_assignments_f.position_id%type;
899: l_old_position_id per_all_assignments_f.position_id%type;
900: l_job_id per_all_assignments_f.job_id%type;

Line 897: l_grade_id per_all_assignments_f.grade_id%type;

893: ) is
894: --
895: l_proc varchar2(72) :=g_package||'get_vac_defaults';
896: l_recruiter_id per_all_assignments_f.recruiter_id%type;
897: l_grade_id per_all_assignments_f.grade_id%type;
898: l_position_id per_all_assignments_f.position_id%type;
899: l_old_position_id per_all_assignments_f.position_id%type;
900: l_job_id per_all_assignments_f.job_id%type;
901: l_location_id per_all_assignments_f.location_id%type;

Line 898: l_position_id per_all_assignments_f.position_id%type;

894: --
895: l_proc varchar2(72) :=g_package||'get_vac_defaults';
896: l_recruiter_id per_all_assignments_f.recruiter_id%type;
897: l_grade_id per_all_assignments_f.grade_id%type;
898: l_position_id per_all_assignments_f.position_id%type;
899: l_old_position_id per_all_assignments_f.position_id%type;
900: l_job_id per_all_assignments_f.job_id%type;
901: l_location_id per_all_assignments_f.location_id%type;
902: l_organization_id per_all_assignments_f.organization_id%type;

Line 899: l_old_position_id per_all_assignments_f.position_id%type;

895: l_proc varchar2(72) :=g_package||'get_vac_defaults';
896: l_recruiter_id per_all_assignments_f.recruiter_id%type;
897: l_grade_id per_all_assignments_f.grade_id%type;
898: l_position_id per_all_assignments_f.position_id%type;
899: l_old_position_id per_all_assignments_f.position_id%type;
900: l_job_id per_all_assignments_f.job_id%type;
901: l_location_id per_all_assignments_f.location_id%type;
902: l_organization_id per_all_assignments_f.organization_id%type;
903: l_people_group_id per_all_assignments_f.people_group_id%type;

Line 900: l_job_id per_all_assignments_f.job_id%type;

896: l_recruiter_id per_all_assignments_f.recruiter_id%type;
897: l_grade_id per_all_assignments_f.grade_id%type;
898: l_position_id per_all_assignments_f.position_id%type;
899: l_old_position_id per_all_assignments_f.position_id%type;
900: l_job_id per_all_assignments_f.job_id%type;
901: l_location_id per_all_assignments_f.location_id%type;
902: l_organization_id per_all_assignments_f.organization_id%type;
903: l_people_group_id per_all_assignments_f.people_group_id%type;
904: l_pgp_rec pay_people_groups%rowtype;

Line 901: l_location_id per_all_assignments_f.location_id%type;

897: l_grade_id per_all_assignments_f.grade_id%type;
898: l_position_id per_all_assignments_f.position_id%type;
899: l_old_position_id per_all_assignments_f.position_id%type;
900: l_job_id per_all_assignments_f.job_id%type;
901: l_location_id per_all_assignments_f.location_id%type;
902: l_organization_id per_all_assignments_f.organization_id%type;
903: l_people_group_id per_all_assignments_f.people_group_id%type;
904: l_pgp_rec pay_people_groups%rowtype;
905: l_vacancy_id per_vacancies.vacancy_id%type;

Line 902: l_organization_id per_all_assignments_f.organization_id%type;

898: l_position_id per_all_assignments_f.position_id%type;
899: l_old_position_id per_all_assignments_f.position_id%type;
900: l_job_id per_all_assignments_f.job_id%type;
901: l_location_id per_all_assignments_f.location_id%type;
902: l_organization_id per_all_assignments_f.organization_id%type;
903: l_people_group_id per_all_assignments_f.people_group_id%type;
904: l_pgp_rec pay_people_groups%rowtype;
905: l_vacancy_id per_vacancies.vacancy_id%type;
906: l_vacancy per_vacancies.name%type;

Line 903: l_people_group_id per_all_assignments_f.people_group_id%type;

899: l_old_position_id per_all_assignments_f.position_id%type;
900: l_job_id per_all_assignments_f.job_id%type;
901: l_location_id per_all_assignments_f.location_id%type;
902: l_organization_id per_all_assignments_f.organization_id%type;
903: l_people_group_id per_all_assignments_f.people_group_id%type;
904: l_pgp_rec pay_people_groups%rowtype;
905: l_vacancy_id per_vacancies.vacancy_id%type;
906: l_vacancy per_vacancies.name%type;
907: l_dummy number;