APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_ADD_SHD

Line 4118: NVL(per_add_shd.g_old_rec.date_from,hr_api.g_date)

4114: -- Desc: Modified the if condition.to replace address_line1 with style and date_from
4115: -- IF (p_address_id IS NULL AND p_address_line1 IS NOT NULL)
4116: IF (p_address_id IS NULL AND p_style IS NOT NULL and p_adr_date_from IS NOT NULL)
4117: OR (p_address_id IS NOT NULL AND (
4118: NVL(per_add_shd.g_old_rec.date_from,hr_api.g_date)
4119: <> NVL(p_adr_date_from,hr_api.g_date)
4120: OR NVL(per_add_shd.g_old_rec.style,hr_api.g_varchar2)
4121: <> NVL(p_style,hr_api.g_varchar2)
4122: OR NVL(per_add_shd.g_old_rec.address_line1,hr_api.g_varchar2)

Line 4120: OR NVL(per_add_shd.g_old_rec.style,hr_api.g_varchar2)

4116: IF (p_address_id IS NULL AND p_style IS NOT NULL and p_adr_date_from IS NOT NULL)
4117: OR (p_address_id IS NOT NULL AND (
4118: NVL(per_add_shd.g_old_rec.date_from,hr_api.g_date)
4119: <> NVL(p_adr_date_from,hr_api.g_date)
4120: OR NVL(per_add_shd.g_old_rec.style,hr_api.g_varchar2)
4121: <> NVL(p_style,hr_api.g_varchar2)
4122: OR NVL(per_add_shd.g_old_rec.address_line1,hr_api.g_varchar2)
4123: <> NVL(p_address_line1,hr_api.g_varchar2)
4124: OR NVL(per_add_shd.g_old_rec.address_line2,hr_api.g_varchar2)

Line 4122: OR NVL(per_add_shd.g_old_rec.address_line1,hr_api.g_varchar2)

4118: NVL(per_add_shd.g_old_rec.date_from,hr_api.g_date)
4119: <> NVL(p_adr_date_from,hr_api.g_date)
4120: OR NVL(per_add_shd.g_old_rec.style,hr_api.g_varchar2)
4121: <> NVL(p_style,hr_api.g_varchar2)
4122: OR NVL(per_add_shd.g_old_rec.address_line1,hr_api.g_varchar2)
4123: <> NVL(p_address_line1,hr_api.g_varchar2)
4124: OR NVL(per_add_shd.g_old_rec.address_line2,hr_api.g_varchar2)
4125: <> NVL(p_address_line2,hr_api.g_varchar2)
4126: OR NVL(per_add_shd.g_old_rec.address_line3,hr_api.g_varchar2)

Line 4124: OR NVL(per_add_shd.g_old_rec.address_line2,hr_api.g_varchar2)

4120: OR NVL(per_add_shd.g_old_rec.style,hr_api.g_varchar2)
4121: <> NVL(p_style,hr_api.g_varchar2)
4122: OR NVL(per_add_shd.g_old_rec.address_line1,hr_api.g_varchar2)
4123: <> NVL(p_address_line1,hr_api.g_varchar2)
4124: OR NVL(per_add_shd.g_old_rec.address_line2,hr_api.g_varchar2)
4125: <> NVL(p_address_line2,hr_api.g_varchar2)
4126: OR NVL(per_add_shd.g_old_rec.address_line3,hr_api.g_varchar2)
4127: <> NVL(p_address_line3,hr_api.g_varchar2)
4128: OR NVL(per_add_shd.g_old_rec.address_type,hr_api.g_varchar2)

Line 4126: OR NVL(per_add_shd.g_old_rec.address_line3,hr_api.g_varchar2)

4122: OR NVL(per_add_shd.g_old_rec.address_line1,hr_api.g_varchar2)
4123: <> NVL(p_address_line1,hr_api.g_varchar2)
4124: OR NVL(per_add_shd.g_old_rec.address_line2,hr_api.g_varchar2)
4125: <> NVL(p_address_line2,hr_api.g_varchar2)
4126: OR NVL(per_add_shd.g_old_rec.address_line3,hr_api.g_varchar2)
4127: <> NVL(p_address_line3,hr_api.g_varchar2)
4128: OR NVL(per_add_shd.g_old_rec.address_type,hr_api.g_varchar2)
4129: <> NVL(p_address_type,hr_api.g_varchar2)
4130: OR NVL(per_add_shd.g_old_rec.country,hr_api.g_varchar2)

Line 4128: OR NVL(per_add_shd.g_old_rec.address_type,hr_api.g_varchar2)

4124: OR NVL(per_add_shd.g_old_rec.address_line2,hr_api.g_varchar2)
4125: <> NVL(p_address_line2,hr_api.g_varchar2)
4126: OR NVL(per_add_shd.g_old_rec.address_line3,hr_api.g_varchar2)
4127: <> NVL(p_address_line3,hr_api.g_varchar2)
4128: OR NVL(per_add_shd.g_old_rec.address_type,hr_api.g_varchar2)
4129: <> NVL(p_address_type,hr_api.g_varchar2)
4130: OR NVL(per_add_shd.g_old_rec.country,hr_api.g_varchar2)
4131: <> NVL(p_country,hr_api.g_varchar2)
4132: OR NVL(per_add_shd.g_old_rec.date_to,hr_api.g_date)

Line 4130: OR NVL(per_add_shd.g_old_rec.country,hr_api.g_varchar2)

4126: OR NVL(per_add_shd.g_old_rec.address_line3,hr_api.g_varchar2)
4127: <> NVL(p_address_line3,hr_api.g_varchar2)
4128: OR NVL(per_add_shd.g_old_rec.address_type,hr_api.g_varchar2)
4129: <> NVL(p_address_type,hr_api.g_varchar2)
4130: OR NVL(per_add_shd.g_old_rec.country,hr_api.g_varchar2)
4131: <> NVL(p_country,hr_api.g_varchar2)
4132: OR NVL(per_add_shd.g_old_rec.date_to,hr_api.g_date)
4133: <> NVL(p_adr_date_to,hr_api.g_date)
4134: OR NVL(per_add_shd.g_old_rec.postal_code,hr_api.g_varchar2)

Line 4132: OR NVL(per_add_shd.g_old_rec.date_to,hr_api.g_date)

4128: OR NVL(per_add_shd.g_old_rec.address_type,hr_api.g_varchar2)
4129: <> NVL(p_address_type,hr_api.g_varchar2)
4130: OR NVL(per_add_shd.g_old_rec.country,hr_api.g_varchar2)
4131: <> NVL(p_country,hr_api.g_varchar2)
4132: OR NVL(per_add_shd.g_old_rec.date_to,hr_api.g_date)
4133: <> NVL(p_adr_date_to,hr_api.g_date)
4134: OR NVL(per_add_shd.g_old_rec.postal_code,hr_api.g_varchar2)
4135: <> NVL(p_postal_code,hr_api.g_varchar2)
4136: OR NVL(per_add_shd.g_old_rec.region_1,hr_api.g_varchar2)

Line 4134: OR NVL(per_add_shd.g_old_rec.postal_code,hr_api.g_varchar2)

4130: OR NVL(per_add_shd.g_old_rec.country,hr_api.g_varchar2)
4131: <> NVL(p_country,hr_api.g_varchar2)
4132: OR NVL(per_add_shd.g_old_rec.date_to,hr_api.g_date)
4133: <> NVL(p_adr_date_to,hr_api.g_date)
4134: OR NVL(per_add_shd.g_old_rec.postal_code,hr_api.g_varchar2)
4135: <> NVL(p_postal_code,hr_api.g_varchar2)
4136: OR NVL(per_add_shd.g_old_rec.region_1,hr_api.g_varchar2)
4137: <> NVL(p_region_1,hr_api.g_varchar2)
4138: OR NVL(per_add_shd.g_old_rec.region_2,hr_api.g_varchar2)

Line 4136: OR NVL(per_add_shd.g_old_rec.region_1,hr_api.g_varchar2)

4132: OR NVL(per_add_shd.g_old_rec.date_to,hr_api.g_date)
4133: <> NVL(p_adr_date_to,hr_api.g_date)
4134: OR NVL(per_add_shd.g_old_rec.postal_code,hr_api.g_varchar2)
4135: <> NVL(p_postal_code,hr_api.g_varchar2)
4136: OR NVL(per_add_shd.g_old_rec.region_1,hr_api.g_varchar2)
4137: <> NVL(p_region_1,hr_api.g_varchar2)
4138: OR NVL(per_add_shd.g_old_rec.region_2,hr_api.g_varchar2)
4139: <> NVL(p_region_2,hr_api.g_varchar2)
4140: OR NVL(per_add_shd.g_old_rec.region_3,hr_api.g_varchar2)

Line 4138: OR NVL(per_add_shd.g_old_rec.region_2,hr_api.g_varchar2)

4134: OR NVL(per_add_shd.g_old_rec.postal_code,hr_api.g_varchar2)
4135: <> NVL(p_postal_code,hr_api.g_varchar2)
4136: OR NVL(per_add_shd.g_old_rec.region_1,hr_api.g_varchar2)
4137: <> NVL(p_region_1,hr_api.g_varchar2)
4138: OR NVL(per_add_shd.g_old_rec.region_2,hr_api.g_varchar2)
4139: <> NVL(p_region_2,hr_api.g_varchar2)
4140: OR NVL(per_add_shd.g_old_rec.region_3,hr_api.g_varchar2)
4141: <> NVL(p_region_3,hr_api.g_varchar2)
4142: OR NVL(per_add_shd.g_old_rec.town_or_city,hr_api.g_varchar2)

Line 4140: OR NVL(per_add_shd.g_old_rec.region_3,hr_api.g_varchar2)

4136: OR NVL(per_add_shd.g_old_rec.region_1,hr_api.g_varchar2)
4137: <> NVL(p_region_1,hr_api.g_varchar2)
4138: OR NVL(per_add_shd.g_old_rec.region_2,hr_api.g_varchar2)
4139: <> NVL(p_region_2,hr_api.g_varchar2)
4140: OR NVL(per_add_shd.g_old_rec.region_3,hr_api.g_varchar2)
4141: <> NVL(p_region_3,hr_api.g_varchar2)
4142: OR NVL(per_add_shd.g_old_rec.town_or_city,hr_api.g_varchar2)
4143: <> NVL(p_town_or_city,hr_api.g_varchar2)
4144: OR NVL(per_add_shd.g_old_rec.telephone_number_1,hr_api.g_varchar2)

Line 4142: OR NVL(per_add_shd.g_old_rec.town_or_city,hr_api.g_varchar2)

4138: OR NVL(per_add_shd.g_old_rec.region_2,hr_api.g_varchar2)
4139: <> NVL(p_region_2,hr_api.g_varchar2)
4140: OR NVL(per_add_shd.g_old_rec.region_3,hr_api.g_varchar2)
4141: <> NVL(p_region_3,hr_api.g_varchar2)
4142: OR NVL(per_add_shd.g_old_rec.town_or_city,hr_api.g_varchar2)
4143: <> NVL(p_town_or_city,hr_api.g_varchar2)
4144: OR NVL(per_add_shd.g_old_rec.telephone_number_1,hr_api.g_varchar2)
4145: <> NVL(p_telephone_number_1,hr_api.g_varchar2)
4146: OR NVL(per_add_shd.g_old_rec.telephone_number_2,hr_api.g_varchar2)

Line 4144: OR NVL(per_add_shd.g_old_rec.telephone_number_1,hr_api.g_varchar2)

4140: OR NVL(per_add_shd.g_old_rec.region_3,hr_api.g_varchar2)
4141: <> NVL(p_region_3,hr_api.g_varchar2)
4142: OR NVL(per_add_shd.g_old_rec.town_or_city,hr_api.g_varchar2)
4143: <> NVL(p_town_or_city,hr_api.g_varchar2)
4144: OR NVL(per_add_shd.g_old_rec.telephone_number_1,hr_api.g_varchar2)
4145: <> NVL(p_telephone_number_1,hr_api.g_varchar2)
4146: OR NVL(per_add_shd.g_old_rec.telephone_number_2,hr_api.g_varchar2)
4147: <> NVL(p_telephone_number_2,hr_api.g_varchar2)
4148: OR NVL(per_add_shd.g_old_rec.telephone_number_3,hr_api.g_varchar2)

Line 4146: OR NVL(per_add_shd.g_old_rec.telephone_number_2,hr_api.g_varchar2)

4142: OR NVL(per_add_shd.g_old_rec.town_or_city,hr_api.g_varchar2)
4143: <> NVL(p_town_or_city,hr_api.g_varchar2)
4144: OR NVL(per_add_shd.g_old_rec.telephone_number_1,hr_api.g_varchar2)
4145: <> NVL(p_telephone_number_1,hr_api.g_varchar2)
4146: OR NVL(per_add_shd.g_old_rec.telephone_number_2,hr_api.g_varchar2)
4147: <> NVL(p_telephone_number_2,hr_api.g_varchar2)
4148: OR NVL(per_add_shd.g_old_rec.telephone_number_3,hr_api.g_varchar2)
4149: <> NVL(p_telephone_number_3,hr_api.g_varchar2)
4150: OR NVL(per_add_shd.g_old_rec.addr_attribute_category,hr_api.g_varchar2)

Line 4148: OR NVL(per_add_shd.g_old_rec.telephone_number_3,hr_api.g_varchar2)

4144: OR NVL(per_add_shd.g_old_rec.telephone_number_1,hr_api.g_varchar2)
4145: <> NVL(p_telephone_number_1,hr_api.g_varchar2)
4146: OR NVL(per_add_shd.g_old_rec.telephone_number_2,hr_api.g_varchar2)
4147: <> NVL(p_telephone_number_2,hr_api.g_varchar2)
4148: OR NVL(per_add_shd.g_old_rec.telephone_number_3,hr_api.g_varchar2)
4149: <> NVL(p_telephone_number_3,hr_api.g_varchar2)
4150: OR NVL(per_add_shd.g_old_rec.addr_attribute_category,hr_api.g_varchar2)
4151: <> NVL(p_addr_attribute_category,hr_api.g_varchar2)
4152: OR NVL(per_add_shd.g_old_rec.addr_attribute1,hr_api.g_varchar2)

Line 4150: OR NVL(per_add_shd.g_old_rec.addr_attribute_category,hr_api.g_varchar2)

4146: OR NVL(per_add_shd.g_old_rec.telephone_number_2,hr_api.g_varchar2)
4147: <> NVL(p_telephone_number_2,hr_api.g_varchar2)
4148: OR NVL(per_add_shd.g_old_rec.telephone_number_3,hr_api.g_varchar2)
4149: <> NVL(p_telephone_number_3,hr_api.g_varchar2)
4150: OR NVL(per_add_shd.g_old_rec.addr_attribute_category,hr_api.g_varchar2)
4151: <> NVL(p_addr_attribute_category,hr_api.g_varchar2)
4152: OR NVL(per_add_shd.g_old_rec.addr_attribute1,hr_api.g_varchar2)
4153: <> NVL(p_addr_attribute1,hr_api.g_varchar2)
4154: OR NVL(per_add_shd.g_old_rec.addr_attribute2,hr_api.g_varchar2)

Line 4152: OR NVL(per_add_shd.g_old_rec.addr_attribute1,hr_api.g_varchar2)

4148: OR NVL(per_add_shd.g_old_rec.telephone_number_3,hr_api.g_varchar2)
4149: <> NVL(p_telephone_number_3,hr_api.g_varchar2)
4150: OR NVL(per_add_shd.g_old_rec.addr_attribute_category,hr_api.g_varchar2)
4151: <> NVL(p_addr_attribute_category,hr_api.g_varchar2)
4152: OR NVL(per_add_shd.g_old_rec.addr_attribute1,hr_api.g_varchar2)
4153: <> NVL(p_addr_attribute1,hr_api.g_varchar2)
4154: OR NVL(per_add_shd.g_old_rec.addr_attribute2,hr_api.g_varchar2)
4155: <> NVL(p_addr_attribute2,hr_api.g_varchar2)
4156: OR NVL(per_add_shd.g_old_rec.addr_attribute3,hr_api.g_varchar2)

Line 4154: OR NVL(per_add_shd.g_old_rec.addr_attribute2,hr_api.g_varchar2)

4150: OR NVL(per_add_shd.g_old_rec.addr_attribute_category,hr_api.g_varchar2)
4151: <> NVL(p_addr_attribute_category,hr_api.g_varchar2)
4152: OR NVL(per_add_shd.g_old_rec.addr_attribute1,hr_api.g_varchar2)
4153: <> NVL(p_addr_attribute1,hr_api.g_varchar2)
4154: OR NVL(per_add_shd.g_old_rec.addr_attribute2,hr_api.g_varchar2)
4155: <> NVL(p_addr_attribute2,hr_api.g_varchar2)
4156: OR NVL(per_add_shd.g_old_rec.addr_attribute3,hr_api.g_varchar2)
4157: <> NVL(p_addr_attribute3,hr_api.g_varchar2)
4158: OR NVL(per_add_shd.g_old_rec.addr_attribute4,hr_api.g_varchar2)

Line 4156: OR NVL(per_add_shd.g_old_rec.addr_attribute3,hr_api.g_varchar2)

4152: OR NVL(per_add_shd.g_old_rec.addr_attribute1,hr_api.g_varchar2)
4153: <> NVL(p_addr_attribute1,hr_api.g_varchar2)
4154: OR NVL(per_add_shd.g_old_rec.addr_attribute2,hr_api.g_varchar2)
4155: <> NVL(p_addr_attribute2,hr_api.g_varchar2)
4156: OR NVL(per_add_shd.g_old_rec.addr_attribute3,hr_api.g_varchar2)
4157: <> NVL(p_addr_attribute3,hr_api.g_varchar2)
4158: OR NVL(per_add_shd.g_old_rec.addr_attribute4,hr_api.g_varchar2)
4159: <> NVL(p_addr_attribute4,hr_api.g_varchar2)
4160: OR NVL(per_add_shd.g_old_rec.addr_attribute5,hr_api.g_varchar2)

Line 4158: OR NVL(per_add_shd.g_old_rec.addr_attribute4,hr_api.g_varchar2)

4154: OR NVL(per_add_shd.g_old_rec.addr_attribute2,hr_api.g_varchar2)
4155: <> NVL(p_addr_attribute2,hr_api.g_varchar2)
4156: OR NVL(per_add_shd.g_old_rec.addr_attribute3,hr_api.g_varchar2)
4157: <> NVL(p_addr_attribute3,hr_api.g_varchar2)
4158: OR NVL(per_add_shd.g_old_rec.addr_attribute4,hr_api.g_varchar2)
4159: <> NVL(p_addr_attribute4,hr_api.g_varchar2)
4160: OR NVL(per_add_shd.g_old_rec.addr_attribute5,hr_api.g_varchar2)
4161: <> NVL(p_addr_attribute5,hr_api.g_varchar2)
4162: OR NVL(per_add_shd.g_old_rec.addr_attribute6,hr_api.g_varchar2)

Line 4160: OR NVL(per_add_shd.g_old_rec.addr_attribute5,hr_api.g_varchar2)

4156: OR NVL(per_add_shd.g_old_rec.addr_attribute3,hr_api.g_varchar2)
4157: <> NVL(p_addr_attribute3,hr_api.g_varchar2)
4158: OR NVL(per_add_shd.g_old_rec.addr_attribute4,hr_api.g_varchar2)
4159: <> NVL(p_addr_attribute4,hr_api.g_varchar2)
4160: OR NVL(per_add_shd.g_old_rec.addr_attribute5,hr_api.g_varchar2)
4161: <> NVL(p_addr_attribute5,hr_api.g_varchar2)
4162: OR NVL(per_add_shd.g_old_rec.addr_attribute6,hr_api.g_varchar2)
4163: <> NVL(p_addr_attribute6,hr_api.g_varchar2)
4164: OR NVL(per_add_shd.g_old_rec.addr_attribute7,hr_api.g_varchar2)

Line 4162: OR NVL(per_add_shd.g_old_rec.addr_attribute6,hr_api.g_varchar2)

4158: OR NVL(per_add_shd.g_old_rec.addr_attribute4,hr_api.g_varchar2)
4159: <> NVL(p_addr_attribute4,hr_api.g_varchar2)
4160: OR NVL(per_add_shd.g_old_rec.addr_attribute5,hr_api.g_varchar2)
4161: <> NVL(p_addr_attribute5,hr_api.g_varchar2)
4162: OR NVL(per_add_shd.g_old_rec.addr_attribute6,hr_api.g_varchar2)
4163: <> NVL(p_addr_attribute6,hr_api.g_varchar2)
4164: OR NVL(per_add_shd.g_old_rec.addr_attribute7,hr_api.g_varchar2)
4165: <> NVL(p_addr_attribute7,hr_api.g_varchar2)
4166: OR NVL(per_add_shd.g_old_rec.addr_attribute8,hr_api.g_varchar2)

Line 4164: OR NVL(per_add_shd.g_old_rec.addr_attribute7,hr_api.g_varchar2)

4160: OR NVL(per_add_shd.g_old_rec.addr_attribute5,hr_api.g_varchar2)
4161: <> NVL(p_addr_attribute5,hr_api.g_varchar2)
4162: OR NVL(per_add_shd.g_old_rec.addr_attribute6,hr_api.g_varchar2)
4163: <> NVL(p_addr_attribute6,hr_api.g_varchar2)
4164: OR NVL(per_add_shd.g_old_rec.addr_attribute7,hr_api.g_varchar2)
4165: <> NVL(p_addr_attribute7,hr_api.g_varchar2)
4166: OR NVL(per_add_shd.g_old_rec.addr_attribute8,hr_api.g_varchar2)
4167: <> NVL(p_addr_attribute8,hr_api.g_varchar2)
4168: OR NVL(per_add_shd.g_old_rec.addr_attribute9,hr_api.g_varchar2)

Line 4166: OR NVL(per_add_shd.g_old_rec.addr_attribute8,hr_api.g_varchar2)

4162: OR NVL(per_add_shd.g_old_rec.addr_attribute6,hr_api.g_varchar2)
4163: <> NVL(p_addr_attribute6,hr_api.g_varchar2)
4164: OR NVL(per_add_shd.g_old_rec.addr_attribute7,hr_api.g_varchar2)
4165: <> NVL(p_addr_attribute7,hr_api.g_varchar2)
4166: OR NVL(per_add_shd.g_old_rec.addr_attribute8,hr_api.g_varchar2)
4167: <> NVL(p_addr_attribute8,hr_api.g_varchar2)
4168: OR NVL(per_add_shd.g_old_rec.addr_attribute9,hr_api.g_varchar2)
4169: <> NVL(p_addr_attribute9,hr_api.g_varchar2)
4170: OR NVL(per_add_shd.g_old_rec.addr_attribute10,hr_api.g_varchar2)

Line 4168: OR NVL(per_add_shd.g_old_rec.addr_attribute9,hr_api.g_varchar2)

4164: OR NVL(per_add_shd.g_old_rec.addr_attribute7,hr_api.g_varchar2)
4165: <> NVL(p_addr_attribute7,hr_api.g_varchar2)
4166: OR NVL(per_add_shd.g_old_rec.addr_attribute8,hr_api.g_varchar2)
4167: <> NVL(p_addr_attribute8,hr_api.g_varchar2)
4168: OR NVL(per_add_shd.g_old_rec.addr_attribute9,hr_api.g_varchar2)
4169: <> NVL(p_addr_attribute9,hr_api.g_varchar2)
4170: OR NVL(per_add_shd.g_old_rec.addr_attribute10,hr_api.g_varchar2)
4171: <> NVL(p_addr_attribute10,hr_api.g_varchar2)
4172: OR NVL(per_add_shd.g_old_rec.addr_attribute11,hr_api.g_varchar2)

Line 4170: OR NVL(per_add_shd.g_old_rec.addr_attribute10,hr_api.g_varchar2)

4166: OR NVL(per_add_shd.g_old_rec.addr_attribute8,hr_api.g_varchar2)
4167: <> NVL(p_addr_attribute8,hr_api.g_varchar2)
4168: OR NVL(per_add_shd.g_old_rec.addr_attribute9,hr_api.g_varchar2)
4169: <> NVL(p_addr_attribute9,hr_api.g_varchar2)
4170: OR NVL(per_add_shd.g_old_rec.addr_attribute10,hr_api.g_varchar2)
4171: <> NVL(p_addr_attribute10,hr_api.g_varchar2)
4172: OR NVL(per_add_shd.g_old_rec.addr_attribute11,hr_api.g_varchar2)
4173: <> NVL(p_addr_attribute11,hr_api.g_varchar2)
4174: OR NVL(per_add_shd.g_old_rec.addr_attribute12,hr_api.g_varchar2)

Line 4172: OR NVL(per_add_shd.g_old_rec.addr_attribute11,hr_api.g_varchar2)

4168: OR NVL(per_add_shd.g_old_rec.addr_attribute9,hr_api.g_varchar2)
4169: <> NVL(p_addr_attribute9,hr_api.g_varchar2)
4170: OR NVL(per_add_shd.g_old_rec.addr_attribute10,hr_api.g_varchar2)
4171: <> NVL(p_addr_attribute10,hr_api.g_varchar2)
4172: OR NVL(per_add_shd.g_old_rec.addr_attribute11,hr_api.g_varchar2)
4173: <> NVL(p_addr_attribute11,hr_api.g_varchar2)
4174: OR NVL(per_add_shd.g_old_rec.addr_attribute12,hr_api.g_varchar2)
4175: <> NVL(p_addr_attribute12,hr_api.g_varchar2)
4176: OR NVL(per_add_shd.g_old_rec.addr_attribute13,hr_api.g_varchar2)

Line 4174: OR NVL(per_add_shd.g_old_rec.addr_attribute12,hr_api.g_varchar2)

4170: OR NVL(per_add_shd.g_old_rec.addr_attribute10,hr_api.g_varchar2)
4171: <> NVL(p_addr_attribute10,hr_api.g_varchar2)
4172: OR NVL(per_add_shd.g_old_rec.addr_attribute11,hr_api.g_varchar2)
4173: <> NVL(p_addr_attribute11,hr_api.g_varchar2)
4174: OR NVL(per_add_shd.g_old_rec.addr_attribute12,hr_api.g_varchar2)
4175: <> NVL(p_addr_attribute12,hr_api.g_varchar2)
4176: OR NVL(per_add_shd.g_old_rec.addr_attribute13,hr_api.g_varchar2)
4177: <> NVL(p_addr_attribute13,hr_api.g_varchar2)
4178: OR NVL(per_add_shd.g_old_rec.addr_attribute14,hr_api.g_varchar2)

Line 4176: OR NVL(per_add_shd.g_old_rec.addr_attribute13,hr_api.g_varchar2)

4172: OR NVL(per_add_shd.g_old_rec.addr_attribute11,hr_api.g_varchar2)
4173: <> NVL(p_addr_attribute11,hr_api.g_varchar2)
4174: OR NVL(per_add_shd.g_old_rec.addr_attribute12,hr_api.g_varchar2)
4175: <> NVL(p_addr_attribute12,hr_api.g_varchar2)
4176: OR NVL(per_add_shd.g_old_rec.addr_attribute13,hr_api.g_varchar2)
4177: <> NVL(p_addr_attribute13,hr_api.g_varchar2)
4178: OR NVL(per_add_shd.g_old_rec.addr_attribute14,hr_api.g_varchar2)
4179: <> NVL(p_addr_attribute14,hr_api.g_varchar2)
4180: OR NVL(per_add_shd.g_old_rec.addr_attribute15,hr_api.g_varchar2)

Line 4178: OR NVL(per_add_shd.g_old_rec.addr_attribute14,hr_api.g_varchar2)

4174: OR NVL(per_add_shd.g_old_rec.addr_attribute12,hr_api.g_varchar2)
4175: <> NVL(p_addr_attribute12,hr_api.g_varchar2)
4176: OR NVL(per_add_shd.g_old_rec.addr_attribute13,hr_api.g_varchar2)
4177: <> NVL(p_addr_attribute13,hr_api.g_varchar2)
4178: OR NVL(per_add_shd.g_old_rec.addr_attribute14,hr_api.g_varchar2)
4179: <> NVL(p_addr_attribute14,hr_api.g_varchar2)
4180: OR NVL(per_add_shd.g_old_rec.addr_attribute15,hr_api.g_varchar2)
4181: <> NVL(p_addr_attribute15,hr_api.g_varchar2)
4182: OR NVL(per_add_shd.g_old_rec.addr_attribute16,hr_api.g_varchar2)

Line 4180: OR NVL(per_add_shd.g_old_rec.addr_attribute15,hr_api.g_varchar2)

4176: OR NVL(per_add_shd.g_old_rec.addr_attribute13,hr_api.g_varchar2)
4177: <> NVL(p_addr_attribute13,hr_api.g_varchar2)
4178: OR NVL(per_add_shd.g_old_rec.addr_attribute14,hr_api.g_varchar2)
4179: <> NVL(p_addr_attribute14,hr_api.g_varchar2)
4180: OR NVL(per_add_shd.g_old_rec.addr_attribute15,hr_api.g_varchar2)
4181: <> NVL(p_addr_attribute15,hr_api.g_varchar2)
4182: OR NVL(per_add_shd.g_old_rec.addr_attribute16,hr_api.g_varchar2)
4183: <> NVL(p_addr_attribute16,hr_api.g_varchar2)
4184: OR NVL(per_add_shd.g_old_rec.addr_attribute17,hr_api.g_varchar2)

Line 4182: OR NVL(per_add_shd.g_old_rec.addr_attribute16,hr_api.g_varchar2)

4178: OR NVL(per_add_shd.g_old_rec.addr_attribute14,hr_api.g_varchar2)
4179: <> NVL(p_addr_attribute14,hr_api.g_varchar2)
4180: OR NVL(per_add_shd.g_old_rec.addr_attribute15,hr_api.g_varchar2)
4181: <> NVL(p_addr_attribute15,hr_api.g_varchar2)
4182: OR NVL(per_add_shd.g_old_rec.addr_attribute16,hr_api.g_varchar2)
4183: <> NVL(p_addr_attribute16,hr_api.g_varchar2)
4184: OR NVL(per_add_shd.g_old_rec.addr_attribute17,hr_api.g_varchar2)
4185: <> NVL(p_addr_attribute17,hr_api.g_varchar2)
4186: OR NVL(per_add_shd.g_old_rec.addr_attribute18,hr_api.g_varchar2)

Line 4184: OR NVL(per_add_shd.g_old_rec.addr_attribute17,hr_api.g_varchar2)

4180: OR NVL(per_add_shd.g_old_rec.addr_attribute15,hr_api.g_varchar2)
4181: <> NVL(p_addr_attribute15,hr_api.g_varchar2)
4182: OR NVL(per_add_shd.g_old_rec.addr_attribute16,hr_api.g_varchar2)
4183: <> NVL(p_addr_attribute16,hr_api.g_varchar2)
4184: OR NVL(per_add_shd.g_old_rec.addr_attribute17,hr_api.g_varchar2)
4185: <> NVL(p_addr_attribute17,hr_api.g_varchar2)
4186: OR NVL(per_add_shd.g_old_rec.addr_attribute18,hr_api.g_varchar2)
4187: <> NVL(p_addr_attribute18,hr_api.g_varchar2)
4188: OR NVL(per_add_shd.g_old_rec.addr_attribute19,hr_api.g_varchar2)

Line 4186: OR NVL(per_add_shd.g_old_rec.addr_attribute18,hr_api.g_varchar2)

4182: OR NVL(per_add_shd.g_old_rec.addr_attribute16,hr_api.g_varchar2)
4183: <> NVL(p_addr_attribute16,hr_api.g_varchar2)
4184: OR NVL(per_add_shd.g_old_rec.addr_attribute17,hr_api.g_varchar2)
4185: <> NVL(p_addr_attribute17,hr_api.g_varchar2)
4186: OR NVL(per_add_shd.g_old_rec.addr_attribute18,hr_api.g_varchar2)
4187: <> NVL(p_addr_attribute18,hr_api.g_varchar2)
4188: OR NVL(per_add_shd.g_old_rec.addr_attribute19,hr_api.g_varchar2)
4189: <> NVL(p_addr_attribute19,hr_api.g_varchar2)
4190: OR NVL(per_add_shd.g_old_rec.addr_attribute20,hr_api.g_varchar2)

Line 4188: OR NVL(per_add_shd.g_old_rec.addr_attribute19,hr_api.g_varchar2)

4184: OR NVL(per_add_shd.g_old_rec.addr_attribute17,hr_api.g_varchar2)
4185: <> NVL(p_addr_attribute17,hr_api.g_varchar2)
4186: OR NVL(per_add_shd.g_old_rec.addr_attribute18,hr_api.g_varchar2)
4187: <> NVL(p_addr_attribute18,hr_api.g_varchar2)
4188: OR NVL(per_add_shd.g_old_rec.addr_attribute19,hr_api.g_varchar2)
4189: <> NVL(p_addr_attribute19,hr_api.g_varchar2)
4190: OR NVL(per_add_shd.g_old_rec.addr_attribute20,hr_api.g_varchar2)
4191: <> NVL(p_addr_attribute20,hr_api.g_varchar2)
4192: -- Bug 3216519 Start Here

Line 4190: OR NVL(per_add_shd.g_old_rec.addr_attribute20,hr_api.g_varchar2)

4186: OR NVL(per_add_shd.g_old_rec.addr_attribute18,hr_api.g_varchar2)
4187: <> NVL(p_addr_attribute18,hr_api.g_varchar2)
4188: OR NVL(per_add_shd.g_old_rec.addr_attribute19,hr_api.g_varchar2)
4189: <> NVL(p_addr_attribute19,hr_api.g_varchar2)
4190: OR NVL(per_add_shd.g_old_rec.addr_attribute20,hr_api.g_varchar2)
4191: <> NVL(p_addr_attribute20,hr_api.g_varchar2)
4192: -- Bug 3216519 Start Here
4193: OR NVL(per_add_shd.g_old_rec.add_information13,hr_api.g_varchar2)
4194: <> NVL(p_add_information13,hr_api.g_varchar2)

Line 4193: OR NVL(per_add_shd.g_old_rec.add_information13,hr_api.g_varchar2)

4189: <> NVL(p_addr_attribute19,hr_api.g_varchar2)
4190: OR NVL(per_add_shd.g_old_rec.addr_attribute20,hr_api.g_varchar2)
4191: <> NVL(p_addr_attribute20,hr_api.g_varchar2)
4192: -- Bug 3216519 Start Here
4193: OR NVL(per_add_shd.g_old_rec.add_information13,hr_api.g_varchar2)
4194: <> NVL(p_add_information13,hr_api.g_varchar2)
4195: OR NVL(per_add_shd.g_old_rec.add_information14,hr_api.g_varchar2)
4196: <> NVL(p_add_information14,hr_api.g_varchar2)
4197: OR NVL(per_add_shd.g_old_rec.add_information15,hr_api.g_varchar2)

Line 4195: OR NVL(per_add_shd.g_old_rec.add_information14,hr_api.g_varchar2)

4191: <> NVL(p_addr_attribute20,hr_api.g_varchar2)
4192: -- Bug 3216519 Start Here
4193: OR NVL(per_add_shd.g_old_rec.add_information13,hr_api.g_varchar2)
4194: <> NVL(p_add_information13,hr_api.g_varchar2)
4195: OR NVL(per_add_shd.g_old_rec.add_information14,hr_api.g_varchar2)
4196: <> NVL(p_add_information14,hr_api.g_varchar2)
4197: OR NVL(per_add_shd.g_old_rec.add_information15,hr_api.g_varchar2)
4198: <> NVL(p_add_information15,hr_api.g_varchar2)
4199: OR NVL(per_add_shd.g_old_rec.add_information16,hr_api.g_varchar2)

Line 4197: OR NVL(per_add_shd.g_old_rec.add_information15,hr_api.g_varchar2)

4193: OR NVL(per_add_shd.g_old_rec.add_information13,hr_api.g_varchar2)
4194: <> NVL(p_add_information13,hr_api.g_varchar2)
4195: OR NVL(per_add_shd.g_old_rec.add_information14,hr_api.g_varchar2)
4196: <> NVL(p_add_information14,hr_api.g_varchar2)
4197: OR NVL(per_add_shd.g_old_rec.add_information15,hr_api.g_varchar2)
4198: <> NVL(p_add_information15,hr_api.g_varchar2)
4199: OR NVL(per_add_shd.g_old_rec.add_information16,hr_api.g_varchar2)
4200: <> NVL(p_add_information16,hr_api.g_varchar2)
4201: -- Bug 3216519 End Here

Line 4199: OR NVL(per_add_shd.g_old_rec.add_information16,hr_api.g_varchar2)

4195: OR NVL(per_add_shd.g_old_rec.add_information14,hr_api.g_varchar2)
4196: <> NVL(p_add_information14,hr_api.g_varchar2)
4197: OR NVL(per_add_shd.g_old_rec.add_information15,hr_api.g_varchar2)
4198: <> NVL(p_add_information15,hr_api.g_varchar2)
4199: OR NVL(per_add_shd.g_old_rec.add_information16,hr_api.g_varchar2)
4200: <> NVL(p_add_information16,hr_api.g_varchar2)
4201: -- Bug 3216519 End Here
4202: OR NVL(per_add_shd.g_old_rec.add_information17,hr_api.g_varchar2)
4203: <> NVL(p_add_information17,hr_api.g_varchar2)

Line 4202: OR NVL(per_add_shd.g_old_rec.add_information17,hr_api.g_varchar2)

4198: <> NVL(p_add_information15,hr_api.g_varchar2)
4199: OR NVL(per_add_shd.g_old_rec.add_information16,hr_api.g_varchar2)
4200: <> NVL(p_add_information16,hr_api.g_varchar2)
4201: -- Bug 3216519 End Here
4202: OR NVL(per_add_shd.g_old_rec.add_information17,hr_api.g_varchar2)
4203: <> NVL(p_add_information17,hr_api.g_varchar2)
4204: OR NVL(per_add_shd.g_old_rec.add_information18,hr_api.g_varchar2)
4205: <> NVL(p_add_information18,hr_api.g_varchar2)
4206: OR NVL(per_add_shd.g_old_rec.add_information19,hr_api.g_varchar2)

Line 4204: OR NVL(per_add_shd.g_old_rec.add_information18,hr_api.g_varchar2)

4200: <> NVL(p_add_information16,hr_api.g_varchar2)
4201: -- Bug 3216519 End Here
4202: OR NVL(per_add_shd.g_old_rec.add_information17,hr_api.g_varchar2)
4203: <> NVL(p_add_information17,hr_api.g_varchar2)
4204: OR NVL(per_add_shd.g_old_rec.add_information18,hr_api.g_varchar2)
4205: <> NVL(p_add_information18,hr_api.g_varchar2)
4206: OR NVL(per_add_shd.g_old_rec.add_information19,hr_api.g_varchar2)
4207: <> NVL(p_add_information19,hr_api.g_varchar2)
4208: OR NVL(per_add_shd.g_old_rec.add_information20,hr_api.g_varchar2)

Line 4206: OR NVL(per_add_shd.g_old_rec.add_information19,hr_api.g_varchar2)

4202: OR NVL(per_add_shd.g_old_rec.add_information17,hr_api.g_varchar2)
4203: <> NVL(p_add_information17,hr_api.g_varchar2)
4204: OR NVL(per_add_shd.g_old_rec.add_information18,hr_api.g_varchar2)
4205: <> NVL(p_add_information18,hr_api.g_varchar2)
4206: OR NVL(per_add_shd.g_old_rec.add_information19,hr_api.g_varchar2)
4207: <> NVL(p_add_information19,hr_api.g_varchar2)
4208: OR NVL(per_add_shd.g_old_rec.add_information20,hr_api.g_varchar2)
4209: <> NVL(p_add_information20,hr_api.g_varchar2)
4210: ) ) THEN

Line 4208: OR NVL(per_add_shd.g_old_rec.add_information20,hr_api.g_varchar2)

4204: OR NVL(per_add_shd.g_old_rec.add_information18,hr_api.g_varchar2)
4205: <> NVL(p_add_information18,hr_api.g_varchar2)
4206: OR NVL(per_add_shd.g_old_rec.add_information19,hr_api.g_varchar2)
4207: <> NVL(p_add_information19,hr_api.g_varchar2)
4208: OR NVL(per_add_shd.g_old_rec.add_information20,hr_api.g_varchar2)
4209: <> NVL(p_add_information20,hr_api.g_varchar2)
4210: ) ) THEN
4211: --
4212: --

Line 7219: per_add_shd.lck

7215: --
7216: IF p_address_id IS NOT NULL THEN
7217: hr_utility.set_location(l_proc, 40);
7218: --
7219: per_add_shd.lck
7220: (p_address_id => p_address_id
7221: ,p_object_version_number => p_addr_object_version_number);
7222: END IF;
7223: --