APPS.GHR_HISTORY_CASCADE dependencies on PER_PEOPLE_EXTRA_INFO

Line 59: Procedure correct_peopleei_row ( p_peopleei_data in out nocopy per_people_extra_info%rowtype);

55:
56: Procedure correct_asgn_row (
57: p_asgn_data in out nocopy per_all_assignments_f%rowtype);
58:
59: Procedure correct_peopleei_row ( p_peopleei_data in out nocopy per_people_extra_info%rowtype);
60:
61: Procedure correct_addresses_row( p_addr_data in out nocopy per_addresses%rowtype);
62:
63: Procedure correct_perana_row( p_perana_data in out nocopy per_person_analyses%rowtype);

Line 1139: -- This procedure cascades data changes in per_people_extra_info core application table.

1135: -- ---------------------------------------------------------------------------
1136: -- {Start Of Comments}
1137: --
1138: -- Description:
1139: -- This procedure cascades data changes in per_people_extra_info core application table.
1140: -- Since extra information tables are not date-tracked by core, cascade of these
1141: -- tables simply re-applies the most recent record in history according to
1142: -- the sysdate. This is necessary because update to database will have applied
1143: -- any changes to this table regardless of effective date of the action. So, this

Line 1172: l_peopleei_data per_people_extra_info%rowtype;

1168: p_post_record in ghr_pa_history%rowtype
1169: ) is
1170:
1171: l_hist_peopleei_data ghr_pa_history%rowtype;
1172: l_peopleei_data per_people_extra_info%rowtype;
1173: l_result_code varchar2(30);
1174: l_proc varchar2(30):='Cascade_peopleei';
1175:
1176: Begin

Line 2138: -- This procedure applies the record given to the per_people_extra_info table.

2134: -- ---------------------------------------------------------------------------
2135: -- {Start Of Comments}
2136: --
2137: -- Description:
2138: -- This procedure applies the record given to the per_people_extra_info table.
2139: --
2140: -- Pre-Requisities:
2141: -- None.
2142: --

Line 2144: -- p_peopleei_data -> per_people_extra_info record that is being applied.

2140: -- Pre-Requisities:
2141: -- None.
2142: --
2143: -- In Parameters:
2144: -- p_peopleei_data -> per_people_extra_info record that is being applied.
2145: --
2146: -- Post Success:
2147: -- per_people_extra_info record will have been applied.
2148: --

Line 2147: -- per_people_extra_info record will have been applied.

2143: -- In Parameters:
2144: -- p_peopleei_data -> per_people_extra_info record that is being applied.
2145: --
2146: -- Post Success:
2147: -- per_people_extra_info record will have been applied.
2148: --
2149: -- Post Failure:
2150: -- Error would have been displayed to user and exception raised.
2151: --

Line 2160: Procedure Correct_peopleei_row ( p_peopleei_data in out nocopy per_people_extra_info%rowtype) is

2156: -- Internal Development Use Only.
2157: --
2158: -- {End Of Comments}
2159: -- ---------------------------------------------------------------------------
2160: Procedure Correct_peopleei_row ( p_peopleei_data in out nocopy per_people_extra_info%rowtype) is
2161:
2162: -- this cursor gets the object_version_number from core table, so the core
2163: -- table can be updated.
2164: cursor c_peopleei_getovn( cp_people_ei_id number) is

Line 2166: from per_people_extra_info

2162: -- this cursor gets the object_version_number from core table, so the core
2163: -- table can be updated.
2164: cursor c_peopleei_getovn( cp_people_ei_id number) is
2165: select object_version_number
2166: from per_people_extra_info
2167: where person_extra_info_id = cp_people_ei_id;
2168:
2169: l_peopleei_data per_people_extra_info%rowtype;
2170: l_proc varchar2(30):='correct_peopleei_row';

Line 2169: l_peopleei_data per_people_extra_info%rowtype;

2165: select object_version_number
2166: from per_people_extra_info
2167: where person_extra_info_id = cp_people_ei_id;
2168:
2169: l_peopleei_data per_people_extra_info%rowtype;
2170: l_proc varchar2(30):='correct_peopleei_row';
2171: Begin
2172: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2173: hr_utility.set_location( 'p_peopleei_data.person_extra_info_id : ' || p_peopleei_data.person_extra_info_id || l_proc, 11);