APPS.GHR_HISTORY_CONV_RG dependencies on PER_ADDRESSES

Line 3271: -- to the per_addresses type record.

3267: end conv_to_element_entry_rg;
3268:
3269:
3270: -- Procedure conv_to_addresses_rg copies the individual fields supplied as parameters
3271: -- to the per_addresses type record.
3272: Procedure conv_to_addresses_rg(
3273: p_address_id in per_addresses.address_id%type default null,
3274: p_business_group_id in per_addresses.business_group_id%type default null,
3275: p_person_id in per_addresses.person_id%type default null,

Line 3273: p_address_id in per_addresses.address_id%type default null,

3269:
3270: -- Procedure conv_to_addresses_rg copies the individual fields supplied as parameters
3271: -- to the per_addresses type record.
3272: Procedure conv_to_addresses_rg(
3273: p_address_id in per_addresses.address_id%type default null,
3274: p_business_group_id in per_addresses.business_group_id%type default null,
3275: p_person_id in per_addresses.person_id%type default null,
3276: p_date_from in per_addresses.date_from%type default null,
3277: p_primary_flag in per_addresses.primary_flag%type default null,

Line 3274: p_business_group_id in per_addresses.business_group_id%type default null,

3270: -- Procedure conv_to_addresses_rg copies the individual fields supplied as parameters
3271: -- to the per_addresses type record.
3272: Procedure conv_to_addresses_rg(
3273: p_address_id in per_addresses.address_id%type default null,
3274: p_business_group_id in per_addresses.business_group_id%type default null,
3275: p_person_id in per_addresses.person_id%type default null,
3276: p_date_from in per_addresses.date_from%type default null,
3277: p_primary_flag in per_addresses.primary_flag%type default null,
3278: p_style in per_addresses.style%type default null,

Line 3275: p_person_id in per_addresses.person_id%type default null,

3271: -- to the per_addresses type record.
3272: Procedure conv_to_addresses_rg(
3273: p_address_id in per_addresses.address_id%type default null,
3274: p_business_group_id in per_addresses.business_group_id%type default null,
3275: p_person_id in per_addresses.person_id%type default null,
3276: p_date_from in per_addresses.date_from%type default null,
3277: p_primary_flag in per_addresses.primary_flag%type default null,
3278: p_style in per_addresses.style%type default null,
3279: p_address_line1 in per_addresses.address_line1%type default null,

Line 3276: p_date_from in per_addresses.date_from%type default null,

3272: Procedure conv_to_addresses_rg(
3273: p_address_id in per_addresses.address_id%type default null,
3274: p_business_group_id in per_addresses.business_group_id%type default null,
3275: p_person_id in per_addresses.person_id%type default null,
3276: p_date_from in per_addresses.date_from%type default null,
3277: p_primary_flag in per_addresses.primary_flag%type default null,
3278: p_style in per_addresses.style%type default null,
3279: p_address_line1 in per_addresses.address_line1%type default null,
3280: p_address_line2 in per_addresses.address_line2%type default null,

Line 3277: p_primary_flag in per_addresses.primary_flag%type default null,

3273: p_address_id in per_addresses.address_id%type default null,
3274: p_business_group_id in per_addresses.business_group_id%type default null,
3275: p_person_id in per_addresses.person_id%type default null,
3276: p_date_from in per_addresses.date_from%type default null,
3277: p_primary_flag in per_addresses.primary_flag%type default null,
3278: p_style in per_addresses.style%type default null,
3279: p_address_line1 in per_addresses.address_line1%type default null,
3280: p_address_line2 in per_addresses.address_line2%type default null,
3281: p_address_line3 in per_addresses.address_line3%type default null,

Line 3278: p_style in per_addresses.style%type default null,

3274: p_business_group_id in per_addresses.business_group_id%type default null,
3275: p_person_id in per_addresses.person_id%type default null,
3276: p_date_from in per_addresses.date_from%type default null,
3277: p_primary_flag in per_addresses.primary_flag%type default null,
3278: p_style in per_addresses.style%type default null,
3279: p_address_line1 in per_addresses.address_line1%type default null,
3280: p_address_line2 in per_addresses.address_line2%type default null,
3281: p_address_line3 in per_addresses.address_line3%type default null,
3282: p_address_type in per_addresses.address_type%type default null,

Line 3279: p_address_line1 in per_addresses.address_line1%type default null,

3275: p_person_id in per_addresses.person_id%type default null,
3276: p_date_from in per_addresses.date_from%type default null,
3277: p_primary_flag in per_addresses.primary_flag%type default null,
3278: p_style in per_addresses.style%type default null,
3279: p_address_line1 in per_addresses.address_line1%type default null,
3280: p_address_line2 in per_addresses.address_line2%type default null,
3281: p_address_line3 in per_addresses.address_line3%type default null,
3282: p_address_type in per_addresses.address_type%type default null,
3283: -- p_comments in per_addresses.comments%type default null,

Line 3280: p_address_line2 in per_addresses.address_line2%type default null,

3276: p_date_from in per_addresses.date_from%type default null,
3277: p_primary_flag in per_addresses.primary_flag%type default null,
3278: p_style in per_addresses.style%type default null,
3279: p_address_line1 in per_addresses.address_line1%type default null,
3280: p_address_line2 in per_addresses.address_line2%type default null,
3281: p_address_line3 in per_addresses.address_line3%type default null,
3282: p_address_type in per_addresses.address_type%type default null,
3283: -- p_comments in per_addresses.comments%type default null,
3284: p_country in per_addresses.country%type default null,

Line 3281: p_address_line3 in per_addresses.address_line3%type default null,

3277: p_primary_flag in per_addresses.primary_flag%type default null,
3278: p_style in per_addresses.style%type default null,
3279: p_address_line1 in per_addresses.address_line1%type default null,
3280: p_address_line2 in per_addresses.address_line2%type default null,
3281: p_address_line3 in per_addresses.address_line3%type default null,
3282: p_address_type in per_addresses.address_type%type default null,
3283: -- p_comments in per_addresses.comments%type default null,
3284: p_country in per_addresses.country%type default null,
3285: p_date_to in per_addresses.date_to%type default null,

Line 3282: p_address_type in per_addresses.address_type%type default null,

3278: p_style in per_addresses.style%type default null,
3279: p_address_line1 in per_addresses.address_line1%type default null,
3280: p_address_line2 in per_addresses.address_line2%type default null,
3281: p_address_line3 in per_addresses.address_line3%type default null,
3282: p_address_type in per_addresses.address_type%type default null,
3283: -- p_comments in per_addresses.comments%type default null,
3284: p_country in per_addresses.country%type default null,
3285: p_date_to in per_addresses.date_to%type default null,
3286: p_postal_code in per_addresses.postal_code%type default null,

Line 3283: -- p_comments in per_addresses.comments%type default null,

3279: p_address_line1 in per_addresses.address_line1%type default null,
3280: p_address_line2 in per_addresses.address_line2%type default null,
3281: p_address_line3 in per_addresses.address_line3%type default null,
3282: p_address_type in per_addresses.address_type%type default null,
3283: -- p_comments in per_addresses.comments%type default null,
3284: p_country in per_addresses.country%type default null,
3285: p_date_to in per_addresses.date_to%type default null,
3286: p_postal_code in per_addresses.postal_code%type default null,
3287: p_region_1 in per_addresses.region_1%type default null,

Line 3284: p_country in per_addresses.country%type default null,

3280: p_address_line2 in per_addresses.address_line2%type default null,
3281: p_address_line3 in per_addresses.address_line3%type default null,
3282: p_address_type in per_addresses.address_type%type default null,
3283: -- p_comments in per_addresses.comments%type default null,
3284: p_country in per_addresses.country%type default null,
3285: p_date_to in per_addresses.date_to%type default null,
3286: p_postal_code in per_addresses.postal_code%type default null,
3287: p_region_1 in per_addresses.region_1%type default null,
3288: p_region_2 in per_addresses.region_2%type default null,

Line 3285: p_date_to in per_addresses.date_to%type default null,

3281: p_address_line3 in per_addresses.address_line3%type default null,
3282: p_address_type in per_addresses.address_type%type default null,
3283: -- p_comments in per_addresses.comments%type default null,
3284: p_country in per_addresses.country%type default null,
3285: p_date_to in per_addresses.date_to%type default null,
3286: p_postal_code in per_addresses.postal_code%type default null,
3287: p_region_1 in per_addresses.region_1%type default null,
3288: p_region_2 in per_addresses.region_2%type default null,
3289: p_region_3 in per_addresses.region_3%type default null,

Line 3286: p_postal_code in per_addresses.postal_code%type default null,

3282: p_address_type in per_addresses.address_type%type default null,
3283: -- p_comments in per_addresses.comments%type default null,
3284: p_country in per_addresses.country%type default null,
3285: p_date_to in per_addresses.date_to%type default null,
3286: p_postal_code in per_addresses.postal_code%type default null,
3287: p_region_1 in per_addresses.region_1%type default null,
3288: p_region_2 in per_addresses.region_2%type default null,
3289: p_region_3 in per_addresses.region_3%type default null,
3290: p_telephone_number_1 in per_addresses.telephone_number_1%type default null,

Line 3287: p_region_1 in per_addresses.region_1%type default null,

3283: -- p_comments in per_addresses.comments%type default null,
3284: p_country in per_addresses.country%type default null,
3285: p_date_to in per_addresses.date_to%type default null,
3286: p_postal_code in per_addresses.postal_code%type default null,
3287: p_region_1 in per_addresses.region_1%type default null,
3288: p_region_2 in per_addresses.region_2%type default null,
3289: p_region_3 in per_addresses.region_3%type default null,
3290: p_telephone_number_1 in per_addresses.telephone_number_1%type default null,
3291: p_telephone_number_2 in per_addresses.telephone_number_2%type default null,

Line 3288: p_region_2 in per_addresses.region_2%type default null,

3284: p_country in per_addresses.country%type default null,
3285: p_date_to in per_addresses.date_to%type default null,
3286: p_postal_code in per_addresses.postal_code%type default null,
3287: p_region_1 in per_addresses.region_1%type default null,
3288: p_region_2 in per_addresses.region_2%type default null,
3289: p_region_3 in per_addresses.region_3%type default null,
3290: p_telephone_number_1 in per_addresses.telephone_number_1%type default null,
3291: p_telephone_number_2 in per_addresses.telephone_number_2%type default null,
3292: p_telephone_number_3 in per_addresses.telephone_number_3%type default null,

Line 3289: p_region_3 in per_addresses.region_3%type default null,

3285: p_date_to in per_addresses.date_to%type default null,
3286: p_postal_code in per_addresses.postal_code%type default null,
3287: p_region_1 in per_addresses.region_1%type default null,
3288: p_region_2 in per_addresses.region_2%type default null,
3289: p_region_3 in per_addresses.region_3%type default null,
3290: p_telephone_number_1 in per_addresses.telephone_number_1%type default null,
3291: p_telephone_number_2 in per_addresses.telephone_number_2%type default null,
3292: p_telephone_number_3 in per_addresses.telephone_number_3%type default null,
3293: p_town_or_city in per_addresses.town_or_city%type default null,

Line 3290: p_telephone_number_1 in per_addresses.telephone_number_1%type default null,

3286: p_postal_code in per_addresses.postal_code%type default null,
3287: p_region_1 in per_addresses.region_1%type default null,
3288: p_region_2 in per_addresses.region_2%type default null,
3289: p_region_3 in per_addresses.region_3%type default null,
3290: p_telephone_number_1 in per_addresses.telephone_number_1%type default null,
3291: p_telephone_number_2 in per_addresses.telephone_number_2%type default null,
3292: p_telephone_number_3 in per_addresses.telephone_number_3%type default null,
3293: p_town_or_city in per_addresses.town_or_city%type default null,
3294: p_request_id in per_addresses.request_id%type default null,

Line 3291: p_telephone_number_2 in per_addresses.telephone_number_2%type default null,

3287: p_region_1 in per_addresses.region_1%type default null,
3288: p_region_2 in per_addresses.region_2%type default null,
3289: p_region_3 in per_addresses.region_3%type default null,
3290: p_telephone_number_1 in per_addresses.telephone_number_1%type default null,
3291: p_telephone_number_2 in per_addresses.telephone_number_2%type default null,
3292: p_telephone_number_3 in per_addresses.telephone_number_3%type default null,
3293: p_town_or_city in per_addresses.town_or_city%type default null,
3294: p_request_id in per_addresses.request_id%type default null,
3295: p_program_application_id in per_addresses.program_application_id%type default null,

Line 3292: p_telephone_number_3 in per_addresses.telephone_number_3%type default null,

3288: p_region_2 in per_addresses.region_2%type default null,
3289: p_region_3 in per_addresses.region_3%type default null,
3290: p_telephone_number_1 in per_addresses.telephone_number_1%type default null,
3291: p_telephone_number_2 in per_addresses.telephone_number_2%type default null,
3292: p_telephone_number_3 in per_addresses.telephone_number_3%type default null,
3293: p_town_or_city in per_addresses.town_or_city%type default null,
3294: p_request_id in per_addresses.request_id%type default null,
3295: p_program_application_id in per_addresses.program_application_id%type default null,
3296: p_program_id in per_addresses.program_id%type default null,

Line 3293: p_town_or_city in per_addresses.town_or_city%type default null,

3289: p_region_3 in per_addresses.region_3%type default null,
3290: p_telephone_number_1 in per_addresses.telephone_number_1%type default null,
3291: p_telephone_number_2 in per_addresses.telephone_number_2%type default null,
3292: p_telephone_number_3 in per_addresses.telephone_number_3%type default null,
3293: p_town_or_city in per_addresses.town_or_city%type default null,
3294: p_request_id in per_addresses.request_id%type default null,
3295: p_program_application_id in per_addresses.program_application_id%type default null,
3296: p_program_id in per_addresses.program_id%type default null,
3297: p_program_update_date in per_addresses.program_update_date%type default null,

Line 3294: p_request_id in per_addresses.request_id%type default null,

3290: p_telephone_number_1 in per_addresses.telephone_number_1%type default null,
3291: p_telephone_number_2 in per_addresses.telephone_number_2%type default null,
3292: p_telephone_number_3 in per_addresses.telephone_number_3%type default null,
3293: p_town_or_city in per_addresses.town_or_city%type default null,
3294: p_request_id in per_addresses.request_id%type default null,
3295: p_program_application_id in per_addresses.program_application_id%type default null,
3296: p_program_id in per_addresses.program_id%type default null,
3297: p_program_update_date in per_addresses.program_update_date%type default null,
3298: p_addr_attribute_category in per_addresses.addr_attribute_category%type default null,

Line 3295: p_program_application_id in per_addresses.program_application_id%type default null,

3291: p_telephone_number_2 in per_addresses.telephone_number_2%type default null,
3292: p_telephone_number_3 in per_addresses.telephone_number_3%type default null,
3293: p_town_or_city in per_addresses.town_or_city%type default null,
3294: p_request_id in per_addresses.request_id%type default null,
3295: p_program_application_id in per_addresses.program_application_id%type default null,
3296: p_program_id in per_addresses.program_id%type default null,
3297: p_program_update_date in per_addresses.program_update_date%type default null,
3298: p_addr_attribute_category in per_addresses.addr_attribute_category%type default null,
3299: p_addr_attribute1 in per_addresses.addr_attribute1%type default null,

Line 3296: p_program_id in per_addresses.program_id%type default null,

3292: p_telephone_number_3 in per_addresses.telephone_number_3%type default null,
3293: p_town_or_city in per_addresses.town_or_city%type default null,
3294: p_request_id in per_addresses.request_id%type default null,
3295: p_program_application_id in per_addresses.program_application_id%type default null,
3296: p_program_id in per_addresses.program_id%type default null,
3297: p_program_update_date in per_addresses.program_update_date%type default null,
3298: p_addr_attribute_category in per_addresses.addr_attribute_category%type default null,
3299: p_addr_attribute1 in per_addresses.addr_attribute1%type default null,
3300: p_addr_attribute2 in per_addresses.addr_attribute2%type default null,

Line 3297: p_program_update_date in per_addresses.program_update_date%type default null,

3293: p_town_or_city in per_addresses.town_or_city%type default null,
3294: p_request_id in per_addresses.request_id%type default null,
3295: p_program_application_id in per_addresses.program_application_id%type default null,
3296: p_program_id in per_addresses.program_id%type default null,
3297: p_program_update_date in per_addresses.program_update_date%type default null,
3298: p_addr_attribute_category in per_addresses.addr_attribute_category%type default null,
3299: p_addr_attribute1 in per_addresses.addr_attribute1%type default null,
3300: p_addr_attribute2 in per_addresses.addr_attribute2%type default null,
3301: p_addr_attribute3 in per_addresses.addr_attribute3%type default null,

Line 3298: p_addr_attribute_category in per_addresses.addr_attribute_category%type default null,

3294: p_request_id in per_addresses.request_id%type default null,
3295: p_program_application_id in per_addresses.program_application_id%type default null,
3296: p_program_id in per_addresses.program_id%type default null,
3297: p_program_update_date in per_addresses.program_update_date%type default null,
3298: p_addr_attribute_category in per_addresses.addr_attribute_category%type default null,
3299: p_addr_attribute1 in per_addresses.addr_attribute1%type default null,
3300: p_addr_attribute2 in per_addresses.addr_attribute2%type default null,
3301: p_addr_attribute3 in per_addresses.addr_attribute3%type default null,
3302: p_addr_attribute4 in per_addresses.addr_attribute4%type default null,

Line 3299: p_addr_attribute1 in per_addresses.addr_attribute1%type default null,

3295: p_program_application_id in per_addresses.program_application_id%type default null,
3296: p_program_id in per_addresses.program_id%type default null,
3297: p_program_update_date in per_addresses.program_update_date%type default null,
3298: p_addr_attribute_category in per_addresses.addr_attribute_category%type default null,
3299: p_addr_attribute1 in per_addresses.addr_attribute1%type default null,
3300: p_addr_attribute2 in per_addresses.addr_attribute2%type default null,
3301: p_addr_attribute3 in per_addresses.addr_attribute3%type default null,
3302: p_addr_attribute4 in per_addresses.addr_attribute4%type default null,
3303: p_addr_attribute5 in per_addresses.addr_attribute5%type default null,

Line 3300: p_addr_attribute2 in per_addresses.addr_attribute2%type default null,

3296: p_program_id in per_addresses.program_id%type default null,
3297: p_program_update_date in per_addresses.program_update_date%type default null,
3298: p_addr_attribute_category in per_addresses.addr_attribute_category%type default null,
3299: p_addr_attribute1 in per_addresses.addr_attribute1%type default null,
3300: p_addr_attribute2 in per_addresses.addr_attribute2%type default null,
3301: p_addr_attribute3 in per_addresses.addr_attribute3%type default null,
3302: p_addr_attribute4 in per_addresses.addr_attribute4%type default null,
3303: p_addr_attribute5 in per_addresses.addr_attribute5%type default null,
3304: p_addr_attribute6 in per_addresses.addr_attribute6%type default null,

Line 3301: p_addr_attribute3 in per_addresses.addr_attribute3%type default null,

3297: p_program_update_date in per_addresses.program_update_date%type default null,
3298: p_addr_attribute_category in per_addresses.addr_attribute_category%type default null,
3299: p_addr_attribute1 in per_addresses.addr_attribute1%type default null,
3300: p_addr_attribute2 in per_addresses.addr_attribute2%type default null,
3301: p_addr_attribute3 in per_addresses.addr_attribute3%type default null,
3302: p_addr_attribute4 in per_addresses.addr_attribute4%type default null,
3303: p_addr_attribute5 in per_addresses.addr_attribute5%type default null,
3304: p_addr_attribute6 in per_addresses.addr_attribute6%type default null,
3305: p_addr_attribute7 in per_addresses.addr_attribute7%type default null,

Line 3302: p_addr_attribute4 in per_addresses.addr_attribute4%type default null,

3298: p_addr_attribute_category in per_addresses.addr_attribute_category%type default null,
3299: p_addr_attribute1 in per_addresses.addr_attribute1%type default null,
3300: p_addr_attribute2 in per_addresses.addr_attribute2%type default null,
3301: p_addr_attribute3 in per_addresses.addr_attribute3%type default null,
3302: p_addr_attribute4 in per_addresses.addr_attribute4%type default null,
3303: p_addr_attribute5 in per_addresses.addr_attribute5%type default null,
3304: p_addr_attribute6 in per_addresses.addr_attribute6%type default null,
3305: p_addr_attribute7 in per_addresses.addr_attribute7%type default null,
3306: p_addr_attribute8 in per_addresses.addr_attribute8%type default null,

Line 3303: p_addr_attribute5 in per_addresses.addr_attribute5%type default null,

3299: p_addr_attribute1 in per_addresses.addr_attribute1%type default null,
3300: p_addr_attribute2 in per_addresses.addr_attribute2%type default null,
3301: p_addr_attribute3 in per_addresses.addr_attribute3%type default null,
3302: p_addr_attribute4 in per_addresses.addr_attribute4%type default null,
3303: p_addr_attribute5 in per_addresses.addr_attribute5%type default null,
3304: p_addr_attribute6 in per_addresses.addr_attribute6%type default null,
3305: p_addr_attribute7 in per_addresses.addr_attribute7%type default null,
3306: p_addr_attribute8 in per_addresses.addr_attribute8%type default null,
3307: p_addr_attribute9 in per_addresses.addr_attribute9%type default null,

Line 3304: p_addr_attribute6 in per_addresses.addr_attribute6%type default null,

3300: p_addr_attribute2 in per_addresses.addr_attribute2%type default null,
3301: p_addr_attribute3 in per_addresses.addr_attribute3%type default null,
3302: p_addr_attribute4 in per_addresses.addr_attribute4%type default null,
3303: p_addr_attribute5 in per_addresses.addr_attribute5%type default null,
3304: p_addr_attribute6 in per_addresses.addr_attribute6%type default null,
3305: p_addr_attribute7 in per_addresses.addr_attribute7%type default null,
3306: p_addr_attribute8 in per_addresses.addr_attribute8%type default null,
3307: p_addr_attribute9 in per_addresses.addr_attribute9%type default null,
3308: p_addr_attribute10 in per_addresses.addr_attribute10%type default null,

Line 3305: p_addr_attribute7 in per_addresses.addr_attribute7%type default null,

3301: p_addr_attribute3 in per_addresses.addr_attribute3%type default null,
3302: p_addr_attribute4 in per_addresses.addr_attribute4%type default null,
3303: p_addr_attribute5 in per_addresses.addr_attribute5%type default null,
3304: p_addr_attribute6 in per_addresses.addr_attribute6%type default null,
3305: p_addr_attribute7 in per_addresses.addr_attribute7%type default null,
3306: p_addr_attribute8 in per_addresses.addr_attribute8%type default null,
3307: p_addr_attribute9 in per_addresses.addr_attribute9%type default null,
3308: p_addr_attribute10 in per_addresses.addr_attribute10%type default null,
3309: p_addr_attribute11 in per_addresses.addr_attribute11%type default null,

Line 3306: p_addr_attribute8 in per_addresses.addr_attribute8%type default null,

3302: p_addr_attribute4 in per_addresses.addr_attribute4%type default null,
3303: p_addr_attribute5 in per_addresses.addr_attribute5%type default null,
3304: p_addr_attribute6 in per_addresses.addr_attribute6%type default null,
3305: p_addr_attribute7 in per_addresses.addr_attribute7%type default null,
3306: p_addr_attribute8 in per_addresses.addr_attribute8%type default null,
3307: p_addr_attribute9 in per_addresses.addr_attribute9%type default null,
3308: p_addr_attribute10 in per_addresses.addr_attribute10%type default null,
3309: p_addr_attribute11 in per_addresses.addr_attribute11%type default null,
3310: p_addr_attribute12 in per_addresses.addr_attribute12%type default null,

Line 3307: p_addr_attribute9 in per_addresses.addr_attribute9%type default null,

3303: p_addr_attribute5 in per_addresses.addr_attribute5%type default null,
3304: p_addr_attribute6 in per_addresses.addr_attribute6%type default null,
3305: p_addr_attribute7 in per_addresses.addr_attribute7%type default null,
3306: p_addr_attribute8 in per_addresses.addr_attribute8%type default null,
3307: p_addr_attribute9 in per_addresses.addr_attribute9%type default null,
3308: p_addr_attribute10 in per_addresses.addr_attribute10%type default null,
3309: p_addr_attribute11 in per_addresses.addr_attribute11%type default null,
3310: p_addr_attribute12 in per_addresses.addr_attribute12%type default null,
3311: p_addr_attribute13 in per_addresses.addr_attribute13%type default null,

Line 3308: p_addr_attribute10 in per_addresses.addr_attribute10%type default null,

3304: p_addr_attribute6 in per_addresses.addr_attribute6%type default null,
3305: p_addr_attribute7 in per_addresses.addr_attribute7%type default null,
3306: p_addr_attribute8 in per_addresses.addr_attribute8%type default null,
3307: p_addr_attribute9 in per_addresses.addr_attribute9%type default null,
3308: p_addr_attribute10 in per_addresses.addr_attribute10%type default null,
3309: p_addr_attribute11 in per_addresses.addr_attribute11%type default null,
3310: p_addr_attribute12 in per_addresses.addr_attribute12%type default null,
3311: p_addr_attribute13 in per_addresses.addr_attribute13%type default null,
3312: p_addr_attribute14 in per_addresses.addr_attribute14%type default null,

Line 3309: p_addr_attribute11 in per_addresses.addr_attribute11%type default null,

3305: p_addr_attribute7 in per_addresses.addr_attribute7%type default null,
3306: p_addr_attribute8 in per_addresses.addr_attribute8%type default null,
3307: p_addr_attribute9 in per_addresses.addr_attribute9%type default null,
3308: p_addr_attribute10 in per_addresses.addr_attribute10%type default null,
3309: p_addr_attribute11 in per_addresses.addr_attribute11%type default null,
3310: p_addr_attribute12 in per_addresses.addr_attribute12%type default null,
3311: p_addr_attribute13 in per_addresses.addr_attribute13%type default null,
3312: p_addr_attribute14 in per_addresses.addr_attribute14%type default null,
3313: p_addr_attribute15 in per_addresses.addr_attribute15%type default null,

Line 3310: p_addr_attribute12 in per_addresses.addr_attribute12%type default null,

3306: p_addr_attribute8 in per_addresses.addr_attribute8%type default null,
3307: p_addr_attribute9 in per_addresses.addr_attribute9%type default null,
3308: p_addr_attribute10 in per_addresses.addr_attribute10%type default null,
3309: p_addr_attribute11 in per_addresses.addr_attribute11%type default null,
3310: p_addr_attribute12 in per_addresses.addr_attribute12%type default null,
3311: p_addr_attribute13 in per_addresses.addr_attribute13%type default null,
3312: p_addr_attribute14 in per_addresses.addr_attribute14%type default null,
3313: p_addr_attribute15 in per_addresses.addr_attribute15%type default null,
3314: p_addr_attribute16 in per_addresses.addr_attribute16%type default null,

Line 3311: p_addr_attribute13 in per_addresses.addr_attribute13%type default null,

3307: p_addr_attribute9 in per_addresses.addr_attribute9%type default null,
3308: p_addr_attribute10 in per_addresses.addr_attribute10%type default null,
3309: p_addr_attribute11 in per_addresses.addr_attribute11%type default null,
3310: p_addr_attribute12 in per_addresses.addr_attribute12%type default null,
3311: p_addr_attribute13 in per_addresses.addr_attribute13%type default null,
3312: p_addr_attribute14 in per_addresses.addr_attribute14%type default null,
3313: p_addr_attribute15 in per_addresses.addr_attribute15%type default null,
3314: p_addr_attribute16 in per_addresses.addr_attribute16%type default null,
3315: p_addr_attribute17 in per_addresses.addr_attribute17%type default null,

Line 3312: p_addr_attribute14 in per_addresses.addr_attribute14%type default null,

3308: p_addr_attribute10 in per_addresses.addr_attribute10%type default null,
3309: p_addr_attribute11 in per_addresses.addr_attribute11%type default null,
3310: p_addr_attribute12 in per_addresses.addr_attribute12%type default null,
3311: p_addr_attribute13 in per_addresses.addr_attribute13%type default null,
3312: p_addr_attribute14 in per_addresses.addr_attribute14%type default null,
3313: p_addr_attribute15 in per_addresses.addr_attribute15%type default null,
3314: p_addr_attribute16 in per_addresses.addr_attribute16%type default null,
3315: p_addr_attribute17 in per_addresses.addr_attribute17%type default null,
3316: p_addr_attribute18 in per_addresses.addr_attribute18%type default null,

Line 3313: p_addr_attribute15 in per_addresses.addr_attribute15%type default null,

3309: p_addr_attribute11 in per_addresses.addr_attribute11%type default null,
3310: p_addr_attribute12 in per_addresses.addr_attribute12%type default null,
3311: p_addr_attribute13 in per_addresses.addr_attribute13%type default null,
3312: p_addr_attribute14 in per_addresses.addr_attribute14%type default null,
3313: p_addr_attribute15 in per_addresses.addr_attribute15%type default null,
3314: p_addr_attribute16 in per_addresses.addr_attribute16%type default null,
3315: p_addr_attribute17 in per_addresses.addr_attribute17%type default null,
3316: p_addr_attribute18 in per_addresses.addr_attribute18%type default null,
3317: p_addr_attribute19 in per_addresses.addr_attribute19%type default null,

Line 3314: p_addr_attribute16 in per_addresses.addr_attribute16%type default null,

3310: p_addr_attribute12 in per_addresses.addr_attribute12%type default null,
3311: p_addr_attribute13 in per_addresses.addr_attribute13%type default null,
3312: p_addr_attribute14 in per_addresses.addr_attribute14%type default null,
3313: p_addr_attribute15 in per_addresses.addr_attribute15%type default null,
3314: p_addr_attribute16 in per_addresses.addr_attribute16%type default null,
3315: p_addr_attribute17 in per_addresses.addr_attribute17%type default null,
3316: p_addr_attribute18 in per_addresses.addr_attribute18%type default null,
3317: p_addr_attribute19 in per_addresses.addr_attribute19%type default null,
3318: p_addr_attribute20 in per_addresses.addr_attribute20%type default null,

Line 3315: p_addr_attribute17 in per_addresses.addr_attribute17%type default null,

3311: p_addr_attribute13 in per_addresses.addr_attribute13%type default null,
3312: p_addr_attribute14 in per_addresses.addr_attribute14%type default null,
3313: p_addr_attribute15 in per_addresses.addr_attribute15%type default null,
3314: p_addr_attribute16 in per_addresses.addr_attribute16%type default null,
3315: p_addr_attribute17 in per_addresses.addr_attribute17%type default null,
3316: p_addr_attribute18 in per_addresses.addr_attribute18%type default null,
3317: p_addr_attribute19 in per_addresses.addr_attribute19%type default null,
3318: p_addr_attribute20 in per_addresses.addr_attribute20%type default null,
3319: -- p_object_version_number in per_addresses.object_version_number%type default null,

Line 3316: p_addr_attribute18 in per_addresses.addr_attribute18%type default null,

3312: p_addr_attribute14 in per_addresses.addr_attribute14%type default null,
3313: p_addr_attribute15 in per_addresses.addr_attribute15%type default null,
3314: p_addr_attribute16 in per_addresses.addr_attribute16%type default null,
3315: p_addr_attribute17 in per_addresses.addr_attribute17%type default null,
3316: p_addr_attribute18 in per_addresses.addr_attribute18%type default null,
3317: p_addr_attribute19 in per_addresses.addr_attribute19%type default null,
3318: p_addr_attribute20 in per_addresses.addr_attribute20%type default null,
3319: -- p_object_version_number in per_addresses.object_version_number%type default null,
3320: p_addresses_data in out nocopy per_addresses%rowtype ) as

Line 3317: p_addr_attribute19 in per_addresses.addr_attribute19%type default null,

3313: p_addr_attribute15 in per_addresses.addr_attribute15%type default null,
3314: p_addr_attribute16 in per_addresses.addr_attribute16%type default null,
3315: p_addr_attribute17 in per_addresses.addr_attribute17%type default null,
3316: p_addr_attribute18 in per_addresses.addr_attribute18%type default null,
3317: p_addr_attribute19 in per_addresses.addr_attribute19%type default null,
3318: p_addr_attribute20 in per_addresses.addr_attribute20%type default null,
3319: -- p_object_version_number in per_addresses.object_version_number%type default null,
3320: p_addresses_data in out nocopy per_addresses%rowtype ) as
3321:

Line 3318: p_addr_attribute20 in per_addresses.addr_attribute20%type default null,

3314: p_addr_attribute16 in per_addresses.addr_attribute16%type default null,
3315: p_addr_attribute17 in per_addresses.addr_attribute17%type default null,
3316: p_addr_attribute18 in per_addresses.addr_attribute18%type default null,
3317: p_addr_attribute19 in per_addresses.addr_attribute19%type default null,
3318: p_addr_attribute20 in per_addresses.addr_attribute20%type default null,
3319: -- p_object_version_number in per_addresses.object_version_number%type default null,
3320: p_addresses_data in out nocopy per_addresses%rowtype ) as
3321:
3322: l_proc varchar2(30):='conv_to_addresses_rg';

Line 3319: -- p_object_version_number in per_addresses.object_version_number%type default null,

3315: p_addr_attribute17 in per_addresses.addr_attribute17%type default null,
3316: p_addr_attribute18 in per_addresses.addr_attribute18%type default null,
3317: p_addr_attribute19 in per_addresses.addr_attribute19%type default null,
3318: p_addr_attribute20 in per_addresses.addr_attribute20%type default null,
3319: -- p_object_version_number in per_addresses.object_version_number%type default null,
3320: p_addresses_data in out nocopy per_addresses%rowtype ) as
3321:
3322: l_proc varchar2(30):='conv_to_addresses_rg';
3323: l_addresses_data per_addresses%rowtype;

Line 3320: p_addresses_data in out nocopy per_addresses%rowtype ) as

3316: p_addr_attribute18 in per_addresses.addr_attribute18%type default null,
3317: p_addr_attribute19 in per_addresses.addr_attribute19%type default null,
3318: p_addr_attribute20 in per_addresses.addr_attribute20%type default null,
3319: -- p_object_version_number in per_addresses.object_version_number%type default null,
3320: p_addresses_data in out nocopy per_addresses%rowtype ) as
3321:
3322: l_proc varchar2(30):='conv_to_addresses_rg';
3323: l_addresses_data per_addresses%rowtype;
3324:

Line 3323: l_addresses_data per_addresses%rowtype;

3319: -- p_object_version_number in per_addresses.object_version_number%type default null,
3320: p_addresses_data in out nocopy per_addresses%rowtype ) as
3321:
3322: l_proc varchar2(30):='conv_to_addresses_rg';
3323: l_addresses_data per_addresses%rowtype;
3324:
3325: begin
3326:
3327: l_addresses_data := p_addresses_data ; --NOCOPY CHANGES

Line 3438: -- to the per_addresses record

3434: end conv_to_addresses_rg;
3435:
3436:
3437: -- Procedure conv_to_addresses_rg converts the ghr_addresses record to
3438: -- to the per_addresses record
3439: Procedure conv_to_addresses_rg(p_addresses_h_v in ghr_addresses_h_v%rowtype,
3440: p_addresses_data out nocopy per_addresses%rowtype) is
3441:
3442: l_proc varchar2(30):='Conv_to_addresses_rg';

Line 3440: p_addresses_data out nocopy per_addresses%rowtype) is

3436:
3437: -- Procedure conv_to_addresses_rg converts the ghr_addresses record to
3438: -- to the per_addresses record
3439: Procedure conv_to_addresses_rg(p_addresses_h_v in ghr_addresses_h_v%rowtype,
3440: p_addresses_data out nocopy per_addresses%rowtype) is
3441:
3442: l_proc varchar2(30):='Conv_to_addresses_rg';
3443: l_addresses_data per_addresses%rowtype;
3444:

Line 3443: l_addresses_data per_addresses%rowtype;

3439: Procedure conv_to_addresses_rg(p_addresses_h_v in ghr_addresses_h_v%rowtype,
3440: p_addresses_data out nocopy per_addresses%rowtype) is
3441:
3442: l_proc varchar2(30):='Conv_to_addresses_rg';
3443: l_addresses_data per_addresses%rowtype;
3444:
3445: Begin
3446: hr_utility.set_location('Entering : ' || l_proc, 100);
3447: conv_to_addresses_rg(

Line 3511: p_addresses_data in per_addresses%rowtype,

3507:
3508: -- procedure conv_addresses_rg_to_hist_rg converts the addresses_rg record type to
3509: -- ghr_addresses_history record type
3510: Procedure conv_addresses_rg_to_hist_rg(
3511: p_addresses_data in per_addresses%rowtype,
3512: p_history_data in out nocopy ghr_pa_history%rowtype) as
3513:
3514: l_proc varchar2(30) := 'conv_addresses_rg_to_hist_rg';
3515: l_history_data ghr_pa_history%rowtype;

Line 3588: p_addresses_data in out nocopy per_addresses%rowtype) as

3584: --procedure conv_to_addresses_rg converts the ghr_addresses_history
3585: --record type to addresses_rg
3586: Procedure conv_to_addresses_rg(
3587: p_history_data in ghr_pa_history%rowtype,
3588: p_addresses_data in out nocopy per_addresses%rowtype) as
3589:
3590: l_proc varchar2(30) := 'conv_addresses_rg_to_hist_rg';
3591: l_addresses_data per_addresses%rowtype;
3592: begin

Line 3591: l_addresses_data per_addresses%rowtype;

3587: p_history_data in ghr_pa_history%rowtype,
3588: p_addresses_data in out nocopy per_addresses%rowtype) as
3589:
3590: l_proc varchar2(30) := 'conv_addresses_rg_to_hist_rg';
3591: l_addresses_data per_addresses%rowtype;
3592: begin
3593:
3594: l_addresses_data :=p_addresses_data; --NOCOPY Changes
3595: hr_utility.set_location('entering:'|| l_proc, 5);