APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_ADD_SHD

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

4078: -- Desc: Modified the if condition.to replace address_line1 with style and date_from
4079: -- IF (p_address_id IS NULL AND p_address_line1 IS NOT NULL)
4080: IF (p_address_id IS NULL AND p_style IS NOT NULL and p_adr_date_from IS NOT NULL)
4081: OR (p_address_id IS NOT NULL AND (
4082: NVL(per_add_shd.g_old_rec.date_from,hr_api.g_date)
4083: <> NVL(p_adr_date_from,hr_api.g_date)
4084: OR NVL(per_add_shd.g_old_rec.style,hr_api.g_varchar2)
4085: <> NVL(p_style,hr_api.g_varchar2)
4086: OR NVL(per_add_shd.g_old_rec.address_line1,hr_api.g_varchar2)

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

4080: IF (p_address_id IS NULL AND p_style IS NOT NULL and p_adr_date_from IS NOT NULL)
4081: OR (p_address_id IS NOT NULL AND (
4082: NVL(per_add_shd.g_old_rec.date_from,hr_api.g_date)
4083: <> NVL(p_adr_date_from,hr_api.g_date)
4084: OR NVL(per_add_shd.g_old_rec.style,hr_api.g_varchar2)
4085: <> NVL(p_style,hr_api.g_varchar2)
4086: OR NVL(per_add_shd.g_old_rec.address_line1,hr_api.g_varchar2)
4087: <> NVL(p_address_line1,hr_api.g_varchar2)
4088: OR NVL(per_add_shd.g_old_rec.address_line2,hr_api.g_varchar2)

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

4082: NVL(per_add_shd.g_old_rec.date_from,hr_api.g_date)
4083: <> NVL(p_adr_date_from,hr_api.g_date)
4084: OR NVL(per_add_shd.g_old_rec.style,hr_api.g_varchar2)
4085: <> NVL(p_style,hr_api.g_varchar2)
4086: OR NVL(per_add_shd.g_old_rec.address_line1,hr_api.g_varchar2)
4087: <> NVL(p_address_line1,hr_api.g_varchar2)
4088: OR NVL(per_add_shd.g_old_rec.address_line2,hr_api.g_varchar2)
4089: <> NVL(p_address_line2,hr_api.g_varchar2)
4090: OR NVL(per_add_shd.g_old_rec.address_line3,hr_api.g_varchar2)

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

4084: OR NVL(per_add_shd.g_old_rec.style,hr_api.g_varchar2)
4085: <> NVL(p_style,hr_api.g_varchar2)
4086: OR NVL(per_add_shd.g_old_rec.address_line1,hr_api.g_varchar2)
4087: <> NVL(p_address_line1,hr_api.g_varchar2)
4088: OR NVL(per_add_shd.g_old_rec.address_line2,hr_api.g_varchar2)
4089: <> NVL(p_address_line2,hr_api.g_varchar2)
4090: OR NVL(per_add_shd.g_old_rec.address_line3,hr_api.g_varchar2)
4091: <> NVL(p_address_line3,hr_api.g_varchar2)
4092: OR NVL(per_add_shd.g_old_rec.address_type,hr_api.g_varchar2)

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

4086: OR NVL(per_add_shd.g_old_rec.address_line1,hr_api.g_varchar2)
4087: <> NVL(p_address_line1,hr_api.g_varchar2)
4088: OR NVL(per_add_shd.g_old_rec.address_line2,hr_api.g_varchar2)
4089: <> NVL(p_address_line2,hr_api.g_varchar2)
4090: OR NVL(per_add_shd.g_old_rec.address_line3,hr_api.g_varchar2)
4091: <> NVL(p_address_line3,hr_api.g_varchar2)
4092: OR NVL(per_add_shd.g_old_rec.address_type,hr_api.g_varchar2)
4093: <> NVL(p_address_type,hr_api.g_varchar2)
4094: OR NVL(per_add_shd.g_old_rec.country,hr_api.g_varchar2)

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

4088: OR NVL(per_add_shd.g_old_rec.address_line2,hr_api.g_varchar2)
4089: <> NVL(p_address_line2,hr_api.g_varchar2)
4090: OR NVL(per_add_shd.g_old_rec.address_line3,hr_api.g_varchar2)
4091: <> NVL(p_address_line3,hr_api.g_varchar2)
4092: OR NVL(per_add_shd.g_old_rec.address_type,hr_api.g_varchar2)
4093: <> NVL(p_address_type,hr_api.g_varchar2)
4094: OR NVL(per_add_shd.g_old_rec.country,hr_api.g_varchar2)
4095: <> NVL(p_country,hr_api.g_varchar2)
4096: OR NVL(per_add_shd.g_old_rec.date_to,hr_api.g_date)

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

4090: OR NVL(per_add_shd.g_old_rec.address_line3,hr_api.g_varchar2)
4091: <> NVL(p_address_line3,hr_api.g_varchar2)
4092: OR NVL(per_add_shd.g_old_rec.address_type,hr_api.g_varchar2)
4093: <> NVL(p_address_type,hr_api.g_varchar2)
4094: OR NVL(per_add_shd.g_old_rec.country,hr_api.g_varchar2)
4095: <> NVL(p_country,hr_api.g_varchar2)
4096: OR NVL(per_add_shd.g_old_rec.date_to,hr_api.g_date)
4097: <> NVL(p_adr_date_to,hr_api.g_date)
4098: OR NVL(per_add_shd.g_old_rec.postal_code,hr_api.g_varchar2)

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

4092: OR NVL(per_add_shd.g_old_rec.address_type,hr_api.g_varchar2)
4093: <> NVL(p_address_type,hr_api.g_varchar2)
4094: OR NVL(per_add_shd.g_old_rec.country,hr_api.g_varchar2)
4095: <> NVL(p_country,hr_api.g_varchar2)
4096: OR NVL(per_add_shd.g_old_rec.date_to,hr_api.g_date)
4097: <> NVL(p_adr_date_to,hr_api.g_date)
4098: OR NVL(per_add_shd.g_old_rec.postal_code,hr_api.g_varchar2)
4099: <> NVL(p_postal_code,hr_api.g_varchar2)
4100: OR NVL(per_add_shd.g_old_rec.region_1,hr_api.g_varchar2)

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

4094: OR NVL(per_add_shd.g_old_rec.country,hr_api.g_varchar2)
4095: <> NVL(p_country,hr_api.g_varchar2)
4096: OR NVL(per_add_shd.g_old_rec.date_to,hr_api.g_date)
4097: <> NVL(p_adr_date_to,hr_api.g_date)
4098: OR NVL(per_add_shd.g_old_rec.postal_code,hr_api.g_varchar2)
4099: <> NVL(p_postal_code,hr_api.g_varchar2)
4100: OR NVL(per_add_shd.g_old_rec.region_1,hr_api.g_varchar2)
4101: <> NVL(p_region_1,hr_api.g_varchar2)
4102: OR NVL(per_add_shd.g_old_rec.region_2,hr_api.g_varchar2)

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

4096: OR NVL(per_add_shd.g_old_rec.date_to,hr_api.g_date)
4097: <> NVL(p_adr_date_to,hr_api.g_date)
4098: OR NVL(per_add_shd.g_old_rec.postal_code,hr_api.g_varchar2)
4099: <> NVL(p_postal_code,hr_api.g_varchar2)
4100: OR NVL(per_add_shd.g_old_rec.region_1,hr_api.g_varchar2)
4101: <> NVL(p_region_1,hr_api.g_varchar2)
4102: OR NVL(per_add_shd.g_old_rec.region_2,hr_api.g_varchar2)
4103: <> NVL(p_region_2,hr_api.g_varchar2)
4104: OR NVL(per_add_shd.g_old_rec.region_3,hr_api.g_varchar2)

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

4098: OR NVL(per_add_shd.g_old_rec.postal_code,hr_api.g_varchar2)
4099: <> NVL(p_postal_code,hr_api.g_varchar2)
4100: OR NVL(per_add_shd.g_old_rec.region_1,hr_api.g_varchar2)
4101: <> NVL(p_region_1,hr_api.g_varchar2)
4102: OR NVL(per_add_shd.g_old_rec.region_2,hr_api.g_varchar2)
4103: <> NVL(p_region_2,hr_api.g_varchar2)
4104: OR NVL(per_add_shd.g_old_rec.region_3,hr_api.g_varchar2)
4105: <> NVL(p_region_3,hr_api.g_varchar2)
4106: OR NVL(per_add_shd.g_old_rec.town_or_city,hr_api.g_varchar2)

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

4100: OR NVL(per_add_shd.g_old_rec.region_1,hr_api.g_varchar2)
4101: <> NVL(p_region_1,hr_api.g_varchar2)
4102: OR NVL(per_add_shd.g_old_rec.region_2,hr_api.g_varchar2)
4103: <> NVL(p_region_2,hr_api.g_varchar2)
4104: OR NVL(per_add_shd.g_old_rec.region_3,hr_api.g_varchar2)
4105: <> NVL(p_region_3,hr_api.g_varchar2)
4106: OR NVL(per_add_shd.g_old_rec.town_or_city,hr_api.g_varchar2)
4107: <> NVL(p_town_or_city,hr_api.g_varchar2)
4108: OR NVL(per_add_shd.g_old_rec.telephone_number_1,hr_api.g_varchar2)

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

4102: OR NVL(per_add_shd.g_old_rec.region_2,hr_api.g_varchar2)
4103: <> NVL(p_region_2,hr_api.g_varchar2)
4104: OR NVL(per_add_shd.g_old_rec.region_3,hr_api.g_varchar2)
4105: <> NVL(p_region_3,hr_api.g_varchar2)
4106: OR NVL(per_add_shd.g_old_rec.town_or_city,hr_api.g_varchar2)
4107: <> NVL(p_town_or_city,hr_api.g_varchar2)
4108: OR NVL(per_add_shd.g_old_rec.telephone_number_1,hr_api.g_varchar2)
4109: <> NVL(p_telephone_number_1,hr_api.g_varchar2)
4110: OR NVL(per_add_shd.g_old_rec.telephone_number_2,hr_api.g_varchar2)

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

4104: OR NVL(per_add_shd.g_old_rec.region_3,hr_api.g_varchar2)
4105: <> NVL(p_region_3,hr_api.g_varchar2)
4106: OR NVL(per_add_shd.g_old_rec.town_or_city,hr_api.g_varchar2)
4107: <> NVL(p_town_or_city,hr_api.g_varchar2)
4108: OR NVL(per_add_shd.g_old_rec.telephone_number_1,hr_api.g_varchar2)
4109: <> NVL(p_telephone_number_1,hr_api.g_varchar2)
4110: OR NVL(per_add_shd.g_old_rec.telephone_number_2,hr_api.g_varchar2)
4111: <> NVL(p_telephone_number_2,hr_api.g_varchar2)
4112: OR NVL(per_add_shd.g_old_rec.telephone_number_3,hr_api.g_varchar2)

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

4106: OR NVL(per_add_shd.g_old_rec.town_or_city,hr_api.g_varchar2)
4107: <> NVL(p_town_or_city,hr_api.g_varchar2)
4108: OR NVL(per_add_shd.g_old_rec.telephone_number_1,hr_api.g_varchar2)
4109: <> NVL(p_telephone_number_1,hr_api.g_varchar2)
4110: OR NVL(per_add_shd.g_old_rec.telephone_number_2,hr_api.g_varchar2)
4111: <> NVL(p_telephone_number_2,hr_api.g_varchar2)
4112: OR NVL(per_add_shd.g_old_rec.telephone_number_3,hr_api.g_varchar2)
4113: <> NVL(p_telephone_number_3,hr_api.g_varchar2)
4114: OR NVL(per_add_shd.g_old_rec.addr_attribute_category,hr_api.g_varchar2)

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

4108: OR NVL(per_add_shd.g_old_rec.telephone_number_1,hr_api.g_varchar2)
4109: <> NVL(p_telephone_number_1,hr_api.g_varchar2)
4110: OR NVL(per_add_shd.g_old_rec.telephone_number_2,hr_api.g_varchar2)
4111: <> NVL(p_telephone_number_2,hr_api.g_varchar2)
4112: OR NVL(per_add_shd.g_old_rec.telephone_number_3,hr_api.g_varchar2)
4113: <> NVL(p_telephone_number_3,hr_api.g_varchar2)
4114: OR NVL(per_add_shd.g_old_rec.addr_attribute_category,hr_api.g_varchar2)
4115: <> NVL(p_addr_attribute_category,hr_api.g_varchar2)
4116: OR NVL(per_add_shd.g_old_rec.addr_attribute1,hr_api.g_varchar2)

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

4110: OR NVL(per_add_shd.g_old_rec.telephone_number_2,hr_api.g_varchar2)
4111: <> NVL(p_telephone_number_2,hr_api.g_varchar2)
4112: OR NVL(per_add_shd.g_old_rec.telephone_number_3,hr_api.g_varchar2)
4113: <> NVL(p_telephone_number_3,hr_api.g_varchar2)
4114: OR NVL(per_add_shd.g_old_rec.addr_attribute_category,hr_api.g_varchar2)
4115: <> NVL(p_addr_attribute_category,hr_api.g_varchar2)
4116: OR NVL(per_add_shd.g_old_rec.addr_attribute1,hr_api.g_varchar2)
4117: <> NVL(p_addr_attribute1,hr_api.g_varchar2)
4118: OR NVL(per_add_shd.g_old_rec.addr_attribute2,hr_api.g_varchar2)

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

4112: OR NVL(per_add_shd.g_old_rec.telephone_number_3,hr_api.g_varchar2)
4113: <> NVL(p_telephone_number_3,hr_api.g_varchar2)
4114: OR NVL(per_add_shd.g_old_rec.addr_attribute_category,hr_api.g_varchar2)
4115: <> NVL(p_addr_attribute_category,hr_api.g_varchar2)
4116: OR NVL(per_add_shd.g_old_rec.addr_attribute1,hr_api.g_varchar2)
4117: <> NVL(p_addr_attribute1,hr_api.g_varchar2)
4118: OR NVL(per_add_shd.g_old_rec.addr_attribute2,hr_api.g_varchar2)
4119: <> NVL(p_addr_attribute2,hr_api.g_varchar2)
4120: OR NVL(per_add_shd.g_old_rec.addr_attribute3,hr_api.g_varchar2)

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

4114: OR NVL(per_add_shd.g_old_rec.addr_attribute_category,hr_api.g_varchar2)
4115: <> NVL(p_addr_attribute_category,hr_api.g_varchar2)
4116: OR NVL(per_add_shd.g_old_rec.addr_attribute1,hr_api.g_varchar2)
4117: <> NVL(p_addr_attribute1,hr_api.g_varchar2)
4118: OR NVL(per_add_shd.g_old_rec.addr_attribute2,hr_api.g_varchar2)
4119: <> NVL(p_addr_attribute2,hr_api.g_varchar2)
4120: OR NVL(per_add_shd.g_old_rec.addr_attribute3,hr_api.g_varchar2)
4121: <> NVL(p_addr_attribute3,hr_api.g_varchar2)
4122: OR NVL(per_add_shd.g_old_rec.addr_attribute4,hr_api.g_varchar2)

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

4116: OR NVL(per_add_shd.g_old_rec.addr_attribute1,hr_api.g_varchar2)
4117: <> NVL(p_addr_attribute1,hr_api.g_varchar2)
4118: OR NVL(per_add_shd.g_old_rec.addr_attribute2,hr_api.g_varchar2)
4119: <> NVL(p_addr_attribute2,hr_api.g_varchar2)
4120: OR NVL(per_add_shd.g_old_rec.addr_attribute3,hr_api.g_varchar2)
4121: <> NVL(p_addr_attribute3,hr_api.g_varchar2)
4122: OR NVL(per_add_shd.g_old_rec.addr_attribute4,hr_api.g_varchar2)
4123: <> NVL(p_addr_attribute4,hr_api.g_varchar2)
4124: OR NVL(per_add_shd.g_old_rec.addr_attribute5,hr_api.g_varchar2)

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

4118: OR NVL(per_add_shd.g_old_rec.addr_attribute2,hr_api.g_varchar2)
4119: <> NVL(p_addr_attribute2,hr_api.g_varchar2)
4120: OR NVL(per_add_shd.g_old_rec.addr_attribute3,hr_api.g_varchar2)
4121: <> NVL(p_addr_attribute3,hr_api.g_varchar2)
4122: OR NVL(per_add_shd.g_old_rec.addr_attribute4,hr_api.g_varchar2)
4123: <> NVL(p_addr_attribute4,hr_api.g_varchar2)
4124: OR NVL(per_add_shd.g_old_rec.addr_attribute5,hr_api.g_varchar2)
4125: <> NVL(p_addr_attribute5,hr_api.g_varchar2)
4126: OR NVL(per_add_shd.g_old_rec.addr_attribute6,hr_api.g_varchar2)

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

4120: OR NVL(per_add_shd.g_old_rec.addr_attribute3,hr_api.g_varchar2)
4121: <> NVL(p_addr_attribute3,hr_api.g_varchar2)
4122: OR NVL(per_add_shd.g_old_rec.addr_attribute4,hr_api.g_varchar2)
4123: <> NVL(p_addr_attribute4,hr_api.g_varchar2)
4124: OR NVL(per_add_shd.g_old_rec.addr_attribute5,hr_api.g_varchar2)
4125: <> NVL(p_addr_attribute5,hr_api.g_varchar2)
4126: OR NVL(per_add_shd.g_old_rec.addr_attribute6,hr_api.g_varchar2)
4127: <> NVL(p_addr_attribute6,hr_api.g_varchar2)
4128: OR NVL(per_add_shd.g_old_rec.addr_attribute7,hr_api.g_varchar2)

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

4122: OR NVL(per_add_shd.g_old_rec.addr_attribute4,hr_api.g_varchar2)
4123: <> NVL(p_addr_attribute4,hr_api.g_varchar2)
4124: OR NVL(per_add_shd.g_old_rec.addr_attribute5,hr_api.g_varchar2)
4125: <> NVL(p_addr_attribute5,hr_api.g_varchar2)
4126: OR NVL(per_add_shd.g_old_rec.addr_attribute6,hr_api.g_varchar2)
4127: <> NVL(p_addr_attribute6,hr_api.g_varchar2)
4128: OR NVL(per_add_shd.g_old_rec.addr_attribute7,hr_api.g_varchar2)
4129: <> NVL(p_addr_attribute7,hr_api.g_varchar2)
4130: OR NVL(per_add_shd.g_old_rec.addr_attribute8,hr_api.g_varchar2)

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

4124: OR NVL(per_add_shd.g_old_rec.addr_attribute5,hr_api.g_varchar2)
4125: <> NVL(p_addr_attribute5,hr_api.g_varchar2)
4126: OR NVL(per_add_shd.g_old_rec.addr_attribute6,hr_api.g_varchar2)
4127: <> NVL(p_addr_attribute6,hr_api.g_varchar2)
4128: OR NVL(per_add_shd.g_old_rec.addr_attribute7,hr_api.g_varchar2)
4129: <> NVL(p_addr_attribute7,hr_api.g_varchar2)
4130: OR NVL(per_add_shd.g_old_rec.addr_attribute8,hr_api.g_varchar2)
4131: <> NVL(p_addr_attribute8,hr_api.g_varchar2)
4132: OR NVL(per_add_shd.g_old_rec.addr_attribute9,hr_api.g_varchar2)

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

4126: OR NVL(per_add_shd.g_old_rec.addr_attribute6,hr_api.g_varchar2)
4127: <> NVL(p_addr_attribute6,hr_api.g_varchar2)
4128: OR NVL(per_add_shd.g_old_rec.addr_attribute7,hr_api.g_varchar2)
4129: <> NVL(p_addr_attribute7,hr_api.g_varchar2)
4130: OR NVL(per_add_shd.g_old_rec.addr_attribute8,hr_api.g_varchar2)
4131: <> NVL(p_addr_attribute8,hr_api.g_varchar2)
4132: OR NVL(per_add_shd.g_old_rec.addr_attribute9,hr_api.g_varchar2)
4133: <> NVL(p_addr_attribute9,hr_api.g_varchar2)
4134: OR NVL(per_add_shd.g_old_rec.addr_attribute10,hr_api.g_varchar2)

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

4128: OR NVL(per_add_shd.g_old_rec.addr_attribute7,hr_api.g_varchar2)
4129: <> NVL(p_addr_attribute7,hr_api.g_varchar2)
4130: OR NVL(per_add_shd.g_old_rec.addr_attribute8,hr_api.g_varchar2)
4131: <> NVL(p_addr_attribute8,hr_api.g_varchar2)
4132: OR NVL(per_add_shd.g_old_rec.addr_attribute9,hr_api.g_varchar2)
4133: <> NVL(p_addr_attribute9,hr_api.g_varchar2)
4134: OR NVL(per_add_shd.g_old_rec.addr_attribute10,hr_api.g_varchar2)
4135: <> NVL(p_addr_attribute10,hr_api.g_varchar2)
4136: OR NVL(per_add_shd.g_old_rec.addr_attribute11,hr_api.g_varchar2)

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

4130: OR NVL(per_add_shd.g_old_rec.addr_attribute8,hr_api.g_varchar2)
4131: <> NVL(p_addr_attribute8,hr_api.g_varchar2)
4132: OR NVL(per_add_shd.g_old_rec.addr_attribute9,hr_api.g_varchar2)
4133: <> NVL(p_addr_attribute9,hr_api.g_varchar2)
4134: OR NVL(per_add_shd.g_old_rec.addr_attribute10,hr_api.g_varchar2)
4135: <> NVL(p_addr_attribute10,hr_api.g_varchar2)
4136: OR NVL(per_add_shd.g_old_rec.addr_attribute11,hr_api.g_varchar2)
4137: <> NVL(p_addr_attribute11,hr_api.g_varchar2)
4138: OR NVL(per_add_shd.g_old_rec.addr_attribute12,hr_api.g_varchar2)

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

4132: OR NVL(per_add_shd.g_old_rec.addr_attribute9,hr_api.g_varchar2)
4133: <> NVL(p_addr_attribute9,hr_api.g_varchar2)
4134: OR NVL(per_add_shd.g_old_rec.addr_attribute10,hr_api.g_varchar2)
4135: <> NVL(p_addr_attribute10,hr_api.g_varchar2)
4136: OR NVL(per_add_shd.g_old_rec.addr_attribute11,hr_api.g_varchar2)
4137: <> NVL(p_addr_attribute11,hr_api.g_varchar2)
4138: OR NVL(per_add_shd.g_old_rec.addr_attribute12,hr_api.g_varchar2)
4139: <> NVL(p_addr_attribute12,hr_api.g_varchar2)
4140: OR NVL(per_add_shd.g_old_rec.addr_attribute13,hr_api.g_varchar2)

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

4134: OR NVL(per_add_shd.g_old_rec.addr_attribute10,hr_api.g_varchar2)
4135: <> NVL(p_addr_attribute10,hr_api.g_varchar2)
4136: OR NVL(per_add_shd.g_old_rec.addr_attribute11,hr_api.g_varchar2)
4137: <> NVL(p_addr_attribute11,hr_api.g_varchar2)
4138: OR NVL(per_add_shd.g_old_rec.addr_attribute12,hr_api.g_varchar2)
4139: <> NVL(p_addr_attribute12,hr_api.g_varchar2)
4140: OR NVL(per_add_shd.g_old_rec.addr_attribute13,hr_api.g_varchar2)
4141: <> NVL(p_addr_attribute13,hr_api.g_varchar2)
4142: OR NVL(per_add_shd.g_old_rec.addr_attribute14,hr_api.g_varchar2)

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

4136: OR NVL(per_add_shd.g_old_rec.addr_attribute11,hr_api.g_varchar2)
4137: <> NVL(p_addr_attribute11,hr_api.g_varchar2)
4138: OR NVL(per_add_shd.g_old_rec.addr_attribute12,hr_api.g_varchar2)
4139: <> NVL(p_addr_attribute12,hr_api.g_varchar2)
4140: OR NVL(per_add_shd.g_old_rec.addr_attribute13,hr_api.g_varchar2)
4141: <> NVL(p_addr_attribute13,hr_api.g_varchar2)
4142: OR NVL(per_add_shd.g_old_rec.addr_attribute14,hr_api.g_varchar2)
4143: <> NVL(p_addr_attribute14,hr_api.g_varchar2)
4144: OR NVL(per_add_shd.g_old_rec.addr_attribute15,hr_api.g_varchar2)

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

4138: OR NVL(per_add_shd.g_old_rec.addr_attribute12,hr_api.g_varchar2)
4139: <> NVL(p_addr_attribute12,hr_api.g_varchar2)
4140: OR NVL(per_add_shd.g_old_rec.addr_attribute13,hr_api.g_varchar2)
4141: <> NVL(p_addr_attribute13,hr_api.g_varchar2)
4142: OR NVL(per_add_shd.g_old_rec.addr_attribute14,hr_api.g_varchar2)
4143: <> NVL(p_addr_attribute14,hr_api.g_varchar2)
4144: OR NVL(per_add_shd.g_old_rec.addr_attribute15,hr_api.g_varchar2)
4145: <> NVL(p_addr_attribute15,hr_api.g_varchar2)
4146: OR NVL(per_add_shd.g_old_rec.addr_attribute16,hr_api.g_varchar2)

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

4140: OR NVL(per_add_shd.g_old_rec.addr_attribute13,hr_api.g_varchar2)
4141: <> NVL(p_addr_attribute13,hr_api.g_varchar2)
4142: OR NVL(per_add_shd.g_old_rec.addr_attribute14,hr_api.g_varchar2)
4143: <> NVL(p_addr_attribute14,hr_api.g_varchar2)
4144: OR NVL(per_add_shd.g_old_rec.addr_attribute15,hr_api.g_varchar2)
4145: <> NVL(p_addr_attribute15,hr_api.g_varchar2)
4146: OR NVL(per_add_shd.g_old_rec.addr_attribute16,hr_api.g_varchar2)
4147: <> NVL(p_addr_attribute16,hr_api.g_varchar2)
4148: OR NVL(per_add_shd.g_old_rec.addr_attribute17,hr_api.g_varchar2)

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

4142: OR NVL(per_add_shd.g_old_rec.addr_attribute14,hr_api.g_varchar2)
4143: <> NVL(p_addr_attribute14,hr_api.g_varchar2)
4144: OR NVL(per_add_shd.g_old_rec.addr_attribute15,hr_api.g_varchar2)
4145: <> NVL(p_addr_attribute15,hr_api.g_varchar2)
4146: OR NVL(per_add_shd.g_old_rec.addr_attribute16,hr_api.g_varchar2)
4147: <> NVL(p_addr_attribute16,hr_api.g_varchar2)
4148: OR NVL(per_add_shd.g_old_rec.addr_attribute17,hr_api.g_varchar2)
4149: <> NVL(p_addr_attribute17,hr_api.g_varchar2)
4150: OR NVL(per_add_shd.g_old_rec.addr_attribute18,hr_api.g_varchar2)

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

4144: OR NVL(per_add_shd.g_old_rec.addr_attribute15,hr_api.g_varchar2)
4145: <> NVL(p_addr_attribute15,hr_api.g_varchar2)
4146: OR NVL(per_add_shd.g_old_rec.addr_attribute16,hr_api.g_varchar2)
4147: <> NVL(p_addr_attribute16,hr_api.g_varchar2)
4148: OR NVL(per_add_shd.g_old_rec.addr_attribute17,hr_api.g_varchar2)
4149: <> NVL(p_addr_attribute17,hr_api.g_varchar2)
4150: OR NVL(per_add_shd.g_old_rec.addr_attribute18,hr_api.g_varchar2)
4151: <> NVL(p_addr_attribute18,hr_api.g_varchar2)
4152: OR NVL(per_add_shd.g_old_rec.addr_attribute19,hr_api.g_varchar2)

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

4146: OR NVL(per_add_shd.g_old_rec.addr_attribute16,hr_api.g_varchar2)
4147: <> NVL(p_addr_attribute16,hr_api.g_varchar2)
4148: OR NVL(per_add_shd.g_old_rec.addr_attribute17,hr_api.g_varchar2)
4149: <> NVL(p_addr_attribute17,hr_api.g_varchar2)
4150: OR NVL(per_add_shd.g_old_rec.addr_attribute18,hr_api.g_varchar2)
4151: <> NVL(p_addr_attribute18,hr_api.g_varchar2)
4152: OR NVL(per_add_shd.g_old_rec.addr_attribute19,hr_api.g_varchar2)
4153: <> NVL(p_addr_attribute19,hr_api.g_varchar2)
4154: OR NVL(per_add_shd.g_old_rec.addr_attribute20,hr_api.g_varchar2)

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

4148: OR NVL(per_add_shd.g_old_rec.addr_attribute17,hr_api.g_varchar2)
4149: <> NVL(p_addr_attribute17,hr_api.g_varchar2)
4150: OR NVL(per_add_shd.g_old_rec.addr_attribute18,hr_api.g_varchar2)
4151: <> NVL(p_addr_attribute18,hr_api.g_varchar2)
4152: OR NVL(per_add_shd.g_old_rec.addr_attribute19,hr_api.g_varchar2)
4153: <> NVL(p_addr_attribute19,hr_api.g_varchar2)
4154: OR NVL(per_add_shd.g_old_rec.addr_attribute20,hr_api.g_varchar2)
4155: <> NVL(p_addr_attribute20,hr_api.g_varchar2)
4156: -- Bug 3216519 Start Here

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

4150: OR NVL(per_add_shd.g_old_rec.addr_attribute18,hr_api.g_varchar2)
4151: <> NVL(p_addr_attribute18,hr_api.g_varchar2)
4152: OR NVL(per_add_shd.g_old_rec.addr_attribute19,hr_api.g_varchar2)
4153: <> NVL(p_addr_attribute19,hr_api.g_varchar2)
4154: OR NVL(per_add_shd.g_old_rec.addr_attribute20,hr_api.g_varchar2)
4155: <> NVL(p_addr_attribute20,hr_api.g_varchar2)
4156: -- Bug 3216519 Start Here
4157: OR NVL(per_add_shd.g_old_rec.add_information13,hr_api.g_varchar2)
4158: <> NVL(p_add_information13,hr_api.g_varchar2)

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

4153: <> NVL(p_addr_attribute19,hr_api.g_varchar2)
4154: OR NVL(per_add_shd.g_old_rec.addr_attribute20,hr_api.g_varchar2)
4155: <> NVL(p_addr_attribute20,hr_api.g_varchar2)
4156: -- Bug 3216519 Start Here
4157: OR NVL(per_add_shd.g_old_rec.add_information13,hr_api.g_varchar2)
4158: <> NVL(p_add_information13,hr_api.g_varchar2)
4159: OR NVL(per_add_shd.g_old_rec.add_information14,hr_api.g_varchar2)
4160: <> NVL(p_add_information14,hr_api.g_varchar2)
4161: OR NVL(per_add_shd.g_old_rec.add_information15,hr_api.g_varchar2)

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

4155: <> NVL(p_addr_attribute20,hr_api.g_varchar2)
4156: -- Bug 3216519 Start Here
4157: OR NVL(per_add_shd.g_old_rec.add_information13,hr_api.g_varchar2)
4158: <> NVL(p_add_information13,hr_api.g_varchar2)
4159: OR NVL(per_add_shd.g_old_rec.add_information14,hr_api.g_varchar2)
4160: <> NVL(p_add_information14,hr_api.g_varchar2)
4161: OR NVL(per_add_shd.g_old_rec.add_information15,hr_api.g_varchar2)
4162: <> NVL(p_add_information15,hr_api.g_varchar2)
4163: OR NVL(per_add_shd.g_old_rec.add_information16,hr_api.g_varchar2)

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

4157: OR NVL(per_add_shd.g_old_rec.add_information13,hr_api.g_varchar2)
4158: <> NVL(p_add_information13,hr_api.g_varchar2)
4159: OR NVL(per_add_shd.g_old_rec.add_information14,hr_api.g_varchar2)
4160: <> NVL(p_add_information14,hr_api.g_varchar2)
4161: OR NVL(per_add_shd.g_old_rec.add_information15,hr_api.g_varchar2)
4162: <> NVL(p_add_information15,hr_api.g_varchar2)
4163: OR NVL(per_add_shd.g_old_rec.add_information16,hr_api.g_varchar2)
4164: <> NVL(p_add_information16,hr_api.g_varchar2)
4165: -- Bug 3216519 End Here

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

4159: OR NVL(per_add_shd.g_old_rec.add_information14,hr_api.g_varchar2)
4160: <> NVL(p_add_information14,hr_api.g_varchar2)
4161: OR NVL(per_add_shd.g_old_rec.add_information15,hr_api.g_varchar2)
4162: <> NVL(p_add_information15,hr_api.g_varchar2)
4163: OR NVL(per_add_shd.g_old_rec.add_information16,hr_api.g_varchar2)
4164: <> NVL(p_add_information16,hr_api.g_varchar2)
4165: -- Bug 3216519 End Here
4166: OR NVL(per_add_shd.g_old_rec.add_information17,hr_api.g_varchar2)
4167: <> NVL(p_add_information17,hr_api.g_varchar2)

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

4162: <> NVL(p_add_information15,hr_api.g_varchar2)
4163: OR NVL(per_add_shd.g_old_rec.add_information16,hr_api.g_varchar2)
4164: <> NVL(p_add_information16,hr_api.g_varchar2)
4165: -- Bug 3216519 End Here
4166: OR NVL(per_add_shd.g_old_rec.add_information17,hr_api.g_varchar2)
4167: <> NVL(p_add_information17,hr_api.g_varchar2)
4168: OR NVL(per_add_shd.g_old_rec.add_information18,hr_api.g_varchar2)
4169: <> NVL(p_add_information18,hr_api.g_varchar2)
4170: OR NVL(per_add_shd.g_old_rec.add_information19,hr_api.g_varchar2)

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

4164: <> NVL(p_add_information16,hr_api.g_varchar2)
4165: -- Bug 3216519 End Here
4166: OR NVL(per_add_shd.g_old_rec.add_information17,hr_api.g_varchar2)
4167: <> NVL(p_add_information17,hr_api.g_varchar2)
4168: OR NVL(per_add_shd.g_old_rec.add_information18,hr_api.g_varchar2)
4169: <> NVL(p_add_information18,hr_api.g_varchar2)
4170: OR NVL(per_add_shd.g_old_rec.add_information19,hr_api.g_varchar2)
4171: <> NVL(p_add_information19,hr_api.g_varchar2)
4172: OR NVL(per_add_shd.g_old_rec.add_information20,hr_api.g_varchar2)

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

4166: OR NVL(per_add_shd.g_old_rec.add_information17,hr_api.g_varchar2)
4167: <> NVL(p_add_information17,hr_api.g_varchar2)
4168: OR NVL(per_add_shd.g_old_rec.add_information18,hr_api.g_varchar2)
4169: <> NVL(p_add_information18,hr_api.g_varchar2)
4170: OR NVL(per_add_shd.g_old_rec.add_information19,hr_api.g_varchar2)
4171: <> NVL(p_add_information19,hr_api.g_varchar2)
4172: OR NVL(per_add_shd.g_old_rec.add_information20,hr_api.g_varchar2)
4173: <> NVL(p_add_information20,hr_api.g_varchar2)
4174: ) ) THEN

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

4168: OR NVL(per_add_shd.g_old_rec.add_information18,hr_api.g_varchar2)
4169: <> NVL(p_add_information18,hr_api.g_varchar2)
4170: OR NVL(per_add_shd.g_old_rec.add_information19,hr_api.g_varchar2)
4171: <> NVL(p_add_information19,hr_api.g_varchar2)
4172: OR NVL(per_add_shd.g_old_rec.add_information20,hr_api.g_varchar2)
4173: <> NVL(p_add_information20,hr_api.g_varchar2)
4174: ) ) THEN
4175: --
4176: --

Line 7179: per_add_shd.lck

7175: --
7176: IF p_address_id IS NOT NULL THEN
7177: hr_utility.set_location(l_proc, 40);
7178: --
7179: per_add_shd.lck
7180: (p_address_id => p_address_id
7181: ,p_object_version_number => p_addr_object_version_number);
7182: END IF;
7183: --