APPS.GHR_HISTORY_CONV_RG dependencies on PER_PEOPLE_EXTRA_INFO

Line 2008: p_peopleei_data out nocopy per_people_extra_info%rowtype) is

2004:
2005:
2006:
2007: Procedure conv_to_peopleei_rg ( p_peopleei_h_v in ghr_people_extra_info_h_v%rowtype,
2008: p_peopleei_data out nocopy per_people_extra_info%rowtype) is
2009:
2010: l_peopleei_data per_people_extra_info%rowtype;
2011: l_proc varchar2(30):='conv_to_peopleei_rg';
2012: Begin

Line 2010: l_peopleei_data per_people_extra_info%rowtype;

2006:
2007: Procedure conv_to_peopleei_rg ( p_peopleei_h_v in ghr_people_extra_info_h_v%rowtype,
2008: p_peopleei_data out nocopy per_people_extra_info%rowtype) is
2009:
2010: l_peopleei_data per_people_extra_info%rowtype;
2011: l_proc varchar2(30):='conv_to_peopleei_rg';
2012: Begin
2013:
2014: hr_utility.set_location('Entering : '|| l_proc, 100);

Line 2094: p_person_extra_info_id in per_people_extra_info.person_extra_info_id%type default null,

2090:
2091: -- Procedure conv_to_peopleei_rg copies the individuual fields supplied as parameters
2092: -- to the per_peopleei type record.
2093: procedure conv_to_peopleei_rg (
2094: p_person_extra_info_id in per_people_extra_info.person_extra_info_id%type default null,
2095: p_person_id in per_people_extra_info.person_id%type default null,
2096: p_information_type in per_people_extra_info.information_type%type default null,
2097: p_request_id in per_people_extra_info.request_id%type default null,
2098: p_program_application_id in per_people_extra_info.program_application_id%type default null,

Line 2095: p_person_id in per_people_extra_info.person_id%type default null,

2091: -- Procedure conv_to_peopleei_rg copies the individuual fields supplied as parameters
2092: -- to the per_peopleei type record.
2093: procedure conv_to_peopleei_rg (
2094: p_person_extra_info_id in per_people_extra_info.person_extra_info_id%type default null,
2095: p_person_id in per_people_extra_info.person_id%type default null,
2096: p_information_type in per_people_extra_info.information_type%type default null,
2097: p_request_id in per_people_extra_info.request_id%type default null,
2098: p_program_application_id in per_people_extra_info.program_application_id%type default null,
2099: p_program_id in per_people_extra_info.program_id%type default null,

Line 2096: p_information_type in per_people_extra_info.information_type%type default null,

2092: -- to the per_peopleei type record.
2093: procedure conv_to_peopleei_rg (
2094: p_person_extra_info_id in per_people_extra_info.person_extra_info_id%type default null,
2095: p_person_id in per_people_extra_info.person_id%type default null,
2096: p_information_type in per_people_extra_info.information_type%type default null,
2097: p_request_id in per_people_extra_info.request_id%type default null,
2098: p_program_application_id in per_people_extra_info.program_application_id%type default null,
2099: p_program_id in per_people_extra_info.program_id%type default null,
2100: p_program_update_date in per_people_extra_info.program_update_date%type default null,

Line 2097: p_request_id in per_people_extra_info.request_id%type default null,

2093: procedure conv_to_peopleei_rg (
2094: p_person_extra_info_id in per_people_extra_info.person_extra_info_id%type default null,
2095: p_person_id in per_people_extra_info.person_id%type default null,
2096: p_information_type in per_people_extra_info.information_type%type default null,
2097: p_request_id in per_people_extra_info.request_id%type default null,
2098: p_program_application_id in per_people_extra_info.program_application_id%type default null,
2099: p_program_id in per_people_extra_info.program_id%type default null,
2100: p_program_update_date in per_people_extra_info.program_update_date%type default null,
2101: p_pei_attribute_category in per_people_extra_info.pei_attribute_category%type default null,

Line 2098: p_program_application_id in per_people_extra_info.program_application_id%type default null,

2094: p_person_extra_info_id in per_people_extra_info.person_extra_info_id%type default null,
2095: p_person_id in per_people_extra_info.person_id%type default null,
2096: p_information_type in per_people_extra_info.information_type%type default null,
2097: p_request_id in per_people_extra_info.request_id%type default null,
2098: p_program_application_id in per_people_extra_info.program_application_id%type default null,
2099: p_program_id in per_people_extra_info.program_id%type default null,
2100: p_program_update_date in per_people_extra_info.program_update_date%type default null,
2101: p_pei_attribute_category in per_people_extra_info.pei_attribute_category%type default null,
2102: p_pei_attribute1 in per_people_extra_info.pei_attribute1%type default null,

Line 2099: p_program_id in per_people_extra_info.program_id%type default null,

2095: p_person_id in per_people_extra_info.person_id%type default null,
2096: p_information_type in per_people_extra_info.information_type%type default null,
2097: p_request_id in per_people_extra_info.request_id%type default null,
2098: p_program_application_id in per_people_extra_info.program_application_id%type default null,
2099: p_program_id in per_people_extra_info.program_id%type default null,
2100: p_program_update_date in per_people_extra_info.program_update_date%type default null,
2101: p_pei_attribute_category in per_people_extra_info.pei_attribute_category%type default null,
2102: p_pei_attribute1 in per_people_extra_info.pei_attribute1%type default null,
2103: p_pei_attribute2 in per_people_extra_info.pei_attribute2%type default null,

Line 2100: p_program_update_date in per_people_extra_info.program_update_date%type default null,

2096: p_information_type in per_people_extra_info.information_type%type default null,
2097: p_request_id in per_people_extra_info.request_id%type default null,
2098: p_program_application_id in per_people_extra_info.program_application_id%type default null,
2099: p_program_id in per_people_extra_info.program_id%type default null,
2100: p_program_update_date in per_people_extra_info.program_update_date%type default null,
2101: p_pei_attribute_category in per_people_extra_info.pei_attribute_category%type default null,
2102: p_pei_attribute1 in per_people_extra_info.pei_attribute1%type default null,
2103: p_pei_attribute2 in per_people_extra_info.pei_attribute2%type default null,
2104: p_pei_attribute3 in per_people_extra_info.pei_attribute3%type default null,

Line 2101: p_pei_attribute_category in per_people_extra_info.pei_attribute_category%type default null,

2097: p_request_id in per_people_extra_info.request_id%type default null,
2098: p_program_application_id in per_people_extra_info.program_application_id%type default null,
2099: p_program_id in per_people_extra_info.program_id%type default null,
2100: p_program_update_date in per_people_extra_info.program_update_date%type default null,
2101: p_pei_attribute_category in per_people_extra_info.pei_attribute_category%type default null,
2102: p_pei_attribute1 in per_people_extra_info.pei_attribute1%type default null,
2103: p_pei_attribute2 in per_people_extra_info.pei_attribute2%type default null,
2104: p_pei_attribute3 in per_people_extra_info.pei_attribute3%type default null,
2105: p_pei_attribute4 in per_people_extra_info.pei_attribute4%type default null,

Line 2102: p_pei_attribute1 in per_people_extra_info.pei_attribute1%type default null,

2098: p_program_application_id in per_people_extra_info.program_application_id%type default null,
2099: p_program_id in per_people_extra_info.program_id%type default null,
2100: p_program_update_date in per_people_extra_info.program_update_date%type default null,
2101: p_pei_attribute_category in per_people_extra_info.pei_attribute_category%type default null,
2102: p_pei_attribute1 in per_people_extra_info.pei_attribute1%type default null,
2103: p_pei_attribute2 in per_people_extra_info.pei_attribute2%type default null,
2104: p_pei_attribute3 in per_people_extra_info.pei_attribute3%type default null,
2105: p_pei_attribute4 in per_people_extra_info.pei_attribute4%type default null,
2106: p_pei_attribute5 in per_people_extra_info.pei_attribute5%type default null,

Line 2103: p_pei_attribute2 in per_people_extra_info.pei_attribute2%type default null,

2099: p_program_id in per_people_extra_info.program_id%type default null,
2100: p_program_update_date in per_people_extra_info.program_update_date%type default null,
2101: p_pei_attribute_category in per_people_extra_info.pei_attribute_category%type default null,
2102: p_pei_attribute1 in per_people_extra_info.pei_attribute1%type default null,
2103: p_pei_attribute2 in per_people_extra_info.pei_attribute2%type default null,
2104: p_pei_attribute3 in per_people_extra_info.pei_attribute3%type default null,
2105: p_pei_attribute4 in per_people_extra_info.pei_attribute4%type default null,
2106: p_pei_attribute5 in per_people_extra_info.pei_attribute5%type default null,
2107: p_pei_attribute6 in per_people_extra_info.pei_attribute6%type default null,

Line 2104: p_pei_attribute3 in per_people_extra_info.pei_attribute3%type default null,

2100: p_program_update_date in per_people_extra_info.program_update_date%type default null,
2101: p_pei_attribute_category in per_people_extra_info.pei_attribute_category%type default null,
2102: p_pei_attribute1 in per_people_extra_info.pei_attribute1%type default null,
2103: p_pei_attribute2 in per_people_extra_info.pei_attribute2%type default null,
2104: p_pei_attribute3 in per_people_extra_info.pei_attribute3%type default null,
2105: p_pei_attribute4 in per_people_extra_info.pei_attribute4%type default null,
2106: p_pei_attribute5 in per_people_extra_info.pei_attribute5%type default null,
2107: p_pei_attribute6 in per_people_extra_info.pei_attribute6%type default null,
2108: p_pei_attribute7 in per_people_extra_info.pei_attribute7%type default null,

Line 2105: p_pei_attribute4 in per_people_extra_info.pei_attribute4%type default null,

2101: p_pei_attribute_category in per_people_extra_info.pei_attribute_category%type default null,
2102: p_pei_attribute1 in per_people_extra_info.pei_attribute1%type default null,
2103: p_pei_attribute2 in per_people_extra_info.pei_attribute2%type default null,
2104: p_pei_attribute3 in per_people_extra_info.pei_attribute3%type default null,
2105: p_pei_attribute4 in per_people_extra_info.pei_attribute4%type default null,
2106: p_pei_attribute5 in per_people_extra_info.pei_attribute5%type default null,
2107: p_pei_attribute6 in per_people_extra_info.pei_attribute6%type default null,
2108: p_pei_attribute7 in per_people_extra_info.pei_attribute7%type default null,
2109: p_pei_attribute8 in per_people_extra_info.pei_attribute8%type default null,

Line 2106: p_pei_attribute5 in per_people_extra_info.pei_attribute5%type default null,

2102: p_pei_attribute1 in per_people_extra_info.pei_attribute1%type default null,
2103: p_pei_attribute2 in per_people_extra_info.pei_attribute2%type default null,
2104: p_pei_attribute3 in per_people_extra_info.pei_attribute3%type default null,
2105: p_pei_attribute4 in per_people_extra_info.pei_attribute4%type default null,
2106: p_pei_attribute5 in per_people_extra_info.pei_attribute5%type default null,
2107: p_pei_attribute6 in per_people_extra_info.pei_attribute6%type default null,
2108: p_pei_attribute7 in per_people_extra_info.pei_attribute7%type default null,
2109: p_pei_attribute8 in per_people_extra_info.pei_attribute8%type default null,
2110: p_pei_attribute9 in per_people_extra_info.pei_attribute9%type default null,

Line 2107: p_pei_attribute6 in per_people_extra_info.pei_attribute6%type default null,

2103: p_pei_attribute2 in per_people_extra_info.pei_attribute2%type default null,
2104: p_pei_attribute3 in per_people_extra_info.pei_attribute3%type default null,
2105: p_pei_attribute4 in per_people_extra_info.pei_attribute4%type default null,
2106: p_pei_attribute5 in per_people_extra_info.pei_attribute5%type default null,
2107: p_pei_attribute6 in per_people_extra_info.pei_attribute6%type default null,
2108: p_pei_attribute7 in per_people_extra_info.pei_attribute7%type default null,
2109: p_pei_attribute8 in per_people_extra_info.pei_attribute8%type default null,
2110: p_pei_attribute9 in per_people_extra_info.pei_attribute9%type default null,
2111: p_pei_attribute10 in per_people_extra_info.pei_attribute10%type default null,

Line 2108: p_pei_attribute7 in per_people_extra_info.pei_attribute7%type default null,

2104: p_pei_attribute3 in per_people_extra_info.pei_attribute3%type default null,
2105: p_pei_attribute4 in per_people_extra_info.pei_attribute4%type default null,
2106: p_pei_attribute5 in per_people_extra_info.pei_attribute5%type default null,
2107: p_pei_attribute6 in per_people_extra_info.pei_attribute6%type default null,
2108: p_pei_attribute7 in per_people_extra_info.pei_attribute7%type default null,
2109: p_pei_attribute8 in per_people_extra_info.pei_attribute8%type default null,
2110: p_pei_attribute9 in per_people_extra_info.pei_attribute9%type default null,
2111: p_pei_attribute10 in per_people_extra_info.pei_attribute10%type default null,
2112: p_pei_attribute11 in per_people_extra_info.pei_attribute11%type default null,

Line 2109: p_pei_attribute8 in per_people_extra_info.pei_attribute8%type default null,

2105: p_pei_attribute4 in per_people_extra_info.pei_attribute4%type default null,
2106: p_pei_attribute5 in per_people_extra_info.pei_attribute5%type default null,
2107: p_pei_attribute6 in per_people_extra_info.pei_attribute6%type default null,
2108: p_pei_attribute7 in per_people_extra_info.pei_attribute7%type default null,
2109: p_pei_attribute8 in per_people_extra_info.pei_attribute8%type default null,
2110: p_pei_attribute9 in per_people_extra_info.pei_attribute9%type default null,
2111: p_pei_attribute10 in per_people_extra_info.pei_attribute10%type default null,
2112: p_pei_attribute11 in per_people_extra_info.pei_attribute11%type default null,
2113: p_pei_attribute12 in per_people_extra_info.pei_attribute12%type default null,

Line 2110: p_pei_attribute9 in per_people_extra_info.pei_attribute9%type default null,

2106: p_pei_attribute5 in per_people_extra_info.pei_attribute5%type default null,
2107: p_pei_attribute6 in per_people_extra_info.pei_attribute6%type default null,
2108: p_pei_attribute7 in per_people_extra_info.pei_attribute7%type default null,
2109: p_pei_attribute8 in per_people_extra_info.pei_attribute8%type default null,
2110: p_pei_attribute9 in per_people_extra_info.pei_attribute9%type default null,
2111: p_pei_attribute10 in per_people_extra_info.pei_attribute10%type default null,
2112: p_pei_attribute11 in per_people_extra_info.pei_attribute11%type default null,
2113: p_pei_attribute12 in per_people_extra_info.pei_attribute12%type default null,
2114: p_pei_attribute13 in per_people_extra_info.pei_attribute13%type default null,

Line 2111: p_pei_attribute10 in per_people_extra_info.pei_attribute10%type default null,

2107: p_pei_attribute6 in per_people_extra_info.pei_attribute6%type default null,
2108: p_pei_attribute7 in per_people_extra_info.pei_attribute7%type default null,
2109: p_pei_attribute8 in per_people_extra_info.pei_attribute8%type default null,
2110: p_pei_attribute9 in per_people_extra_info.pei_attribute9%type default null,
2111: p_pei_attribute10 in per_people_extra_info.pei_attribute10%type default null,
2112: p_pei_attribute11 in per_people_extra_info.pei_attribute11%type default null,
2113: p_pei_attribute12 in per_people_extra_info.pei_attribute12%type default null,
2114: p_pei_attribute13 in per_people_extra_info.pei_attribute13%type default null,
2115: p_pei_attribute14 in per_people_extra_info.pei_attribute14%type default null,

Line 2112: p_pei_attribute11 in per_people_extra_info.pei_attribute11%type default null,

2108: p_pei_attribute7 in per_people_extra_info.pei_attribute7%type default null,
2109: p_pei_attribute8 in per_people_extra_info.pei_attribute8%type default null,
2110: p_pei_attribute9 in per_people_extra_info.pei_attribute9%type default null,
2111: p_pei_attribute10 in per_people_extra_info.pei_attribute10%type default null,
2112: p_pei_attribute11 in per_people_extra_info.pei_attribute11%type default null,
2113: p_pei_attribute12 in per_people_extra_info.pei_attribute12%type default null,
2114: p_pei_attribute13 in per_people_extra_info.pei_attribute13%type default null,
2115: p_pei_attribute14 in per_people_extra_info.pei_attribute14%type default null,
2116: p_pei_attribute15 in per_people_extra_info.pei_attribute15%type default null,

Line 2113: p_pei_attribute12 in per_people_extra_info.pei_attribute12%type default null,

2109: p_pei_attribute8 in per_people_extra_info.pei_attribute8%type default null,
2110: p_pei_attribute9 in per_people_extra_info.pei_attribute9%type default null,
2111: p_pei_attribute10 in per_people_extra_info.pei_attribute10%type default null,
2112: p_pei_attribute11 in per_people_extra_info.pei_attribute11%type default null,
2113: p_pei_attribute12 in per_people_extra_info.pei_attribute12%type default null,
2114: p_pei_attribute13 in per_people_extra_info.pei_attribute13%type default null,
2115: p_pei_attribute14 in per_people_extra_info.pei_attribute14%type default null,
2116: p_pei_attribute15 in per_people_extra_info.pei_attribute15%type default null,
2117: p_pei_attribute16 in per_people_extra_info.pei_attribute16%type default null,

Line 2114: p_pei_attribute13 in per_people_extra_info.pei_attribute13%type default null,

2110: p_pei_attribute9 in per_people_extra_info.pei_attribute9%type default null,
2111: p_pei_attribute10 in per_people_extra_info.pei_attribute10%type default null,
2112: p_pei_attribute11 in per_people_extra_info.pei_attribute11%type default null,
2113: p_pei_attribute12 in per_people_extra_info.pei_attribute12%type default null,
2114: p_pei_attribute13 in per_people_extra_info.pei_attribute13%type default null,
2115: p_pei_attribute14 in per_people_extra_info.pei_attribute14%type default null,
2116: p_pei_attribute15 in per_people_extra_info.pei_attribute15%type default null,
2117: p_pei_attribute16 in per_people_extra_info.pei_attribute16%type default null,
2118: p_pei_attribute17 in per_people_extra_info.pei_attribute17%type default null,

Line 2115: p_pei_attribute14 in per_people_extra_info.pei_attribute14%type default null,

2111: p_pei_attribute10 in per_people_extra_info.pei_attribute10%type default null,
2112: p_pei_attribute11 in per_people_extra_info.pei_attribute11%type default null,
2113: p_pei_attribute12 in per_people_extra_info.pei_attribute12%type default null,
2114: p_pei_attribute13 in per_people_extra_info.pei_attribute13%type default null,
2115: p_pei_attribute14 in per_people_extra_info.pei_attribute14%type default null,
2116: p_pei_attribute15 in per_people_extra_info.pei_attribute15%type default null,
2117: p_pei_attribute16 in per_people_extra_info.pei_attribute16%type default null,
2118: p_pei_attribute17 in per_people_extra_info.pei_attribute17%type default null,
2119: p_pei_attribute18 in per_people_extra_info.pei_attribute18%type default null,

Line 2116: p_pei_attribute15 in per_people_extra_info.pei_attribute15%type default null,

2112: p_pei_attribute11 in per_people_extra_info.pei_attribute11%type default null,
2113: p_pei_attribute12 in per_people_extra_info.pei_attribute12%type default null,
2114: p_pei_attribute13 in per_people_extra_info.pei_attribute13%type default null,
2115: p_pei_attribute14 in per_people_extra_info.pei_attribute14%type default null,
2116: p_pei_attribute15 in per_people_extra_info.pei_attribute15%type default null,
2117: p_pei_attribute16 in per_people_extra_info.pei_attribute16%type default null,
2118: p_pei_attribute17 in per_people_extra_info.pei_attribute17%type default null,
2119: p_pei_attribute18 in per_people_extra_info.pei_attribute18%type default null,
2120: p_pei_attribute19 in per_people_extra_info.pei_attribute19%type default null,

Line 2117: p_pei_attribute16 in per_people_extra_info.pei_attribute16%type default null,

2113: p_pei_attribute12 in per_people_extra_info.pei_attribute12%type default null,
2114: p_pei_attribute13 in per_people_extra_info.pei_attribute13%type default null,
2115: p_pei_attribute14 in per_people_extra_info.pei_attribute14%type default null,
2116: p_pei_attribute15 in per_people_extra_info.pei_attribute15%type default null,
2117: p_pei_attribute16 in per_people_extra_info.pei_attribute16%type default null,
2118: p_pei_attribute17 in per_people_extra_info.pei_attribute17%type default null,
2119: p_pei_attribute18 in per_people_extra_info.pei_attribute18%type default null,
2120: p_pei_attribute19 in per_people_extra_info.pei_attribute19%type default null,
2121: p_pei_attribute20 in per_people_extra_info.pei_attribute20%type default null,

Line 2118: p_pei_attribute17 in per_people_extra_info.pei_attribute17%type default null,

2114: p_pei_attribute13 in per_people_extra_info.pei_attribute13%type default null,
2115: p_pei_attribute14 in per_people_extra_info.pei_attribute14%type default null,
2116: p_pei_attribute15 in per_people_extra_info.pei_attribute15%type default null,
2117: p_pei_attribute16 in per_people_extra_info.pei_attribute16%type default null,
2118: p_pei_attribute17 in per_people_extra_info.pei_attribute17%type default null,
2119: p_pei_attribute18 in per_people_extra_info.pei_attribute18%type default null,
2120: p_pei_attribute19 in per_people_extra_info.pei_attribute19%type default null,
2121: p_pei_attribute20 in per_people_extra_info.pei_attribute20%type default null,
2122: p_pei_information_category in per_people_extra_info.pei_information_category%type default null,

Line 2119: p_pei_attribute18 in per_people_extra_info.pei_attribute18%type default null,

2115: p_pei_attribute14 in per_people_extra_info.pei_attribute14%type default null,
2116: p_pei_attribute15 in per_people_extra_info.pei_attribute15%type default null,
2117: p_pei_attribute16 in per_people_extra_info.pei_attribute16%type default null,
2118: p_pei_attribute17 in per_people_extra_info.pei_attribute17%type default null,
2119: p_pei_attribute18 in per_people_extra_info.pei_attribute18%type default null,
2120: p_pei_attribute19 in per_people_extra_info.pei_attribute19%type default null,
2121: p_pei_attribute20 in per_people_extra_info.pei_attribute20%type default null,
2122: p_pei_information_category in per_people_extra_info.pei_information_category%type default null,
2123: p_pei_information1 in per_people_extra_info.pei_information1%type default null,

Line 2120: p_pei_attribute19 in per_people_extra_info.pei_attribute19%type default null,

2116: p_pei_attribute15 in per_people_extra_info.pei_attribute15%type default null,
2117: p_pei_attribute16 in per_people_extra_info.pei_attribute16%type default null,
2118: p_pei_attribute17 in per_people_extra_info.pei_attribute17%type default null,
2119: p_pei_attribute18 in per_people_extra_info.pei_attribute18%type default null,
2120: p_pei_attribute19 in per_people_extra_info.pei_attribute19%type default null,
2121: p_pei_attribute20 in per_people_extra_info.pei_attribute20%type default null,
2122: p_pei_information_category in per_people_extra_info.pei_information_category%type default null,
2123: p_pei_information1 in per_people_extra_info.pei_information1%type default null,
2124: p_pei_information2 in per_people_extra_info.pei_information2%type default null,

Line 2121: p_pei_attribute20 in per_people_extra_info.pei_attribute20%type default null,

2117: p_pei_attribute16 in per_people_extra_info.pei_attribute16%type default null,
2118: p_pei_attribute17 in per_people_extra_info.pei_attribute17%type default null,
2119: p_pei_attribute18 in per_people_extra_info.pei_attribute18%type default null,
2120: p_pei_attribute19 in per_people_extra_info.pei_attribute19%type default null,
2121: p_pei_attribute20 in per_people_extra_info.pei_attribute20%type default null,
2122: p_pei_information_category in per_people_extra_info.pei_information_category%type default null,
2123: p_pei_information1 in per_people_extra_info.pei_information1%type default null,
2124: p_pei_information2 in per_people_extra_info.pei_information2%type default null,
2125: p_pei_information3 in per_people_extra_info.pei_information3%type default null,

Line 2122: p_pei_information_category in per_people_extra_info.pei_information_category%type default null,

2118: p_pei_attribute17 in per_people_extra_info.pei_attribute17%type default null,
2119: p_pei_attribute18 in per_people_extra_info.pei_attribute18%type default null,
2120: p_pei_attribute19 in per_people_extra_info.pei_attribute19%type default null,
2121: p_pei_attribute20 in per_people_extra_info.pei_attribute20%type default null,
2122: p_pei_information_category in per_people_extra_info.pei_information_category%type default null,
2123: p_pei_information1 in per_people_extra_info.pei_information1%type default null,
2124: p_pei_information2 in per_people_extra_info.pei_information2%type default null,
2125: p_pei_information3 in per_people_extra_info.pei_information3%type default null,
2126: p_pei_information4 in per_people_extra_info.pei_information4%type default null,

Line 2123: p_pei_information1 in per_people_extra_info.pei_information1%type default null,

2119: p_pei_attribute18 in per_people_extra_info.pei_attribute18%type default null,
2120: p_pei_attribute19 in per_people_extra_info.pei_attribute19%type default null,
2121: p_pei_attribute20 in per_people_extra_info.pei_attribute20%type default null,
2122: p_pei_information_category in per_people_extra_info.pei_information_category%type default null,
2123: p_pei_information1 in per_people_extra_info.pei_information1%type default null,
2124: p_pei_information2 in per_people_extra_info.pei_information2%type default null,
2125: p_pei_information3 in per_people_extra_info.pei_information3%type default null,
2126: p_pei_information4 in per_people_extra_info.pei_information4%type default null,
2127: p_pei_information5 in per_people_extra_info.pei_information5%type default null,

Line 2124: p_pei_information2 in per_people_extra_info.pei_information2%type default null,

2120: p_pei_attribute19 in per_people_extra_info.pei_attribute19%type default null,
2121: p_pei_attribute20 in per_people_extra_info.pei_attribute20%type default null,
2122: p_pei_information_category in per_people_extra_info.pei_information_category%type default null,
2123: p_pei_information1 in per_people_extra_info.pei_information1%type default null,
2124: p_pei_information2 in per_people_extra_info.pei_information2%type default null,
2125: p_pei_information3 in per_people_extra_info.pei_information3%type default null,
2126: p_pei_information4 in per_people_extra_info.pei_information4%type default null,
2127: p_pei_information5 in per_people_extra_info.pei_information5%type default null,
2128: p_pei_information6 in per_people_extra_info.pei_information6%type default null,

Line 2125: p_pei_information3 in per_people_extra_info.pei_information3%type default null,

2121: p_pei_attribute20 in per_people_extra_info.pei_attribute20%type default null,
2122: p_pei_information_category in per_people_extra_info.pei_information_category%type default null,
2123: p_pei_information1 in per_people_extra_info.pei_information1%type default null,
2124: p_pei_information2 in per_people_extra_info.pei_information2%type default null,
2125: p_pei_information3 in per_people_extra_info.pei_information3%type default null,
2126: p_pei_information4 in per_people_extra_info.pei_information4%type default null,
2127: p_pei_information5 in per_people_extra_info.pei_information5%type default null,
2128: p_pei_information6 in per_people_extra_info.pei_information6%type default null,
2129: p_pei_information7 in per_people_extra_info.pei_information7%type default null,

Line 2126: p_pei_information4 in per_people_extra_info.pei_information4%type default null,

2122: p_pei_information_category in per_people_extra_info.pei_information_category%type default null,
2123: p_pei_information1 in per_people_extra_info.pei_information1%type default null,
2124: p_pei_information2 in per_people_extra_info.pei_information2%type default null,
2125: p_pei_information3 in per_people_extra_info.pei_information3%type default null,
2126: p_pei_information4 in per_people_extra_info.pei_information4%type default null,
2127: p_pei_information5 in per_people_extra_info.pei_information5%type default null,
2128: p_pei_information6 in per_people_extra_info.pei_information6%type default null,
2129: p_pei_information7 in per_people_extra_info.pei_information7%type default null,
2130: p_pei_information8 in per_people_extra_info.pei_information8%type default null,

Line 2127: p_pei_information5 in per_people_extra_info.pei_information5%type default null,

2123: p_pei_information1 in per_people_extra_info.pei_information1%type default null,
2124: p_pei_information2 in per_people_extra_info.pei_information2%type default null,
2125: p_pei_information3 in per_people_extra_info.pei_information3%type default null,
2126: p_pei_information4 in per_people_extra_info.pei_information4%type default null,
2127: p_pei_information5 in per_people_extra_info.pei_information5%type default null,
2128: p_pei_information6 in per_people_extra_info.pei_information6%type default null,
2129: p_pei_information7 in per_people_extra_info.pei_information7%type default null,
2130: p_pei_information8 in per_people_extra_info.pei_information8%type default null,
2131: p_pei_information9 in per_people_extra_info.pei_information9%type default null,

Line 2128: p_pei_information6 in per_people_extra_info.pei_information6%type default null,

2124: p_pei_information2 in per_people_extra_info.pei_information2%type default null,
2125: p_pei_information3 in per_people_extra_info.pei_information3%type default null,
2126: p_pei_information4 in per_people_extra_info.pei_information4%type default null,
2127: p_pei_information5 in per_people_extra_info.pei_information5%type default null,
2128: p_pei_information6 in per_people_extra_info.pei_information6%type default null,
2129: p_pei_information7 in per_people_extra_info.pei_information7%type default null,
2130: p_pei_information8 in per_people_extra_info.pei_information8%type default null,
2131: p_pei_information9 in per_people_extra_info.pei_information9%type default null,
2132: p_pei_information10 in per_people_extra_info.pei_information10%type default null,

Line 2129: p_pei_information7 in per_people_extra_info.pei_information7%type default null,

2125: p_pei_information3 in per_people_extra_info.pei_information3%type default null,
2126: p_pei_information4 in per_people_extra_info.pei_information4%type default null,
2127: p_pei_information5 in per_people_extra_info.pei_information5%type default null,
2128: p_pei_information6 in per_people_extra_info.pei_information6%type default null,
2129: p_pei_information7 in per_people_extra_info.pei_information7%type default null,
2130: p_pei_information8 in per_people_extra_info.pei_information8%type default null,
2131: p_pei_information9 in per_people_extra_info.pei_information9%type default null,
2132: p_pei_information10 in per_people_extra_info.pei_information10%type default null,
2133: p_pei_information11 in per_people_extra_info.pei_information11%type default null,

Line 2130: p_pei_information8 in per_people_extra_info.pei_information8%type default null,

2126: p_pei_information4 in per_people_extra_info.pei_information4%type default null,
2127: p_pei_information5 in per_people_extra_info.pei_information5%type default null,
2128: p_pei_information6 in per_people_extra_info.pei_information6%type default null,
2129: p_pei_information7 in per_people_extra_info.pei_information7%type default null,
2130: p_pei_information8 in per_people_extra_info.pei_information8%type default null,
2131: p_pei_information9 in per_people_extra_info.pei_information9%type default null,
2132: p_pei_information10 in per_people_extra_info.pei_information10%type default null,
2133: p_pei_information11 in per_people_extra_info.pei_information11%type default null,
2134: p_pei_information12 in per_people_extra_info.pei_information12%type default null,

Line 2131: p_pei_information9 in per_people_extra_info.pei_information9%type default null,

2127: p_pei_information5 in per_people_extra_info.pei_information5%type default null,
2128: p_pei_information6 in per_people_extra_info.pei_information6%type default null,
2129: p_pei_information7 in per_people_extra_info.pei_information7%type default null,
2130: p_pei_information8 in per_people_extra_info.pei_information8%type default null,
2131: p_pei_information9 in per_people_extra_info.pei_information9%type default null,
2132: p_pei_information10 in per_people_extra_info.pei_information10%type default null,
2133: p_pei_information11 in per_people_extra_info.pei_information11%type default null,
2134: p_pei_information12 in per_people_extra_info.pei_information12%type default null,
2135: p_pei_information13 in per_people_extra_info.pei_information13%type default null,

Line 2132: p_pei_information10 in per_people_extra_info.pei_information10%type default null,

2128: p_pei_information6 in per_people_extra_info.pei_information6%type default null,
2129: p_pei_information7 in per_people_extra_info.pei_information7%type default null,
2130: p_pei_information8 in per_people_extra_info.pei_information8%type default null,
2131: p_pei_information9 in per_people_extra_info.pei_information9%type default null,
2132: p_pei_information10 in per_people_extra_info.pei_information10%type default null,
2133: p_pei_information11 in per_people_extra_info.pei_information11%type default null,
2134: p_pei_information12 in per_people_extra_info.pei_information12%type default null,
2135: p_pei_information13 in per_people_extra_info.pei_information13%type default null,
2136: p_pei_information14 in per_people_extra_info.pei_information14%type default null,

Line 2133: p_pei_information11 in per_people_extra_info.pei_information11%type default null,

2129: p_pei_information7 in per_people_extra_info.pei_information7%type default null,
2130: p_pei_information8 in per_people_extra_info.pei_information8%type default null,
2131: p_pei_information9 in per_people_extra_info.pei_information9%type default null,
2132: p_pei_information10 in per_people_extra_info.pei_information10%type default null,
2133: p_pei_information11 in per_people_extra_info.pei_information11%type default null,
2134: p_pei_information12 in per_people_extra_info.pei_information12%type default null,
2135: p_pei_information13 in per_people_extra_info.pei_information13%type default null,
2136: p_pei_information14 in per_people_extra_info.pei_information14%type default null,
2137: p_pei_information15 in per_people_extra_info.pei_information15%type default null,

Line 2134: p_pei_information12 in per_people_extra_info.pei_information12%type default null,

2130: p_pei_information8 in per_people_extra_info.pei_information8%type default null,
2131: p_pei_information9 in per_people_extra_info.pei_information9%type default null,
2132: p_pei_information10 in per_people_extra_info.pei_information10%type default null,
2133: p_pei_information11 in per_people_extra_info.pei_information11%type default null,
2134: p_pei_information12 in per_people_extra_info.pei_information12%type default null,
2135: p_pei_information13 in per_people_extra_info.pei_information13%type default null,
2136: p_pei_information14 in per_people_extra_info.pei_information14%type default null,
2137: p_pei_information15 in per_people_extra_info.pei_information15%type default null,
2138: p_pei_information16 in per_people_extra_info.pei_information16%type default null,

Line 2135: p_pei_information13 in per_people_extra_info.pei_information13%type default null,

2131: p_pei_information9 in per_people_extra_info.pei_information9%type default null,
2132: p_pei_information10 in per_people_extra_info.pei_information10%type default null,
2133: p_pei_information11 in per_people_extra_info.pei_information11%type default null,
2134: p_pei_information12 in per_people_extra_info.pei_information12%type default null,
2135: p_pei_information13 in per_people_extra_info.pei_information13%type default null,
2136: p_pei_information14 in per_people_extra_info.pei_information14%type default null,
2137: p_pei_information15 in per_people_extra_info.pei_information15%type default null,
2138: p_pei_information16 in per_people_extra_info.pei_information16%type default null,
2139: p_pei_information17 in per_people_extra_info.pei_information17%type default null,

Line 2136: p_pei_information14 in per_people_extra_info.pei_information14%type default null,

2132: p_pei_information10 in per_people_extra_info.pei_information10%type default null,
2133: p_pei_information11 in per_people_extra_info.pei_information11%type default null,
2134: p_pei_information12 in per_people_extra_info.pei_information12%type default null,
2135: p_pei_information13 in per_people_extra_info.pei_information13%type default null,
2136: p_pei_information14 in per_people_extra_info.pei_information14%type default null,
2137: p_pei_information15 in per_people_extra_info.pei_information15%type default null,
2138: p_pei_information16 in per_people_extra_info.pei_information16%type default null,
2139: p_pei_information17 in per_people_extra_info.pei_information17%type default null,
2140: p_pei_information18 in per_people_extra_info.pei_information18%type default null,

Line 2137: p_pei_information15 in per_people_extra_info.pei_information15%type default null,

2133: p_pei_information11 in per_people_extra_info.pei_information11%type default null,
2134: p_pei_information12 in per_people_extra_info.pei_information12%type default null,
2135: p_pei_information13 in per_people_extra_info.pei_information13%type default null,
2136: p_pei_information14 in per_people_extra_info.pei_information14%type default null,
2137: p_pei_information15 in per_people_extra_info.pei_information15%type default null,
2138: p_pei_information16 in per_people_extra_info.pei_information16%type default null,
2139: p_pei_information17 in per_people_extra_info.pei_information17%type default null,
2140: p_pei_information18 in per_people_extra_info.pei_information18%type default null,
2141: p_pei_information19 in per_people_extra_info.pei_information19%type default null,

Line 2138: p_pei_information16 in per_people_extra_info.pei_information16%type default null,

2134: p_pei_information12 in per_people_extra_info.pei_information12%type default null,
2135: p_pei_information13 in per_people_extra_info.pei_information13%type default null,
2136: p_pei_information14 in per_people_extra_info.pei_information14%type default null,
2137: p_pei_information15 in per_people_extra_info.pei_information15%type default null,
2138: p_pei_information16 in per_people_extra_info.pei_information16%type default null,
2139: p_pei_information17 in per_people_extra_info.pei_information17%type default null,
2140: p_pei_information18 in per_people_extra_info.pei_information18%type default null,
2141: p_pei_information19 in per_people_extra_info.pei_information19%type default null,
2142: p_pei_information20 in per_people_extra_info.pei_information20%type default null,

Line 2139: p_pei_information17 in per_people_extra_info.pei_information17%type default null,

2135: p_pei_information13 in per_people_extra_info.pei_information13%type default null,
2136: p_pei_information14 in per_people_extra_info.pei_information14%type default null,
2137: p_pei_information15 in per_people_extra_info.pei_information15%type default null,
2138: p_pei_information16 in per_people_extra_info.pei_information16%type default null,
2139: p_pei_information17 in per_people_extra_info.pei_information17%type default null,
2140: p_pei_information18 in per_people_extra_info.pei_information18%type default null,
2141: p_pei_information19 in per_people_extra_info.pei_information19%type default null,
2142: p_pei_information20 in per_people_extra_info.pei_information20%type default null,
2143: p_pei_information21 in per_people_extra_info.pei_information21%type default null,

Line 2140: p_pei_information18 in per_people_extra_info.pei_information18%type default null,

2136: p_pei_information14 in per_people_extra_info.pei_information14%type default null,
2137: p_pei_information15 in per_people_extra_info.pei_information15%type default null,
2138: p_pei_information16 in per_people_extra_info.pei_information16%type default null,
2139: p_pei_information17 in per_people_extra_info.pei_information17%type default null,
2140: p_pei_information18 in per_people_extra_info.pei_information18%type default null,
2141: p_pei_information19 in per_people_extra_info.pei_information19%type default null,
2142: p_pei_information20 in per_people_extra_info.pei_information20%type default null,
2143: p_pei_information21 in per_people_extra_info.pei_information21%type default null,
2144: p_pei_information22 in per_people_extra_info.pei_information22%type default null,

Line 2141: p_pei_information19 in per_people_extra_info.pei_information19%type default null,

2137: p_pei_information15 in per_people_extra_info.pei_information15%type default null,
2138: p_pei_information16 in per_people_extra_info.pei_information16%type default null,
2139: p_pei_information17 in per_people_extra_info.pei_information17%type default null,
2140: p_pei_information18 in per_people_extra_info.pei_information18%type default null,
2141: p_pei_information19 in per_people_extra_info.pei_information19%type default null,
2142: p_pei_information20 in per_people_extra_info.pei_information20%type default null,
2143: p_pei_information21 in per_people_extra_info.pei_information21%type default null,
2144: p_pei_information22 in per_people_extra_info.pei_information22%type default null,
2145: p_pei_information23 in per_people_extra_info.pei_information23%type default null,

Line 2142: p_pei_information20 in per_people_extra_info.pei_information20%type default null,

2138: p_pei_information16 in per_people_extra_info.pei_information16%type default null,
2139: p_pei_information17 in per_people_extra_info.pei_information17%type default null,
2140: p_pei_information18 in per_people_extra_info.pei_information18%type default null,
2141: p_pei_information19 in per_people_extra_info.pei_information19%type default null,
2142: p_pei_information20 in per_people_extra_info.pei_information20%type default null,
2143: p_pei_information21 in per_people_extra_info.pei_information21%type default null,
2144: p_pei_information22 in per_people_extra_info.pei_information22%type default null,
2145: p_pei_information23 in per_people_extra_info.pei_information23%type default null,
2146: p_pei_information24 in per_people_extra_info.pei_information24%type default null,

Line 2143: p_pei_information21 in per_people_extra_info.pei_information21%type default null,

2139: p_pei_information17 in per_people_extra_info.pei_information17%type default null,
2140: p_pei_information18 in per_people_extra_info.pei_information18%type default null,
2141: p_pei_information19 in per_people_extra_info.pei_information19%type default null,
2142: p_pei_information20 in per_people_extra_info.pei_information20%type default null,
2143: p_pei_information21 in per_people_extra_info.pei_information21%type default null,
2144: p_pei_information22 in per_people_extra_info.pei_information22%type default null,
2145: p_pei_information23 in per_people_extra_info.pei_information23%type default null,
2146: p_pei_information24 in per_people_extra_info.pei_information24%type default null,
2147: p_pei_information25 in per_people_extra_info.pei_information25%type default null,

Line 2144: p_pei_information22 in per_people_extra_info.pei_information22%type default null,

2140: p_pei_information18 in per_people_extra_info.pei_information18%type default null,
2141: p_pei_information19 in per_people_extra_info.pei_information19%type default null,
2142: p_pei_information20 in per_people_extra_info.pei_information20%type default null,
2143: p_pei_information21 in per_people_extra_info.pei_information21%type default null,
2144: p_pei_information22 in per_people_extra_info.pei_information22%type default null,
2145: p_pei_information23 in per_people_extra_info.pei_information23%type default null,
2146: p_pei_information24 in per_people_extra_info.pei_information24%type default null,
2147: p_pei_information25 in per_people_extra_info.pei_information25%type default null,
2148: p_pei_information26 in per_people_extra_info.pei_information26%type default null,

Line 2145: p_pei_information23 in per_people_extra_info.pei_information23%type default null,

2141: p_pei_information19 in per_people_extra_info.pei_information19%type default null,
2142: p_pei_information20 in per_people_extra_info.pei_information20%type default null,
2143: p_pei_information21 in per_people_extra_info.pei_information21%type default null,
2144: p_pei_information22 in per_people_extra_info.pei_information22%type default null,
2145: p_pei_information23 in per_people_extra_info.pei_information23%type default null,
2146: p_pei_information24 in per_people_extra_info.pei_information24%type default null,
2147: p_pei_information25 in per_people_extra_info.pei_information25%type default null,
2148: p_pei_information26 in per_people_extra_info.pei_information26%type default null,
2149: p_pei_information27 in per_people_extra_info.pei_information27%type default null,

Line 2146: p_pei_information24 in per_people_extra_info.pei_information24%type default null,

2142: p_pei_information20 in per_people_extra_info.pei_information20%type default null,
2143: p_pei_information21 in per_people_extra_info.pei_information21%type default null,
2144: p_pei_information22 in per_people_extra_info.pei_information22%type default null,
2145: p_pei_information23 in per_people_extra_info.pei_information23%type default null,
2146: p_pei_information24 in per_people_extra_info.pei_information24%type default null,
2147: p_pei_information25 in per_people_extra_info.pei_information25%type default null,
2148: p_pei_information26 in per_people_extra_info.pei_information26%type default null,
2149: p_pei_information27 in per_people_extra_info.pei_information27%type default null,
2150: p_pei_information28 in per_people_extra_info.pei_information28%type default null,

Line 2147: p_pei_information25 in per_people_extra_info.pei_information25%type default null,

2143: p_pei_information21 in per_people_extra_info.pei_information21%type default null,
2144: p_pei_information22 in per_people_extra_info.pei_information22%type default null,
2145: p_pei_information23 in per_people_extra_info.pei_information23%type default null,
2146: p_pei_information24 in per_people_extra_info.pei_information24%type default null,
2147: p_pei_information25 in per_people_extra_info.pei_information25%type default null,
2148: p_pei_information26 in per_people_extra_info.pei_information26%type default null,
2149: p_pei_information27 in per_people_extra_info.pei_information27%type default null,
2150: p_pei_information28 in per_people_extra_info.pei_information28%type default null,
2151: p_pei_information29 in per_people_extra_info.pei_information29%type default null,

Line 2148: p_pei_information26 in per_people_extra_info.pei_information26%type default null,

2144: p_pei_information22 in per_people_extra_info.pei_information22%type default null,
2145: p_pei_information23 in per_people_extra_info.pei_information23%type default null,
2146: p_pei_information24 in per_people_extra_info.pei_information24%type default null,
2147: p_pei_information25 in per_people_extra_info.pei_information25%type default null,
2148: p_pei_information26 in per_people_extra_info.pei_information26%type default null,
2149: p_pei_information27 in per_people_extra_info.pei_information27%type default null,
2150: p_pei_information28 in per_people_extra_info.pei_information28%type default null,
2151: p_pei_information29 in per_people_extra_info.pei_information29%type default null,
2152: p_pei_information30 in per_people_extra_info.pei_information30%type default null,

Line 2149: p_pei_information27 in per_people_extra_info.pei_information27%type default null,

2145: p_pei_information23 in per_people_extra_info.pei_information23%type default null,
2146: p_pei_information24 in per_people_extra_info.pei_information24%type default null,
2147: p_pei_information25 in per_people_extra_info.pei_information25%type default null,
2148: p_pei_information26 in per_people_extra_info.pei_information26%type default null,
2149: p_pei_information27 in per_people_extra_info.pei_information27%type default null,
2150: p_pei_information28 in per_people_extra_info.pei_information28%type default null,
2151: p_pei_information29 in per_people_extra_info.pei_information29%type default null,
2152: p_pei_information30 in per_people_extra_info.pei_information30%type default null,
2153: -- p_object_version_number in per_people_extra_info.object_version_number%type default null,

Line 2150: p_pei_information28 in per_people_extra_info.pei_information28%type default null,

2146: p_pei_information24 in per_people_extra_info.pei_information24%type default null,
2147: p_pei_information25 in per_people_extra_info.pei_information25%type default null,
2148: p_pei_information26 in per_people_extra_info.pei_information26%type default null,
2149: p_pei_information27 in per_people_extra_info.pei_information27%type default null,
2150: p_pei_information28 in per_people_extra_info.pei_information28%type default null,
2151: p_pei_information29 in per_people_extra_info.pei_information29%type default null,
2152: p_pei_information30 in per_people_extra_info.pei_information30%type default null,
2153: -- p_object_version_number in per_people_extra_info.object_version_number%type default null,
2154: p_peopleei_data in out nocopy per_people_extra_info%rowtype ) as

Line 2151: p_pei_information29 in per_people_extra_info.pei_information29%type default null,

2147: p_pei_information25 in per_people_extra_info.pei_information25%type default null,
2148: p_pei_information26 in per_people_extra_info.pei_information26%type default null,
2149: p_pei_information27 in per_people_extra_info.pei_information27%type default null,
2150: p_pei_information28 in per_people_extra_info.pei_information28%type default null,
2151: p_pei_information29 in per_people_extra_info.pei_information29%type default null,
2152: p_pei_information30 in per_people_extra_info.pei_information30%type default null,
2153: -- p_object_version_number in per_people_extra_info.object_version_number%type default null,
2154: p_peopleei_data in out nocopy per_people_extra_info%rowtype ) as
2155:

Line 2152: p_pei_information30 in per_people_extra_info.pei_information30%type default null,

2148: p_pei_information26 in per_people_extra_info.pei_information26%type default null,
2149: p_pei_information27 in per_people_extra_info.pei_information27%type default null,
2150: p_pei_information28 in per_people_extra_info.pei_information28%type default null,
2151: p_pei_information29 in per_people_extra_info.pei_information29%type default null,
2152: p_pei_information30 in per_people_extra_info.pei_information30%type default null,
2153: -- p_object_version_number in per_people_extra_info.object_version_number%type default null,
2154: p_peopleei_data in out nocopy per_people_extra_info%rowtype ) as
2155:
2156: l_proc varchar2(30):= 'conv_to_peopleei_rg ';

Line 2153: -- p_object_version_number in per_people_extra_info.object_version_number%type default null,

2149: p_pei_information27 in per_people_extra_info.pei_information27%type default null,
2150: p_pei_information28 in per_people_extra_info.pei_information28%type default null,
2151: p_pei_information29 in per_people_extra_info.pei_information29%type default null,
2152: p_pei_information30 in per_people_extra_info.pei_information30%type default null,
2153: -- p_object_version_number in per_people_extra_info.object_version_number%type default null,
2154: p_peopleei_data in out nocopy per_people_extra_info%rowtype ) as
2155:
2156: l_proc varchar2(30):= 'conv_to_peopleei_rg ';
2157: l_peopleei_data per_people_extra_info%rowtype;

Line 2154: p_peopleei_data in out nocopy per_people_extra_info%rowtype ) as

2150: p_pei_information28 in per_people_extra_info.pei_information28%type default null,
2151: p_pei_information29 in per_people_extra_info.pei_information29%type default null,
2152: p_pei_information30 in per_people_extra_info.pei_information30%type default null,
2153: -- p_object_version_number in per_people_extra_info.object_version_number%type default null,
2154: p_peopleei_data in out nocopy per_people_extra_info%rowtype ) as
2155:
2156: l_proc varchar2(30):= 'conv_to_peopleei_rg ';
2157: l_peopleei_data per_people_extra_info%rowtype;
2158:

Line 2157: l_peopleei_data per_people_extra_info%rowtype;

2153: -- p_object_version_number in per_people_extra_info.object_version_number%type default null,
2154: p_peopleei_data in out nocopy per_people_extra_info%rowtype ) as
2155:
2156: l_proc varchar2(30):= 'conv_to_peopleei_rg ';
2157: l_peopleei_data per_people_extra_info%rowtype;
2158:
2159: begin
2160:
2161: l_peopleei_data :=p_peopleei_data; --NOCOPY CHANGES

Line 2297: -- procedure conv_peopleei_rg_to_hist_rg converts the per_people_extra_info record type

2293: End conv_to_peopleei_rg;
2294:
2295:
2296:
2297: -- procedure conv_peopleei_rg_to_hist_rg converts the per_people_extra_info record type
2298: -- to ghr_pa_history record type
2299: Procedure conv_peopleei_rg_to_hist_rg(
2300: p_people_ei_data in per_people_extra_info%rowtype,
2301: p_history_data in out nocopy ghr_pa_history%rowtype) as

Line 2300: p_people_ei_data in per_people_extra_info%rowtype,

2296:
2297: -- procedure conv_peopleei_rg_to_hist_rg converts the per_people_extra_info record type
2298: -- to ghr_pa_history record type
2299: Procedure conv_peopleei_rg_to_hist_rg(
2300: p_people_ei_data in per_people_extra_info%rowtype,
2301: p_history_data in out nocopy ghr_pa_history%rowtype) as
2302:
2303: l_proc varchar2(30) := 'conv_peopleei_rg_to_hist_rg';
2304: l_history_data ghr_pa_history%rowtype;

Line 2386: -- per_people_extra_info type

2382:
2383: end conv_peopleei_rg_to_hist_rg;
2384:
2385: -- procedure conv_to_peopleei_rg converts the ghr_pa_history record type to
2386: -- per_people_extra_info type
2387: --
2388: Procedure conv_to_peopleei_rg(
2389: p_history_data in ghr_pa_history%rowtype,
2390: p_people_ei_data in out nocopy per_people_extra_info%rowtype ) as

Line 2390: p_people_ei_data in out nocopy per_people_extra_info%rowtype ) as

2386: -- per_people_extra_info type
2387: --
2388: Procedure conv_to_peopleei_rg(
2389: p_history_data in ghr_pa_history%rowtype,
2390: p_people_ei_data in out nocopy per_people_extra_info%rowtype ) as
2391:
2392: l_proc varchar2(30) := 'conv_to_peopleei_rg';
2393: l_people_ei_data per_people_extra_info%rowtype;
2394:

Line 2393: l_people_ei_data per_people_extra_info%rowtype;

2389: p_history_data in ghr_pa_history%rowtype,
2390: p_people_ei_data in out nocopy per_people_extra_info%rowtype ) as
2391:
2392: l_proc varchar2(30) := 'conv_to_peopleei_rg';
2393: l_people_ei_data per_people_extra_info%rowtype;
2394:
2395: begin
2396:
2397: l_people_ei_data :=p_people_ei_data; --NOCOPY CHANGES