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

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

Line 1248: l_asgnei_data per_assignment_extra_info%rowtype;

1244: p_post_record in ghr_pa_history%rowtype
1245: ) is
1246:
1247: l_hist_asgnei_data ghr_pa_history%rowtype;
1248: l_asgnei_data per_assignment_extra_info%rowtype;
1249: l_result_code varchar2(30);
1250: l_proc varchar2(30):='Cascade_asgnei';
1251:
1252: Begin

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

2265: -- ---------------------------------------------------------------------------
2266: -- {Start Of Comments}
2267: --
2268: -- Description:
2269: -- This procedure applies the record given to the per_assignment_extra_info table.
2270: --
2271: -- Pre-Requisities:
2272: -- None.
2273: --

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

2271: -- Pre-Requisities:
2272: -- None.
2273: --
2274: -- In Parameters:
2275: -- p_asgnei_data -> per_assignment_extra_info record that is being applied.
2276: --
2277: -- Post Success:
2278: -- per_assignment_extra_info record will have been applied.
2279: --

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

2274: -- In Parameters:
2275: -- p_asgnei_data -> per_assignment_extra_info record that is being applied.
2276: --
2277: -- Post Success:
2278: -- per_assignment_extra_info record will have been applied.
2279: --
2280: -- Post Failure:
2281: -- Error would have been displayed to user and exception raised.
2282: --

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

2289: -- {End Of Comments}
2290: -- ---------------------------------------------------------------------------
2291:
2292: -- Procedure Correct_asgnei_row will update the Per_People_F row in correct mode
2293: Procedure Correct_asgnei_row (p_asgnei_data in out nocopy per_assignment_extra_info%rowtype) is
2294:
2295: -- this cursor gets the object_version_number from core table, so the core
2296: -- table can be updated.
2297: cursor c_asgnei_getovn( cp_assignment_ei_id number) is

Line 2299: from per_assignment_extra_info

2295: -- this cursor gets the object_version_number from core table, so the core
2296: -- table can be updated.
2297: cursor c_asgnei_getovn( cp_assignment_ei_id number) is
2298: select object_version_number
2299: from per_assignment_extra_info
2300: where assignment_extra_info_id = cp_assignment_ei_id;
2301:
2302: l_asgnei_data per_assignment_extra_info%rowtype;
2303: l_proc varchar2(30):='Correct_asgnei_Row';

Line 2302: l_asgnei_data per_assignment_extra_info%rowtype;

2298: select object_version_number
2299: from per_assignment_extra_info
2300: where assignment_extra_info_id = cp_assignment_ei_id;
2301:
2302: l_asgnei_data per_assignment_extra_info%rowtype;
2303: l_proc varchar2(30):='Correct_asgnei_Row';
2304:
2305: Begin
2306: hr_utility.set_location( 'Entering : ' || l_proc, 20);