APPS.GHR_HISTORY_CASCADE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 70: p_asgnei_data in out nocopy per_assignment_extra_info%rowtype);

66:
67: Procedure Correct_posn_row (p_posn_data in out nocopy hr_all_positions_f%rowtype);
68:
69: Procedure Correct_asgnei_row (
70: p_asgnei_data in out nocopy per_assignment_extra_info%rowtype);
71:
72: Procedure cascade_change( p_pre_record in ghr_pa_history%rowtype,
73: p_post_record in ghr_pa_history%rowtype,
74: p_apply_record in out nocopy ghr_pa_history%rowtype,

Line 1208: -- This procedure cascades data changes in per_assignment_extra_info core application table.

1204: -- ---------------------------------------------------------------------------
1205: -- {Start Of Comments}
1206: --
1207: -- Description:
1208: -- This procedure cascades data changes in per_assignment_extra_info core application table.
1209: -- Since extra information tables are not date-tracked by core, cascade of these
1210: -- tables simply re-applies the most recent record in history according to
1211: -- the sysdate. This is necessary because update to database will have applied
1212: -- any changes to this table regardless of effective date of the action. So, this

Line 1242: l_asgnei_data per_assignment_extra_info%rowtype;

1238: p_post_record in ghr_pa_history%rowtype
1239: ) is
1240:
1241: l_hist_asgnei_data ghr_pa_history%rowtype;
1242: l_asgnei_data per_assignment_extra_info%rowtype;
1243: l_result_code varchar2(30);
1244: l_proc varchar2(30):='Cascade_asgnei';
1245:
1246: Begin

Line 2246: -- This procedure applies the record given to the per_assignment_extra_info table.

2242: -- ---------------------------------------------------------------------------
2243: -- {Start Of Comments}
2244: --
2245: -- Description:
2246: -- This procedure applies the record given to the per_assignment_extra_info table.
2247: --
2248: -- Pre-Requisities:
2249: -- None.
2250: --

Line 2252: -- p_asgnei_data -> per_assignment_extra_info record that is being applied.

2248: -- Pre-Requisities:
2249: -- None.
2250: --
2251: -- In Parameters:
2252: -- p_asgnei_data -> per_assignment_extra_info record that is being applied.
2253: --
2254: -- Post Success:
2255: -- per_assignment_extra_info record will have been applied.
2256: --

Line 2255: -- per_assignment_extra_info record will have been applied.

2251: -- In Parameters:
2252: -- p_asgnei_data -> per_assignment_extra_info record that is being applied.
2253: --
2254: -- Post Success:
2255: -- per_assignment_extra_info record will have been applied.
2256: --
2257: -- Post Failure:
2258: -- Error would have been displayed to user and exception raised.
2259: --

Line 2270: Procedure Correct_asgnei_row (p_asgnei_data in out nocopy per_assignment_extra_info%rowtype) is

2266: -- {End Of Comments}
2267: -- ---------------------------------------------------------------------------
2268:
2269: -- Procedure Correct_asgnei_row will update the Per_People_F row in correct mode
2270: Procedure Correct_asgnei_row (p_asgnei_data in out nocopy per_assignment_extra_info%rowtype) is
2271:
2272: -- this cursor gets the object_version_number from core table, so the core
2273: -- table can be updated.
2274: cursor c_asgnei_getovn( cp_assignment_ei_id number) is

Line 2276: from per_assignment_extra_info

2272: -- this cursor gets the object_version_number from core table, so the core
2273: -- table can be updated.
2274: cursor c_asgnei_getovn( cp_assignment_ei_id number) is
2275: select object_version_number
2276: from per_assignment_extra_info
2277: where assignment_extra_info_id = cp_assignment_ei_id;
2278:
2279: l_asgnei_data per_assignment_extra_info%rowtype;
2280: l_proc varchar2(30):='Correct_asgnei_Row';

Line 2279: l_asgnei_data per_assignment_extra_info%rowtype;

2275: select object_version_number
2276: from per_assignment_extra_info
2277: where assignment_extra_info_id = cp_assignment_ei_id;
2278:
2279: l_asgnei_data per_assignment_extra_info%rowtype;
2280: l_proc varchar2(30):='Correct_asgnei_Row';
2281:
2282: Begin
2283: hr_utility.set_location( 'Entering : ' || l_proc, 20);