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_MAINTAIN_UPDATE dependencies on PER_ASG_SHD

Line 4253: IF per_asg_shd.g_old_rec.people_group_id IS NOT NULL THEN

4249: IF p_assignment_update_allowed='TRUE' THEN
4250: --
4251: -- check to see if the assignment data has changed
4252: --
4253: IF per_asg_shd.g_old_rec.people_group_id IS NOT NULL THEN
4254: --
4255: hr_utility.set_location(l_proc, 60);
4256: --
4257: OPEN csr_pgp_rec(per_asg_shd.g_old_rec.people_group_id);

Line 4257: OPEN csr_pgp_rec(per_asg_shd.g_old_rec.people_group_id);

4253: IF per_asg_shd.g_old_rec.people_group_id IS NOT NULL THEN
4254: --
4255: hr_utility.set_location(l_proc, 60);
4256: --
4257: OPEN csr_pgp_rec(per_asg_shd.g_old_rec.people_group_id);
4258: FETCH csr_pgp_rec INTO l_pgp_rec;
4259: CLOSE csr_pgp_rec;
4260: END IF;
4261: --

Line 4262: IF per_asg_shd.g_old_rec.soft_coding_keyflex_id IS NOT NULL THEN

4258: FETCH csr_pgp_rec INTO l_pgp_rec;
4259: CLOSE csr_pgp_rec;
4260: END IF;
4261: --
4262: IF per_asg_shd.g_old_rec.soft_coding_keyflex_id IS NOT NULL THEN
4263: --
4264: hr_utility.set_location(l_proc, 70);
4265: --
4266: OPEN csr_scl_rec(per_asg_shd.g_old_rec.soft_coding_keyflex_id);

Line 4266: OPEN csr_scl_rec(per_asg_shd.g_old_rec.soft_coding_keyflex_id);

4262: IF per_asg_shd.g_old_rec.soft_coding_keyflex_id IS NOT NULL THEN
4263: --
4264: hr_utility.set_location(l_proc, 70);
4265: --
4266: OPEN csr_scl_rec(per_asg_shd.g_old_rec.soft_coding_keyflex_id);
4267: FETCH csr_scl_rec INTO l_scl_rec;
4268: CLOSE csr_scl_rec;
4269: END IF;
4270: --

Line 4273: IF NVL(per_asg_shd.g_old_rec.recruiter_id,hr_api.g_number)

4269: END IF;
4270: --
4271: hr_utility.set_location(l_proc, 80);
4272: --
4273: IF NVL(per_asg_shd.g_old_rec.recruiter_id,hr_api.g_number)
4274: <>NVL(p_recruiter_id,hr_api.g_number)
4275: OR NVL(per_asg_shd.g_old_rec.grade_id,hr_api.g_number)
4276: <>NVL(p_grade_id,hr_api.g_number)
4277: OR NVL(per_asg_shd.g_old_rec.grade_ladder_pgm_id,hr_api.g_number)

Line 4275: OR NVL(per_asg_shd.g_old_rec.grade_id,hr_api.g_number)

4271: hr_utility.set_location(l_proc, 80);
4272: --
4273: IF NVL(per_asg_shd.g_old_rec.recruiter_id,hr_api.g_number)
4274: <>NVL(p_recruiter_id,hr_api.g_number)
4275: OR NVL(per_asg_shd.g_old_rec.grade_id,hr_api.g_number)
4276: <>NVL(p_grade_id,hr_api.g_number)
4277: OR NVL(per_asg_shd.g_old_rec.grade_ladder_pgm_id,hr_api.g_number)
4278: <>NVL(p_grade_ladder_pgm_id,hr_api.g_number)
4279: OR NVL(per_asg_shd.g_old_rec.position_id,hr_api.g_number)

Line 4277: OR NVL(per_asg_shd.g_old_rec.grade_ladder_pgm_id,hr_api.g_number)

4273: IF NVL(per_asg_shd.g_old_rec.recruiter_id,hr_api.g_number)
4274: <>NVL(p_recruiter_id,hr_api.g_number)
4275: OR NVL(per_asg_shd.g_old_rec.grade_id,hr_api.g_number)
4276: <>NVL(p_grade_id,hr_api.g_number)
4277: OR NVL(per_asg_shd.g_old_rec.grade_ladder_pgm_id,hr_api.g_number)
4278: <>NVL(p_grade_ladder_pgm_id,hr_api.g_number)
4279: OR NVL(per_asg_shd.g_old_rec.position_id,hr_api.g_number)
4280: <>NVL(p_position_id,hr_api.g_number)
4281: OR NVL(per_asg_shd.g_old_rec.job_id,hr_api.g_number)

Line 4279: OR NVL(per_asg_shd.g_old_rec.position_id,hr_api.g_number)

4275: OR NVL(per_asg_shd.g_old_rec.grade_id,hr_api.g_number)
4276: <>NVL(p_grade_id,hr_api.g_number)
4277: OR NVL(per_asg_shd.g_old_rec.grade_ladder_pgm_id,hr_api.g_number)
4278: <>NVL(p_grade_ladder_pgm_id,hr_api.g_number)
4279: OR NVL(per_asg_shd.g_old_rec.position_id,hr_api.g_number)
4280: <>NVL(p_position_id,hr_api.g_number)
4281: OR NVL(per_asg_shd.g_old_rec.job_id,hr_api.g_number)
4282: <>NVL(p_job_id,hr_api.g_number)
4283: OR NVL(per_asg_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)

Line 4281: OR NVL(per_asg_shd.g_old_rec.job_id,hr_api.g_number)

4277: OR NVL(per_asg_shd.g_old_rec.grade_ladder_pgm_id,hr_api.g_number)
4278: <>NVL(p_grade_ladder_pgm_id,hr_api.g_number)
4279: OR NVL(per_asg_shd.g_old_rec.position_id,hr_api.g_number)
4280: <>NVL(p_position_id,hr_api.g_number)
4281: OR NVL(per_asg_shd.g_old_rec.job_id,hr_api.g_number)
4282: <>NVL(p_job_id,hr_api.g_number)
4283: OR NVL(per_asg_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)
4284: <>NVL(p_assignment_status_type_id,hr_api.g_number)
4285: OR NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)

Line 4283: OR NVL(per_asg_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)

4279: OR NVL(per_asg_shd.g_old_rec.position_id,hr_api.g_number)
4280: <>NVL(p_position_id,hr_api.g_number)
4281: OR NVL(per_asg_shd.g_old_rec.job_id,hr_api.g_number)
4282: <>NVL(p_job_id,hr_api.g_number)
4283: OR NVL(per_asg_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)
4284: <>NVL(p_assignment_status_type_id,hr_api.g_number)
4285: OR NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)
4286: <>NVL(p_payroll_id,hr_api.g_number)
4287: OR NVL(per_asg_shd.g_old_rec.location_id,hr_api.g_number)

Line 4285: OR NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)

4281: OR NVL(per_asg_shd.g_old_rec.job_id,hr_api.g_number)
4282: <>NVL(p_job_id,hr_api.g_number)
4283: OR NVL(per_asg_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)
4284: <>NVL(p_assignment_status_type_id,hr_api.g_number)
4285: OR NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)
4286: <>NVL(p_payroll_id,hr_api.g_number)
4287: OR NVL(per_asg_shd.g_old_rec.location_id,hr_api.g_number)
4288: <>NVL(p_location_id,hr_api.g_number)
4289: OR NVL(per_asg_shd.g_old_rec.person_referred_by_id,hr_api.g_number)

Line 4287: OR NVL(per_asg_shd.g_old_rec.location_id,hr_api.g_number)

4283: OR NVL(per_asg_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)
4284: <>NVL(p_assignment_status_type_id,hr_api.g_number)
4285: OR NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)
4286: <>NVL(p_payroll_id,hr_api.g_number)
4287: OR NVL(per_asg_shd.g_old_rec.location_id,hr_api.g_number)
4288: <>NVL(p_location_id,hr_api.g_number)
4289: OR NVL(per_asg_shd.g_old_rec.person_referred_by_id,hr_api.g_number)
4290: <>NVL(p_person_referred_by_id,hr_api.g_number)
4291: OR NVL(per_asg_shd.g_old_rec.supervisor_id,hr_api.g_number)

Line 4289: OR NVL(per_asg_shd.g_old_rec.person_referred_by_id,hr_api.g_number)

4285: OR NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)
4286: <>NVL(p_payroll_id,hr_api.g_number)
4287: OR NVL(per_asg_shd.g_old_rec.location_id,hr_api.g_number)
4288: <>NVL(p_location_id,hr_api.g_number)
4289: OR NVL(per_asg_shd.g_old_rec.person_referred_by_id,hr_api.g_number)
4290: <>NVL(p_person_referred_by_id,hr_api.g_number)
4291: OR NVL(per_asg_shd.g_old_rec.supervisor_id,hr_api.g_number)
4292: <>NVL(p_supervisor_id,hr_api.g_number)
4293: OR NVL(per_asg_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)

Line 4291: OR NVL(per_asg_shd.g_old_rec.supervisor_id,hr_api.g_number)

4287: OR NVL(per_asg_shd.g_old_rec.location_id,hr_api.g_number)
4288: <>NVL(p_location_id,hr_api.g_number)
4289: OR NVL(per_asg_shd.g_old_rec.person_referred_by_id,hr_api.g_number)
4290: <>NVL(p_person_referred_by_id,hr_api.g_number)
4291: OR NVL(per_asg_shd.g_old_rec.supervisor_id,hr_api.g_number)
4292: <>NVL(p_supervisor_id,hr_api.g_number)
4293: OR NVL(per_asg_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
4294: <>NVL(p_supervisor_assignment_id,hr_api.g_number)
4295: OR NVL(per_asg_shd.g_old_rec.recruitment_activity_id,hr_api.g_number)

Line 4293: OR NVL(per_asg_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)

4289: OR NVL(per_asg_shd.g_old_rec.person_referred_by_id,hr_api.g_number)
4290: <>NVL(p_person_referred_by_id,hr_api.g_number)
4291: OR NVL(per_asg_shd.g_old_rec.supervisor_id,hr_api.g_number)
4292: <>NVL(p_supervisor_id,hr_api.g_number)
4293: OR NVL(per_asg_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
4294: <>NVL(p_supervisor_assignment_id,hr_api.g_number)
4295: OR NVL(per_asg_shd.g_old_rec.recruitment_activity_id,hr_api.g_number)
4296: <>NVL(p_recruitment_activity_id,hr_api.g_number)
4297: OR NVL(per_asg_shd.g_old_rec.source_organization_id,hr_api.g_number)

Line 4295: OR NVL(per_asg_shd.g_old_rec.recruitment_activity_id,hr_api.g_number)

4291: OR NVL(per_asg_shd.g_old_rec.supervisor_id,hr_api.g_number)
4292: <>NVL(p_supervisor_id,hr_api.g_number)
4293: OR NVL(per_asg_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
4294: <>NVL(p_supervisor_assignment_id,hr_api.g_number)
4295: OR NVL(per_asg_shd.g_old_rec.recruitment_activity_id,hr_api.g_number)
4296: <>NVL(p_recruitment_activity_id,hr_api.g_number)
4297: OR NVL(per_asg_shd.g_old_rec.source_organization_id,hr_api.g_number)
4298: <>NVL(p_source_organization_id,hr_api.g_number)
4299: OR NVL(per_asg_shd.g_old_rec.organization_id,hr_api.g_number)

Line 4297: OR NVL(per_asg_shd.g_old_rec.source_organization_id,hr_api.g_number)

4293: OR NVL(per_asg_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
4294: <>NVL(p_supervisor_assignment_id,hr_api.g_number)
4295: OR NVL(per_asg_shd.g_old_rec.recruitment_activity_id,hr_api.g_number)
4296: <>NVL(p_recruitment_activity_id,hr_api.g_number)
4297: OR NVL(per_asg_shd.g_old_rec.source_organization_id,hr_api.g_number)
4298: <>NVL(p_source_organization_id,hr_api.g_number)
4299: OR NVL(per_asg_shd.g_old_rec.organization_id,hr_api.g_number)
4300: <>NVL(p_organization_id,hr_api.g_number)
4301: OR NVL(l_pgp_rec.segment1,hr_api.g_varchar2)

Line 4299: OR NVL(per_asg_shd.g_old_rec.organization_id,hr_api.g_number)

4295: OR NVL(per_asg_shd.g_old_rec.recruitment_activity_id,hr_api.g_number)
4296: <>NVL(p_recruitment_activity_id,hr_api.g_number)
4297: OR NVL(per_asg_shd.g_old_rec.source_organization_id,hr_api.g_number)
4298: <>NVL(p_source_organization_id,hr_api.g_number)
4299: OR NVL(per_asg_shd.g_old_rec.organization_id,hr_api.g_number)
4300: <>NVL(p_organization_id,hr_api.g_number)
4301: OR NVL(l_pgp_rec.segment1,hr_api.g_varchar2)
4302: <>NVL(p_pgp_segment1,hr_api.g_varchar2)
4303: OR NVL(l_pgp_rec.segment2,hr_api.g_varchar2)

Line 4421: OR NVL(per_asg_shd.g_old_rec.vacancy_id,hr_api.g_number)

4417: OR NVL(l_scl_rec.segment29,hr_api.g_varchar2)
4418: <>NVL(p_scl_segment29,hr_api.g_varchar2)
4419: OR NVL(l_scl_rec.segment30,hr_api.g_varchar2)
4420: <>NVL(p_scl_segment30,hr_api.g_varchar2)
4421: OR NVL(per_asg_shd.g_old_rec.vacancy_id,hr_api.g_number)
4422: <>NVL(p_vacancy_id,hr_api.g_number)
4423: OR NVL(per_asg_shd.g_old_rec.pay_basis_id,hr_api.g_number)
4424: <>NVL(p_pay_basis_id,hr_api.g_number)
4425: OR NVL(per_asg_shd.g_old_rec.assignment_type,hr_api.g_varchar2)

Line 4423: OR NVL(per_asg_shd.g_old_rec.pay_basis_id,hr_api.g_number)

4419: OR NVL(l_scl_rec.segment30,hr_api.g_varchar2)
4420: <>NVL(p_scl_segment30,hr_api.g_varchar2)
4421: OR NVL(per_asg_shd.g_old_rec.vacancy_id,hr_api.g_number)
4422: <>NVL(p_vacancy_id,hr_api.g_number)
4423: OR NVL(per_asg_shd.g_old_rec.pay_basis_id,hr_api.g_number)
4424: <>NVL(p_pay_basis_id,hr_api.g_number)
4425: OR NVL(per_asg_shd.g_old_rec.assignment_type,hr_api.g_varchar2)
4426: <>NVL(p_assignment_type,hr_api.g_varchar2)
4427: OR NVL(per_asg_shd.g_old_rec.primary_flag,hr_api.g_varchar2)

Line 4425: OR NVL(per_asg_shd.g_old_rec.assignment_type,hr_api.g_varchar2)

4421: OR NVL(per_asg_shd.g_old_rec.vacancy_id,hr_api.g_number)
4422: <>NVL(p_vacancy_id,hr_api.g_number)
4423: OR NVL(per_asg_shd.g_old_rec.pay_basis_id,hr_api.g_number)
4424: <>NVL(p_pay_basis_id,hr_api.g_number)
4425: OR NVL(per_asg_shd.g_old_rec.assignment_type,hr_api.g_varchar2)
4426: <>NVL(p_assignment_type,hr_api.g_varchar2)
4427: OR NVL(per_asg_shd.g_old_rec.primary_flag,hr_api.g_varchar2)
4428: <>NVL(p_asg_primary_flag,hr_api.g_varchar2)
4429: OR NVL(per_asg_shd.g_old_rec.assignment_number,hr_api.g_varchar2)

Line 4427: OR NVL(per_asg_shd.g_old_rec.primary_flag,hr_api.g_varchar2)

4423: OR NVL(per_asg_shd.g_old_rec.pay_basis_id,hr_api.g_number)
4424: <>NVL(p_pay_basis_id,hr_api.g_number)
4425: OR NVL(per_asg_shd.g_old_rec.assignment_type,hr_api.g_varchar2)
4426: <>NVL(p_assignment_type,hr_api.g_varchar2)
4427: OR NVL(per_asg_shd.g_old_rec.primary_flag,hr_api.g_varchar2)
4428: <>NVL(p_asg_primary_flag,hr_api.g_varchar2)
4429: OR NVL(per_asg_shd.g_old_rec.assignment_number,hr_api.g_varchar2)
4430: <>NVL(l_assignment_number,hr_api.g_varchar2)
4431: OR NVL(per_asg_shd.g_old_rec.date_probation_end,hr_api.g_date)

Line 4429: OR NVL(per_asg_shd.g_old_rec.assignment_number,hr_api.g_varchar2)

4425: OR NVL(per_asg_shd.g_old_rec.assignment_type,hr_api.g_varchar2)
4426: <>NVL(p_assignment_type,hr_api.g_varchar2)
4427: OR NVL(per_asg_shd.g_old_rec.primary_flag,hr_api.g_varchar2)
4428: <>NVL(p_asg_primary_flag,hr_api.g_varchar2)
4429: OR NVL(per_asg_shd.g_old_rec.assignment_number,hr_api.g_varchar2)
4430: <>NVL(l_assignment_number,hr_api.g_varchar2)
4431: OR NVL(per_asg_shd.g_old_rec.date_probation_end,hr_api.g_date)
4432: <>NVL(p_date_probation_end,hr_api.g_date)
4433: OR NVL(per_asg_shd.g_old_rec.default_code_comb_id,hr_api.g_number)

Line 4431: OR NVL(per_asg_shd.g_old_rec.date_probation_end,hr_api.g_date)

4427: OR NVL(per_asg_shd.g_old_rec.primary_flag,hr_api.g_varchar2)
4428: <>NVL(p_asg_primary_flag,hr_api.g_varchar2)
4429: OR NVL(per_asg_shd.g_old_rec.assignment_number,hr_api.g_varchar2)
4430: <>NVL(l_assignment_number,hr_api.g_varchar2)
4431: OR NVL(per_asg_shd.g_old_rec.date_probation_end,hr_api.g_date)
4432: <>NVL(p_date_probation_end,hr_api.g_date)
4433: OR NVL(per_asg_shd.g_old_rec.default_code_comb_id,hr_api.g_number)
4434: <>NVL(p_default_code_comb_id,hr_api.g_number)
4435: OR NVL(per_asg_shd.g_old_rec.employment_category,hr_api.g_varchar2)

Line 4433: OR NVL(per_asg_shd.g_old_rec.default_code_comb_id,hr_api.g_number)

4429: OR NVL(per_asg_shd.g_old_rec.assignment_number,hr_api.g_varchar2)
4430: <>NVL(l_assignment_number,hr_api.g_varchar2)
4431: OR NVL(per_asg_shd.g_old_rec.date_probation_end,hr_api.g_date)
4432: <>NVL(p_date_probation_end,hr_api.g_date)
4433: OR NVL(per_asg_shd.g_old_rec.default_code_comb_id,hr_api.g_number)
4434: <>NVL(p_default_code_comb_id,hr_api.g_number)
4435: OR NVL(per_asg_shd.g_old_rec.employment_category,hr_api.g_varchar2)
4436: <>NVL(p_employment_category,hr_api.g_varchar2)
4437: OR NVL(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2)

Line 4435: OR NVL(per_asg_shd.g_old_rec.employment_category,hr_api.g_varchar2)

4431: OR NVL(per_asg_shd.g_old_rec.date_probation_end,hr_api.g_date)
4432: <>NVL(p_date_probation_end,hr_api.g_date)
4433: OR NVL(per_asg_shd.g_old_rec.default_code_comb_id,hr_api.g_number)
4434: <>NVL(p_default_code_comb_id,hr_api.g_number)
4435: OR NVL(per_asg_shd.g_old_rec.employment_category,hr_api.g_varchar2)
4436: <>NVL(p_employment_category,hr_api.g_varchar2)
4437: OR NVL(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2)
4438: <>NVL(p_employee_category,hr_api.g_varchar2)
4439: OR NVL(per_asg_shd.g_old_rec.frequency,hr_api.g_varchar2)

Line 4437: OR NVL(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2)

4433: OR NVL(per_asg_shd.g_old_rec.default_code_comb_id,hr_api.g_number)
4434: <>NVL(p_default_code_comb_id,hr_api.g_number)
4435: OR NVL(per_asg_shd.g_old_rec.employment_category,hr_api.g_varchar2)
4436: <>NVL(p_employment_category,hr_api.g_varchar2)
4437: OR NVL(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2)
4438: <>NVL(p_employee_category,hr_api.g_varchar2)
4439: OR NVL(per_asg_shd.g_old_rec.frequency,hr_api.g_varchar2)
4440: <>NVL(p_frequency,hr_api.g_varchar2)
4441: OR NVL(per_asg_shd.g_old_rec.normal_hours,hr_api.g_number)

Line 4439: OR NVL(per_asg_shd.g_old_rec.frequency,hr_api.g_varchar2)

4435: OR NVL(per_asg_shd.g_old_rec.employment_category,hr_api.g_varchar2)
4436: <>NVL(p_employment_category,hr_api.g_varchar2)
4437: OR NVL(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2)
4438: <>NVL(p_employee_category,hr_api.g_varchar2)
4439: OR NVL(per_asg_shd.g_old_rec.frequency,hr_api.g_varchar2)
4440: <>NVL(p_frequency,hr_api.g_varchar2)
4441: OR NVL(per_asg_shd.g_old_rec.normal_hours,hr_api.g_number)
4442: <>NVL(p_normal_hours,hr_api.g_number)
4443: OR NVL(per_asg_shd.g_old_rec.probation_period,hr_api.g_number)

Line 4441: OR NVL(per_asg_shd.g_old_rec.normal_hours,hr_api.g_number)

4437: OR NVL(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2)
4438: <>NVL(p_employee_category,hr_api.g_varchar2)
4439: OR NVL(per_asg_shd.g_old_rec.frequency,hr_api.g_varchar2)
4440: <>NVL(p_frequency,hr_api.g_varchar2)
4441: OR NVL(per_asg_shd.g_old_rec.normal_hours,hr_api.g_number)
4442: <>NVL(p_normal_hours,hr_api.g_number)
4443: OR NVL(per_asg_shd.g_old_rec.probation_period,hr_api.g_number)
4444: <>NVL(p_probation_period,hr_api.g_number)
4445: OR NVL(per_asg_shd.g_old_rec.probation_unit,hr_api.g_varchar2)

Line 4443: OR NVL(per_asg_shd.g_old_rec.probation_period,hr_api.g_number)

4439: OR NVL(per_asg_shd.g_old_rec.frequency,hr_api.g_varchar2)
4440: <>NVL(p_frequency,hr_api.g_varchar2)
4441: OR NVL(per_asg_shd.g_old_rec.normal_hours,hr_api.g_number)
4442: <>NVL(p_normal_hours,hr_api.g_number)
4443: OR NVL(per_asg_shd.g_old_rec.probation_period,hr_api.g_number)
4444: <>NVL(p_probation_period,hr_api.g_number)
4445: OR NVL(per_asg_shd.g_old_rec.probation_unit,hr_api.g_varchar2)
4446: <>NVL(p_probation_unit,hr_api.g_varchar2)
4447: OR NVL(per_asg_shd.g_old_rec.notice_period,hr_api.g_number)

Line 4445: OR NVL(per_asg_shd.g_old_rec.probation_unit,hr_api.g_varchar2)

4441: OR NVL(per_asg_shd.g_old_rec.normal_hours,hr_api.g_number)
4442: <>NVL(p_normal_hours,hr_api.g_number)
4443: OR NVL(per_asg_shd.g_old_rec.probation_period,hr_api.g_number)
4444: <>NVL(p_probation_period,hr_api.g_number)
4445: OR NVL(per_asg_shd.g_old_rec.probation_unit,hr_api.g_varchar2)
4446: <>NVL(p_probation_unit,hr_api.g_varchar2)
4447: OR NVL(per_asg_shd.g_old_rec.notice_period,hr_api.g_number)
4448: <>NVL(p_notice_period,hr_api.g_number)
4449: OR NVL(per_asg_shd.g_old_rec.notice_period_uom,hr_api.g_varchar2)

Line 4447: OR NVL(per_asg_shd.g_old_rec.notice_period,hr_api.g_number)

4443: OR NVL(per_asg_shd.g_old_rec.probation_period,hr_api.g_number)
4444: <>NVL(p_probation_period,hr_api.g_number)
4445: OR NVL(per_asg_shd.g_old_rec.probation_unit,hr_api.g_varchar2)
4446: <>NVL(p_probation_unit,hr_api.g_varchar2)
4447: OR NVL(per_asg_shd.g_old_rec.notice_period,hr_api.g_number)
4448: <>NVL(p_notice_period,hr_api.g_number)
4449: OR NVL(per_asg_shd.g_old_rec.notice_period_uom,hr_api.g_varchar2)
4450: <>NVL(p_notice_unit,hr_api.g_varchar2)
4451: OR NVL(per_asg_shd.g_old_rec.set_of_books_id,hr_api.g_number)

Line 4449: OR NVL(per_asg_shd.g_old_rec.notice_period_uom,hr_api.g_varchar2)

4445: OR NVL(per_asg_shd.g_old_rec.probation_unit,hr_api.g_varchar2)
4446: <>NVL(p_probation_unit,hr_api.g_varchar2)
4447: OR NVL(per_asg_shd.g_old_rec.notice_period,hr_api.g_number)
4448: <>NVL(p_notice_period,hr_api.g_number)
4449: OR NVL(per_asg_shd.g_old_rec.notice_period_uom,hr_api.g_varchar2)
4450: <>NVL(p_notice_unit,hr_api.g_varchar2)
4451: OR NVL(per_asg_shd.g_old_rec.set_of_books_id,hr_api.g_number)
4452: <>NVL(p_set_of_books_id,hr_api.g_number)
4453: OR NVL(per_asg_shd.g_old_rec.title,hr_api.g_varchar2)

Line 4451: OR NVL(per_asg_shd.g_old_rec.set_of_books_id,hr_api.g_number)

4447: OR NVL(per_asg_shd.g_old_rec.notice_period,hr_api.g_number)
4448: <>NVL(p_notice_period,hr_api.g_number)
4449: OR NVL(per_asg_shd.g_old_rec.notice_period_uom,hr_api.g_varchar2)
4450: <>NVL(p_notice_unit,hr_api.g_varchar2)
4451: OR NVL(per_asg_shd.g_old_rec.set_of_books_id,hr_api.g_number)
4452: <>NVL(p_set_of_books_id,hr_api.g_number)
4453: OR NVL(per_asg_shd.g_old_rec.title,hr_api.g_varchar2)
4454: <>NVL(p_billing_title,hr_api.g_varchar2)
4455: OR NVL(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2)

Line 4453: OR NVL(per_asg_shd.g_old_rec.title,hr_api.g_varchar2)

4449: OR NVL(per_asg_shd.g_old_rec.notice_period_uom,hr_api.g_varchar2)
4450: <>NVL(p_notice_unit,hr_api.g_varchar2)
4451: OR NVL(per_asg_shd.g_old_rec.set_of_books_id,hr_api.g_number)
4452: <>NVL(p_set_of_books_id,hr_api.g_number)
4453: OR NVL(per_asg_shd.g_old_rec.title,hr_api.g_varchar2)
4454: <>NVL(p_billing_title,hr_api.g_varchar2)
4455: OR NVL(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2)
4456: <>NVL(p_time_normal_finish,hr_api.g_varchar2)
4457: OR NVL(per_asg_shd.g_old_rec.time_normal_start,hr_api.g_varchar2)

Line 4455: OR NVL(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2)

4451: OR NVL(per_asg_shd.g_old_rec.set_of_books_id,hr_api.g_number)
4452: <>NVL(p_set_of_books_id,hr_api.g_number)
4453: OR NVL(per_asg_shd.g_old_rec.title,hr_api.g_varchar2)
4454: <>NVL(p_billing_title,hr_api.g_varchar2)
4455: OR NVL(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2)
4456: <>NVL(p_time_normal_finish,hr_api.g_varchar2)
4457: OR NVL(per_asg_shd.g_old_rec.time_normal_start,hr_api.g_varchar2)
4458: <>NVL(p_time_normal_start,hr_api.g_varchar2)
4459: OR NVL(per_asg_shd.g_old_rec.ass_attribute_category,hr_api.g_varchar2)

Line 4457: OR NVL(per_asg_shd.g_old_rec.time_normal_start,hr_api.g_varchar2)

4453: OR NVL(per_asg_shd.g_old_rec.title,hr_api.g_varchar2)
4454: <>NVL(p_billing_title,hr_api.g_varchar2)
4455: OR NVL(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2)
4456: <>NVL(p_time_normal_finish,hr_api.g_varchar2)
4457: OR NVL(per_asg_shd.g_old_rec.time_normal_start,hr_api.g_varchar2)
4458: <>NVL(p_time_normal_start,hr_api.g_varchar2)
4459: OR NVL(per_asg_shd.g_old_rec.ass_attribute_category,hr_api.g_varchar2)
4460: <>NVL(p_ass_attribute_category,hr_api.g_varchar2)
4461: OR NVL(per_asg_shd.g_old_rec.ass_attribute1,hr_api.g_varchar2)

Line 4459: OR NVL(per_asg_shd.g_old_rec.ass_attribute_category,hr_api.g_varchar2)

4455: OR NVL(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2)
4456: <>NVL(p_time_normal_finish,hr_api.g_varchar2)
4457: OR NVL(per_asg_shd.g_old_rec.time_normal_start,hr_api.g_varchar2)
4458: <>NVL(p_time_normal_start,hr_api.g_varchar2)
4459: OR NVL(per_asg_shd.g_old_rec.ass_attribute_category,hr_api.g_varchar2)
4460: <>NVL(p_ass_attribute_category,hr_api.g_varchar2)
4461: OR NVL(per_asg_shd.g_old_rec.ass_attribute1,hr_api.g_varchar2)
4462: <>NVL(p_ass_attribute1,hr_api.g_varchar2)
4463: OR NVL(per_asg_shd.g_old_rec.ass_attribute2,hr_api.g_varchar2)

Line 4461: OR NVL(per_asg_shd.g_old_rec.ass_attribute1,hr_api.g_varchar2)

4457: OR NVL(per_asg_shd.g_old_rec.time_normal_start,hr_api.g_varchar2)
4458: <>NVL(p_time_normal_start,hr_api.g_varchar2)
4459: OR NVL(per_asg_shd.g_old_rec.ass_attribute_category,hr_api.g_varchar2)
4460: <>NVL(p_ass_attribute_category,hr_api.g_varchar2)
4461: OR NVL(per_asg_shd.g_old_rec.ass_attribute1,hr_api.g_varchar2)
4462: <>NVL(p_ass_attribute1,hr_api.g_varchar2)
4463: OR NVL(per_asg_shd.g_old_rec.ass_attribute2,hr_api.g_varchar2)
4464: <>NVL(p_ass_attribute2,hr_api.g_varchar2)
4465: OR NVL(per_asg_shd.g_old_rec.ass_attribute3,hr_api.g_varchar2)

Line 4463: OR NVL(per_asg_shd.g_old_rec.ass_attribute2,hr_api.g_varchar2)

4459: OR NVL(per_asg_shd.g_old_rec.ass_attribute_category,hr_api.g_varchar2)
4460: <>NVL(p_ass_attribute_category,hr_api.g_varchar2)
4461: OR NVL(per_asg_shd.g_old_rec.ass_attribute1,hr_api.g_varchar2)
4462: <>NVL(p_ass_attribute1,hr_api.g_varchar2)
4463: OR NVL(per_asg_shd.g_old_rec.ass_attribute2,hr_api.g_varchar2)
4464: <>NVL(p_ass_attribute2,hr_api.g_varchar2)
4465: OR NVL(per_asg_shd.g_old_rec.ass_attribute3,hr_api.g_varchar2)
4466: <>NVL(p_ass_attribute3,hr_api.g_varchar2)
4467: OR NVL(per_asg_shd.g_old_rec.ass_attribute4,hr_api.g_varchar2)

Line 4465: OR NVL(per_asg_shd.g_old_rec.ass_attribute3,hr_api.g_varchar2)

4461: OR NVL(per_asg_shd.g_old_rec.ass_attribute1,hr_api.g_varchar2)
4462: <>NVL(p_ass_attribute1,hr_api.g_varchar2)
4463: OR NVL(per_asg_shd.g_old_rec.ass_attribute2,hr_api.g_varchar2)
4464: <>NVL(p_ass_attribute2,hr_api.g_varchar2)
4465: OR NVL(per_asg_shd.g_old_rec.ass_attribute3,hr_api.g_varchar2)
4466: <>NVL(p_ass_attribute3,hr_api.g_varchar2)
4467: OR NVL(per_asg_shd.g_old_rec.ass_attribute4,hr_api.g_varchar2)
4468: <>NVL(p_ass_attribute4,hr_api.g_varchar2)
4469: OR NVL(per_asg_shd.g_old_rec.ass_attribute5,hr_api.g_varchar2)

Line 4467: OR NVL(per_asg_shd.g_old_rec.ass_attribute4,hr_api.g_varchar2)

4463: OR NVL(per_asg_shd.g_old_rec.ass_attribute2,hr_api.g_varchar2)
4464: <>NVL(p_ass_attribute2,hr_api.g_varchar2)
4465: OR NVL(per_asg_shd.g_old_rec.ass_attribute3,hr_api.g_varchar2)
4466: <>NVL(p_ass_attribute3,hr_api.g_varchar2)
4467: OR NVL(per_asg_shd.g_old_rec.ass_attribute4,hr_api.g_varchar2)
4468: <>NVL(p_ass_attribute4,hr_api.g_varchar2)
4469: OR NVL(per_asg_shd.g_old_rec.ass_attribute5,hr_api.g_varchar2)
4470: <>NVL(p_ass_attribute5,hr_api.g_varchar2)
4471: OR NVL(per_asg_shd.g_old_rec.ass_attribute6,hr_api.g_varchar2)

Line 4469: OR NVL(per_asg_shd.g_old_rec.ass_attribute5,hr_api.g_varchar2)

4465: OR NVL(per_asg_shd.g_old_rec.ass_attribute3,hr_api.g_varchar2)
4466: <>NVL(p_ass_attribute3,hr_api.g_varchar2)
4467: OR NVL(per_asg_shd.g_old_rec.ass_attribute4,hr_api.g_varchar2)
4468: <>NVL(p_ass_attribute4,hr_api.g_varchar2)
4469: OR NVL(per_asg_shd.g_old_rec.ass_attribute5,hr_api.g_varchar2)
4470: <>NVL(p_ass_attribute5,hr_api.g_varchar2)
4471: OR NVL(per_asg_shd.g_old_rec.ass_attribute6,hr_api.g_varchar2)
4472: <>NVL(p_ass_attribute6,hr_api.g_varchar2)
4473: OR NVL(per_asg_shd.g_old_rec.ass_attribute7,hr_api.g_varchar2)

Line 4471: OR NVL(per_asg_shd.g_old_rec.ass_attribute6,hr_api.g_varchar2)

4467: OR NVL(per_asg_shd.g_old_rec.ass_attribute4,hr_api.g_varchar2)
4468: <>NVL(p_ass_attribute4,hr_api.g_varchar2)
4469: OR NVL(per_asg_shd.g_old_rec.ass_attribute5,hr_api.g_varchar2)
4470: <>NVL(p_ass_attribute5,hr_api.g_varchar2)
4471: OR NVL(per_asg_shd.g_old_rec.ass_attribute6,hr_api.g_varchar2)
4472: <>NVL(p_ass_attribute6,hr_api.g_varchar2)
4473: OR NVL(per_asg_shd.g_old_rec.ass_attribute7,hr_api.g_varchar2)
4474: <>NVL(p_ass_attribute7,hr_api.g_varchar2)
4475: OR NVL(per_asg_shd.g_old_rec.ass_attribute8,hr_api.g_varchar2)

Line 4473: OR NVL(per_asg_shd.g_old_rec.ass_attribute7,hr_api.g_varchar2)

4469: OR NVL(per_asg_shd.g_old_rec.ass_attribute5,hr_api.g_varchar2)
4470: <>NVL(p_ass_attribute5,hr_api.g_varchar2)
4471: OR NVL(per_asg_shd.g_old_rec.ass_attribute6,hr_api.g_varchar2)
4472: <>NVL(p_ass_attribute6,hr_api.g_varchar2)
4473: OR NVL(per_asg_shd.g_old_rec.ass_attribute7,hr_api.g_varchar2)
4474: <>NVL(p_ass_attribute7,hr_api.g_varchar2)
4475: OR NVL(per_asg_shd.g_old_rec.ass_attribute8,hr_api.g_varchar2)
4476: <>NVL(p_ass_attribute8,hr_api.g_varchar2)
4477: OR NVL(per_asg_shd.g_old_rec.ass_attribute9,hr_api.g_varchar2)

Line 4475: OR NVL(per_asg_shd.g_old_rec.ass_attribute8,hr_api.g_varchar2)

4471: OR NVL(per_asg_shd.g_old_rec.ass_attribute6,hr_api.g_varchar2)
4472: <>NVL(p_ass_attribute6,hr_api.g_varchar2)
4473: OR NVL(per_asg_shd.g_old_rec.ass_attribute7,hr_api.g_varchar2)
4474: <>NVL(p_ass_attribute7,hr_api.g_varchar2)
4475: OR NVL(per_asg_shd.g_old_rec.ass_attribute8,hr_api.g_varchar2)
4476: <>NVL(p_ass_attribute8,hr_api.g_varchar2)
4477: OR NVL(per_asg_shd.g_old_rec.ass_attribute9,hr_api.g_varchar2)
4478: <>NVL(p_ass_attribute9,hr_api.g_varchar2)
4479: OR NVL(per_asg_shd.g_old_rec.ass_attribute10,hr_api.g_varchar2)

Line 4477: OR NVL(per_asg_shd.g_old_rec.ass_attribute9,hr_api.g_varchar2)

4473: OR NVL(per_asg_shd.g_old_rec.ass_attribute7,hr_api.g_varchar2)
4474: <>NVL(p_ass_attribute7,hr_api.g_varchar2)
4475: OR NVL(per_asg_shd.g_old_rec.ass_attribute8,hr_api.g_varchar2)
4476: <>NVL(p_ass_attribute8,hr_api.g_varchar2)
4477: OR NVL(per_asg_shd.g_old_rec.ass_attribute9,hr_api.g_varchar2)
4478: <>NVL(p_ass_attribute9,hr_api.g_varchar2)
4479: OR NVL(per_asg_shd.g_old_rec.ass_attribute10,hr_api.g_varchar2)
4480: <>NVL(p_ass_attribute10,hr_api.g_varchar2)
4481: OR NVL(per_asg_shd.g_old_rec.ass_attribute11,hr_api.g_varchar2)

Line 4479: OR NVL(per_asg_shd.g_old_rec.ass_attribute10,hr_api.g_varchar2)

4475: OR NVL(per_asg_shd.g_old_rec.ass_attribute8,hr_api.g_varchar2)
4476: <>NVL(p_ass_attribute8,hr_api.g_varchar2)
4477: OR NVL(per_asg_shd.g_old_rec.ass_attribute9,hr_api.g_varchar2)
4478: <>NVL(p_ass_attribute9,hr_api.g_varchar2)
4479: OR NVL(per_asg_shd.g_old_rec.ass_attribute10,hr_api.g_varchar2)
4480: <>NVL(p_ass_attribute10,hr_api.g_varchar2)
4481: OR NVL(per_asg_shd.g_old_rec.ass_attribute11,hr_api.g_varchar2)
4482: <>NVL(p_ass_attribute11,hr_api.g_varchar2)
4483: OR NVL(per_asg_shd.g_old_rec.ass_attribute12,hr_api.g_varchar2)

Line 4481: OR NVL(per_asg_shd.g_old_rec.ass_attribute11,hr_api.g_varchar2)

4477: OR NVL(per_asg_shd.g_old_rec.ass_attribute9,hr_api.g_varchar2)
4478: <>NVL(p_ass_attribute9,hr_api.g_varchar2)
4479: OR NVL(per_asg_shd.g_old_rec.ass_attribute10,hr_api.g_varchar2)
4480: <>NVL(p_ass_attribute10,hr_api.g_varchar2)
4481: OR NVL(per_asg_shd.g_old_rec.ass_attribute11,hr_api.g_varchar2)
4482: <>NVL(p_ass_attribute11,hr_api.g_varchar2)
4483: OR NVL(per_asg_shd.g_old_rec.ass_attribute12,hr_api.g_varchar2)
4484: <>NVL(p_ass_attribute12,hr_api.g_varchar2)
4485: OR NVL(per_asg_shd.g_old_rec.ass_attribute13,hr_api.g_varchar2)

Line 4483: OR NVL(per_asg_shd.g_old_rec.ass_attribute12,hr_api.g_varchar2)

4479: OR NVL(per_asg_shd.g_old_rec.ass_attribute10,hr_api.g_varchar2)
4480: <>NVL(p_ass_attribute10,hr_api.g_varchar2)
4481: OR NVL(per_asg_shd.g_old_rec.ass_attribute11,hr_api.g_varchar2)
4482: <>NVL(p_ass_attribute11,hr_api.g_varchar2)
4483: OR NVL(per_asg_shd.g_old_rec.ass_attribute12,hr_api.g_varchar2)
4484: <>NVL(p_ass_attribute12,hr_api.g_varchar2)
4485: OR NVL(per_asg_shd.g_old_rec.ass_attribute13,hr_api.g_varchar2)
4486: <>NVL(p_ass_attribute13,hr_api.g_varchar2)
4487: OR NVL(per_asg_shd.g_old_rec.ass_attribute14,hr_api.g_varchar2)

Line 4485: OR NVL(per_asg_shd.g_old_rec.ass_attribute13,hr_api.g_varchar2)

4481: OR NVL(per_asg_shd.g_old_rec.ass_attribute11,hr_api.g_varchar2)
4482: <>NVL(p_ass_attribute11,hr_api.g_varchar2)
4483: OR NVL(per_asg_shd.g_old_rec.ass_attribute12,hr_api.g_varchar2)
4484: <>NVL(p_ass_attribute12,hr_api.g_varchar2)
4485: OR NVL(per_asg_shd.g_old_rec.ass_attribute13,hr_api.g_varchar2)
4486: <>NVL(p_ass_attribute13,hr_api.g_varchar2)
4487: OR NVL(per_asg_shd.g_old_rec.ass_attribute14,hr_api.g_varchar2)
4488: <>NVL(p_ass_attribute14,hr_api.g_varchar2)
4489: OR NVL(per_asg_shd.g_old_rec.ass_attribute15,hr_api.g_varchar2)

Line 4487: OR NVL(per_asg_shd.g_old_rec.ass_attribute14,hr_api.g_varchar2)

4483: OR NVL(per_asg_shd.g_old_rec.ass_attribute12,hr_api.g_varchar2)
4484: <>NVL(p_ass_attribute12,hr_api.g_varchar2)
4485: OR NVL(per_asg_shd.g_old_rec.ass_attribute13,hr_api.g_varchar2)
4486: <>NVL(p_ass_attribute13,hr_api.g_varchar2)
4487: OR NVL(per_asg_shd.g_old_rec.ass_attribute14,hr_api.g_varchar2)
4488: <>NVL(p_ass_attribute14,hr_api.g_varchar2)
4489: OR NVL(per_asg_shd.g_old_rec.ass_attribute15,hr_api.g_varchar2)
4490: <>NVL(p_ass_attribute15,hr_api.g_varchar2)
4491: OR NVL(per_asg_shd.g_old_rec.ass_attribute16,hr_api.g_varchar2)

Line 4489: OR NVL(per_asg_shd.g_old_rec.ass_attribute15,hr_api.g_varchar2)

4485: OR NVL(per_asg_shd.g_old_rec.ass_attribute13,hr_api.g_varchar2)
4486: <>NVL(p_ass_attribute13,hr_api.g_varchar2)
4487: OR NVL(per_asg_shd.g_old_rec.ass_attribute14,hr_api.g_varchar2)
4488: <>NVL(p_ass_attribute14,hr_api.g_varchar2)
4489: OR NVL(per_asg_shd.g_old_rec.ass_attribute15,hr_api.g_varchar2)
4490: <>NVL(p_ass_attribute15,hr_api.g_varchar2)
4491: OR NVL(per_asg_shd.g_old_rec.ass_attribute16,hr_api.g_varchar2)
4492: <>NVL(p_ass_attribute16,hr_api.g_varchar2)
4493: OR NVL(per_asg_shd.g_old_rec.ass_attribute17,hr_api.g_varchar2)

Line 4491: OR NVL(per_asg_shd.g_old_rec.ass_attribute16,hr_api.g_varchar2)

4487: OR NVL(per_asg_shd.g_old_rec.ass_attribute14,hr_api.g_varchar2)
4488: <>NVL(p_ass_attribute14,hr_api.g_varchar2)
4489: OR NVL(per_asg_shd.g_old_rec.ass_attribute15,hr_api.g_varchar2)
4490: <>NVL(p_ass_attribute15,hr_api.g_varchar2)
4491: OR NVL(per_asg_shd.g_old_rec.ass_attribute16,hr_api.g_varchar2)
4492: <>NVL(p_ass_attribute16,hr_api.g_varchar2)
4493: OR NVL(per_asg_shd.g_old_rec.ass_attribute17,hr_api.g_varchar2)
4494: <>NVL(p_ass_attribute17,hr_api.g_varchar2)
4495: OR NVL(per_asg_shd.g_old_rec.ass_attribute18,hr_api.g_varchar2)

Line 4493: OR NVL(per_asg_shd.g_old_rec.ass_attribute17,hr_api.g_varchar2)

4489: OR NVL(per_asg_shd.g_old_rec.ass_attribute15,hr_api.g_varchar2)
4490: <>NVL(p_ass_attribute15,hr_api.g_varchar2)
4491: OR NVL(per_asg_shd.g_old_rec.ass_attribute16,hr_api.g_varchar2)
4492: <>NVL(p_ass_attribute16,hr_api.g_varchar2)
4493: OR NVL(per_asg_shd.g_old_rec.ass_attribute17,hr_api.g_varchar2)
4494: <>NVL(p_ass_attribute17,hr_api.g_varchar2)
4495: OR NVL(per_asg_shd.g_old_rec.ass_attribute18,hr_api.g_varchar2)
4496: <>NVL(p_ass_attribute18,hr_api.g_varchar2)
4497: OR NVL(per_asg_shd.g_old_rec.ass_attribute19,hr_api.g_varchar2)

Line 4495: OR NVL(per_asg_shd.g_old_rec.ass_attribute18,hr_api.g_varchar2)

4491: OR NVL(per_asg_shd.g_old_rec.ass_attribute16,hr_api.g_varchar2)
4492: <>NVL(p_ass_attribute16,hr_api.g_varchar2)
4493: OR NVL(per_asg_shd.g_old_rec.ass_attribute17,hr_api.g_varchar2)
4494: <>NVL(p_ass_attribute17,hr_api.g_varchar2)
4495: OR NVL(per_asg_shd.g_old_rec.ass_attribute18,hr_api.g_varchar2)
4496: <>NVL(p_ass_attribute18,hr_api.g_varchar2)
4497: OR NVL(per_asg_shd.g_old_rec.ass_attribute19,hr_api.g_varchar2)
4498: <>NVL(p_ass_attribute19,hr_api.g_varchar2)
4499: OR NVL(per_asg_shd.g_old_rec.ass_attribute20,hr_api.g_varchar2)

Line 4497: OR NVL(per_asg_shd.g_old_rec.ass_attribute19,hr_api.g_varchar2)

4493: OR NVL(per_asg_shd.g_old_rec.ass_attribute17,hr_api.g_varchar2)
4494: <>NVL(p_ass_attribute17,hr_api.g_varchar2)
4495: OR NVL(per_asg_shd.g_old_rec.ass_attribute18,hr_api.g_varchar2)
4496: <>NVL(p_ass_attribute18,hr_api.g_varchar2)
4497: OR NVL(per_asg_shd.g_old_rec.ass_attribute19,hr_api.g_varchar2)
4498: <>NVL(p_ass_attribute19,hr_api.g_varchar2)
4499: OR NVL(per_asg_shd.g_old_rec.ass_attribute20,hr_api.g_varchar2)
4500: <>NVL(p_ass_attribute20,hr_api.g_varchar2)
4501: OR NVL(per_asg_shd.g_old_rec.ass_attribute21,hr_api.g_varchar2)

Line 4499: OR NVL(per_asg_shd.g_old_rec.ass_attribute20,hr_api.g_varchar2)

4495: OR NVL(per_asg_shd.g_old_rec.ass_attribute18,hr_api.g_varchar2)
4496: <>NVL(p_ass_attribute18,hr_api.g_varchar2)
4497: OR NVL(per_asg_shd.g_old_rec.ass_attribute19,hr_api.g_varchar2)
4498: <>NVL(p_ass_attribute19,hr_api.g_varchar2)
4499: OR NVL(per_asg_shd.g_old_rec.ass_attribute20,hr_api.g_varchar2)
4500: <>NVL(p_ass_attribute20,hr_api.g_varchar2)
4501: OR NVL(per_asg_shd.g_old_rec.ass_attribute21,hr_api.g_varchar2)
4502: <>NVL(p_ass_attribute21,hr_api.g_varchar2)
4503: OR NVL(per_asg_shd.g_old_rec.ass_attribute22,hr_api.g_varchar2)

Line 4501: OR NVL(per_asg_shd.g_old_rec.ass_attribute21,hr_api.g_varchar2)

4497: OR NVL(per_asg_shd.g_old_rec.ass_attribute19,hr_api.g_varchar2)
4498: <>NVL(p_ass_attribute19,hr_api.g_varchar2)
4499: OR NVL(per_asg_shd.g_old_rec.ass_attribute20,hr_api.g_varchar2)
4500: <>NVL(p_ass_attribute20,hr_api.g_varchar2)
4501: OR NVL(per_asg_shd.g_old_rec.ass_attribute21,hr_api.g_varchar2)
4502: <>NVL(p_ass_attribute21,hr_api.g_varchar2)
4503: OR NVL(per_asg_shd.g_old_rec.ass_attribute22,hr_api.g_varchar2)
4504: <>NVL(p_ass_attribute22,hr_api.g_varchar2)
4505: OR NVL(per_asg_shd.g_old_rec.ass_attribute23,hr_api.g_varchar2)

Line 4503: OR NVL(per_asg_shd.g_old_rec.ass_attribute22,hr_api.g_varchar2)

4499: OR NVL(per_asg_shd.g_old_rec.ass_attribute20,hr_api.g_varchar2)
4500: <>NVL(p_ass_attribute20,hr_api.g_varchar2)
4501: OR NVL(per_asg_shd.g_old_rec.ass_attribute21,hr_api.g_varchar2)
4502: <>NVL(p_ass_attribute21,hr_api.g_varchar2)
4503: OR NVL(per_asg_shd.g_old_rec.ass_attribute22,hr_api.g_varchar2)
4504: <>NVL(p_ass_attribute22,hr_api.g_varchar2)
4505: OR NVL(per_asg_shd.g_old_rec.ass_attribute23,hr_api.g_varchar2)
4506: <>NVL(p_ass_attribute23,hr_api.g_varchar2)
4507: OR NVL(per_asg_shd.g_old_rec.ass_attribute24,hr_api.g_varchar2)

Line 4505: OR NVL(per_asg_shd.g_old_rec.ass_attribute23,hr_api.g_varchar2)

4501: OR NVL(per_asg_shd.g_old_rec.ass_attribute21,hr_api.g_varchar2)
4502: <>NVL(p_ass_attribute21,hr_api.g_varchar2)
4503: OR NVL(per_asg_shd.g_old_rec.ass_attribute22,hr_api.g_varchar2)
4504: <>NVL(p_ass_attribute22,hr_api.g_varchar2)
4505: OR NVL(per_asg_shd.g_old_rec.ass_attribute23,hr_api.g_varchar2)
4506: <>NVL(p_ass_attribute23,hr_api.g_varchar2)
4507: OR NVL(per_asg_shd.g_old_rec.ass_attribute24,hr_api.g_varchar2)
4508: <>NVL(p_ass_attribute24,hr_api.g_varchar2)
4509: OR NVL(per_asg_shd.g_old_rec.ass_attribute25,hr_api.g_varchar2)

Line 4507: OR NVL(per_asg_shd.g_old_rec.ass_attribute24,hr_api.g_varchar2)

4503: OR NVL(per_asg_shd.g_old_rec.ass_attribute22,hr_api.g_varchar2)
4504: <>NVL(p_ass_attribute22,hr_api.g_varchar2)
4505: OR NVL(per_asg_shd.g_old_rec.ass_attribute23,hr_api.g_varchar2)
4506: <>NVL(p_ass_attribute23,hr_api.g_varchar2)
4507: OR NVL(per_asg_shd.g_old_rec.ass_attribute24,hr_api.g_varchar2)
4508: <>NVL(p_ass_attribute24,hr_api.g_varchar2)
4509: OR NVL(per_asg_shd.g_old_rec.ass_attribute25,hr_api.g_varchar2)
4510: <>NVL(p_ass_attribute25,hr_api.g_varchar2)
4511: OR NVL(per_asg_shd.g_old_rec.ass_attribute26,hr_api.g_varchar2)

Line 4509: OR NVL(per_asg_shd.g_old_rec.ass_attribute25,hr_api.g_varchar2)

4505: OR NVL(per_asg_shd.g_old_rec.ass_attribute23,hr_api.g_varchar2)
4506: <>NVL(p_ass_attribute23,hr_api.g_varchar2)
4507: OR NVL(per_asg_shd.g_old_rec.ass_attribute24,hr_api.g_varchar2)
4508: <>NVL(p_ass_attribute24,hr_api.g_varchar2)
4509: OR NVL(per_asg_shd.g_old_rec.ass_attribute25,hr_api.g_varchar2)
4510: <>NVL(p_ass_attribute25,hr_api.g_varchar2)
4511: OR NVL(per_asg_shd.g_old_rec.ass_attribute26,hr_api.g_varchar2)
4512: <>NVL(p_ass_attribute26,hr_api.g_varchar2)
4513: OR NVL(per_asg_shd.g_old_rec.ass_attribute27,hr_api.g_varchar2)

Line 4511: OR NVL(per_asg_shd.g_old_rec.ass_attribute26,hr_api.g_varchar2)

4507: OR NVL(per_asg_shd.g_old_rec.ass_attribute24,hr_api.g_varchar2)
4508: <>NVL(p_ass_attribute24,hr_api.g_varchar2)
4509: OR NVL(per_asg_shd.g_old_rec.ass_attribute25,hr_api.g_varchar2)
4510: <>NVL(p_ass_attribute25,hr_api.g_varchar2)
4511: OR NVL(per_asg_shd.g_old_rec.ass_attribute26,hr_api.g_varchar2)
4512: <>NVL(p_ass_attribute26,hr_api.g_varchar2)
4513: OR NVL(per_asg_shd.g_old_rec.ass_attribute27,hr_api.g_varchar2)
4514: <>NVL(p_ass_attribute27,hr_api.g_varchar2)
4515: OR NVL(per_asg_shd.g_old_rec.ass_attribute28,hr_api.g_varchar2)

Line 4513: OR NVL(per_asg_shd.g_old_rec.ass_attribute27,hr_api.g_varchar2)

4509: OR NVL(per_asg_shd.g_old_rec.ass_attribute25,hr_api.g_varchar2)
4510: <>NVL(p_ass_attribute25,hr_api.g_varchar2)
4511: OR NVL(per_asg_shd.g_old_rec.ass_attribute26,hr_api.g_varchar2)
4512: <>NVL(p_ass_attribute26,hr_api.g_varchar2)
4513: OR NVL(per_asg_shd.g_old_rec.ass_attribute27,hr_api.g_varchar2)
4514: <>NVL(p_ass_attribute27,hr_api.g_varchar2)
4515: OR NVL(per_asg_shd.g_old_rec.ass_attribute28,hr_api.g_varchar2)
4516: <>NVL(p_ass_attribute28,hr_api.g_varchar2)
4517: OR NVL(per_asg_shd.g_old_rec.ass_attribute29,hr_api.g_varchar2)

Line 4515: OR NVL(per_asg_shd.g_old_rec.ass_attribute28,hr_api.g_varchar2)

4511: OR NVL(per_asg_shd.g_old_rec.ass_attribute26,hr_api.g_varchar2)
4512: <>NVL(p_ass_attribute26,hr_api.g_varchar2)
4513: OR NVL(per_asg_shd.g_old_rec.ass_attribute27,hr_api.g_varchar2)
4514: <>NVL(p_ass_attribute27,hr_api.g_varchar2)
4515: OR NVL(per_asg_shd.g_old_rec.ass_attribute28,hr_api.g_varchar2)
4516: <>NVL(p_ass_attribute28,hr_api.g_varchar2)
4517: OR NVL(per_asg_shd.g_old_rec.ass_attribute29,hr_api.g_varchar2)
4518: <>NVL(p_ass_attribute29,hr_api.g_varchar2)
4519: OR NVL(per_asg_shd.g_old_rec.ass_attribute30,hr_api.g_varchar2)

Line 4517: OR NVL(per_asg_shd.g_old_rec.ass_attribute29,hr_api.g_varchar2)

4513: OR NVL(per_asg_shd.g_old_rec.ass_attribute27,hr_api.g_varchar2)
4514: <>NVL(p_ass_attribute27,hr_api.g_varchar2)
4515: OR NVL(per_asg_shd.g_old_rec.ass_attribute28,hr_api.g_varchar2)
4516: <>NVL(p_ass_attribute28,hr_api.g_varchar2)
4517: OR NVL(per_asg_shd.g_old_rec.ass_attribute29,hr_api.g_varchar2)
4518: <>NVL(p_ass_attribute29,hr_api.g_varchar2)
4519: OR NVL(per_asg_shd.g_old_rec.ass_attribute30,hr_api.g_varchar2)
4520: <>NVL(p_ass_attribute30,hr_api.g_varchar2)
4521: OR NVL(per_asg_shd.g_old_rec.bargaining_unit_code,hr_api.g_varchar2)

Line 4519: OR NVL(per_asg_shd.g_old_rec.ass_attribute30,hr_api.g_varchar2)

4515: OR NVL(per_asg_shd.g_old_rec.ass_attribute28,hr_api.g_varchar2)
4516: <>NVL(p_ass_attribute28,hr_api.g_varchar2)
4517: OR NVL(per_asg_shd.g_old_rec.ass_attribute29,hr_api.g_varchar2)
4518: <>NVL(p_ass_attribute29,hr_api.g_varchar2)
4519: OR NVL(per_asg_shd.g_old_rec.ass_attribute30,hr_api.g_varchar2)
4520: <>NVL(p_ass_attribute30,hr_api.g_varchar2)
4521: OR NVL(per_asg_shd.g_old_rec.bargaining_unit_code,hr_api.g_varchar2)
4522: <>NVL(p_bargaining_unit_code,hr_api.g_varchar2)
4523: OR NVL(per_asg_shd.g_old_rec.labour_union_member_flag,hr_api.g_varchar2)

Line 4521: OR NVL(per_asg_shd.g_old_rec.bargaining_unit_code,hr_api.g_varchar2)

4517: OR NVL(per_asg_shd.g_old_rec.ass_attribute29,hr_api.g_varchar2)
4518: <>NVL(p_ass_attribute29,hr_api.g_varchar2)
4519: OR NVL(per_asg_shd.g_old_rec.ass_attribute30,hr_api.g_varchar2)
4520: <>NVL(p_ass_attribute30,hr_api.g_varchar2)
4521: OR NVL(per_asg_shd.g_old_rec.bargaining_unit_code,hr_api.g_varchar2)
4522: <>NVL(p_bargaining_unit_code,hr_api.g_varchar2)
4523: OR NVL(per_asg_shd.g_old_rec.labour_union_member_flag,hr_api.g_varchar2)
4524: <>NVL(p_labour_union_member_flag,hr_api.g_varchar2)
4525: --Bug 3063591 Start Here

Line 4523: OR NVL(per_asg_shd.g_old_rec.labour_union_member_flag,hr_api.g_varchar2)

4519: OR NVL(per_asg_shd.g_old_rec.ass_attribute30,hr_api.g_varchar2)
4520: <>NVL(p_ass_attribute30,hr_api.g_varchar2)
4521: OR NVL(per_asg_shd.g_old_rec.bargaining_unit_code,hr_api.g_varchar2)
4522: <>NVL(p_bargaining_unit_code,hr_api.g_varchar2)
4523: OR NVL(per_asg_shd.g_old_rec.labour_union_member_flag,hr_api.g_varchar2)
4524: <>NVL(p_labour_union_member_flag,hr_api.g_varchar2)
4525: --Bug 3063591 Start Here
4526: OR NVL(per_asg_shd.g_old_rec.work_at_home,hr_api.g_varchar2)
4527: <>NVL(p_work_at_home,hr_api.g_varchar2)

Line 4526: OR NVL(per_asg_shd.g_old_rec.work_at_home,hr_api.g_varchar2)

4522: <>NVL(p_bargaining_unit_code,hr_api.g_varchar2)
4523: OR NVL(per_asg_shd.g_old_rec.labour_union_member_flag,hr_api.g_varchar2)
4524: <>NVL(p_labour_union_member_flag,hr_api.g_varchar2)
4525: --Bug 3063591 Start Here
4526: OR NVL(per_asg_shd.g_old_rec.work_at_home,hr_api.g_varchar2)
4527: <>NVL(p_work_at_home,hr_api.g_varchar2)
4528: --Bug 3063591 End Here
4529: OR NVL(per_asg_shd.g_old_rec.hourly_salaried_code,hr_api.g_varchar2)
4530: <>NVL(p_hourly_salaried_code,hr_api.g_varchar2)

Line 4529: OR NVL(per_asg_shd.g_old_rec.hourly_salaried_code,hr_api.g_varchar2)

4525: --Bug 3063591 Start Here
4526: OR NVL(per_asg_shd.g_old_rec.work_at_home,hr_api.g_varchar2)
4527: <>NVL(p_work_at_home,hr_api.g_varchar2)
4528: --Bug 3063591 End Here
4529: OR NVL(per_asg_shd.g_old_rec.hourly_salaried_code,hr_api.g_varchar2)
4530: <>NVL(p_hourly_salaried_code,hr_api.g_varchar2)
4531: OR NVL(per_asg_shd.g_old_rec.special_ceiling_step_id,hr_api.g_number)
4532: <>NVL(p_special_ceiling_step_id,hr_api.g_number)
4533: OR NVL(per_asg_shd.g_old_rec.change_reason,hr_api.g_varchar2)

Line 4531: OR NVL(per_asg_shd.g_old_rec.special_ceiling_step_id,hr_api.g_number)

4527: <>NVL(p_work_at_home,hr_api.g_varchar2)
4528: --Bug 3063591 End Here
4529: OR NVL(per_asg_shd.g_old_rec.hourly_salaried_code,hr_api.g_varchar2)
4530: <>NVL(p_hourly_salaried_code,hr_api.g_varchar2)
4531: OR NVL(per_asg_shd.g_old_rec.special_ceiling_step_id,hr_api.g_number)
4532: <>NVL(p_special_ceiling_step_id,hr_api.g_number)
4533: OR NVL(per_asg_shd.g_old_rec.change_reason,hr_api.g_varchar2)
4534: <>NVL(p_change_reason,hr_api.g_varchar2)
4535: OR NVL(per_asg_shd.g_old_rec.internal_address_line,hr_api.g_varchar2)

Line 4533: OR NVL(per_asg_shd.g_old_rec.change_reason,hr_api.g_varchar2)

4529: OR NVL(per_asg_shd.g_old_rec.hourly_salaried_code,hr_api.g_varchar2)
4530: <>NVL(p_hourly_salaried_code,hr_api.g_varchar2)
4531: OR NVL(per_asg_shd.g_old_rec.special_ceiling_step_id,hr_api.g_number)
4532: <>NVL(p_special_ceiling_step_id,hr_api.g_number)
4533: OR NVL(per_asg_shd.g_old_rec.change_reason,hr_api.g_varchar2)
4534: <>NVL(p_change_reason,hr_api.g_varchar2)
4535: OR NVL(per_asg_shd.g_old_rec.internal_address_line,hr_api.g_varchar2)
4536: <>NVL(p_internal_address_line,hr_api.g_varchar2)
4537: OR NVL(per_asg_shd.g_old_rec.manager_flag,hr_api.g_varchar2)

Line 4535: OR NVL(per_asg_shd.g_old_rec.internal_address_line,hr_api.g_varchar2)

4531: OR NVL(per_asg_shd.g_old_rec.special_ceiling_step_id,hr_api.g_number)
4532: <>NVL(p_special_ceiling_step_id,hr_api.g_number)
4533: OR NVL(per_asg_shd.g_old_rec.change_reason,hr_api.g_varchar2)
4534: <>NVL(p_change_reason,hr_api.g_varchar2)
4535: OR NVL(per_asg_shd.g_old_rec.internal_address_line,hr_api.g_varchar2)
4536: <>NVL(p_internal_address_line,hr_api.g_varchar2)
4537: OR NVL(per_asg_shd.g_old_rec.manager_flag,hr_api.g_varchar2)
4538: <>NVL(p_manager_flag,hr_api.g_varchar2)
4539: OR NVL(per_asg_shd.g_old_rec.perf_review_period,hr_api.g_number)

Line 4537: OR NVL(per_asg_shd.g_old_rec.manager_flag,hr_api.g_varchar2)

4533: OR NVL(per_asg_shd.g_old_rec.change_reason,hr_api.g_varchar2)
4534: <>NVL(p_change_reason,hr_api.g_varchar2)
4535: OR NVL(per_asg_shd.g_old_rec.internal_address_line,hr_api.g_varchar2)
4536: <>NVL(p_internal_address_line,hr_api.g_varchar2)
4537: OR NVL(per_asg_shd.g_old_rec.manager_flag,hr_api.g_varchar2)
4538: <>NVL(p_manager_flag,hr_api.g_varchar2)
4539: OR NVL(per_asg_shd.g_old_rec.perf_review_period,hr_api.g_number)
4540: <>NVL(p_perf_review_period,hr_api.g_number)
4541: OR NVL(per_asg_shd.g_old_rec.perf_review_period_frequency,hr_api.g_varchar2)

Line 4539: OR NVL(per_asg_shd.g_old_rec.perf_review_period,hr_api.g_number)

4535: OR NVL(per_asg_shd.g_old_rec.internal_address_line,hr_api.g_varchar2)
4536: <>NVL(p_internal_address_line,hr_api.g_varchar2)
4537: OR NVL(per_asg_shd.g_old_rec.manager_flag,hr_api.g_varchar2)
4538: <>NVL(p_manager_flag,hr_api.g_varchar2)
4539: OR NVL(per_asg_shd.g_old_rec.perf_review_period,hr_api.g_number)
4540: <>NVL(p_perf_review_period,hr_api.g_number)
4541: OR NVL(per_asg_shd.g_old_rec.perf_review_period_frequency,hr_api.g_varchar2)
4542: <>NVL(p_perf_review_period_frequency,hr_api.g_varchar2)
4543: OR NVL(per_asg_shd.g_old_rec.sal_review_period,hr_api.g_number)

Line 4541: OR NVL(per_asg_shd.g_old_rec.perf_review_period_frequency,hr_api.g_varchar2)

4537: OR NVL(per_asg_shd.g_old_rec.manager_flag,hr_api.g_varchar2)
4538: <>NVL(p_manager_flag,hr_api.g_varchar2)
4539: OR NVL(per_asg_shd.g_old_rec.perf_review_period,hr_api.g_number)
4540: <>NVL(p_perf_review_period,hr_api.g_number)
4541: OR NVL(per_asg_shd.g_old_rec.perf_review_period_frequency,hr_api.g_varchar2)
4542: <>NVL(p_perf_review_period_frequency,hr_api.g_varchar2)
4543: OR NVL(per_asg_shd.g_old_rec.sal_review_period,hr_api.g_number)
4544: <>NVL(p_sal_review_period,hr_api.g_number)
4545: OR NVL(per_asg_shd.g_old_rec.sal_review_period_frequency,hr_api.g_varchar2)

Line 4543: OR NVL(per_asg_shd.g_old_rec.sal_review_period,hr_api.g_number)

4539: OR NVL(per_asg_shd.g_old_rec.perf_review_period,hr_api.g_number)
4540: <>NVL(p_perf_review_period,hr_api.g_number)
4541: OR NVL(per_asg_shd.g_old_rec.perf_review_period_frequency,hr_api.g_varchar2)
4542: <>NVL(p_perf_review_period_frequency,hr_api.g_varchar2)
4543: OR NVL(per_asg_shd.g_old_rec.sal_review_period,hr_api.g_number)
4544: <>NVL(p_sal_review_period,hr_api.g_number)
4545: OR NVL(per_asg_shd.g_old_rec.sal_review_period_frequency,hr_api.g_varchar2)
4546: <>NVL(p_sal_review_period_frequency,hr_api.g_varchar2)
4547: OR NVL(per_asg_shd.g_old_rec.source_type,hr_api.g_varchar2)

Line 4545: OR NVL(per_asg_shd.g_old_rec.sal_review_period_frequency,hr_api.g_varchar2)

4541: OR NVL(per_asg_shd.g_old_rec.perf_review_period_frequency,hr_api.g_varchar2)
4542: <>NVL(p_perf_review_period_frequency,hr_api.g_varchar2)
4543: OR NVL(per_asg_shd.g_old_rec.sal_review_period,hr_api.g_number)
4544: <>NVL(p_sal_review_period,hr_api.g_number)
4545: OR NVL(per_asg_shd.g_old_rec.sal_review_period_frequency,hr_api.g_varchar2)
4546: <>NVL(p_sal_review_period_frequency,hr_api.g_varchar2)
4547: OR NVL(per_asg_shd.g_old_rec.source_type,hr_api.g_varchar2)
4548: <>NVL(p_source_type,hr_api.g_varchar2)
4549: OR NVL(per_asg_shd.g_old_rec.contract_id,hr_api.g_number)

Line 4547: OR NVL(per_asg_shd.g_old_rec.source_type,hr_api.g_varchar2)

4543: OR NVL(per_asg_shd.g_old_rec.sal_review_period,hr_api.g_number)
4544: <>NVL(p_sal_review_period,hr_api.g_number)
4545: OR NVL(per_asg_shd.g_old_rec.sal_review_period_frequency,hr_api.g_varchar2)
4546: <>NVL(p_sal_review_period_frequency,hr_api.g_varchar2)
4547: OR NVL(per_asg_shd.g_old_rec.source_type,hr_api.g_varchar2)
4548: <>NVL(p_source_type,hr_api.g_varchar2)
4549: OR NVL(per_asg_shd.g_old_rec.contract_id,hr_api.g_number)
4550: <>NVL(p_contract_id,hr_api.g_number)
4551: OR NVL(per_asg_shd.g_old_rec.collective_agreement_id,hr_api.g_number)

Line 4549: OR NVL(per_asg_shd.g_old_rec.contract_id,hr_api.g_number)

4545: OR NVL(per_asg_shd.g_old_rec.sal_review_period_frequency,hr_api.g_varchar2)
4546: <>NVL(p_sal_review_period_frequency,hr_api.g_varchar2)
4547: OR NVL(per_asg_shd.g_old_rec.source_type,hr_api.g_varchar2)
4548: <>NVL(p_source_type,hr_api.g_varchar2)
4549: OR NVL(per_asg_shd.g_old_rec.contract_id,hr_api.g_number)
4550: <>NVL(p_contract_id,hr_api.g_number)
4551: OR NVL(per_asg_shd.g_old_rec.collective_agreement_id,hr_api.g_number)
4552: <>NVL(p_collective_agreement_id,hr_api.g_number)
4553: OR NVL(per_asg_shd.g_old_rec.cagr_id_flex_num,hr_api.g_number)

Line 4551: OR NVL(per_asg_shd.g_old_rec.collective_agreement_id,hr_api.g_number)

4547: OR NVL(per_asg_shd.g_old_rec.source_type,hr_api.g_varchar2)
4548: <>NVL(p_source_type,hr_api.g_varchar2)
4549: OR NVL(per_asg_shd.g_old_rec.contract_id,hr_api.g_number)
4550: <>NVL(p_contract_id,hr_api.g_number)
4551: OR NVL(per_asg_shd.g_old_rec.collective_agreement_id,hr_api.g_number)
4552: <>NVL(p_collective_agreement_id,hr_api.g_number)
4553: OR NVL(per_asg_shd.g_old_rec.cagr_id_flex_num,hr_api.g_number)
4554: <>NVL(p_cagr_id_flex_num,hr_api.g_number)
4555: OR NVL(per_asg_shd.g_old_rec.cagr_grade_def_id,hr_api.g_number)

Line 4553: OR NVL(per_asg_shd.g_old_rec.cagr_id_flex_num,hr_api.g_number)

4549: OR NVL(per_asg_shd.g_old_rec.contract_id,hr_api.g_number)
4550: <>NVL(p_contract_id,hr_api.g_number)
4551: OR NVL(per_asg_shd.g_old_rec.collective_agreement_id,hr_api.g_number)
4552: <>NVL(p_collective_agreement_id,hr_api.g_number)
4553: OR NVL(per_asg_shd.g_old_rec.cagr_id_flex_num,hr_api.g_number)
4554: <>NVL(p_cagr_id_flex_num,hr_api.g_number)
4555: OR NVL(per_asg_shd.g_old_rec.cagr_grade_def_id,hr_api.g_number)
4556: <>NVL(p_cagr_grade_def_id,hr_api.g_number)
4557: OR NVL(per_asg_shd.g_old_rec.establishment_id,hr_api.g_number)

Line 4555: OR NVL(per_asg_shd.g_old_rec.cagr_grade_def_id,hr_api.g_number)

4551: OR NVL(per_asg_shd.g_old_rec.collective_agreement_id,hr_api.g_number)
4552: <>NVL(p_collective_agreement_id,hr_api.g_number)
4553: OR NVL(per_asg_shd.g_old_rec.cagr_id_flex_num,hr_api.g_number)
4554: <>NVL(p_cagr_id_flex_num,hr_api.g_number)
4555: OR NVL(per_asg_shd.g_old_rec.cagr_grade_def_id,hr_api.g_number)
4556: <>NVL(p_cagr_grade_def_id,hr_api.g_number)
4557: OR NVL(per_asg_shd.g_old_rec.establishment_id,hr_api.g_number)
4558: <>NVL(p_establishment_id,hr_api.g_number)
4559: --CWK

Line 4557: OR NVL(per_asg_shd.g_old_rec.establishment_id,hr_api.g_number)

4553: OR NVL(per_asg_shd.g_old_rec.cagr_id_flex_num,hr_api.g_number)
4554: <>NVL(p_cagr_id_flex_num,hr_api.g_number)
4555: OR NVL(per_asg_shd.g_old_rec.cagr_grade_def_id,hr_api.g_number)
4556: <>NVL(p_cagr_grade_def_id,hr_api.g_number)
4557: OR NVL(per_asg_shd.g_old_rec.establishment_id,hr_api.g_number)
4558: <>NVL(p_establishment_id,hr_api.g_number)
4559: --CWK
4560: OR NVL(per_asg_shd.g_old_rec.period_of_placement_date_start,hr_api.g_date)
4561: <>NVL(p_placement_date_start,hr_api.g_date)

Line 4560: OR NVL(per_asg_shd.g_old_rec.period_of_placement_date_start,hr_api.g_date)

4556: <>NVL(p_cagr_grade_def_id,hr_api.g_number)
4557: OR NVL(per_asg_shd.g_old_rec.establishment_id,hr_api.g_number)
4558: <>NVL(p_establishment_id,hr_api.g_number)
4559: --CWK
4560: OR NVL(per_asg_shd.g_old_rec.period_of_placement_date_start,hr_api.g_date)
4561: <>NVL(p_placement_date_start,hr_api.g_date)
4562: OR NVL(per_asg_shd.g_old_rec.vendor_id,hr_api.g_number)
4563: <>NVL(p_vendor_id,hr_api.g_number)
4564: OR NVL(per_asg_shd.g_old_rec.vendor_employee_number,hr_api.g_varchar2)

Line 4562: OR NVL(per_asg_shd.g_old_rec.vendor_id,hr_api.g_number)

4558: <>NVL(p_establishment_id,hr_api.g_number)
4559: --CWK
4560: OR NVL(per_asg_shd.g_old_rec.period_of_placement_date_start,hr_api.g_date)
4561: <>NVL(p_placement_date_start,hr_api.g_date)
4562: OR NVL(per_asg_shd.g_old_rec.vendor_id,hr_api.g_number)
4563: <>NVL(p_vendor_id,hr_api.g_number)
4564: OR NVL(per_asg_shd.g_old_rec.vendor_employee_number,hr_api.g_varchar2)
4565: <>NVL(p_vendor_employee_number,hr_api.g_varchar2)
4566: OR NVL(per_asg_shd.g_old_rec.vendor_assignment_number,hr_api.g_varchar2)

Line 4564: OR NVL(per_asg_shd.g_old_rec.vendor_employee_number,hr_api.g_varchar2)

4560: OR NVL(per_asg_shd.g_old_rec.period_of_placement_date_start,hr_api.g_date)
4561: <>NVL(p_placement_date_start,hr_api.g_date)
4562: OR NVL(per_asg_shd.g_old_rec.vendor_id,hr_api.g_number)
4563: <>NVL(p_vendor_id,hr_api.g_number)
4564: OR NVL(per_asg_shd.g_old_rec.vendor_employee_number,hr_api.g_varchar2)
4565: <>NVL(p_vendor_employee_number,hr_api.g_varchar2)
4566: OR NVL(per_asg_shd.g_old_rec.vendor_assignment_number,hr_api.g_varchar2)
4567: <>NVL(p_vendor_assignment_number,hr_api.g_varchar2)
4568: OR NVL(per_asg_shd.g_old_rec.project_title,hr_api.g_varchar2)

Line 4566: OR NVL(per_asg_shd.g_old_rec.vendor_assignment_number,hr_api.g_varchar2)

4562: OR NVL(per_asg_shd.g_old_rec.vendor_id,hr_api.g_number)
4563: <>NVL(p_vendor_id,hr_api.g_number)
4564: OR NVL(per_asg_shd.g_old_rec.vendor_employee_number,hr_api.g_varchar2)
4565: <>NVL(p_vendor_employee_number,hr_api.g_varchar2)
4566: OR NVL(per_asg_shd.g_old_rec.vendor_assignment_number,hr_api.g_varchar2)
4567: <>NVL(p_vendor_assignment_number,hr_api.g_varchar2)
4568: OR NVL(per_asg_shd.g_old_rec.project_title,hr_api.g_varchar2)
4569: <>NVL(p_project_title,hr_api.g_varchar2)
4570: OR NVL(per_asg_shd.g_old_rec.vendor_site_id,hr_api.g_number)

Line 4568: OR NVL(per_asg_shd.g_old_rec.project_title,hr_api.g_varchar2)

4564: OR NVL(per_asg_shd.g_old_rec.vendor_employee_number,hr_api.g_varchar2)
4565: <>NVL(p_vendor_employee_number,hr_api.g_varchar2)
4566: OR NVL(per_asg_shd.g_old_rec.vendor_assignment_number,hr_api.g_varchar2)
4567: <>NVL(p_vendor_assignment_number,hr_api.g_varchar2)
4568: OR NVL(per_asg_shd.g_old_rec.project_title,hr_api.g_varchar2)
4569: <>NVL(p_project_title,hr_api.g_varchar2)
4570: OR NVL(per_asg_shd.g_old_rec.vendor_site_id,hr_api.g_number)
4571: <>NVL(p_vendor_site_id,hr_api.g_number)
4572: OR NVL(per_asg_shd.g_old_rec.po_header_id,hr_api.g_number)

Line 4570: OR NVL(per_asg_shd.g_old_rec.vendor_site_id,hr_api.g_number)

4566: OR NVL(per_asg_shd.g_old_rec.vendor_assignment_number,hr_api.g_varchar2)
4567: <>NVL(p_vendor_assignment_number,hr_api.g_varchar2)
4568: OR NVL(per_asg_shd.g_old_rec.project_title,hr_api.g_varchar2)
4569: <>NVL(p_project_title,hr_api.g_varchar2)
4570: OR NVL(per_asg_shd.g_old_rec.vendor_site_id,hr_api.g_number)
4571: <>NVL(p_vendor_site_id,hr_api.g_number)
4572: OR NVL(per_asg_shd.g_old_rec.po_header_id,hr_api.g_number)
4573: <>NVL(p_po_header_id,hr_api.g_number)
4574: OR NVL(per_asg_shd.g_old_rec.po_line_id,hr_api.g_number)

Line 4572: OR NVL(per_asg_shd.g_old_rec.po_header_id,hr_api.g_number)

4568: OR NVL(per_asg_shd.g_old_rec.project_title,hr_api.g_varchar2)
4569: <>NVL(p_project_title,hr_api.g_varchar2)
4570: OR NVL(per_asg_shd.g_old_rec.vendor_site_id,hr_api.g_number)
4571: <>NVL(p_vendor_site_id,hr_api.g_number)
4572: OR NVL(per_asg_shd.g_old_rec.po_header_id,hr_api.g_number)
4573: <>NVL(p_po_header_id,hr_api.g_number)
4574: OR NVL(per_asg_shd.g_old_rec.po_line_id,hr_api.g_number)
4575: <>NVL(p_po_line_id,hr_api.g_number)
4576: OR NVL(per_asg_shd.g_old_rec.projected_assignment_end,hr_api.g_date)

Line 4574: OR NVL(per_asg_shd.g_old_rec.po_line_id,hr_api.g_number)

4570: OR NVL(per_asg_shd.g_old_rec.vendor_site_id,hr_api.g_number)
4571: <>NVL(p_vendor_site_id,hr_api.g_number)
4572: OR NVL(per_asg_shd.g_old_rec.po_header_id,hr_api.g_number)
4573: <>NVL(p_po_header_id,hr_api.g_number)
4574: OR NVL(per_asg_shd.g_old_rec.po_line_id,hr_api.g_number)
4575: <>NVL(p_po_line_id,hr_api.g_number)
4576: OR NVL(per_asg_shd.g_old_rec.projected_assignment_end,hr_api.g_date)
4577: <>NVL(p_projected_assignment_end,hr_api.g_date)
4578:

Line 4576: OR NVL(per_asg_shd.g_old_rec.projected_assignment_end,hr_api.g_date)

4572: OR NVL(per_asg_shd.g_old_rec.po_header_id,hr_api.g_number)
4573: <>NVL(p_po_header_id,hr_api.g_number)
4574: OR NVL(per_asg_shd.g_old_rec.po_line_id,hr_api.g_number)
4575: <>NVL(p_po_line_id,hr_api.g_number)
4576: OR NVL(per_asg_shd.g_old_rec.projected_assignment_end,hr_api.g_date)
4577: <>NVL(p_projected_assignment_end,hr_api.g_date)
4578:
4579: THEN
4580: --

Line 7136: per_asg_shd.lck

7132: ELSE
7133: l_asg_datetrack_update_mode:=p_datetrack_update_mode;
7134: END IF;
7135: --
7136: per_asg_shd.lck
7137: (p_effective_date => p_effective_date
7138: ,p_datetrack_mode => l_asg_datetrack_update_mode
7139: ,p_assignment_id => p_assignment_id
7140: ,p_object_version_number => p_asg_object_version_number