DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_DPF_SHD

Line 6255: IF NVL(per_dpf_shd.g_old_rec.work_any_country,hr_api.g_varchar2)

6251: );
6252: END IF;
6253: ELSE
6254: --
6255: IF NVL(per_dpf_shd.g_old_rec.work_any_country,hr_api.g_varchar2)
6256: <> NVL(p_work_any_country,hr_api.g_varchar2)
6257: OR NVL(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
6258: <> NVL(p_work_any_location,hr_api.g_varchar2)
6259: OR NVL(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)

Line 6257: OR NVL(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)

6253: ELSE
6254: --
6255: IF NVL(per_dpf_shd.g_old_rec.work_any_country,hr_api.g_varchar2)
6256: <> NVL(p_work_any_country,hr_api.g_varchar2)
6257: OR NVL(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
6258: <> NVL(p_work_any_location,hr_api.g_varchar2)
6259: OR NVL(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
6260: <> NVL(p_relocate_domestically,hr_api.g_varchar2)
6261: OR NVL(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)

Line 6259: OR NVL(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)

6255: IF NVL(per_dpf_shd.g_old_rec.work_any_country,hr_api.g_varchar2)
6256: <> NVL(p_work_any_country,hr_api.g_varchar2)
6257: OR NVL(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
6258: <> NVL(p_work_any_location,hr_api.g_varchar2)
6259: OR NVL(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
6260: <> NVL(p_relocate_domestically,hr_api.g_varchar2)
6261: OR NVL(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
6262: <> NVL(p_relocate_internationally,hr_api.g_varchar2)
6263: OR NVL(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2)

Line 6261: OR NVL(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)

6257: OR NVL(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
6258: <> NVL(p_work_any_location,hr_api.g_varchar2)
6259: OR NVL(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
6260: <> NVL(p_relocate_domestically,hr_api.g_varchar2)
6261: OR NVL(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
6262: <> NVL(p_relocate_internationally,hr_api.g_varchar2)
6263: OR NVL(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2)
6264: <> NVL(p_travel_required,hr_api.g_varchar2)
6265: OR NVL(per_dpf_shd.g_old_rec.country1,hr_api.g_varchar2)

Line 6263: OR NVL(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2)

6259: OR NVL(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
6260: <> NVL(p_relocate_domestically,hr_api.g_varchar2)
6261: OR NVL(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
6262: <> NVL(p_relocate_internationally,hr_api.g_varchar2)
6263: OR NVL(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2)
6264: <> NVL(p_travel_required,hr_api.g_varchar2)
6265: OR NVL(per_dpf_shd.g_old_rec.country1,hr_api.g_varchar2)
6266: <> NVL(p_country1,hr_api.g_varchar2)
6267: OR NVL(per_dpf_shd.g_old_rec.country2,hr_api.g_varchar2)

Line 6265: OR NVL(per_dpf_shd.g_old_rec.country1,hr_api.g_varchar2)

6261: OR NVL(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
6262: <> NVL(p_relocate_internationally,hr_api.g_varchar2)
6263: OR NVL(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2)
6264: <> NVL(p_travel_required,hr_api.g_varchar2)
6265: OR NVL(per_dpf_shd.g_old_rec.country1,hr_api.g_varchar2)
6266: <> NVL(p_country1,hr_api.g_varchar2)
6267: OR NVL(per_dpf_shd.g_old_rec.country2,hr_api.g_varchar2)
6268: <> NVL(p_country2,hr_api.g_varchar2)
6269: OR NVL(per_dpf_shd.g_old_rec.country3,hr_api.g_varchar2)

Line 6267: OR NVL(per_dpf_shd.g_old_rec.country2,hr_api.g_varchar2)

6263: OR NVL(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2)
6264: <> NVL(p_travel_required,hr_api.g_varchar2)
6265: OR NVL(per_dpf_shd.g_old_rec.country1,hr_api.g_varchar2)
6266: <> NVL(p_country1,hr_api.g_varchar2)
6267: OR NVL(per_dpf_shd.g_old_rec.country2,hr_api.g_varchar2)
6268: <> NVL(p_country2,hr_api.g_varchar2)
6269: OR NVL(per_dpf_shd.g_old_rec.country3,hr_api.g_varchar2)
6270: <> NVL(p_country3,hr_api.g_varchar2)
6271: OR NVL(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)

Line 6269: OR NVL(per_dpf_shd.g_old_rec.country3,hr_api.g_varchar2)

6265: OR NVL(per_dpf_shd.g_old_rec.country1,hr_api.g_varchar2)
6266: <> NVL(p_country1,hr_api.g_varchar2)
6267: OR NVL(per_dpf_shd.g_old_rec.country2,hr_api.g_varchar2)
6268: <> NVL(p_country2,hr_api.g_varchar2)
6269: OR NVL(per_dpf_shd.g_old_rec.country3,hr_api.g_varchar2)
6270: <> NVL(p_country3,hr_api.g_varchar2)
6271: OR NVL(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)
6272: <> NVL(p_dpf_work_duration,hr_api.g_varchar2)
6273: OR NVL(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)

Line 6271: OR NVL(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)

6267: OR NVL(per_dpf_shd.g_old_rec.country2,hr_api.g_varchar2)
6268: <> NVL(p_country2,hr_api.g_varchar2)
6269: OR NVL(per_dpf_shd.g_old_rec.country3,hr_api.g_varchar2)
6270: <> NVL(p_country3,hr_api.g_varchar2)
6271: OR NVL(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)
6272: <> NVL(p_dpf_work_duration,hr_api.g_varchar2)
6273: OR NVL(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
6274: <> NVL(p_dpf_work_schedule,hr_api.g_varchar2)
6275: OR NVL(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)

Line 6273: OR NVL(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)

6269: OR NVL(per_dpf_shd.g_old_rec.country3,hr_api.g_varchar2)
6270: <> NVL(p_country3,hr_api.g_varchar2)
6271: OR NVL(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)
6272: <> NVL(p_dpf_work_duration,hr_api.g_varchar2)
6273: OR NVL(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
6274: <> NVL(p_dpf_work_schedule,hr_api.g_varchar2)
6275: OR NVL(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)
6276: <> NVL(p_dpf_work_hours,hr_api.g_varchar2)
6277: OR NVL(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2)

Line 6275: OR NVL(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)

6271: OR NVL(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)
6272: <> NVL(p_dpf_work_duration,hr_api.g_varchar2)
6273: OR NVL(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
6274: <> NVL(p_dpf_work_schedule,hr_api.g_varchar2)
6275: OR NVL(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)
6276: <> NVL(p_dpf_work_hours,hr_api.g_varchar2)
6277: OR NVL(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2)
6278: <> NVL(p_dpf_fte_capacity,hr_api.g_varchar2)
6279: OR NVL(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)

Line 6277: OR NVL(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2)

6273: OR NVL(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
6274: <> NVL(p_dpf_work_schedule,hr_api.g_varchar2)
6275: OR NVL(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)
6276: <> NVL(p_dpf_work_hours,hr_api.g_varchar2)
6277: OR NVL(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2)
6278: <> NVL(p_dpf_fte_capacity,hr_api.g_varchar2)
6279: OR NVL(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)
6280: <> NVL(p_visit_internationally,hr_api.g_varchar2)
6281: OR NVL(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)

Line 6279: OR NVL(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)

6275: OR NVL(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)
6276: <> NVL(p_dpf_work_hours,hr_api.g_varchar2)
6277: OR NVL(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2)
6278: <> NVL(p_dpf_fte_capacity,hr_api.g_varchar2)
6279: OR NVL(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)
6280: <> NVL(p_visit_internationally,hr_api.g_varchar2)
6281: OR NVL(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
6282: <> NVL(p_only_current_location,hr_api.g_varchar2)
6283: OR NVL(per_dpf_shd.g_old_rec.no_country1,hr_api.g_varchar2)

Line 6281: OR NVL(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)

6277: OR NVL(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2)
6278: <> NVL(p_dpf_fte_capacity,hr_api.g_varchar2)
6279: OR NVL(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)
6280: <> NVL(p_visit_internationally,hr_api.g_varchar2)
6281: OR NVL(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
6282: <> NVL(p_only_current_location,hr_api.g_varchar2)
6283: OR NVL(per_dpf_shd.g_old_rec.no_country1,hr_api.g_varchar2)
6284: <> NVL(p_no_country1,hr_api.g_varchar2)
6285: OR NVL(per_dpf_shd.g_old_rec.no_country2,hr_api.g_varchar2)

Line 6283: OR NVL(per_dpf_shd.g_old_rec.no_country1,hr_api.g_varchar2)

6279: OR NVL(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)
6280: <> NVL(p_visit_internationally,hr_api.g_varchar2)
6281: OR NVL(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
6282: <> NVL(p_only_current_location,hr_api.g_varchar2)
6283: OR NVL(per_dpf_shd.g_old_rec.no_country1,hr_api.g_varchar2)
6284: <> NVL(p_no_country1,hr_api.g_varchar2)
6285: OR NVL(per_dpf_shd.g_old_rec.no_country2,hr_api.g_varchar2)
6286: <> NVL(p_no_country2,hr_api.g_varchar2)
6287: OR NVL(per_dpf_shd.g_old_rec.no_country3,hr_api.g_varchar2)

Line 6285: OR NVL(per_dpf_shd.g_old_rec.no_country2,hr_api.g_varchar2)

6281: OR NVL(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
6282: <> NVL(p_only_current_location,hr_api.g_varchar2)
6283: OR NVL(per_dpf_shd.g_old_rec.no_country1,hr_api.g_varchar2)
6284: <> NVL(p_no_country1,hr_api.g_varchar2)
6285: OR NVL(per_dpf_shd.g_old_rec.no_country2,hr_api.g_varchar2)
6286: <> NVL(p_no_country2,hr_api.g_varchar2)
6287: OR NVL(per_dpf_shd.g_old_rec.no_country3,hr_api.g_varchar2)
6288: <> NVL(p_no_country3,hr_api.g_varchar2)
6289: OR NVL(per_dpf_shd.g_old_rec.earliest_available_date,hr_api.g_date)

Line 6287: OR NVL(per_dpf_shd.g_old_rec.no_country3,hr_api.g_varchar2)

6283: OR NVL(per_dpf_shd.g_old_rec.no_country1,hr_api.g_varchar2)
6284: <> NVL(p_no_country1,hr_api.g_varchar2)
6285: OR NVL(per_dpf_shd.g_old_rec.no_country2,hr_api.g_varchar2)
6286: <> NVL(p_no_country2,hr_api.g_varchar2)
6287: OR NVL(per_dpf_shd.g_old_rec.no_country3,hr_api.g_varchar2)
6288: <> NVL(p_no_country3,hr_api.g_varchar2)
6289: OR NVL(per_dpf_shd.g_old_rec.earliest_available_date,hr_api.g_date)
6290: <> NVL(p_earliest_available_date,hr_api.g_date)
6291: OR NVL(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)

Line 6289: OR NVL(per_dpf_shd.g_old_rec.earliest_available_date,hr_api.g_date)

6285: OR NVL(per_dpf_shd.g_old_rec.no_country2,hr_api.g_varchar2)
6286: <> NVL(p_no_country2,hr_api.g_varchar2)
6287: OR NVL(per_dpf_shd.g_old_rec.no_country3,hr_api.g_varchar2)
6288: <> NVL(p_no_country3,hr_api.g_varchar2)
6289: OR NVL(per_dpf_shd.g_old_rec.earliest_available_date,hr_api.g_date)
6290: <> NVL(p_earliest_available_date,hr_api.g_date)
6291: OR NVL(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
6292: <> NVL(p_available_for_transfer,hr_api.g_varchar2)
6293: OR NVL(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2)

Line 6291: OR NVL(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)

6287: OR NVL(per_dpf_shd.g_old_rec.no_country3,hr_api.g_varchar2)
6288: <> NVL(p_no_country3,hr_api.g_varchar2)
6289: OR NVL(per_dpf_shd.g_old_rec.earliest_available_date,hr_api.g_date)
6290: <> NVL(p_earliest_available_date,hr_api.g_date)
6291: OR NVL(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
6292: <> NVL(p_available_for_transfer,hr_api.g_varchar2)
6293: OR NVL(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2)
6294: <> NVL(p_relocation_preference,hr_api.g_varchar2)
6295: OR NVL(per_dpf_shd.g_old_rec.attribute_category,hr_api.g_varchar2)

Line 6293: OR NVL(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2)

6289: OR NVL(per_dpf_shd.g_old_rec.earliest_available_date,hr_api.g_date)
6290: <> NVL(p_earliest_available_date,hr_api.g_date)
6291: OR NVL(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
6292: <> NVL(p_available_for_transfer,hr_api.g_varchar2)
6293: OR NVL(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2)
6294: <> NVL(p_relocation_preference,hr_api.g_varchar2)
6295: OR NVL(per_dpf_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
6296: <> NVL(p_dpf_attribute_category,hr_api.g_varchar2)
6297: OR NVL(per_dpf_shd.g_old_rec.attribute1,hr_api.g_varchar2)

Line 6295: OR NVL(per_dpf_shd.g_old_rec.attribute_category,hr_api.g_varchar2)

6291: OR NVL(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
6292: <> NVL(p_available_for_transfer,hr_api.g_varchar2)
6293: OR NVL(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2)
6294: <> NVL(p_relocation_preference,hr_api.g_varchar2)
6295: OR NVL(per_dpf_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
6296: <> NVL(p_dpf_attribute_category,hr_api.g_varchar2)
6297: OR NVL(per_dpf_shd.g_old_rec.attribute1,hr_api.g_varchar2)
6298: <> NVL(p_dpf_attribute1,hr_api.g_varchar2)
6299: OR NVL(per_dpf_shd.g_old_rec.attribute2,hr_api.g_varchar2)

Line 6297: OR NVL(per_dpf_shd.g_old_rec.attribute1,hr_api.g_varchar2)

6293: OR NVL(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2)
6294: <> NVL(p_relocation_preference,hr_api.g_varchar2)
6295: OR NVL(per_dpf_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
6296: <> NVL(p_dpf_attribute_category,hr_api.g_varchar2)
6297: OR NVL(per_dpf_shd.g_old_rec.attribute1,hr_api.g_varchar2)
6298: <> NVL(p_dpf_attribute1,hr_api.g_varchar2)
6299: OR NVL(per_dpf_shd.g_old_rec.attribute2,hr_api.g_varchar2)
6300: <> NVL(p_dpf_attribute2,hr_api.g_varchar2)
6301: OR NVL(per_dpf_shd.g_old_rec.attribute3,hr_api.g_varchar2)

Line 6299: OR NVL(per_dpf_shd.g_old_rec.attribute2,hr_api.g_varchar2)

6295: OR NVL(per_dpf_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
6296: <> NVL(p_dpf_attribute_category,hr_api.g_varchar2)
6297: OR NVL(per_dpf_shd.g_old_rec.attribute1,hr_api.g_varchar2)
6298: <> NVL(p_dpf_attribute1,hr_api.g_varchar2)
6299: OR NVL(per_dpf_shd.g_old_rec.attribute2,hr_api.g_varchar2)
6300: <> NVL(p_dpf_attribute2,hr_api.g_varchar2)
6301: OR NVL(per_dpf_shd.g_old_rec.attribute3,hr_api.g_varchar2)
6302: <> NVL(p_dpf_attribute3,hr_api.g_varchar2)
6303: OR NVL(per_dpf_shd.g_old_rec.attribute4,hr_api.g_varchar2)

Line 6301: OR NVL(per_dpf_shd.g_old_rec.attribute3,hr_api.g_varchar2)

6297: OR NVL(per_dpf_shd.g_old_rec.attribute1,hr_api.g_varchar2)
6298: <> NVL(p_dpf_attribute1,hr_api.g_varchar2)
6299: OR NVL(per_dpf_shd.g_old_rec.attribute2,hr_api.g_varchar2)
6300: <> NVL(p_dpf_attribute2,hr_api.g_varchar2)
6301: OR NVL(per_dpf_shd.g_old_rec.attribute3,hr_api.g_varchar2)
6302: <> NVL(p_dpf_attribute3,hr_api.g_varchar2)
6303: OR NVL(per_dpf_shd.g_old_rec.attribute4,hr_api.g_varchar2)
6304: <> NVL(p_dpf_attribute4,hr_api.g_varchar2)
6305: OR NVL(per_dpf_shd.g_old_rec.attribute5,hr_api.g_varchar2)

Line 6303: OR NVL(per_dpf_shd.g_old_rec.attribute4,hr_api.g_varchar2)

6299: OR NVL(per_dpf_shd.g_old_rec.attribute2,hr_api.g_varchar2)
6300: <> NVL(p_dpf_attribute2,hr_api.g_varchar2)
6301: OR NVL(per_dpf_shd.g_old_rec.attribute3,hr_api.g_varchar2)
6302: <> NVL(p_dpf_attribute3,hr_api.g_varchar2)
6303: OR NVL(per_dpf_shd.g_old_rec.attribute4,hr_api.g_varchar2)
6304: <> NVL(p_dpf_attribute4,hr_api.g_varchar2)
6305: OR NVL(per_dpf_shd.g_old_rec.attribute5,hr_api.g_varchar2)
6306: <> NVL(p_dpf_attribute5,hr_api.g_varchar2)
6307: OR NVL(per_dpf_shd.g_old_rec.attribute6,hr_api.g_varchar2)

Line 6305: OR NVL(per_dpf_shd.g_old_rec.attribute5,hr_api.g_varchar2)

6301: OR NVL(per_dpf_shd.g_old_rec.attribute3,hr_api.g_varchar2)
6302: <> NVL(p_dpf_attribute3,hr_api.g_varchar2)
6303: OR NVL(per_dpf_shd.g_old_rec.attribute4,hr_api.g_varchar2)
6304: <> NVL(p_dpf_attribute4,hr_api.g_varchar2)
6305: OR NVL(per_dpf_shd.g_old_rec.attribute5,hr_api.g_varchar2)
6306: <> NVL(p_dpf_attribute5,hr_api.g_varchar2)
6307: OR NVL(per_dpf_shd.g_old_rec.attribute6,hr_api.g_varchar2)
6308: <> NVL(p_dpf_attribute6,hr_api.g_varchar2)
6309: OR NVL(per_dpf_shd.g_old_rec.attribute7,hr_api.g_varchar2)

Line 6307: OR NVL(per_dpf_shd.g_old_rec.attribute6,hr_api.g_varchar2)

6303: OR NVL(per_dpf_shd.g_old_rec.attribute4,hr_api.g_varchar2)
6304: <> NVL(p_dpf_attribute4,hr_api.g_varchar2)
6305: OR NVL(per_dpf_shd.g_old_rec.attribute5,hr_api.g_varchar2)
6306: <> NVL(p_dpf_attribute5,hr_api.g_varchar2)
6307: OR NVL(per_dpf_shd.g_old_rec.attribute6,hr_api.g_varchar2)
6308: <> NVL(p_dpf_attribute6,hr_api.g_varchar2)
6309: OR NVL(per_dpf_shd.g_old_rec.attribute7,hr_api.g_varchar2)
6310: <> NVL(p_dpf_attribute7,hr_api.g_varchar2)
6311: OR NVL(per_dpf_shd.g_old_rec.attribute8,hr_api.g_varchar2)

Line 6309: OR NVL(per_dpf_shd.g_old_rec.attribute7,hr_api.g_varchar2)

6305: OR NVL(per_dpf_shd.g_old_rec.attribute5,hr_api.g_varchar2)
6306: <> NVL(p_dpf_attribute5,hr_api.g_varchar2)
6307: OR NVL(per_dpf_shd.g_old_rec.attribute6,hr_api.g_varchar2)
6308: <> NVL(p_dpf_attribute6,hr_api.g_varchar2)
6309: OR NVL(per_dpf_shd.g_old_rec.attribute7,hr_api.g_varchar2)
6310: <> NVL(p_dpf_attribute7,hr_api.g_varchar2)
6311: OR NVL(per_dpf_shd.g_old_rec.attribute8,hr_api.g_varchar2)
6312: <> NVL(p_dpf_attribute8,hr_api.g_varchar2)
6313: OR NVL(per_dpf_shd.g_old_rec.attribute9,hr_api.g_varchar2)

Line 6311: OR NVL(per_dpf_shd.g_old_rec.attribute8,hr_api.g_varchar2)

6307: OR NVL(per_dpf_shd.g_old_rec.attribute6,hr_api.g_varchar2)
6308: <> NVL(p_dpf_attribute6,hr_api.g_varchar2)
6309: OR NVL(per_dpf_shd.g_old_rec.attribute7,hr_api.g_varchar2)
6310: <> NVL(p_dpf_attribute7,hr_api.g_varchar2)
6311: OR NVL(per_dpf_shd.g_old_rec.attribute8,hr_api.g_varchar2)
6312: <> NVL(p_dpf_attribute8,hr_api.g_varchar2)
6313: OR NVL(per_dpf_shd.g_old_rec.attribute9,hr_api.g_varchar2)
6314: <> NVL(p_dpf_attribute9,hr_api.g_varchar2)
6315: OR NVL(per_dpf_shd.g_old_rec.attribute10,hr_api.g_varchar2)

Line 6313: OR NVL(per_dpf_shd.g_old_rec.attribute9,hr_api.g_varchar2)

6309: OR NVL(per_dpf_shd.g_old_rec.attribute7,hr_api.g_varchar2)
6310: <> NVL(p_dpf_attribute7,hr_api.g_varchar2)
6311: OR NVL(per_dpf_shd.g_old_rec.attribute8,hr_api.g_varchar2)
6312: <> NVL(p_dpf_attribute8,hr_api.g_varchar2)
6313: OR NVL(per_dpf_shd.g_old_rec.attribute9,hr_api.g_varchar2)
6314: <> NVL(p_dpf_attribute9,hr_api.g_varchar2)
6315: OR NVL(per_dpf_shd.g_old_rec.attribute10,hr_api.g_varchar2)
6316: <> NVL(p_dpf_attribute10,hr_api.g_varchar2)
6317: OR NVL(per_dpf_shd.g_old_rec.attribute11,hr_api.g_varchar2)

Line 6315: OR NVL(per_dpf_shd.g_old_rec.attribute10,hr_api.g_varchar2)

6311: OR NVL(per_dpf_shd.g_old_rec.attribute8,hr_api.g_varchar2)
6312: <> NVL(p_dpf_attribute8,hr_api.g_varchar2)
6313: OR NVL(per_dpf_shd.g_old_rec.attribute9,hr_api.g_varchar2)
6314: <> NVL(p_dpf_attribute9,hr_api.g_varchar2)
6315: OR NVL(per_dpf_shd.g_old_rec.attribute10,hr_api.g_varchar2)
6316: <> NVL(p_dpf_attribute10,hr_api.g_varchar2)
6317: OR NVL(per_dpf_shd.g_old_rec.attribute11,hr_api.g_varchar2)
6318: <> NVL(p_dpf_attribute11,hr_api.g_varchar2)
6319: OR NVL(per_dpf_shd.g_old_rec.attribute12,hr_api.g_varchar2)

Line 6317: OR NVL(per_dpf_shd.g_old_rec.attribute11,hr_api.g_varchar2)

6313: OR NVL(per_dpf_shd.g_old_rec.attribute9,hr_api.g_varchar2)
6314: <> NVL(p_dpf_attribute9,hr_api.g_varchar2)
6315: OR NVL(per_dpf_shd.g_old_rec.attribute10,hr_api.g_varchar2)
6316: <> NVL(p_dpf_attribute10,hr_api.g_varchar2)
6317: OR NVL(per_dpf_shd.g_old_rec.attribute11,hr_api.g_varchar2)
6318: <> NVL(p_dpf_attribute11,hr_api.g_varchar2)
6319: OR NVL(per_dpf_shd.g_old_rec.attribute12,hr_api.g_varchar2)
6320: <> NVL(p_dpf_attribute12,hr_api.g_varchar2)
6321: OR NVL(per_dpf_shd.g_old_rec.attribute13,hr_api.g_varchar2)

Line 6319: OR NVL(per_dpf_shd.g_old_rec.attribute12,hr_api.g_varchar2)

6315: OR NVL(per_dpf_shd.g_old_rec.attribute10,hr_api.g_varchar2)
6316: <> NVL(p_dpf_attribute10,hr_api.g_varchar2)
6317: OR NVL(per_dpf_shd.g_old_rec.attribute11,hr_api.g_varchar2)
6318: <> NVL(p_dpf_attribute11,hr_api.g_varchar2)
6319: OR NVL(per_dpf_shd.g_old_rec.attribute12,hr_api.g_varchar2)
6320: <> NVL(p_dpf_attribute12,hr_api.g_varchar2)
6321: OR NVL(per_dpf_shd.g_old_rec.attribute13,hr_api.g_varchar2)
6322: <> NVL(p_dpf_attribute13,hr_api.g_varchar2)
6323: OR NVL(per_dpf_shd.g_old_rec.attribute14,hr_api.g_varchar2)

Line 6321: OR NVL(per_dpf_shd.g_old_rec.attribute13,hr_api.g_varchar2)

6317: OR NVL(per_dpf_shd.g_old_rec.attribute11,hr_api.g_varchar2)
6318: <> NVL(p_dpf_attribute11,hr_api.g_varchar2)
6319: OR NVL(per_dpf_shd.g_old_rec.attribute12,hr_api.g_varchar2)
6320: <> NVL(p_dpf_attribute12,hr_api.g_varchar2)
6321: OR NVL(per_dpf_shd.g_old_rec.attribute13,hr_api.g_varchar2)
6322: <> NVL(p_dpf_attribute13,hr_api.g_varchar2)
6323: OR NVL(per_dpf_shd.g_old_rec.attribute14,hr_api.g_varchar2)
6324: <> NVL(p_dpf_attribute14,hr_api.g_varchar2)
6325: OR NVL(per_dpf_shd.g_old_rec.attribute15,hr_api.g_varchar2)

Line 6323: OR NVL(per_dpf_shd.g_old_rec.attribute14,hr_api.g_varchar2)

6319: OR NVL(per_dpf_shd.g_old_rec.attribute12,hr_api.g_varchar2)
6320: <> NVL(p_dpf_attribute12,hr_api.g_varchar2)
6321: OR NVL(per_dpf_shd.g_old_rec.attribute13,hr_api.g_varchar2)
6322: <> NVL(p_dpf_attribute13,hr_api.g_varchar2)
6323: OR NVL(per_dpf_shd.g_old_rec.attribute14,hr_api.g_varchar2)
6324: <> NVL(p_dpf_attribute14,hr_api.g_varchar2)
6325: OR NVL(per_dpf_shd.g_old_rec.attribute15,hr_api.g_varchar2)
6326: <> NVL(p_dpf_attribute15,hr_api.g_varchar2)
6327: OR NVL(per_dpf_shd.g_old_rec.attribute16,hr_api.g_varchar2)

Line 6325: OR NVL(per_dpf_shd.g_old_rec.attribute15,hr_api.g_varchar2)

6321: OR NVL(per_dpf_shd.g_old_rec.attribute13,hr_api.g_varchar2)
6322: <> NVL(p_dpf_attribute13,hr_api.g_varchar2)
6323: OR NVL(per_dpf_shd.g_old_rec.attribute14,hr_api.g_varchar2)
6324: <> NVL(p_dpf_attribute14,hr_api.g_varchar2)
6325: OR NVL(per_dpf_shd.g_old_rec.attribute15,hr_api.g_varchar2)
6326: <> NVL(p_dpf_attribute15,hr_api.g_varchar2)
6327: OR NVL(per_dpf_shd.g_old_rec.attribute16,hr_api.g_varchar2)
6328: <> NVL(p_dpf_attribute16,hr_api.g_varchar2)
6329: OR NVL(per_dpf_shd.g_old_rec.attribute17,hr_api.g_varchar2)

Line 6327: OR NVL(per_dpf_shd.g_old_rec.attribute16,hr_api.g_varchar2)

6323: OR NVL(per_dpf_shd.g_old_rec.attribute14,hr_api.g_varchar2)
6324: <> NVL(p_dpf_attribute14,hr_api.g_varchar2)
6325: OR NVL(per_dpf_shd.g_old_rec.attribute15,hr_api.g_varchar2)
6326: <> NVL(p_dpf_attribute15,hr_api.g_varchar2)
6327: OR NVL(per_dpf_shd.g_old_rec.attribute16,hr_api.g_varchar2)
6328: <> NVL(p_dpf_attribute16,hr_api.g_varchar2)
6329: OR NVL(per_dpf_shd.g_old_rec.attribute17,hr_api.g_varchar2)
6330: <> NVL(p_dpf_attribute17,hr_api.g_varchar2)
6331: OR NVL(per_dpf_shd.g_old_rec.attribute18,hr_api.g_varchar2)

Line 6329: OR NVL(per_dpf_shd.g_old_rec.attribute17,hr_api.g_varchar2)

6325: OR NVL(per_dpf_shd.g_old_rec.attribute15,hr_api.g_varchar2)
6326: <> NVL(p_dpf_attribute15,hr_api.g_varchar2)
6327: OR NVL(per_dpf_shd.g_old_rec.attribute16,hr_api.g_varchar2)
6328: <> NVL(p_dpf_attribute16,hr_api.g_varchar2)
6329: OR NVL(per_dpf_shd.g_old_rec.attribute17,hr_api.g_varchar2)
6330: <> NVL(p_dpf_attribute17,hr_api.g_varchar2)
6331: OR NVL(per_dpf_shd.g_old_rec.attribute18,hr_api.g_varchar2)
6332: <> NVL(p_dpf_attribute18,hr_api.g_varchar2)
6333: OR NVL(per_dpf_shd.g_old_rec.attribute19,hr_api.g_varchar2)

Line 6331: OR NVL(per_dpf_shd.g_old_rec.attribute18,hr_api.g_varchar2)

6327: OR NVL(per_dpf_shd.g_old_rec.attribute16,hr_api.g_varchar2)
6328: <> NVL(p_dpf_attribute16,hr_api.g_varchar2)
6329: OR NVL(per_dpf_shd.g_old_rec.attribute17,hr_api.g_varchar2)
6330: <> NVL(p_dpf_attribute17,hr_api.g_varchar2)
6331: OR NVL(per_dpf_shd.g_old_rec.attribute18,hr_api.g_varchar2)
6332: <> NVL(p_dpf_attribute18,hr_api.g_varchar2)
6333: OR NVL(per_dpf_shd.g_old_rec.attribute19,hr_api.g_varchar2)
6334: <> NVL(p_dpf_attribute19,hr_api.g_varchar2)
6335: OR NVL(per_dpf_shd.g_old_rec.attribute20,hr_api.g_varchar2)

Line 6333: OR NVL(per_dpf_shd.g_old_rec.attribute19,hr_api.g_varchar2)

6329: OR NVL(per_dpf_shd.g_old_rec.attribute17,hr_api.g_varchar2)
6330: <> NVL(p_dpf_attribute17,hr_api.g_varchar2)
6331: OR NVL(per_dpf_shd.g_old_rec.attribute18,hr_api.g_varchar2)
6332: <> NVL(p_dpf_attribute18,hr_api.g_varchar2)
6333: OR NVL(per_dpf_shd.g_old_rec.attribute19,hr_api.g_varchar2)
6334: <> NVL(p_dpf_attribute19,hr_api.g_varchar2)
6335: OR NVL(per_dpf_shd.g_old_rec.attribute20,hr_api.g_varchar2)
6336: <> NVL(p_dpf_attribute20,hr_api.g_varchar2) THEN
6337: --

Line 6335: OR NVL(per_dpf_shd.g_old_rec.attribute20,hr_api.g_varchar2)

6331: OR NVL(per_dpf_shd.g_old_rec.attribute18,hr_api.g_varchar2)
6332: <> NVL(p_dpf_attribute18,hr_api.g_varchar2)
6333: OR NVL(per_dpf_shd.g_old_rec.attribute19,hr_api.g_varchar2)
6334: <> NVL(p_dpf_attribute19,hr_api.g_varchar2)
6335: OR NVL(per_dpf_shd.g_old_rec.attribute20,hr_api.g_varchar2)
6336: <> NVL(p_dpf_attribute20,hr_api.g_varchar2) THEN
6337: --
6338: hr_deployment_factor_api.update_person_dpmt_factor
6339: (p_effective_date => p_effective_date

Line 7235: per_dpf_shd.lck

7231: --
7232: IF p_deployment_factor_id IS NOT NULL THEN
7233: hr_utility.set_location(l_proc, 110);
7234: --
7235: per_dpf_shd.lck
7236: (p_deployment_factor_id => p_deployment_factor_id
7237: ,p_object_version_number => p_dpf_object_version_number);
7238: END IF;
7239: --