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 1133: -- This procedure cascades data changes in per_people_extra_info core application table.

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

Line 1166: l_peopleei_data per_people_extra_info%rowtype;

1162: p_post_record in ghr_pa_history%rowtype
1163: ) is
1164:
1165: l_hist_peopleei_data ghr_pa_history%rowtype;
1166: l_peopleei_data per_people_extra_info%rowtype;
1167: l_result_code varchar2(30);
1168: l_proc varchar2(30):='Cascade_peopleei';
1169:
1170: Begin

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

2111: -- ---------------------------------------------------------------------------
2112: -- {Start Of Comments}
2113: --
2114: -- Description:
2115: -- This procedure applies the record given to the per_people_extra_info table.
2116: --
2117: -- Pre-Requisities:
2118: -- None.
2119: --

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

2117: -- Pre-Requisities:
2118: -- None.
2119: --
2120: -- In Parameters:
2121: -- p_peopleei_data -> per_people_extra_info record that is being applied.
2122: --
2123: -- Post Success:
2124: -- per_people_extra_info record will have been applied.
2125: --

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

2120: -- In Parameters:
2121: -- p_peopleei_data -> per_people_extra_info record that is being applied.
2122: --
2123: -- Post Success:
2124: -- per_people_extra_info record will have been applied.
2125: --
2126: -- Post Failure:
2127: -- Error would have been displayed to user and exception raised.
2128: --

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

2133: -- Internal Development Use Only.
2134: --
2135: -- {End Of Comments}
2136: -- ---------------------------------------------------------------------------
2137: Procedure Correct_peopleei_row ( p_peopleei_data in out nocopy per_people_extra_info%rowtype) is
2138:
2139: -- this cursor gets the object_version_number from core table, so the core
2140: -- table can be updated.
2141: cursor c_peopleei_getovn( cp_people_ei_id number) is

Line 2143: from per_people_extra_info

2139: -- this cursor gets the object_version_number from core table, so the core
2140: -- table can be updated.
2141: cursor c_peopleei_getovn( cp_people_ei_id number) is
2142: select object_version_number
2143: from per_people_extra_info
2144: where person_extra_info_id = cp_people_ei_id;
2145:
2146: l_peopleei_data per_people_extra_info%rowtype;
2147: l_proc varchar2(30):='correct_peopleei_row';

Line 2146: l_peopleei_data per_people_extra_info%rowtype;

2142: select object_version_number
2143: from per_people_extra_info
2144: where person_extra_info_id = cp_people_ei_id;
2145:
2146: l_peopleei_data per_people_extra_info%rowtype;
2147: l_proc varchar2(30):='correct_peopleei_row';
2148: Begin
2149: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2150: hr_utility.set_location( 'p_peopleei_data.person_extra_info_id : ' || p_peopleei_data.person_extra_info_id || l_proc, 11);