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 4289: IF per_asg_shd.g_old_rec.people_group_id IS NOT NULL THEN

4285: IF p_assignment_update_allowed='TRUE' THEN
4286: --
4287: -- check to see if the assignment data has changed
4288: --
4289: IF per_asg_shd.g_old_rec.people_group_id IS NOT NULL THEN
4290: --
4291: hr_utility.set_location(l_proc, 60);
4292: --
4293: OPEN csr_pgp_rec(per_asg_shd.g_old_rec.people_group_id);

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

4289: IF per_asg_shd.g_old_rec.people_group_id IS NOT NULL THEN
4290: --
4291: hr_utility.set_location(l_proc, 60);
4292: --
4293: OPEN csr_pgp_rec(per_asg_shd.g_old_rec.people_group_id);
4294: FETCH csr_pgp_rec INTO l_pgp_rec;
4295: CLOSE csr_pgp_rec;
4296: END IF;
4297: --

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

4294: FETCH csr_pgp_rec INTO l_pgp_rec;
4295: CLOSE csr_pgp_rec;
4296: END IF;
4297: --
4298: IF per_asg_shd.g_old_rec.soft_coding_keyflex_id IS NOT NULL THEN
4299: --
4300: hr_utility.set_location(l_proc, 70);
4301: --
4302: OPEN csr_scl_rec(per_asg_shd.g_old_rec.soft_coding_keyflex_id);

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

4298: IF per_asg_shd.g_old_rec.soft_coding_keyflex_id IS NOT NULL THEN
4299: --
4300: hr_utility.set_location(l_proc, 70);
4301: --
4302: OPEN csr_scl_rec(per_asg_shd.g_old_rec.soft_coding_keyflex_id);
4303: FETCH csr_scl_rec INTO l_scl_rec;
4304: CLOSE csr_scl_rec;
4305: END IF;
4306: --

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

4305: END IF;
4306: --
4307: hr_utility.set_location(l_proc, 80);
4308: --
4309: IF NVL(per_asg_shd.g_old_rec.recruiter_id,hr_api.g_number)
4310: <>NVL(p_recruiter_id,hr_api.g_number)
4311: OR NVL(per_asg_shd.g_old_rec.grade_id,hr_api.g_number)
4312: <>NVL(p_grade_id,hr_api.g_number)
4313: OR NVL(per_asg_shd.g_old_rec.grade_ladder_pgm_id,hr_api.g_number)

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

4307: hr_utility.set_location(l_proc, 80);
4308: --
4309: IF NVL(per_asg_shd.g_old_rec.recruiter_id,hr_api.g_number)
4310: <>NVL(p_recruiter_id,hr_api.g_number)
4311: OR NVL(per_asg_shd.g_old_rec.grade_id,hr_api.g_number)
4312: <>NVL(p_grade_id,hr_api.g_number)
4313: OR NVL(per_asg_shd.g_old_rec.grade_ladder_pgm_id,hr_api.g_number)
4314: <>NVL(p_grade_ladder_pgm_id,hr_api.g_number)
4315: OR NVL(per_asg_shd.g_old_rec.position_id,hr_api.g_number)

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

4309: IF NVL(per_asg_shd.g_old_rec.recruiter_id,hr_api.g_number)
4310: <>NVL(p_recruiter_id,hr_api.g_number)
4311: OR NVL(per_asg_shd.g_old_rec.grade_id,hr_api.g_number)
4312: <>NVL(p_grade_id,hr_api.g_number)
4313: OR NVL(per_asg_shd.g_old_rec.grade_ladder_pgm_id,hr_api.g_number)
4314: <>NVL(p_grade_ladder_pgm_id,hr_api.g_number)
4315: OR NVL(per_asg_shd.g_old_rec.position_id,hr_api.g_number)
4316: <>NVL(p_position_id,hr_api.g_number)
4317: OR NVL(per_asg_shd.g_old_rec.job_id,hr_api.g_number)

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

4311: OR NVL(per_asg_shd.g_old_rec.grade_id,hr_api.g_number)
4312: <>NVL(p_grade_id,hr_api.g_number)
4313: OR NVL(per_asg_shd.g_old_rec.grade_ladder_pgm_id,hr_api.g_number)
4314: <>NVL(p_grade_ladder_pgm_id,hr_api.g_number)
4315: OR NVL(per_asg_shd.g_old_rec.position_id,hr_api.g_number)
4316: <>NVL(p_position_id,hr_api.g_number)
4317: OR NVL(per_asg_shd.g_old_rec.job_id,hr_api.g_number)
4318: <>NVL(p_job_id,hr_api.g_number)
4319: OR NVL(per_asg_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)

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

4313: OR NVL(per_asg_shd.g_old_rec.grade_ladder_pgm_id,hr_api.g_number)
4314: <>NVL(p_grade_ladder_pgm_id,hr_api.g_number)
4315: OR NVL(per_asg_shd.g_old_rec.position_id,hr_api.g_number)
4316: <>NVL(p_position_id,hr_api.g_number)
4317: OR NVL(per_asg_shd.g_old_rec.job_id,hr_api.g_number)
4318: <>NVL(p_job_id,hr_api.g_number)
4319: OR NVL(per_asg_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)
4320: <>NVL(p_assignment_status_type_id,hr_api.g_number)
4321: OR NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)

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

4315: OR NVL(per_asg_shd.g_old_rec.position_id,hr_api.g_number)
4316: <>NVL(p_position_id,hr_api.g_number)
4317: OR NVL(per_asg_shd.g_old_rec.job_id,hr_api.g_number)
4318: <>NVL(p_job_id,hr_api.g_number)
4319: OR NVL(per_asg_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)
4320: <>NVL(p_assignment_status_type_id,hr_api.g_number)
4321: OR NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)
4322: <>NVL(p_payroll_id,hr_api.g_number)
4323: OR NVL(per_asg_shd.g_old_rec.location_id,hr_api.g_number)

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

4317: OR NVL(per_asg_shd.g_old_rec.job_id,hr_api.g_number)
4318: <>NVL(p_job_id,hr_api.g_number)
4319: OR NVL(per_asg_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)
4320: <>NVL(p_assignment_status_type_id,hr_api.g_number)
4321: OR NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)
4322: <>NVL(p_payroll_id,hr_api.g_number)
4323: OR NVL(per_asg_shd.g_old_rec.location_id,hr_api.g_number)
4324: <>NVL(p_location_id,hr_api.g_number)
4325: OR NVL(per_asg_shd.g_old_rec.person_referred_by_id,hr_api.g_number)

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

4319: OR NVL(per_asg_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)
4320: <>NVL(p_assignment_status_type_id,hr_api.g_number)
4321: OR NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)
4322: <>NVL(p_payroll_id,hr_api.g_number)
4323: OR NVL(per_asg_shd.g_old_rec.location_id,hr_api.g_number)
4324: <>NVL(p_location_id,hr_api.g_number)
4325: OR NVL(per_asg_shd.g_old_rec.person_referred_by_id,hr_api.g_number)
4326: <>NVL(p_person_referred_by_id,hr_api.g_number)
4327: OR NVL(per_asg_shd.g_old_rec.supervisor_id,hr_api.g_number)

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

4321: OR NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)
4322: <>NVL(p_payroll_id,hr_api.g_number)
4323: OR NVL(per_asg_shd.g_old_rec.location_id,hr_api.g_number)
4324: <>NVL(p_location_id,hr_api.g_number)
4325: OR NVL(per_asg_shd.g_old_rec.person_referred_by_id,hr_api.g_number)
4326: <>NVL(p_person_referred_by_id,hr_api.g_number)
4327: OR NVL(per_asg_shd.g_old_rec.supervisor_id,hr_api.g_number)
4328: <>NVL(p_supervisor_id,hr_api.g_number)
4329: OR NVL(per_asg_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)

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

4323: OR NVL(per_asg_shd.g_old_rec.location_id,hr_api.g_number)
4324: <>NVL(p_location_id,hr_api.g_number)
4325: OR NVL(per_asg_shd.g_old_rec.person_referred_by_id,hr_api.g_number)
4326: <>NVL(p_person_referred_by_id,hr_api.g_number)
4327: OR NVL(per_asg_shd.g_old_rec.supervisor_id,hr_api.g_number)
4328: <>NVL(p_supervisor_id,hr_api.g_number)
4329: OR NVL(per_asg_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
4330: <>NVL(p_supervisor_assignment_id,hr_api.g_number)
4331: OR NVL(per_asg_shd.g_old_rec.recruitment_activity_id,hr_api.g_number)

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

4325: OR NVL(per_asg_shd.g_old_rec.person_referred_by_id,hr_api.g_number)
4326: <>NVL(p_person_referred_by_id,hr_api.g_number)
4327: OR NVL(per_asg_shd.g_old_rec.supervisor_id,hr_api.g_number)
4328: <>NVL(p_supervisor_id,hr_api.g_number)
4329: OR NVL(per_asg_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
4330: <>NVL(p_supervisor_assignment_id,hr_api.g_number)
4331: OR NVL(per_asg_shd.g_old_rec.recruitment_activity_id,hr_api.g_number)
4332: <>NVL(p_recruitment_activity_id,hr_api.g_number)
4333: OR NVL(per_asg_shd.g_old_rec.source_organization_id,hr_api.g_number)

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

4327: OR NVL(per_asg_shd.g_old_rec.supervisor_id,hr_api.g_number)
4328: <>NVL(p_supervisor_id,hr_api.g_number)
4329: OR NVL(per_asg_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
4330: <>NVL(p_supervisor_assignment_id,hr_api.g_number)
4331: OR NVL(per_asg_shd.g_old_rec.recruitment_activity_id,hr_api.g_number)
4332: <>NVL(p_recruitment_activity_id,hr_api.g_number)
4333: OR NVL(per_asg_shd.g_old_rec.source_organization_id,hr_api.g_number)
4334: <>NVL(p_source_organization_id,hr_api.g_number)
4335: OR NVL(per_asg_shd.g_old_rec.organization_id,hr_api.g_number)

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

4329: OR NVL(per_asg_shd.g_old_rec.supervisor_assignment_id,hr_api.g_number)
4330: <>NVL(p_supervisor_assignment_id,hr_api.g_number)
4331: OR NVL(per_asg_shd.g_old_rec.recruitment_activity_id,hr_api.g_number)
4332: <>NVL(p_recruitment_activity_id,hr_api.g_number)
4333: OR NVL(per_asg_shd.g_old_rec.source_organization_id,hr_api.g_number)
4334: <>NVL(p_source_organization_id,hr_api.g_number)
4335: OR NVL(per_asg_shd.g_old_rec.organization_id,hr_api.g_number)
4336: <>NVL(p_organization_id,hr_api.g_number)
4337: OR NVL(l_pgp_rec.segment1,hr_api.g_varchar2)

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

4331: OR NVL(per_asg_shd.g_old_rec.recruitment_activity_id,hr_api.g_number)
4332: <>NVL(p_recruitment_activity_id,hr_api.g_number)
4333: OR NVL(per_asg_shd.g_old_rec.source_organization_id,hr_api.g_number)
4334: <>NVL(p_source_organization_id,hr_api.g_number)
4335: OR NVL(per_asg_shd.g_old_rec.organization_id,hr_api.g_number)
4336: <>NVL(p_organization_id,hr_api.g_number)
4337: OR NVL(l_pgp_rec.segment1,hr_api.g_varchar2)
4338: <>NVL(p_pgp_segment1,hr_api.g_varchar2)
4339: OR NVL(l_pgp_rec.segment2,hr_api.g_varchar2)

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

4453: OR NVL(l_scl_rec.segment29,hr_api.g_varchar2)
4454: <>NVL(p_scl_segment29,hr_api.g_varchar2)
4455: OR NVL(l_scl_rec.segment30,hr_api.g_varchar2)
4456: <>NVL(p_scl_segment30,hr_api.g_varchar2)
4457: OR NVL(per_asg_shd.g_old_rec.vacancy_id,hr_api.g_number)
4458: <>NVL(p_vacancy_id,hr_api.g_number)
4459: OR NVL(per_asg_shd.g_old_rec.pay_basis_id,hr_api.g_number)
4460: <>NVL(p_pay_basis_id,hr_api.g_number)
4461: OR NVL(per_asg_shd.g_old_rec.assignment_type,hr_api.g_varchar2)

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

4455: OR NVL(l_scl_rec.segment30,hr_api.g_varchar2)
4456: <>NVL(p_scl_segment30,hr_api.g_varchar2)
4457: OR NVL(per_asg_shd.g_old_rec.vacancy_id,hr_api.g_number)
4458: <>NVL(p_vacancy_id,hr_api.g_number)
4459: OR NVL(per_asg_shd.g_old_rec.pay_basis_id,hr_api.g_number)
4460: <>NVL(p_pay_basis_id,hr_api.g_number)
4461: OR NVL(per_asg_shd.g_old_rec.assignment_type,hr_api.g_varchar2)
4462: <>NVL(p_assignment_type,hr_api.g_varchar2)
4463: OR NVL(per_asg_shd.g_old_rec.primary_flag,hr_api.g_varchar2)

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

4457: OR NVL(per_asg_shd.g_old_rec.vacancy_id,hr_api.g_number)
4458: <>NVL(p_vacancy_id,hr_api.g_number)
4459: OR NVL(per_asg_shd.g_old_rec.pay_basis_id,hr_api.g_number)
4460: <>NVL(p_pay_basis_id,hr_api.g_number)
4461: OR NVL(per_asg_shd.g_old_rec.assignment_type,hr_api.g_varchar2)
4462: <>NVL(p_assignment_type,hr_api.g_varchar2)
4463: OR NVL(per_asg_shd.g_old_rec.primary_flag,hr_api.g_varchar2)
4464: <>NVL(p_asg_primary_flag,hr_api.g_varchar2)
4465: OR NVL(per_asg_shd.g_old_rec.assignment_number,hr_api.g_varchar2)

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

4459: OR NVL(per_asg_shd.g_old_rec.pay_basis_id,hr_api.g_number)
4460: <>NVL(p_pay_basis_id,hr_api.g_number)
4461: OR NVL(per_asg_shd.g_old_rec.assignment_type,hr_api.g_varchar2)
4462: <>NVL(p_assignment_type,hr_api.g_varchar2)
4463: OR NVL(per_asg_shd.g_old_rec.primary_flag,hr_api.g_varchar2)
4464: <>NVL(p_asg_primary_flag,hr_api.g_varchar2)
4465: OR NVL(per_asg_shd.g_old_rec.assignment_number,hr_api.g_varchar2)
4466: <>NVL(l_assignment_number,hr_api.g_varchar2)
4467: OR NVL(per_asg_shd.g_old_rec.date_probation_end,hr_api.g_date)

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

4461: OR NVL(per_asg_shd.g_old_rec.assignment_type,hr_api.g_varchar2)
4462: <>NVL(p_assignment_type,hr_api.g_varchar2)
4463: OR NVL(per_asg_shd.g_old_rec.primary_flag,hr_api.g_varchar2)
4464: <>NVL(p_asg_primary_flag,hr_api.g_varchar2)
4465: OR NVL(per_asg_shd.g_old_rec.assignment_number,hr_api.g_varchar2)
4466: <>NVL(l_assignment_number,hr_api.g_varchar2)
4467: OR NVL(per_asg_shd.g_old_rec.date_probation_end,hr_api.g_date)
4468: <>NVL(p_date_probation_end,hr_api.g_date)
4469: OR NVL(per_asg_shd.g_old_rec.default_code_comb_id,hr_api.g_number)

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

4463: OR NVL(per_asg_shd.g_old_rec.primary_flag,hr_api.g_varchar2)
4464: <>NVL(p_asg_primary_flag,hr_api.g_varchar2)
4465: OR NVL(per_asg_shd.g_old_rec.assignment_number,hr_api.g_varchar2)
4466: <>NVL(l_assignment_number,hr_api.g_varchar2)
4467: OR NVL(per_asg_shd.g_old_rec.date_probation_end,hr_api.g_date)
4468: <>NVL(p_date_probation_end,hr_api.g_date)
4469: OR NVL(per_asg_shd.g_old_rec.default_code_comb_id,hr_api.g_number)
4470: <>NVL(p_default_code_comb_id,hr_api.g_number)
4471: OR NVL(per_asg_shd.g_old_rec.employment_category,hr_api.g_varchar2)

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

4465: OR NVL(per_asg_shd.g_old_rec.assignment_number,hr_api.g_varchar2)
4466: <>NVL(l_assignment_number,hr_api.g_varchar2)
4467: OR NVL(per_asg_shd.g_old_rec.date_probation_end,hr_api.g_date)
4468: <>NVL(p_date_probation_end,hr_api.g_date)
4469: OR NVL(per_asg_shd.g_old_rec.default_code_comb_id,hr_api.g_number)
4470: <>NVL(p_default_code_comb_id,hr_api.g_number)
4471: OR NVL(per_asg_shd.g_old_rec.employment_category,hr_api.g_varchar2)
4472: <>NVL(p_employment_category,hr_api.g_varchar2)
4473: OR NVL(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2)

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

4467: OR NVL(per_asg_shd.g_old_rec.date_probation_end,hr_api.g_date)
4468: <>NVL(p_date_probation_end,hr_api.g_date)
4469: OR NVL(per_asg_shd.g_old_rec.default_code_comb_id,hr_api.g_number)
4470: <>NVL(p_default_code_comb_id,hr_api.g_number)
4471: OR NVL(per_asg_shd.g_old_rec.employment_category,hr_api.g_varchar2)
4472: <>NVL(p_employment_category,hr_api.g_varchar2)
4473: OR NVL(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2)
4474: <>NVL(p_employee_category,hr_api.g_varchar2)
4475: OR NVL(per_asg_shd.g_old_rec.frequency,hr_api.g_varchar2)

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

4469: OR NVL(per_asg_shd.g_old_rec.default_code_comb_id,hr_api.g_number)
4470: <>NVL(p_default_code_comb_id,hr_api.g_number)
4471: OR NVL(per_asg_shd.g_old_rec.employment_category,hr_api.g_varchar2)
4472: <>NVL(p_employment_category,hr_api.g_varchar2)
4473: OR NVL(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2)
4474: <>NVL(p_employee_category,hr_api.g_varchar2)
4475: OR NVL(per_asg_shd.g_old_rec.frequency,hr_api.g_varchar2)
4476: <>NVL(p_frequency,hr_api.g_varchar2)
4477: OR NVL(per_asg_shd.g_old_rec.normal_hours,hr_api.g_number)

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

4471: OR NVL(per_asg_shd.g_old_rec.employment_category,hr_api.g_varchar2)
4472: <>NVL(p_employment_category,hr_api.g_varchar2)
4473: OR NVL(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2)
4474: <>NVL(p_employee_category,hr_api.g_varchar2)
4475: OR NVL(per_asg_shd.g_old_rec.frequency,hr_api.g_varchar2)
4476: <>NVL(p_frequency,hr_api.g_varchar2)
4477: OR NVL(per_asg_shd.g_old_rec.normal_hours,hr_api.g_number)
4478: <>NVL(p_normal_hours,hr_api.g_number)
4479: OR NVL(per_asg_shd.g_old_rec.probation_period,hr_api.g_number)

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

4473: OR NVL(per_asg_shd.g_old_rec.employee_category,hr_api.g_varchar2)
4474: <>NVL(p_employee_category,hr_api.g_varchar2)
4475: OR NVL(per_asg_shd.g_old_rec.frequency,hr_api.g_varchar2)
4476: <>NVL(p_frequency,hr_api.g_varchar2)
4477: OR NVL(per_asg_shd.g_old_rec.normal_hours,hr_api.g_number)
4478: <>NVL(p_normal_hours,hr_api.g_number)
4479: OR NVL(per_asg_shd.g_old_rec.probation_period,hr_api.g_number)
4480: <>NVL(p_probation_period,hr_api.g_number)
4481: OR NVL(per_asg_shd.g_old_rec.probation_unit,hr_api.g_varchar2)

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

4475: OR NVL(per_asg_shd.g_old_rec.frequency,hr_api.g_varchar2)
4476: <>NVL(p_frequency,hr_api.g_varchar2)
4477: OR NVL(per_asg_shd.g_old_rec.normal_hours,hr_api.g_number)
4478: <>NVL(p_normal_hours,hr_api.g_number)
4479: OR NVL(per_asg_shd.g_old_rec.probation_period,hr_api.g_number)
4480: <>NVL(p_probation_period,hr_api.g_number)
4481: OR NVL(per_asg_shd.g_old_rec.probation_unit,hr_api.g_varchar2)
4482: <>NVL(p_probation_unit,hr_api.g_varchar2)
4483: OR NVL(per_asg_shd.g_old_rec.notice_period,hr_api.g_number)

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

4477: OR NVL(per_asg_shd.g_old_rec.normal_hours,hr_api.g_number)
4478: <>NVL(p_normal_hours,hr_api.g_number)
4479: OR NVL(per_asg_shd.g_old_rec.probation_period,hr_api.g_number)
4480: <>NVL(p_probation_period,hr_api.g_number)
4481: OR NVL(per_asg_shd.g_old_rec.probation_unit,hr_api.g_varchar2)
4482: <>NVL(p_probation_unit,hr_api.g_varchar2)
4483: OR NVL(per_asg_shd.g_old_rec.notice_period,hr_api.g_number)
4484: <>NVL(p_notice_period,hr_api.g_number)
4485: OR NVL(per_asg_shd.g_old_rec.notice_period_uom,hr_api.g_varchar2)

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

4479: OR NVL(per_asg_shd.g_old_rec.probation_period,hr_api.g_number)
4480: <>NVL(p_probation_period,hr_api.g_number)
4481: OR NVL(per_asg_shd.g_old_rec.probation_unit,hr_api.g_varchar2)
4482: <>NVL(p_probation_unit,hr_api.g_varchar2)
4483: OR NVL(per_asg_shd.g_old_rec.notice_period,hr_api.g_number)
4484: <>NVL(p_notice_period,hr_api.g_number)
4485: OR NVL(per_asg_shd.g_old_rec.notice_period_uom,hr_api.g_varchar2)
4486: <>NVL(p_notice_unit,hr_api.g_varchar2)
4487: OR NVL(per_asg_shd.g_old_rec.set_of_books_id,hr_api.g_number)

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

4481: OR NVL(per_asg_shd.g_old_rec.probation_unit,hr_api.g_varchar2)
4482: <>NVL(p_probation_unit,hr_api.g_varchar2)
4483: OR NVL(per_asg_shd.g_old_rec.notice_period,hr_api.g_number)
4484: <>NVL(p_notice_period,hr_api.g_number)
4485: OR NVL(per_asg_shd.g_old_rec.notice_period_uom,hr_api.g_varchar2)
4486: <>NVL(p_notice_unit,hr_api.g_varchar2)
4487: OR NVL(per_asg_shd.g_old_rec.set_of_books_id,hr_api.g_number)
4488: <>NVL(p_set_of_books_id,hr_api.g_number)
4489: OR NVL(per_asg_shd.g_old_rec.title,hr_api.g_varchar2)

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

4483: OR NVL(per_asg_shd.g_old_rec.notice_period,hr_api.g_number)
4484: <>NVL(p_notice_period,hr_api.g_number)
4485: OR NVL(per_asg_shd.g_old_rec.notice_period_uom,hr_api.g_varchar2)
4486: <>NVL(p_notice_unit,hr_api.g_varchar2)
4487: OR NVL(per_asg_shd.g_old_rec.set_of_books_id,hr_api.g_number)
4488: <>NVL(p_set_of_books_id,hr_api.g_number)
4489: OR NVL(per_asg_shd.g_old_rec.title,hr_api.g_varchar2)
4490: <>NVL(p_billing_title,hr_api.g_varchar2)
4491: OR NVL(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2)

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

4485: OR NVL(per_asg_shd.g_old_rec.notice_period_uom,hr_api.g_varchar2)
4486: <>NVL(p_notice_unit,hr_api.g_varchar2)
4487: OR NVL(per_asg_shd.g_old_rec.set_of_books_id,hr_api.g_number)
4488: <>NVL(p_set_of_books_id,hr_api.g_number)
4489: OR NVL(per_asg_shd.g_old_rec.title,hr_api.g_varchar2)
4490: <>NVL(p_billing_title,hr_api.g_varchar2)
4491: OR NVL(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2)
4492: <>NVL(p_time_normal_finish,hr_api.g_varchar2)
4493: OR NVL(per_asg_shd.g_old_rec.time_normal_start,hr_api.g_varchar2)

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

4487: OR NVL(per_asg_shd.g_old_rec.set_of_books_id,hr_api.g_number)
4488: <>NVL(p_set_of_books_id,hr_api.g_number)
4489: OR NVL(per_asg_shd.g_old_rec.title,hr_api.g_varchar2)
4490: <>NVL(p_billing_title,hr_api.g_varchar2)
4491: OR NVL(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2)
4492: <>NVL(p_time_normal_finish,hr_api.g_varchar2)
4493: OR NVL(per_asg_shd.g_old_rec.time_normal_start,hr_api.g_varchar2)
4494: <>NVL(p_time_normal_start,hr_api.g_varchar2)
4495: OR NVL(per_asg_shd.g_old_rec.ass_attribute_category,hr_api.g_varchar2)

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

4489: OR NVL(per_asg_shd.g_old_rec.title,hr_api.g_varchar2)
4490: <>NVL(p_billing_title,hr_api.g_varchar2)
4491: OR NVL(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2)
4492: <>NVL(p_time_normal_finish,hr_api.g_varchar2)
4493: OR NVL(per_asg_shd.g_old_rec.time_normal_start,hr_api.g_varchar2)
4494: <>NVL(p_time_normal_start,hr_api.g_varchar2)
4495: OR NVL(per_asg_shd.g_old_rec.ass_attribute_category,hr_api.g_varchar2)
4496: <>NVL(p_ass_attribute_category,hr_api.g_varchar2)
4497: OR NVL(per_asg_shd.g_old_rec.ass_attribute1,hr_api.g_varchar2)

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

4491: OR NVL(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2)
4492: <>NVL(p_time_normal_finish,hr_api.g_varchar2)
4493: OR NVL(per_asg_shd.g_old_rec.time_normal_start,hr_api.g_varchar2)
4494: <>NVL(p_time_normal_start,hr_api.g_varchar2)
4495: OR NVL(per_asg_shd.g_old_rec.ass_attribute_category,hr_api.g_varchar2)
4496: <>NVL(p_ass_attribute_category,hr_api.g_varchar2)
4497: OR NVL(per_asg_shd.g_old_rec.ass_attribute1,hr_api.g_varchar2)
4498: <>NVL(p_ass_attribute1,hr_api.g_varchar2)
4499: OR NVL(per_asg_shd.g_old_rec.ass_attribute2,hr_api.g_varchar2)

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

4493: OR NVL(per_asg_shd.g_old_rec.time_normal_start,hr_api.g_varchar2)
4494: <>NVL(p_time_normal_start,hr_api.g_varchar2)
4495: OR NVL(per_asg_shd.g_old_rec.ass_attribute_category,hr_api.g_varchar2)
4496: <>NVL(p_ass_attribute_category,hr_api.g_varchar2)
4497: OR NVL(per_asg_shd.g_old_rec.ass_attribute1,hr_api.g_varchar2)
4498: <>NVL(p_ass_attribute1,hr_api.g_varchar2)
4499: OR NVL(per_asg_shd.g_old_rec.ass_attribute2,hr_api.g_varchar2)
4500: <>NVL(p_ass_attribute2,hr_api.g_varchar2)
4501: OR NVL(per_asg_shd.g_old_rec.ass_attribute3,hr_api.g_varchar2)

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

4495: OR NVL(per_asg_shd.g_old_rec.ass_attribute_category,hr_api.g_varchar2)
4496: <>NVL(p_ass_attribute_category,hr_api.g_varchar2)
4497: OR NVL(per_asg_shd.g_old_rec.ass_attribute1,hr_api.g_varchar2)
4498: <>NVL(p_ass_attribute1,hr_api.g_varchar2)
4499: OR NVL(per_asg_shd.g_old_rec.ass_attribute2,hr_api.g_varchar2)
4500: <>NVL(p_ass_attribute2,hr_api.g_varchar2)
4501: OR NVL(per_asg_shd.g_old_rec.ass_attribute3,hr_api.g_varchar2)
4502: <>NVL(p_ass_attribute3,hr_api.g_varchar2)
4503: OR NVL(per_asg_shd.g_old_rec.ass_attribute4,hr_api.g_varchar2)

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

4497: OR NVL(per_asg_shd.g_old_rec.ass_attribute1,hr_api.g_varchar2)
4498: <>NVL(p_ass_attribute1,hr_api.g_varchar2)
4499: OR NVL(per_asg_shd.g_old_rec.ass_attribute2,hr_api.g_varchar2)
4500: <>NVL(p_ass_attribute2,hr_api.g_varchar2)
4501: OR NVL(per_asg_shd.g_old_rec.ass_attribute3,hr_api.g_varchar2)
4502: <>NVL(p_ass_attribute3,hr_api.g_varchar2)
4503: OR NVL(per_asg_shd.g_old_rec.ass_attribute4,hr_api.g_varchar2)
4504: <>NVL(p_ass_attribute4,hr_api.g_varchar2)
4505: OR NVL(per_asg_shd.g_old_rec.ass_attribute5,hr_api.g_varchar2)

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

4499: OR NVL(per_asg_shd.g_old_rec.ass_attribute2,hr_api.g_varchar2)
4500: <>NVL(p_ass_attribute2,hr_api.g_varchar2)
4501: OR NVL(per_asg_shd.g_old_rec.ass_attribute3,hr_api.g_varchar2)
4502: <>NVL(p_ass_attribute3,hr_api.g_varchar2)
4503: OR NVL(per_asg_shd.g_old_rec.ass_attribute4,hr_api.g_varchar2)
4504: <>NVL(p_ass_attribute4,hr_api.g_varchar2)
4505: OR NVL(per_asg_shd.g_old_rec.ass_attribute5,hr_api.g_varchar2)
4506: <>NVL(p_ass_attribute5,hr_api.g_varchar2)
4507: OR NVL(per_asg_shd.g_old_rec.ass_attribute6,hr_api.g_varchar2)

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

4501: OR NVL(per_asg_shd.g_old_rec.ass_attribute3,hr_api.g_varchar2)
4502: <>NVL(p_ass_attribute3,hr_api.g_varchar2)
4503: OR NVL(per_asg_shd.g_old_rec.ass_attribute4,hr_api.g_varchar2)
4504: <>NVL(p_ass_attribute4,hr_api.g_varchar2)
4505: OR NVL(per_asg_shd.g_old_rec.ass_attribute5,hr_api.g_varchar2)
4506: <>NVL(p_ass_attribute5,hr_api.g_varchar2)
4507: OR NVL(per_asg_shd.g_old_rec.ass_attribute6,hr_api.g_varchar2)
4508: <>NVL(p_ass_attribute6,hr_api.g_varchar2)
4509: OR NVL(per_asg_shd.g_old_rec.ass_attribute7,hr_api.g_varchar2)

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

4503: OR NVL(per_asg_shd.g_old_rec.ass_attribute4,hr_api.g_varchar2)
4504: <>NVL(p_ass_attribute4,hr_api.g_varchar2)
4505: OR NVL(per_asg_shd.g_old_rec.ass_attribute5,hr_api.g_varchar2)
4506: <>NVL(p_ass_attribute5,hr_api.g_varchar2)
4507: OR NVL(per_asg_shd.g_old_rec.ass_attribute6,hr_api.g_varchar2)
4508: <>NVL(p_ass_attribute6,hr_api.g_varchar2)
4509: OR NVL(per_asg_shd.g_old_rec.ass_attribute7,hr_api.g_varchar2)
4510: <>NVL(p_ass_attribute7,hr_api.g_varchar2)
4511: OR NVL(per_asg_shd.g_old_rec.ass_attribute8,hr_api.g_varchar2)

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

4505: OR NVL(per_asg_shd.g_old_rec.ass_attribute5,hr_api.g_varchar2)
4506: <>NVL(p_ass_attribute5,hr_api.g_varchar2)
4507: OR NVL(per_asg_shd.g_old_rec.ass_attribute6,hr_api.g_varchar2)
4508: <>NVL(p_ass_attribute6,hr_api.g_varchar2)
4509: OR NVL(per_asg_shd.g_old_rec.ass_attribute7,hr_api.g_varchar2)
4510: <>NVL(p_ass_attribute7,hr_api.g_varchar2)
4511: OR NVL(per_asg_shd.g_old_rec.ass_attribute8,hr_api.g_varchar2)
4512: <>NVL(p_ass_attribute8,hr_api.g_varchar2)
4513: OR NVL(per_asg_shd.g_old_rec.ass_attribute9,hr_api.g_varchar2)

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

4507: OR NVL(per_asg_shd.g_old_rec.ass_attribute6,hr_api.g_varchar2)
4508: <>NVL(p_ass_attribute6,hr_api.g_varchar2)
4509: OR NVL(per_asg_shd.g_old_rec.ass_attribute7,hr_api.g_varchar2)
4510: <>NVL(p_ass_attribute7,hr_api.g_varchar2)
4511: OR NVL(per_asg_shd.g_old_rec.ass_attribute8,hr_api.g_varchar2)
4512: <>NVL(p_ass_attribute8,hr_api.g_varchar2)
4513: OR NVL(per_asg_shd.g_old_rec.ass_attribute9,hr_api.g_varchar2)
4514: <>NVL(p_ass_attribute9,hr_api.g_varchar2)
4515: OR NVL(per_asg_shd.g_old_rec.ass_attribute10,hr_api.g_varchar2)

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

4509: OR NVL(per_asg_shd.g_old_rec.ass_attribute7,hr_api.g_varchar2)
4510: <>NVL(p_ass_attribute7,hr_api.g_varchar2)
4511: OR NVL(per_asg_shd.g_old_rec.ass_attribute8,hr_api.g_varchar2)
4512: <>NVL(p_ass_attribute8,hr_api.g_varchar2)
4513: OR NVL(per_asg_shd.g_old_rec.ass_attribute9,hr_api.g_varchar2)
4514: <>NVL(p_ass_attribute9,hr_api.g_varchar2)
4515: OR NVL(per_asg_shd.g_old_rec.ass_attribute10,hr_api.g_varchar2)
4516: <>NVL(p_ass_attribute10,hr_api.g_varchar2)
4517: OR NVL(per_asg_shd.g_old_rec.ass_attribute11,hr_api.g_varchar2)

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

4511: OR NVL(per_asg_shd.g_old_rec.ass_attribute8,hr_api.g_varchar2)
4512: <>NVL(p_ass_attribute8,hr_api.g_varchar2)
4513: OR NVL(per_asg_shd.g_old_rec.ass_attribute9,hr_api.g_varchar2)
4514: <>NVL(p_ass_attribute9,hr_api.g_varchar2)
4515: OR NVL(per_asg_shd.g_old_rec.ass_attribute10,hr_api.g_varchar2)
4516: <>NVL(p_ass_attribute10,hr_api.g_varchar2)
4517: OR NVL(per_asg_shd.g_old_rec.ass_attribute11,hr_api.g_varchar2)
4518: <>NVL(p_ass_attribute11,hr_api.g_varchar2)
4519: OR NVL(per_asg_shd.g_old_rec.ass_attribute12,hr_api.g_varchar2)

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

4513: OR NVL(per_asg_shd.g_old_rec.ass_attribute9,hr_api.g_varchar2)
4514: <>NVL(p_ass_attribute9,hr_api.g_varchar2)
4515: OR NVL(per_asg_shd.g_old_rec.ass_attribute10,hr_api.g_varchar2)
4516: <>NVL(p_ass_attribute10,hr_api.g_varchar2)
4517: OR NVL(per_asg_shd.g_old_rec.ass_attribute11,hr_api.g_varchar2)
4518: <>NVL(p_ass_attribute11,hr_api.g_varchar2)
4519: OR NVL(per_asg_shd.g_old_rec.ass_attribute12,hr_api.g_varchar2)
4520: <>NVL(p_ass_attribute12,hr_api.g_varchar2)
4521: OR NVL(per_asg_shd.g_old_rec.ass_attribute13,hr_api.g_varchar2)

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

4515: OR NVL(per_asg_shd.g_old_rec.ass_attribute10,hr_api.g_varchar2)
4516: <>NVL(p_ass_attribute10,hr_api.g_varchar2)
4517: OR NVL(per_asg_shd.g_old_rec.ass_attribute11,hr_api.g_varchar2)
4518: <>NVL(p_ass_attribute11,hr_api.g_varchar2)
4519: OR NVL(per_asg_shd.g_old_rec.ass_attribute12,hr_api.g_varchar2)
4520: <>NVL(p_ass_attribute12,hr_api.g_varchar2)
4521: OR NVL(per_asg_shd.g_old_rec.ass_attribute13,hr_api.g_varchar2)
4522: <>NVL(p_ass_attribute13,hr_api.g_varchar2)
4523: OR NVL(per_asg_shd.g_old_rec.ass_attribute14,hr_api.g_varchar2)

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

4517: OR NVL(per_asg_shd.g_old_rec.ass_attribute11,hr_api.g_varchar2)
4518: <>NVL(p_ass_attribute11,hr_api.g_varchar2)
4519: OR NVL(per_asg_shd.g_old_rec.ass_attribute12,hr_api.g_varchar2)
4520: <>NVL(p_ass_attribute12,hr_api.g_varchar2)
4521: OR NVL(per_asg_shd.g_old_rec.ass_attribute13,hr_api.g_varchar2)
4522: <>NVL(p_ass_attribute13,hr_api.g_varchar2)
4523: OR NVL(per_asg_shd.g_old_rec.ass_attribute14,hr_api.g_varchar2)
4524: <>NVL(p_ass_attribute14,hr_api.g_varchar2)
4525: OR NVL(per_asg_shd.g_old_rec.ass_attribute15,hr_api.g_varchar2)

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

4519: OR NVL(per_asg_shd.g_old_rec.ass_attribute12,hr_api.g_varchar2)
4520: <>NVL(p_ass_attribute12,hr_api.g_varchar2)
4521: OR NVL(per_asg_shd.g_old_rec.ass_attribute13,hr_api.g_varchar2)
4522: <>NVL(p_ass_attribute13,hr_api.g_varchar2)
4523: OR NVL(per_asg_shd.g_old_rec.ass_attribute14,hr_api.g_varchar2)
4524: <>NVL(p_ass_attribute14,hr_api.g_varchar2)
4525: OR NVL(per_asg_shd.g_old_rec.ass_attribute15,hr_api.g_varchar2)
4526: <>NVL(p_ass_attribute15,hr_api.g_varchar2)
4527: OR NVL(per_asg_shd.g_old_rec.ass_attribute16,hr_api.g_varchar2)

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

4521: OR NVL(per_asg_shd.g_old_rec.ass_attribute13,hr_api.g_varchar2)
4522: <>NVL(p_ass_attribute13,hr_api.g_varchar2)
4523: OR NVL(per_asg_shd.g_old_rec.ass_attribute14,hr_api.g_varchar2)
4524: <>NVL(p_ass_attribute14,hr_api.g_varchar2)
4525: OR NVL(per_asg_shd.g_old_rec.ass_attribute15,hr_api.g_varchar2)
4526: <>NVL(p_ass_attribute15,hr_api.g_varchar2)
4527: OR NVL(per_asg_shd.g_old_rec.ass_attribute16,hr_api.g_varchar2)
4528: <>NVL(p_ass_attribute16,hr_api.g_varchar2)
4529: OR NVL(per_asg_shd.g_old_rec.ass_attribute17,hr_api.g_varchar2)

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

4523: OR NVL(per_asg_shd.g_old_rec.ass_attribute14,hr_api.g_varchar2)
4524: <>NVL(p_ass_attribute14,hr_api.g_varchar2)
4525: OR NVL(per_asg_shd.g_old_rec.ass_attribute15,hr_api.g_varchar2)
4526: <>NVL(p_ass_attribute15,hr_api.g_varchar2)
4527: OR NVL(per_asg_shd.g_old_rec.ass_attribute16,hr_api.g_varchar2)
4528: <>NVL(p_ass_attribute16,hr_api.g_varchar2)
4529: OR NVL(per_asg_shd.g_old_rec.ass_attribute17,hr_api.g_varchar2)
4530: <>NVL(p_ass_attribute17,hr_api.g_varchar2)
4531: OR NVL(per_asg_shd.g_old_rec.ass_attribute18,hr_api.g_varchar2)

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

4525: OR NVL(per_asg_shd.g_old_rec.ass_attribute15,hr_api.g_varchar2)
4526: <>NVL(p_ass_attribute15,hr_api.g_varchar2)
4527: OR NVL(per_asg_shd.g_old_rec.ass_attribute16,hr_api.g_varchar2)
4528: <>NVL(p_ass_attribute16,hr_api.g_varchar2)
4529: OR NVL(per_asg_shd.g_old_rec.ass_attribute17,hr_api.g_varchar2)
4530: <>NVL(p_ass_attribute17,hr_api.g_varchar2)
4531: OR NVL(per_asg_shd.g_old_rec.ass_attribute18,hr_api.g_varchar2)
4532: <>NVL(p_ass_attribute18,hr_api.g_varchar2)
4533: OR NVL(per_asg_shd.g_old_rec.ass_attribute19,hr_api.g_varchar2)

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

4527: OR NVL(per_asg_shd.g_old_rec.ass_attribute16,hr_api.g_varchar2)
4528: <>NVL(p_ass_attribute16,hr_api.g_varchar2)
4529: OR NVL(per_asg_shd.g_old_rec.ass_attribute17,hr_api.g_varchar2)
4530: <>NVL(p_ass_attribute17,hr_api.g_varchar2)
4531: OR NVL(per_asg_shd.g_old_rec.ass_attribute18,hr_api.g_varchar2)
4532: <>NVL(p_ass_attribute18,hr_api.g_varchar2)
4533: OR NVL(per_asg_shd.g_old_rec.ass_attribute19,hr_api.g_varchar2)
4534: <>NVL(p_ass_attribute19,hr_api.g_varchar2)
4535: OR NVL(per_asg_shd.g_old_rec.ass_attribute20,hr_api.g_varchar2)

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

4529: OR NVL(per_asg_shd.g_old_rec.ass_attribute17,hr_api.g_varchar2)
4530: <>NVL(p_ass_attribute17,hr_api.g_varchar2)
4531: OR NVL(per_asg_shd.g_old_rec.ass_attribute18,hr_api.g_varchar2)
4532: <>NVL(p_ass_attribute18,hr_api.g_varchar2)
4533: OR NVL(per_asg_shd.g_old_rec.ass_attribute19,hr_api.g_varchar2)
4534: <>NVL(p_ass_attribute19,hr_api.g_varchar2)
4535: OR NVL(per_asg_shd.g_old_rec.ass_attribute20,hr_api.g_varchar2)
4536: <>NVL(p_ass_attribute20,hr_api.g_varchar2)
4537: OR NVL(per_asg_shd.g_old_rec.ass_attribute21,hr_api.g_varchar2)

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

4531: OR NVL(per_asg_shd.g_old_rec.ass_attribute18,hr_api.g_varchar2)
4532: <>NVL(p_ass_attribute18,hr_api.g_varchar2)
4533: OR NVL(per_asg_shd.g_old_rec.ass_attribute19,hr_api.g_varchar2)
4534: <>NVL(p_ass_attribute19,hr_api.g_varchar2)
4535: OR NVL(per_asg_shd.g_old_rec.ass_attribute20,hr_api.g_varchar2)
4536: <>NVL(p_ass_attribute20,hr_api.g_varchar2)
4537: OR NVL(per_asg_shd.g_old_rec.ass_attribute21,hr_api.g_varchar2)
4538: <>NVL(p_ass_attribute21,hr_api.g_varchar2)
4539: OR NVL(per_asg_shd.g_old_rec.ass_attribute22,hr_api.g_varchar2)

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

4533: OR NVL(per_asg_shd.g_old_rec.ass_attribute19,hr_api.g_varchar2)
4534: <>NVL(p_ass_attribute19,hr_api.g_varchar2)
4535: OR NVL(per_asg_shd.g_old_rec.ass_attribute20,hr_api.g_varchar2)
4536: <>NVL(p_ass_attribute20,hr_api.g_varchar2)
4537: OR NVL(per_asg_shd.g_old_rec.ass_attribute21,hr_api.g_varchar2)
4538: <>NVL(p_ass_attribute21,hr_api.g_varchar2)
4539: OR NVL(per_asg_shd.g_old_rec.ass_attribute22,hr_api.g_varchar2)
4540: <>NVL(p_ass_attribute22,hr_api.g_varchar2)
4541: OR NVL(per_asg_shd.g_old_rec.ass_attribute23,hr_api.g_varchar2)

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

4535: OR NVL(per_asg_shd.g_old_rec.ass_attribute20,hr_api.g_varchar2)
4536: <>NVL(p_ass_attribute20,hr_api.g_varchar2)
4537: OR NVL(per_asg_shd.g_old_rec.ass_attribute21,hr_api.g_varchar2)
4538: <>NVL(p_ass_attribute21,hr_api.g_varchar2)
4539: OR NVL(per_asg_shd.g_old_rec.ass_attribute22,hr_api.g_varchar2)
4540: <>NVL(p_ass_attribute22,hr_api.g_varchar2)
4541: OR NVL(per_asg_shd.g_old_rec.ass_attribute23,hr_api.g_varchar2)
4542: <>NVL(p_ass_attribute23,hr_api.g_varchar2)
4543: OR NVL(per_asg_shd.g_old_rec.ass_attribute24,hr_api.g_varchar2)

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

4537: OR NVL(per_asg_shd.g_old_rec.ass_attribute21,hr_api.g_varchar2)
4538: <>NVL(p_ass_attribute21,hr_api.g_varchar2)
4539: OR NVL(per_asg_shd.g_old_rec.ass_attribute22,hr_api.g_varchar2)
4540: <>NVL(p_ass_attribute22,hr_api.g_varchar2)
4541: OR NVL(per_asg_shd.g_old_rec.ass_attribute23,hr_api.g_varchar2)
4542: <>NVL(p_ass_attribute23,hr_api.g_varchar2)
4543: OR NVL(per_asg_shd.g_old_rec.ass_attribute24,hr_api.g_varchar2)
4544: <>NVL(p_ass_attribute24,hr_api.g_varchar2)
4545: OR NVL(per_asg_shd.g_old_rec.ass_attribute25,hr_api.g_varchar2)

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

4539: OR NVL(per_asg_shd.g_old_rec.ass_attribute22,hr_api.g_varchar2)
4540: <>NVL(p_ass_attribute22,hr_api.g_varchar2)
4541: OR NVL(per_asg_shd.g_old_rec.ass_attribute23,hr_api.g_varchar2)
4542: <>NVL(p_ass_attribute23,hr_api.g_varchar2)
4543: OR NVL(per_asg_shd.g_old_rec.ass_attribute24,hr_api.g_varchar2)
4544: <>NVL(p_ass_attribute24,hr_api.g_varchar2)
4545: OR NVL(per_asg_shd.g_old_rec.ass_attribute25,hr_api.g_varchar2)
4546: <>NVL(p_ass_attribute25,hr_api.g_varchar2)
4547: OR NVL(per_asg_shd.g_old_rec.ass_attribute26,hr_api.g_varchar2)

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

4541: OR NVL(per_asg_shd.g_old_rec.ass_attribute23,hr_api.g_varchar2)
4542: <>NVL(p_ass_attribute23,hr_api.g_varchar2)
4543: OR NVL(per_asg_shd.g_old_rec.ass_attribute24,hr_api.g_varchar2)
4544: <>NVL(p_ass_attribute24,hr_api.g_varchar2)
4545: OR NVL(per_asg_shd.g_old_rec.ass_attribute25,hr_api.g_varchar2)
4546: <>NVL(p_ass_attribute25,hr_api.g_varchar2)
4547: OR NVL(per_asg_shd.g_old_rec.ass_attribute26,hr_api.g_varchar2)
4548: <>NVL(p_ass_attribute26,hr_api.g_varchar2)
4549: OR NVL(per_asg_shd.g_old_rec.ass_attribute27,hr_api.g_varchar2)

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

4543: OR NVL(per_asg_shd.g_old_rec.ass_attribute24,hr_api.g_varchar2)
4544: <>NVL(p_ass_attribute24,hr_api.g_varchar2)
4545: OR NVL(per_asg_shd.g_old_rec.ass_attribute25,hr_api.g_varchar2)
4546: <>NVL(p_ass_attribute25,hr_api.g_varchar2)
4547: OR NVL(per_asg_shd.g_old_rec.ass_attribute26,hr_api.g_varchar2)
4548: <>NVL(p_ass_attribute26,hr_api.g_varchar2)
4549: OR NVL(per_asg_shd.g_old_rec.ass_attribute27,hr_api.g_varchar2)
4550: <>NVL(p_ass_attribute27,hr_api.g_varchar2)
4551: OR NVL(per_asg_shd.g_old_rec.ass_attribute28,hr_api.g_varchar2)

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

4545: OR NVL(per_asg_shd.g_old_rec.ass_attribute25,hr_api.g_varchar2)
4546: <>NVL(p_ass_attribute25,hr_api.g_varchar2)
4547: OR NVL(per_asg_shd.g_old_rec.ass_attribute26,hr_api.g_varchar2)
4548: <>NVL(p_ass_attribute26,hr_api.g_varchar2)
4549: OR NVL(per_asg_shd.g_old_rec.ass_attribute27,hr_api.g_varchar2)
4550: <>NVL(p_ass_attribute27,hr_api.g_varchar2)
4551: OR NVL(per_asg_shd.g_old_rec.ass_attribute28,hr_api.g_varchar2)
4552: <>NVL(p_ass_attribute28,hr_api.g_varchar2)
4553: OR NVL(per_asg_shd.g_old_rec.ass_attribute29,hr_api.g_varchar2)

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

4547: OR NVL(per_asg_shd.g_old_rec.ass_attribute26,hr_api.g_varchar2)
4548: <>NVL(p_ass_attribute26,hr_api.g_varchar2)
4549: OR NVL(per_asg_shd.g_old_rec.ass_attribute27,hr_api.g_varchar2)
4550: <>NVL(p_ass_attribute27,hr_api.g_varchar2)
4551: OR NVL(per_asg_shd.g_old_rec.ass_attribute28,hr_api.g_varchar2)
4552: <>NVL(p_ass_attribute28,hr_api.g_varchar2)
4553: OR NVL(per_asg_shd.g_old_rec.ass_attribute29,hr_api.g_varchar2)
4554: <>NVL(p_ass_attribute29,hr_api.g_varchar2)
4555: OR NVL(per_asg_shd.g_old_rec.ass_attribute30,hr_api.g_varchar2)

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

4549: OR NVL(per_asg_shd.g_old_rec.ass_attribute27,hr_api.g_varchar2)
4550: <>NVL(p_ass_attribute27,hr_api.g_varchar2)
4551: OR NVL(per_asg_shd.g_old_rec.ass_attribute28,hr_api.g_varchar2)
4552: <>NVL(p_ass_attribute28,hr_api.g_varchar2)
4553: OR NVL(per_asg_shd.g_old_rec.ass_attribute29,hr_api.g_varchar2)
4554: <>NVL(p_ass_attribute29,hr_api.g_varchar2)
4555: OR NVL(per_asg_shd.g_old_rec.ass_attribute30,hr_api.g_varchar2)
4556: <>NVL(p_ass_attribute30,hr_api.g_varchar2)
4557: OR NVL(per_asg_shd.g_old_rec.bargaining_unit_code,hr_api.g_varchar2)

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

4551: OR NVL(per_asg_shd.g_old_rec.ass_attribute28,hr_api.g_varchar2)
4552: <>NVL(p_ass_attribute28,hr_api.g_varchar2)
4553: OR NVL(per_asg_shd.g_old_rec.ass_attribute29,hr_api.g_varchar2)
4554: <>NVL(p_ass_attribute29,hr_api.g_varchar2)
4555: OR NVL(per_asg_shd.g_old_rec.ass_attribute30,hr_api.g_varchar2)
4556: <>NVL(p_ass_attribute30,hr_api.g_varchar2)
4557: OR NVL(per_asg_shd.g_old_rec.bargaining_unit_code,hr_api.g_varchar2)
4558: <>NVL(p_bargaining_unit_code,hr_api.g_varchar2)
4559: OR NVL(per_asg_shd.g_old_rec.labour_union_member_flag,hr_api.g_varchar2)

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

4553: OR NVL(per_asg_shd.g_old_rec.ass_attribute29,hr_api.g_varchar2)
4554: <>NVL(p_ass_attribute29,hr_api.g_varchar2)
4555: OR NVL(per_asg_shd.g_old_rec.ass_attribute30,hr_api.g_varchar2)
4556: <>NVL(p_ass_attribute30,hr_api.g_varchar2)
4557: OR NVL(per_asg_shd.g_old_rec.bargaining_unit_code,hr_api.g_varchar2)
4558: <>NVL(p_bargaining_unit_code,hr_api.g_varchar2)
4559: OR NVL(per_asg_shd.g_old_rec.labour_union_member_flag,hr_api.g_varchar2)
4560: <>NVL(p_labour_union_member_flag,hr_api.g_varchar2)
4561: --Bug 3063591 Start Here

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

4555: OR NVL(per_asg_shd.g_old_rec.ass_attribute30,hr_api.g_varchar2)
4556: <>NVL(p_ass_attribute30,hr_api.g_varchar2)
4557: OR NVL(per_asg_shd.g_old_rec.bargaining_unit_code,hr_api.g_varchar2)
4558: <>NVL(p_bargaining_unit_code,hr_api.g_varchar2)
4559: OR NVL(per_asg_shd.g_old_rec.labour_union_member_flag,hr_api.g_varchar2)
4560: <>NVL(p_labour_union_member_flag,hr_api.g_varchar2)
4561: --Bug 3063591 Start Here
4562: OR NVL(per_asg_shd.g_old_rec.work_at_home,hr_api.g_varchar2)
4563: <>NVL(p_work_at_home,hr_api.g_varchar2)

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

4558: <>NVL(p_bargaining_unit_code,hr_api.g_varchar2)
4559: OR NVL(per_asg_shd.g_old_rec.labour_union_member_flag,hr_api.g_varchar2)
4560: <>NVL(p_labour_union_member_flag,hr_api.g_varchar2)
4561: --Bug 3063591 Start Here
4562: OR NVL(per_asg_shd.g_old_rec.work_at_home,hr_api.g_varchar2)
4563: <>NVL(p_work_at_home,hr_api.g_varchar2)
4564: --Bug 3063591 End Here
4565: OR NVL(per_asg_shd.g_old_rec.hourly_salaried_code,hr_api.g_varchar2)
4566: <>NVL(p_hourly_salaried_code,hr_api.g_varchar2)

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

4561: --Bug 3063591 Start Here
4562: OR NVL(per_asg_shd.g_old_rec.work_at_home,hr_api.g_varchar2)
4563: <>NVL(p_work_at_home,hr_api.g_varchar2)
4564: --Bug 3063591 End Here
4565: OR NVL(per_asg_shd.g_old_rec.hourly_salaried_code,hr_api.g_varchar2)
4566: <>NVL(p_hourly_salaried_code,hr_api.g_varchar2)
4567: OR NVL(per_asg_shd.g_old_rec.special_ceiling_step_id,hr_api.g_number)
4568: <>NVL(p_special_ceiling_step_id,hr_api.g_number)
4569: OR NVL(per_asg_shd.g_old_rec.change_reason,hr_api.g_varchar2)

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

4563: <>NVL(p_work_at_home,hr_api.g_varchar2)
4564: --Bug 3063591 End Here
4565: OR NVL(per_asg_shd.g_old_rec.hourly_salaried_code,hr_api.g_varchar2)
4566: <>NVL(p_hourly_salaried_code,hr_api.g_varchar2)
4567: OR NVL(per_asg_shd.g_old_rec.special_ceiling_step_id,hr_api.g_number)
4568: <>NVL(p_special_ceiling_step_id,hr_api.g_number)
4569: OR NVL(per_asg_shd.g_old_rec.change_reason,hr_api.g_varchar2)
4570: <>NVL(p_change_reason,hr_api.g_varchar2)
4571: OR NVL(per_asg_shd.g_old_rec.internal_address_line,hr_api.g_varchar2)

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

4565: OR NVL(per_asg_shd.g_old_rec.hourly_salaried_code,hr_api.g_varchar2)
4566: <>NVL(p_hourly_salaried_code,hr_api.g_varchar2)
4567: OR NVL(per_asg_shd.g_old_rec.special_ceiling_step_id,hr_api.g_number)
4568: <>NVL(p_special_ceiling_step_id,hr_api.g_number)
4569: OR NVL(per_asg_shd.g_old_rec.change_reason,hr_api.g_varchar2)
4570: <>NVL(p_change_reason,hr_api.g_varchar2)
4571: OR NVL(per_asg_shd.g_old_rec.internal_address_line,hr_api.g_varchar2)
4572: <>NVL(p_internal_address_line,hr_api.g_varchar2)
4573: OR NVL(per_asg_shd.g_old_rec.manager_flag,hr_api.g_varchar2)

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

4567: OR NVL(per_asg_shd.g_old_rec.special_ceiling_step_id,hr_api.g_number)
4568: <>NVL(p_special_ceiling_step_id,hr_api.g_number)
4569: OR NVL(per_asg_shd.g_old_rec.change_reason,hr_api.g_varchar2)
4570: <>NVL(p_change_reason,hr_api.g_varchar2)
4571: OR NVL(per_asg_shd.g_old_rec.internal_address_line,hr_api.g_varchar2)
4572: <>NVL(p_internal_address_line,hr_api.g_varchar2)
4573: OR NVL(per_asg_shd.g_old_rec.manager_flag,hr_api.g_varchar2)
4574: <>NVL(p_manager_flag,hr_api.g_varchar2)
4575: OR NVL(per_asg_shd.g_old_rec.perf_review_period,hr_api.g_number)

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

4569: OR NVL(per_asg_shd.g_old_rec.change_reason,hr_api.g_varchar2)
4570: <>NVL(p_change_reason,hr_api.g_varchar2)
4571: OR NVL(per_asg_shd.g_old_rec.internal_address_line,hr_api.g_varchar2)
4572: <>NVL(p_internal_address_line,hr_api.g_varchar2)
4573: OR NVL(per_asg_shd.g_old_rec.manager_flag,hr_api.g_varchar2)
4574: <>NVL(p_manager_flag,hr_api.g_varchar2)
4575: OR NVL(per_asg_shd.g_old_rec.perf_review_period,hr_api.g_number)
4576: <>NVL(p_perf_review_period,hr_api.g_number)
4577: OR NVL(per_asg_shd.g_old_rec.perf_review_period_frequency,hr_api.g_varchar2)

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

4571: OR NVL(per_asg_shd.g_old_rec.internal_address_line,hr_api.g_varchar2)
4572: <>NVL(p_internal_address_line,hr_api.g_varchar2)
4573: OR NVL(per_asg_shd.g_old_rec.manager_flag,hr_api.g_varchar2)
4574: <>NVL(p_manager_flag,hr_api.g_varchar2)
4575: OR NVL(per_asg_shd.g_old_rec.perf_review_period,hr_api.g_number)
4576: <>NVL(p_perf_review_period,hr_api.g_number)
4577: OR NVL(per_asg_shd.g_old_rec.perf_review_period_frequency,hr_api.g_varchar2)
4578: <>NVL(p_perf_review_period_frequency,hr_api.g_varchar2)
4579: OR NVL(per_asg_shd.g_old_rec.sal_review_period,hr_api.g_number)

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

4573: OR NVL(per_asg_shd.g_old_rec.manager_flag,hr_api.g_varchar2)
4574: <>NVL(p_manager_flag,hr_api.g_varchar2)
4575: OR NVL(per_asg_shd.g_old_rec.perf_review_period,hr_api.g_number)
4576: <>NVL(p_perf_review_period,hr_api.g_number)
4577: OR NVL(per_asg_shd.g_old_rec.perf_review_period_frequency,hr_api.g_varchar2)
4578: <>NVL(p_perf_review_period_frequency,hr_api.g_varchar2)
4579: OR NVL(per_asg_shd.g_old_rec.sal_review_period,hr_api.g_number)
4580: <>NVL(p_sal_review_period,hr_api.g_number)
4581: OR NVL(per_asg_shd.g_old_rec.sal_review_period_frequency,hr_api.g_varchar2)

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

4575: OR NVL(per_asg_shd.g_old_rec.perf_review_period,hr_api.g_number)
4576: <>NVL(p_perf_review_period,hr_api.g_number)
4577: OR NVL(per_asg_shd.g_old_rec.perf_review_period_frequency,hr_api.g_varchar2)
4578: <>NVL(p_perf_review_period_frequency,hr_api.g_varchar2)
4579: OR NVL(per_asg_shd.g_old_rec.sal_review_period,hr_api.g_number)
4580: <>NVL(p_sal_review_period,hr_api.g_number)
4581: OR NVL(per_asg_shd.g_old_rec.sal_review_period_frequency,hr_api.g_varchar2)
4582: <>NVL(p_sal_review_period_frequency,hr_api.g_varchar2)
4583: OR NVL(per_asg_shd.g_old_rec.source_type,hr_api.g_varchar2)

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

4577: OR NVL(per_asg_shd.g_old_rec.perf_review_period_frequency,hr_api.g_varchar2)
4578: <>NVL(p_perf_review_period_frequency,hr_api.g_varchar2)
4579: OR NVL(per_asg_shd.g_old_rec.sal_review_period,hr_api.g_number)
4580: <>NVL(p_sal_review_period,hr_api.g_number)
4581: OR NVL(per_asg_shd.g_old_rec.sal_review_period_frequency,hr_api.g_varchar2)
4582: <>NVL(p_sal_review_period_frequency,hr_api.g_varchar2)
4583: OR NVL(per_asg_shd.g_old_rec.source_type,hr_api.g_varchar2)
4584: <>NVL(p_source_type,hr_api.g_varchar2)
4585: OR NVL(per_asg_shd.g_old_rec.contract_id,hr_api.g_number)

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

4579: OR NVL(per_asg_shd.g_old_rec.sal_review_period,hr_api.g_number)
4580: <>NVL(p_sal_review_period,hr_api.g_number)
4581: OR NVL(per_asg_shd.g_old_rec.sal_review_period_frequency,hr_api.g_varchar2)
4582: <>NVL(p_sal_review_period_frequency,hr_api.g_varchar2)
4583: OR NVL(per_asg_shd.g_old_rec.source_type,hr_api.g_varchar2)
4584: <>NVL(p_source_type,hr_api.g_varchar2)
4585: OR NVL(per_asg_shd.g_old_rec.contract_id,hr_api.g_number)
4586: <>NVL(p_contract_id,hr_api.g_number)
4587: OR NVL(per_asg_shd.g_old_rec.collective_agreement_id,hr_api.g_number)

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

4581: OR NVL(per_asg_shd.g_old_rec.sal_review_period_frequency,hr_api.g_varchar2)
4582: <>NVL(p_sal_review_period_frequency,hr_api.g_varchar2)
4583: OR NVL(per_asg_shd.g_old_rec.source_type,hr_api.g_varchar2)
4584: <>NVL(p_source_type,hr_api.g_varchar2)
4585: OR NVL(per_asg_shd.g_old_rec.contract_id,hr_api.g_number)
4586: <>NVL(p_contract_id,hr_api.g_number)
4587: OR NVL(per_asg_shd.g_old_rec.collective_agreement_id,hr_api.g_number)
4588: <>NVL(p_collective_agreement_id,hr_api.g_number)
4589: OR NVL(per_asg_shd.g_old_rec.cagr_id_flex_num,hr_api.g_number)

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

4583: OR NVL(per_asg_shd.g_old_rec.source_type,hr_api.g_varchar2)
4584: <>NVL(p_source_type,hr_api.g_varchar2)
4585: OR NVL(per_asg_shd.g_old_rec.contract_id,hr_api.g_number)
4586: <>NVL(p_contract_id,hr_api.g_number)
4587: OR NVL(per_asg_shd.g_old_rec.collective_agreement_id,hr_api.g_number)
4588: <>NVL(p_collective_agreement_id,hr_api.g_number)
4589: OR NVL(per_asg_shd.g_old_rec.cagr_id_flex_num,hr_api.g_number)
4590: <>NVL(p_cagr_id_flex_num,hr_api.g_number)
4591: OR NVL(per_asg_shd.g_old_rec.cagr_grade_def_id,hr_api.g_number)

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

4585: OR NVL(per_asg_shd.g_old_rec.contract_id,hr_api.g_number)
4586: <>NVL(p_contract_id,hr_api.g_number)
4587: OR NVL(per_asg_shd.g_old_rec.collective_agreement_id,hr_api.g_number)
4588: <>NVL(p_collective_agreement_id,hr_api.g_number)
4589: OR NVL(per_asg_shd.g_old_rec.cagr_id_flex_num,hr_api.g_number)
4590: <>NVL(p_cagr_id_flex_num,hr_api.g_number)
4591: OR NVL(per_asg_shd.g_old_rec.cagr_grade_def_id,hr_api.g_number)
4592: <>NVL(p_cagr_grade_def_id,hr_api.g_number)
4593: OR NVL(per_asg_shd.g_old_rec.establishment_id,hr_api.g_number)

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

4587: OR NVL(per_asg_shd.g_old_rec.collective_agreement_id,hr_api.g_number)
4588: <>NVL(p_collective_agreement_id,hr_api.g_number)
4589: OR NVL(per_asg_shd.g_old_rec.cagr_id_flex_num,hr_api.g_number)
4590: <>NVL(p_cagr_id_flex_num,hr_api.g_number)
4591: OR NVL(per_asg_shd.g_old_rec.cagr_grade_def_id,hr_api.g_number)
4592: <>NVL(p_cagr_grade_def_id,hr_api.g_number)
4593: OR NVL(per_asg_shd.g_old_rec.establishment_id,hr_api.g_number)
4594: <>NVL(p_establishment_id,hr_api.g_number)
4595: --CWK

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

4589: OR NVL(per_asg_shd.g_old_rec.cagr_id_flex_num,hr_api.g_number)
4590: <>NVL(p_cagr_id_flex_num,hr_api.g_number)
4591: OR NVL(per_asg_shd.g_old_rec.cagr_grade_def_id,hr_api.g_number)
4592: <>NVL(p_cagr_grade_def_id,hr_api.g_number)
4593: OR NVL(per_asg_shd.g_old_rec.establishment_id,hr_api.g_number)
4594: <>NVL(p_establishment_id,hr_api.g_number)
4595: --CWK
4596: OR NVL(per_asg_shd.g_old_rec.period_of_placement_date_start,hr_api.g_date)
4597: <>NVL(p_placement_date_start,hr_api.g_date)

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

4592: <>NVL(p_cagr_grade_def_id,hr_api.g_number)
4593: OR NVL(per_asg_shd.g_old_rec.establishment_id,hr_api.g_number)
4594: <>NVL(p_establishment_id,hr_api.g_number)
4595: --CWK
4596: OR NVL(per_asg_shd.g_old_rec.period_of_placement_date_start,hr_api.g_date)
4597: <>NVL(p_placement_date_start,hr_api.g_date)
4598: OR NVL(per_asg_shd.g_old_rec.vendor_id,hr_api.g_number)
4599: <>NVL(p_vendor_id,hr_api.g_number)
4600: OR NVL(per_asg_shd.g_old_rec.vendor_employee_number,hr_api.g_varchar2)

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

4594: <>NVL(p_establishment_id,hr_api.g_number)
4595: --CWK
4596: OR NVL(per_asg_shd.g_old_rec.period_of_placement_date_start,hr_api.g_date)
4597: <>NVL(p_placement_date_start,hr_api.g_date)
4598: OR NVL(per_asg_shd.g_old_rec.vendor_id,hr_api.g_number)
4599: <>NVL(p_vendor_id,hr_api.g_number)
4600: OR NVL(per_asg_shd.g_old_rec.vendor_employee_number,hr_api.g_varchar2)
4601: <>NVL(p_vendor_employee_number,hr_api.g_varchar2)
4602: OR NVL(per_asg_shd.g_old_rec.vendor_assignment_number,hr_api.g_varchar2)

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

4596: OR NVL(per_asg_shd.g_old_rec.period_of_placement_date_start,hr_api.g_date)
4597: <>NVL(p_placement_date_start,hr_api.g_date)
4598: OR NVL(per_asg_shd.g_old_rec.vendor_id,hr_api.g_number)
4599: <>NVL(p_vendor_id,hr_api.g_number)
4600: OR NVL(per_asg_shd.g_old_rec.vendor_employee_number,hr_api.g_varchar2)
4601: <>NVL(p_vendor_employee_number,hr_api.g_varchar2)
4602: OR NVL(per_asg_shd.g_old_rec.vendor_assignment_number,hr_api.g_varchar2)
4603: <>NVL(p_vendor_assignment_number,hr_api.g_varchar2)
4604: OR NVL(per_asg_shd.g_old_rec.project_title,hr_api.g_varchar2)

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

4598: OR NVL(per_asg_shd.g_old_rec.vendor_id,hr_api.g_number)
4599: <>NVL(p_vendor_id,hr_api.g_number)
4600: OR NVL(per_asg_shd.g_old_rec.vendor_employee_number,hr_api.g_varchar2)
4601: <>NVL(p_vendor_employee_number,hr_api.g_varchar2)
4602: OR NVL(per_asg_shd.g_old_rec.vendor_assignment_number,hr_api.g_varchar2)
4603: <>NVL(p_vendor_assignment_number,hr_api.g_varchar2)
4604: OR NVL(per_asg_shd.g_old_rec.project_title,hr_api.g_varchar2)
4605: <>NVL(p_project_title,hr_api.g_varchar2)
4606: OR NVL(per_asg_shd.g_old_rec.vendor_site_id,hr_api.g_number)

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

4600: OR NVL(per_asg_shd.g_old_rec.vendor_employee_number,hr_api.g_varchar2)
4601: <>NVL(p_vendor_employee_number,hr_api.g_varchar2)
4602: OR NVL(per_asg_shd.g_old_rec.vendor_assignment_number,hr_api.g_varchar2)
4603: <>NVL(p_vendor_assignment_number,hr_api.g_varchar2)
4604: OR NVL(per_asg_shd.g_old_rec.project_title,hr_api.g_varchar2)
4605: <>NVL(p_project_title,hr_api.g_varchar2)
4606: OR NVL(per_asg_shd.g_old_rec.vendor_site_id,hr_api.g_number)
4607: <>NVL(p_vendor_site_id,hr_api.g_number)
4608: OR NVL(per_asg_shd.g_old_rec.po_header_id,hr_api.g_number)

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

4602: OR NVL(per_asg_shd.g_old_rec.vendor_assignment_number,hr_api.g_varchar2)
4603: <>NVL(p_vendor_assignment_number,hr_api.g_varchar2)
4604: OR NVL(per_asg_shd.g_old_rec.project_title,hr_api.g_varchar2)
4605: <>NVL(p_project_title,hr_api.g_varchar2)
4606: OR NVL(per_asg_shd.g_old_rec.vendor_site_id,hr_api.g_number)
4607: <>NVL(p_vendor_site_id,hr_api.g_number)
4608: OR NVL(per_asg_shd.g_old_rec.po_header_id,hr_api.g_number)
4609: <>NVL(p_po_header_id,hr_api.g_number)
4610: OR NVL(per_asg_shd.g_old_rec.po_line_id,hr_api.g_number)

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

4604: OR NVL(per_asg_shd.g_old_rec.project_title,hr_api.g_varchar2)
4605: <>NVL(p_project_title,hr_api.g_varchar2)
4606: OR NVL(per_asg_shd.g_old_rec.vendor_site_id,hr_api.g_number)
4607: <>NVL(p_vendor_site_id,hr_api.g_number)
4608: OR NVL(per_asg_shd.g_old_rec.po_header_id,hr_api.g_number)
4609: <>NVL(p_po_header_id,hr_api.g_number)
4610: OR NVL(per_asg_shd.g_old_rec.po_line_id,hr_api.g_number)
4611: <>NVL(p_po_line_id,hr_api.g_number)
4612: OR NVL(per_asg_shd.g_old_rec.projected_assignment_end,hr_api.g_date)

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

4606: OR NVL(per_asg_shd.g_old_rec.vendor_site_id,hr_api.g_number)
4607: <>NVL(p_vendor_site_id,hr_api.g_number)
4608: OR NVL(per_asg_shd.g_old_rec.po_header_id,hr_api.g_number)
4609: <>NVL(p_po_header_id,hr_api.g_number)
4610: OR NVL(per_asg_shd.g_old_rec.po_line_id,hr_api.g_number)
4611: <>NVL(p_po_line_id,hr_api.g_number)
4612: OR NVL(per_asg_shd.g_old_rec.projected_assignment_end,hr_api.g_date)
4613: <>NVL(p_projected_assignment_end,hr_api.g_date)
4614:

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

4608: OR NVL(per_asg_shd.g_old_rec.po_header_id,hr_api.g_number)
4609: <>NVL(p_po_header_id,hr_api.g_number)
4610: OR NVL(per_asg_shd.g_old_rec.po_line_id,hr_api.g_number)
4611: <>NVL(p_po_line_id,hr_api.g_number)
4612: OR NVL(per_asg_shd.g_old_rec.projected_assignment_end,hr_api.g_date)
4613: <>NVL(p_projected_assignment_end,hr_api.g_date)
4614:
4615: THEN
4616: --

Line 7176: per_asg_shd.lck

7172: ELSE
7173: l_asg_datetrack_update_mode:=p_datetrack_update_mode;
7174: END IF;
7175: --
7176: per_asg_shd.lck
7177: (p_effective_date => p_effective_date
7178: ,p_datetrack_mode => l_asg_datetrack_update_mode
7179: ,p_assignment_id => p_assignment_id
7180: ,p_object_version_number => p_asg_object_version_number