DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_DPF_SHD

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

6291: );
6292: END IF;
6293: ELSE
6294: --
6295: IF NVL(per_dpf_shd.g_old_rec.work_any_country,hr_api.g_varchar2)
6296: <> NVL(p_work_any_country,hr_api.g_varchar2)
6297: OR NVL(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
6298: <> NVL(p_work_any_location,hr_api.g_varchar2)
6299: OR NVL(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)

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

6293: ELSE
6294: --
6295: IF NVL(per_dpf_shd.g_old_rec.work_any_country,hr_api.g_varchar2)
6296: <> NVL(p_work_any_country,hr_api.g_varchar2)
6297: OR NVL(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
6298: <> NVL(p_work_any_location,hr_api.g_varchar2)
6299: OR NVL(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
6300: <> NVL(p_relocate_domestically,hr_api.g_varchar2)
6301: OR NVL(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)

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

6295: IF NVL(per_dpf_shd.g_old_rec.work_any_country,hr_api.g_varchar2)
6296: <> NVL(p_work_any_country,hr_api.g_varchar2)
6297: OR NVL(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
6298: <> NVL(p_work_any_location,hr_api.g_varchar2)
6299: OR NVL(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
6300: <> NVL(p_relocate_domestically,hr_api.g_varchar2)
6301: OR NVL(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
6302: <> NVL(p_relocate_internationally,hr_api.g_varchar2)
6303: OR NVL(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2)

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

6297: OR NVL(per_dpf_shd.g_old_rec.work_any_location,hr_api.g_varchar2)
6298: <> NVL(p_work_any_location,hr_api.g_varchar2)
6299: OR NVL(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
6300: <> NVL(p_relocate_domestically,hr_api.g_varchar2)
6301: OR NVL(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
6302: <> NVL(p_relocate_internationally,hr_api.g_varchar2)
6303: OR NVL(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2)
6304: <> NVL(p_travel_required,hr_api.g_varchar2)
6305: OR NVL(per_dpf_shd.g_old_rec.country1,hr_api.g_varchar2)

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

6299: OR NVL(per_dpf_shd.g_old_rec.relocate_domestically,hr_api.g_varchar2)
6300: <> NVL(p_relocate_domestically,hr_api.g_varchar2)
6301: OR NVL(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
6302: <> NVL(p_relocate_internationally,hr_api.g_varchar2)
6303: OR NVL(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2)
6304: <> NVL(p_travel_required,hr_api.g_varchar2)
6305: OR NVL(per_dpf_shd.g_old_rec.country1,hr_api.g_varchar2)
6306: <> NVL(p_country1,hr_api.g_varchar2)
6307: OR NVL(per_dpf_shd.g_old_rec.country2,hr_api.g_varchar2)

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

6301: OR NVL(per_dpf_shd.g_old_rec.relocate_internationally,hr_api.g_varchar2)
6302: <> NVL(p_relocate_internationally,hr_api.g_varchar2)
6303: OR NVL(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2)
6304: <> NVL(p_travel_required,hr_api.g_varchar2)
6305: OR NVL(per_dpf_shd.g_old_rec.country1,hr_api.g_varchar2)
6306: <> NVL(p_country1,hr_api.g_varchar2)
6307: OR NVL(per_dpf_shd.g_old_rec.country2,hr_api.g_varchar2)
6308: <> NVL(p_country2,hr_api.g_varchar2)
6309: OR NVL(per_dpf_shd.g_old_rec.country3,hr_api.g_varchar2)

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

6303: OR NVL(per_dpf_shd.g_old_rec.travel_required,hr_api.g_varchar2)
6304: <> NVL(p_travel_required,hr_api.g_varchar2)
6305: OR NVL(per_dpf_shd.g_old_rec.country1,hr_api.g_varchar2)
6306: <> NVL(p_country1,hr_api.g_varchar2)
6307: OR NVL(per_dpf_shd.g_old_rec.country2,hr_api.g_varchar2)
6308: <> NVL(p_country2,hr_api.g_varchar2)
6309: OR NVL(per_dpf_shd.g_old_rec.country3,hr_api.g_varchar2)
6310: <> NVL(p_country3,hr_api.g_varchar2)
6311: OR NVL(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)

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

6305: OR NVL(per_dpf_shd.g_old_rec.country1,hr_api.g_varchar2)
6306: <> NVL(p_country1,hr_api.g_varchar2)
6307: OR NVL(per_dpf_shd.g_old_rec.country2,hr_api.g_varchar2)
6308: <> NVL(p_country2,hr_api.g_varchar2)
6309: OR NVL(per_dpf_shd.g_old_rec.country3,hr_api.g_varchar2)
6310: <> NVL(p_country3,hr_api.g_varchar2)
6311: OR NVL(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)
6312: <> NVL(p_dpf_work_duration,hr_api.g_varchar2)
6313: OR NVL(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)

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

6307: OR NVL(per_dpf_shd.g_old_rec.country2,hr_api.g_varchar2)
6308: <> NVL(p_country2,hr_api.g_varchar2)
6309: OR NVL(per_dpf_shd.g_old_rec.country3,hr_api.g_varchar2)
6310: <> NVL(p_country3,hr_api.g_varchar2)
6311: OR NVL(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)
6312: <> NVL(p_dpf_work_duration,hr_api.g_varchar2)
6313: OR NVL(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
6314: <> NVL(p_dpf_work_schedule,hr_api.g_varchar2)
6315: OR NVL(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)

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

6309: OR NVL(per_dpf_shd.g_old_rec.country3,hr_api.g_varchar2)
6310: <> NVL(p_country3,hr_api.g_varchar2)
6311: OR NVL(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)
6312: <> NVL(p_dpf_work_duration,hr_api.g_varchar2)
6313: OR NVL(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
6314: <> NVL(p_dpf_work_schedule,hr_api.g_varchar2)
6315: OR NVL(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)
6316: <> NVL(p_dpf_work_hours,hr_api.g_varchar2)
6317: OR NVL(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2)

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

6311: OR NVL(per_dpf_shd.g_old_rec.work_duration,hr_api.g_varchar2)
6312: <> NVL(p_dpf_work_duration,hr_api.g_varchar2)
6313: OR NVL(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
6314: <> NVL(p_dpf_work_schedule,hr_api.g_varchar2)
6315: OR NVL(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)
6316: <> NVL(p_dpf_work_hours,hr_api.g_varchar2)
6317: OR NVL(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2)
6318: <> NVL(p_dpf_fte_capacity,hr_api.g_varchar2)
6319: OR NVL(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)

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

6313: OR NVL(per_dpf_shd.g_old_rec.work_schedule,hr_api.g_varchar2)
6314: <> NVL(p_dpf_work_schedule,hr_api.g_varchar2)
6315: OR NVL(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)
6316: <> NVL(p_dpf_work_hours,hr_api.g_varchar2)
6317: OR NVL(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2)
6318: <> NVL(p_dpf_fte_capacity,hr_api.g_varchar2)
6319: OR NVL(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)
6320: <> NVL(p_visit_internationally,hr_api.g_varchar2)
6321: OR NVL(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)

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

6315: OR NVL(per_dpf_shd.g_old_rec.work_hours,hr_api.g_varchar2)
6316: <> NVL(p_dpf_work_hours,hr_api.g_varchar2)
6317: OR NVL(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2)
6318: <> NVL(p_dpf_fte_capacity,hr_api.g_varchar2)
6319: OR NVL(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)
6320: <> NVL(p_visit_internationally,hr_api.g_varchar2)
6321: OR NVL(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
6322: <> NVL(p_only_current_location,hr_api.g_varchar2)
6323: OR NVL(per_dpf_shd.g_old_rec.no_country1,hr_api.g_varchar2)

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

6317: OR NVL(per_dpf_shd.g_old_rec.fte_capacity,hr_api.g_varchar2)
6318: <> NVL(p_dpf_fte_capacity,hr_api.g_varchar2)
6319: OR NVL(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)
6320: <> NVL(p_visit_internationally,hr_api.g_varchar2)
6321: OR NVL(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
6322: <> NVL(p_only_current_location,hr_api.g_varchar2)
6323: OR NVL(per_dpf_shd.g_old_rec.no_country1,hr_api.g_varchar2)
6324: <> NVL(p_no_country1,hr_api.g_varchar2)
6325: OR NVL(per_dpf_shd.g_old_rec.no_country2,hr_api.g_varchar2)

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

6319: OR NVL(per_dpf_shd.g_old_rec.visit_internationally,hr_api.g_varchar2)
6320: <> NVL(p_visit_internationally,hr_api.g_varchar2)
6321: OR NVL(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
6322: <> NVL(p_only_current_location,hr_api.g_varchar2)
6323: OR NVL(per_dpf_shd.g_old_rec.no_country1,hr_api.g_varchar2)
6324: <> NVL(p_no_country1,hr_api.g_varchar2)
6325: OR NVL(per_dpf_shd.g_old_rec.no_country2,hr_api.g_varchar2)
6326: <> NVL(p_no_country2,hr_api.g_varchar2)
6327: OR NVL(per_dpf_shd.g_old_rec.no_country3,hr_api.g_varchar2)

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

6321: OR NVL(per_dpf_shd.g_old_rec.only_current_location,hr_api.g_varchar2)
6322: <> NVL(p_only_current_location,hr_api.g_varchar2)
6323: OR NVL(per_dpf_shd.g_old_rec.no_country1,hr_api.g_varchar2)
6324: <> NVL(p_no_country1,hr_api.g_varchar2)
6325: OR NVL(per_dpf_shd.g_old_rec.no_country2,hr_api.g_varchar2)
6326: <> NVL(p_no_country2,hr_api.g_varchar2)
6327: OR NVL(per_dpf_shd.g_old_rec.no_country3,hr_api.g_varchar2)
6328: <> NVL(p_no_country3,hr_api.g_varchar2)
6329: OR NVL(per_dpf_shd.g_old_rec.earliest_available_date,hr_api.g_date)

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

6323: OR NVL(per_dpf_shd.g_old_rec.no_country1,hr_api.g_varchar2)
6324: <> NVL(p_no_country1,hr_api.g_varchar2)
6325: OR NVL(per_dpf_shd.g_old_rec.no_country2,hr_api.g_varchar2)
6326: <> NVL(p_no_country2,hr_api.g_varchar2)
6327: OR NVL(per_dpf_shd.g_old_rec.no_country3,hr_api.g_varchar2)
6328: <> NVL(p_no_country3,hr_api.g_varchar2)
6329: OR NVL(per_dpf_shd.g_old_rec.earliest_available_date,hr_api.g_date)
6330: <> NVL(p_earliest_available_date,hr_api.g_date)
6331: OR NVL(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)

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

6325: OR NVL(per_dpf_shd.g_old_rec.no_country2,hr_api.g_varchar2)
6326: <> NVL(p_no_country2,hr_api.g_varchar2)
6327: OR NVL(per_dpf_shd.g_old_rec.no_country3,hr_api.g_varchar2)
6328: <> NVL(p_no_country3,hr_api.g_varchar2)
6329: OR NVL(per_dpf_shd.g_old_rec.earliest_available_date,hr_api.g_date)
6330: <> NVL(p_earliest_available_date,hr_api.g_date)
6331: OR NVL(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
6332: <> NVL(p_available_for_transfer,hr_api.g_varchar2)
6333: OR NVL(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2)

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

6327: OR NVL(per_dpf_shd.g_old_rec.no_country3,hr_api.g_varchar2)
6328: <> NVL(p_no_country3,hr_api.g_varchar2)
6329: OR NVL(per_dpf_shd.g_old_rec.earliest_available_date,hr_api.g_date)
6330: <> NVL(p_earliest_available_date,hr_api.g_date)
6331: OR NVL(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
6332: <> NVL(p_available_for_transfer,hr_api.g_varchar2)
6333: OR NVL(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2)
6334: <> NVL(p_relocation_preference,hr_api.g_varchar2)
6335: OR NVL(per_dpf_shd.g_old_rec.attribute_category,hr_api.g_varchar2)

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

6329: OR NVL(per_dpf_shd.g_old_rec.earliest_available_date,hr_api.g_date)
6330: <> NVL(p_earliest_available_date,hr_api.g_date)
6331: OR NVL(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
6332: <> NVL(p_available_for_transfer,hr_api.g_varchar2)
6333: OR NVL(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2)
6334: <> NVL(p_relocation_preference,hr_api.g_varchar2)
6335: OR NVL(per_dpf_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
6336: <> NVL(p_dpf_attribute_category,hr_api.g_varchar2)
6337: OR NVL(per_dpf_shd.g_old_rec.attribute1,hr_api.g_varchar2)

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

6331: OR NVL(per_dpf_shd.g_old_rec.available_for_transfer,hr_api.g_varchar2)
6332: <> NVL(p_available_for_transfer,hr_api.g_varchar2)
6333: OR NVL(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2)
6334: <> NVL(p_relocation_preference,hr_api.g_varchar2)
6335: OR NVL(per_dpf_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
6336: <> NVL(p_dpf_attribute_category,hr_api.g_varchar2)
6337: OR NVL(per_dpf_shd.g_old_rec.attribute1,hr_api.g_varchar2)
6338: <> NVL(p_dpf_attribute1,hr_api.g_varchar2)
6339: OR NVL(per_dpf_shd.g_old_rec.attribute2,hr_api.g_varchar2)

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

6333: OR NVL(per_dpf_shd.g_old_rec.relocation_preference,hr_api.g_varchar2)
6334: <> NVL(p_relocation_preference,hr_api.g_varchar2)
6335: OR NVL(per_dpf_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
6336: <> NVL(p_dpf_attribute_category,hr_api.g_varchar2)
6337: OR NVL(per_dpf_shd.g_old_rec.attribute1,hr_api.g_varchar2)
6338: <> NVL(p_dpf_attribute1,hr_api.g_varchar2)
6339: OR NVL(per_dpf_shd.g_old_rec.attribute2,hr_api.g_varchar2)
6340: <> NVL(p_dpf_attribute2,hr_api.g_varchar2)
6341: OR NVL(per_dpf_shd.g_old_rec.attribute3,hr_api.g_varchar2)

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

6335: OR NVL(per_dpf_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
6336: <> NVL(p_dpf_attribute_category,hr_api.g_varchar2)
6337: OR NVL(per_dpf_shd.g_old_rec.attribute1,hr_api.g_varchar2)
6338: <> NVL(p_dpf_attribute1,hr_api.g_varchar2)
6339: OR NVL(per_dpf_shd.g_old_rec.attribute2,hr_api.g_varchar2)
6340: <> NVL(p_dpf_attribute2,hr_api.g_varchar2)
6341: OR NVL(per_dpf_shd.g_old_rec.attribute3,hr_api.g_varchar2)
6342: <> NVL(p_dpf_attribute3,hr_api.g_varchar2)
6343: OR NVL(per_dpf_shd.g_old_rec.attribute4,hr_api.g_varchar2)

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

6337: OR NVL(per_dpf_shd.g_old_rec.attribute1,hr_api.g_varchar2)
6338: <> NVL(p_dpf_attribute1,hr_api.g_varchar2)
6339: OR NVL(per_dpf_shd.g_old_rec.attribute2,hr_api.g_varchar2)
6340: <> NVL(p_dpf_attribute2,hr_api.g_varchar2)
6341: OR NVL(per_dpf_shd.g_old_rec.attribute3,hr_api.g_varchar2)
6342: <> NVL(p_dpf_attribute3,hr_api.g_varchar2)
6343: OR NVL(per_dpf_shd.g_old_rec.attribute4,hr_api.g_varchar2)
6344: <> NVL(p_dpf_attribute4,hr_api.g_varchar2)
6345: OR NVL(per_dpf_shd.g_old_rec.attribute5,hr_api.g_varchar2)

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

6339: OR NVL(per_dpf_shd.g_old_rec.attribute2,hr_api.g_varchar2)
6340: <> NVL(p_dpf_attribute2,hr_api.g_varchar2)
6341: OR NVL(per_dpf_shd.g_old_rec.attribute3,hr_api.g_varchar2)
6342: <> NVL(p_dpf_attribute3,hr_api.g_varchar2)
6343: OR NVL(per_dpf_shd.g_old_rec.attribute4,hr_api.g_varchar2)
6344: <> NVL(p_dpf_attribute4,hr_api.g_varchar2)
6345: OR NVL(per_dpf_shd.g_old_rec.attribute5,hr_api.g_varchar2)
6346: <> NVL(p_dpf_attribute5,hr_api.g_varchar2)
6347: OR NVL(per_dpf_shd.g_old_rec.attribute6,hr_api.g_varchar2)

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

6341: OR NVL(per_dpf_shd.g_old_rec.attribute3,hr_api.g_varchar2)
6342: <> NVL(p_dpf_attribute3,hr_api.g_varchar2)
6343: OR NVL(per_dpf_shd.g_old_rec.attribute4,hr_api.g_varchar2)
6344: <> NVL(p_dpf_attribute4,hr_api.g_varchar2)
6345: OR NVL(per_dpf_shd.g_old_rec.attribute5,hr_api.g_varchar2)
6346: <> NVL(p_dpf_attribute5,hr_api.g_varchar2)
6347: OR NVL(per_dpf_shd.g_old_rec.attribute6,hr_api.g_varchar2)
6348: <> NVL(p_dpf_attribute6,hr_api.g_varchar2)
6349: OR NVL(per_dpf_shd.g_old_rec.attribute7,hr_api.g_varchar2)

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

6343: OR NVL(per_dpf_shd.g_old_rec.attribute4,hr_api.g_varchar2)
6344: <> NVL(p_dpf_attribute4,hr_api.g_varchar2)
6345: OR NVL(per_dpf_shd.g_old_rec.attribute5,hr_api.g_varchar2)
6346: <> NVL(p_dpf_attribute5,hr_api.g_varchar2)
6347: OR NVL(per_dpf_shd.g_old_rec.attribute6,hr_api.g_varchar2)
6348: <> NVL(p_dpf_attribute6,hr_api.g_varchar2)
6349: OR NVL(per_dpf_shd.g_old_rec.attribute7,hr_api.g_varchar2)
6350: <> NVL(p_dpf_attribute7,hr_api.g_varchar2)
6351: OR NVL(per_dpf_shd.g_old_rec.attribute8,hr_api.g_varchar2)

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

6345: OR NVL(per_dpf_shd.g_old_rec.attribute5,hr_api.g_varchar2)
6346: <> NVL(p_dpf_attribute5,hr_api.g_varchar2)
6347: OR NVL(per_dpf_shd.g_old_rec.attribute6,hr_api.g_varchar2)
6348: <> NVL(p_dpf_attribute6,hr_api.g_varchar2)
6349: OR NVL(per_dpf_shd.g_old_rec.attribute7,hr_api.g_varchar2)
6350: <> NVL(p_dpf_attribute7,hr_api.g_varchar2)
6351: OR NVL(per_dpf_shd.g_old_rec.attribute8,hr_api.g_varchar2)
6352: <> NVL(p_dpf_attribute8,hr_api.g_varchar2)
6353: OR NVL(per_dpf_shd.g_old_rec.attribute9,hr_api.g_varchar2)

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

6347: OR NVL(per_dpf_shd.g_old_rec.attribute6,hr_api.g_varchar2)
6348: <> NVL(p_dpf_attribute6,hr_api.g_varchar2)
6349: OR NVL(per_dpf_shd.g_old_rec.attribute7,hr_api.g_varchar2)
6350: <> NVL(p_dpf_attribute7,hr_api.g_varchar2)
6351: OR NVL(per_dpf_shd.g_old_rec.attribute8,hr_api.g_varchar2)
6352: <> NVL(p_dpf_attribute8,hr_api.g_varchar2)
6353: OR NVL(per_dpf_shd.g_old_rec.attribute9,hr_api.g_varchar2)
6354: <> NVL(p_dpf_attribute9,hr_api.g_varchar2)
6355: OR NVL(per_dpf_shd.g_old_rec.attribute10,hr_api.g_varchar2)

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

6349: OR NVL(per_dpf_shd.g_old_rec.attribute7,hr_api.g_varchar2)
6350: <> NVL(p_dpf_attribute7,hr_api.g_varchar2)
6351: OR NVL(per_dpf_shd.g_old_rec.attribute8,hr_api.g_varchar2)
6352: <> NVL(p_dpf_attribute8,hr_api.g_varchar2)
6353: OR NVL(per_dpf_shd.g_old_rec.attribute9,hr_api.g_varchar2)
6354: <> NVL(p_dpf_attribute9,hr_api.g_varchar2)
6355: OR NVL(per_dpf_shd.g_old_rec.attribute10,hr_api.g_varchar2)
6356: <> NVL(p_dpf_attribute10,hr_api.g_varchar2)
6357: OR NVL(per_dpf_shd.g_old_rec.attribute11,hr_api.g_varchar2)

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

6351: OR NVL(per_dpf_shd.g_old_rec.attribute8,hr_api.g_varchar2)
6352: <> NVL(p_dpf_attribute8,hr_api.g_varchar2)
6353: OR NVL(per_dpf_shd.g_old_rec.attribute9,hr_api.g_varchar2)
6354: <> NVL(p_dpf_attribute9,hr_api.g_varchar2)
6355: OR NVL(per_dpf_shd.g_old_rec.attribute10,hr_api.g_varchar2)
6356: <> NVL(p_dpf_attribute10,hr_api.g_varchar2)
6357: OR NVL(per_dpf_shd.g_old_rec.attribute11,hr_api.g_varchar2)
6358: <> NVL(p_dpf_attribute11,hr_api.g_varchar2)
6359: OR NVL(per_dpf_shd.g_old_rec.attribute12,hr_api.g_varchar2)

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

6353: OR NVL(per_dpf_shd.g_old_rec.attribute9,hr_api.g_varchar2)
6354: <> NVL(p_dpf_attribute9,hr_api.g_varchar2)
6355: OR NVL(per_dpf_shd.g_old_rec.attribute10,hr_api.g_varchar2)
6356: <> NVL(p_dpf_attribute10,hr_api.g_varchar2)
6357: OR NVL(per_dpf_shd.g_old_rec.attribute11,hr_api.g_varchar2)
6358: <> NVL(p_dpf_attribute11,hr_api.g_varchar2)
6359: OR NVL(per_dpf_shd.g_old_rec.attribute12,hr_api.g_varchar2)
6360: <> NVL(p_dpf_attribute12,hr_api.g_varchar2)
6361: OR NVL(per_dpf_shd.g_old_rec.attribute13,hr_api.g_varchar2)

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

6355: OR NVL(per_dpf_shd.g_old_rec.attribute10,hr_api.g_varchar2)
6356: <> NVL(p_dpf_attribute10,hr_api.g_varchar2)
6357: OR NVL(per_dpf_shd.g_old_rec.attribute11,hr_api.g_varchar2)
6358: <> NVL(p_dpf_attribute11,hr_api.g_varchar2)
6359: OR NVL(per_dpf_shd.g_old_rec.attribute12,hr_api.g_varchar2)
6360: <> NVL(p_dpf_attribute12,hr_api.g_varchar2)
6361: OR NVL(per_dpf_shd.g_old_rec.attribute13,hr_api.g_varchar2)
6362: <> NVL(p_dpf_attribute13,hr_api.g_varchar2)
6363: OR NVL(per_dpf_shd.g_old_rec.attribute14,hr_api.g_varchar2)

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

6357: OR NVL(per_dpf_shd.g_old_rec.attribute11,hr_api.g_varchar2)
6358: <> NVL(p_dpf_attribute11,hr_api.g_varchar2)
6359: OR NVL(per_dpf_shd.g_old_rec.attribute12,hr_api.g_varchar2)
6360: <> NVL(p_dpf_attribute12,hr_api.g_varchar2)
6361: OR NVL(per_dpf_shd.g_old_rec.attribute13,hr_api.g_varchar2)
6362: <> NVL(p_dpf_attribute13,hr_api.g_varchar2)
6363: OR NVL(per_dpf_shd.g_old_rec.attribute14,hr_api.g_varchar2)
6364: <> NVL(p_dpf_attribute14,hr_api.g_varchar2)
6365: OR NVL(per_dpf_shd.g_old_rec.attribute15,hr_api.g_varchar2)

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

6359: OR NVL(per_dpf_shd.g_old_rec.attribute12,hr_api.g_varchar2)
6360: <> NVL(p_dpf_attribute12,hr_api.g_varchar2)
6361: OR NVL(per_dpf_shd.g_old_rec.attribute13,hr_api.g_varchar2)
6362: <> NVL(p_dpf_attribute13,hr_api.g_varchar2)
6363: OR NVL(per_dpf_shd.g_old_rec.attribute14,hr_api.g_varchar2)
6364: <> NVL(p_dpf_attribute14,hr_api.g_varchar2)
6365: OR NVL(per_dpf_shd.g_old_rec.attribute15,hr_api.g_varchar2)
6366: <> NVL(p_dpf_attribute15,hr_api.g_varchar2)
6367: OR NVL(per_dpf_shd.g_old_rec.attribute16,hr_api.g_varchar2)

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

6361: OR NVL(per_dpf_shd.g_old_rec.attribute13,hr_api.g_varchar2)
6362: <> NVL(p_dpf_attribute13,hr_api.g_varchar2)
6363: OR NVL(per_dpf_shd.g_old_rec.attribute14,hr_api.g_varchar2)
6364: <> NVL(p_dpf_attribute14,hr_api.g_varchar2)
6365: OR NVL(per_dpf_shd.g_old_rec.attribute15,hr_api.g_varchar2)
6366: <> NVL(p_dpf_attribute15,hr_api.g_varchar2)
6367: OR NVL(per_dpf_shd.g_old_rec.attribute16,hr_api.g_varchar2)
6368: <> NVL(p_dpf_attribute16,hr_api.g_varchar2)
6369: OR NVL(per_dpf_shd.g_old_rec.attribute17,hr_api.g_varchar2)

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

6363: OR NVL(per_dpf_shd.g_old_rec.attribute14,hr_api.g_varchar2)
6364: <> NVL(p_dpf_attribute14,hr_api.g_varchar2)
6365: OR NVL(per_dpf_shd.g_old_rec.attribute15,hr_api.g_varchar2)
6366: <> NVL(p_dpf_attribute15,hr_api.g_varchar2)
6367: OR NVL(per_dpf_shd.g_old_rec.attribute16,hr_api.g_varchar2)
6368: <> NVL(p_dpf_attribute16,hr_api.g_varchar2)
6369: OR NVL(per_dpf_shd.g_old_rec.attribute17,hr_api.g_varchar2)
6370: <> NVL(p_dpf_attribute17,hr_api.g_varchar2)
6371: OR NVL(per_dpf_shd.g_old_rec.attribute18,hr_api.g_varchar2)

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

6365: OR NVL(per_dpf_shd.g_old_rec.attribute15,hr_api.g_varchar2)
6366: <> NVL(p_dpf_attribute15,hr_api.g_varchar2)
6367: OR NVL(per_dpf_shd.g_old_rec.attribute16,hr_api.g_varchar2)
6368: <> NVL(p_dpf_attribute16,hr_api.g_varchar2)
6369: OR NVL(per_dpf_shd.g_old_rec.attribute17,hr_api.g_varchar2)
6370: <> NVL(p_dpf_attribute17,hr_api.g_varchar2)
6371: OR NVL(per_dpf_shd.g_old_rec.attribute18,hr_api.g_varchar2)
6372: <> NVL(p_dpf_attribute18,hr_api.g_varchar2)
6373: OR NVL(per_dpf_shd.g_old_rec.attribute19,hr_api.g_varchar2)

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

6367: OR NVL(per_dpf_shd.g_old_rec.attribute16,hr_api.g_varchar2)
6368: <> NVL(p_dpf_attribute16,hr_api.g_varchar2)
6369: OR NVL(per_dpf_shd.g_old_rec.attribute17,hr_api.g_varchar2)
6370: <> NVL(p_dpf_attribute17,hr_api.g_varchar2)
6371: OR NVL(per_dpf_shd.g_old_rec.attribute18,hr_api.g_varchar2)
6372: <> NVL(p_dpf_attribute18,hr_api.g_varchar2)
6373: OR NVL(per_dpf_shd.g_old_rec.attribute19,hr_api.g_varchar2)
6374: <> NVL(p_dpf_attribute19,hr_api.g_varchar2)
6375: OR NVL(per_dpf_shd.g_old_rec.attribute20,hr_api.g_varchar2)

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

6369: OR NVL(per_dpf_shd.g_old_rec.attribute17,hr_api.g_varchar2)
6370: <> NVL(p_dpf_attribute17,hr_api.g_varchar2)
6371: OR NVL(per_dpf_shd.g_old_rec.attribute18,hr_api.g_varchar2)
6372: <> NVL(p_dpf_attribute18,hr_api.g_varchar2)
6373: OR NVL(per_dpf_shd.g_old_rec.attribute19,hr_api.g_varchar2)
6374: <> NVL(p_dpf_attribute19,hr_api.g_varchar2)
6375: OR NVL(per_dpf_shd.g_old_rec.attribute20,hr_api.g_varchar2)
6376: <> NVL(p_dpf_attribute20,hr_api.g_varchar2) THEN
6377: --

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

6371: OR NVL(per_dpf_shd.g_old_rec.attribute18,hr_api.g_varchar2)
6372: <> NVL(p_dpf_attribute18,hr_api.g_varchar2)
6373: OR NVL(per_dpf_shd.g_old_rec.attribute19,hr_api.g_varchar2)
6374: <> NVL(p_dpf_attribute19,hr_api.g_varchar2)
6375: OR NVL(per_dpf_shd.g_old_rec.attribute20,hr_api.g_varchar2)
6376: <> NVL(p_dpf_attribute20,hr_api.g_varchar2) THEN
6377: --
6378: hr_deployment_factor_api.update_person_dpmt_factor
6379: (p_effective_date => p_effective_date

Line 7275: per_dpf_shd.lck

7271: --
7272: IF p_deployment_factor_id IS NOT NULL THEN
7273: hr_utility.set_location(l_proc, 110);
7274: --
7275: per_dpf_shd.lck
7276: (p_deployment_factor_id => p_deployment_factor_id
7277: ,p_object_version_number => p_dpf_object_version_number);
7278: END IF;
7279: --