APPS.GHR_HISTORY_CASCADE dependencies on PER_POSITION_EXTRA_INFO

Line 65: Procedure Correct_posnei_row (p_posnei_data in out nocopy per_position_extra_info%rowtype);

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);
64:
65: Procedure Correct_posnei_row (p_posnei_data in out nocopy per_position_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 (

Line 1288: -- This procedure cascades data changes in per_position_extra_info core application table.

1284: -- ---------------------------------------------------------------------------
1285: -- {Start Of Comments}
1286: --
1287: -- Description:
1288: -- This procedure cascades data changes in per_position_extra_info core application table.
1289: -- Since extra information tables are not date-tracked by core, cascade of these
1290: -- tables simply re-applies the most recent record in history according to
1291: -- the sysdate. This is necessary because update to database will have applied
1292: -- any changes to this table regardless of effective date of the action. So, this

Line 1320: l_posnei_data per_position_extra_info%rowtype;

1316: Procedure Cascade_posnei (
1317: p_post_record in ghr_pa_history%rowtype) is
1318:
1319: l_hist_posnei_data ghr_pa_history%rowtype;
1320: l_posnei_data per_position_extra_info%rowtype;
1321: l_result_code varchar2(30);
1322: l_proc varchar2(30):='Cascade_posnei';
1323:
1324: l_curr_sess_date fnd_sessions.effective_date%type;

Line 2396: -- This procedure applies the record given to the per_position_extra_info table.

2392: -- ---------------------------------------------------------------------------
2393: -- {Start Of Comments}
2394: --
2395: -- Description:
2396: -- This procedure applies the record given to the per_position_extra_info table.
2397: --
2398: -- Pre-Requisities:
2399: -- None.
2400: --

Line 2402: -- p_posnei_data -> per_position_extra_info record that is being applied.

2398: -- Pre-Requisities:
2399: -- None.
2400: --
2401: -- In Parameters:
2402: -- p_posnei_data -> per_position_extra_info record that is being applied.
2403: --
2404: -- Post Success:
2405: -- per_position_extra_info record will have been applied.
2406: --

Line 2405: -- per_position_extra_info record will have been applied.

2401: -- In Parameters:
2402: -- p_posnei_data -> per_position_extra_info record that is being applied.
2403: --
2404: -- Post Success:
2405: -- per_position_extra_info record will have been applied.
2406: --
2407: -- Post Failure:
2408: -- Error would have been displayed to user and exception raised.
2409: --

Line 2418: -- Procedure Correct_posnei_row will update the Per_position_extra_info row in correct mode

2414: -- Internal Development Use Only.
2415: --
2416: -- {End Of Comments}
2417: -- ---------------------------------------------------------------------------
2418: -- Procedure Correct_posnei_row will update the Per_position_extra_info row in correct mode
2419: Procedure Correct_posnei_row (p_posnei_data in out nocopy per_position_extra_info%rowtype) is
2420:
2421: -- this cursor gets the object_version_number from core table, so the core
2422: -- table can be updated.

Line 2419: Procedure Correct_posnei_row (p_posnei_data in out nocopy per_position_extra_info%rowtype) is

2415: --
2416: -- {End Of Comments}
2417: -- ---------------------------------------------------------------------------
2418: -- Procedure Correct_posnei_row will update the Per_position_extra_info row in correct mode
2419: Procedure Correct_posnei_row (p_posnei_data in out nocopy per_position_extra_info%rowtype) is
2420:
2421: -- this cursor gets the object_version_number from core table, so the core
2422: -- table can be updated.
2423: cursor c_posnei_getovn( cp_position_ei_id number) is

Line 2425: from per_position_extra_info

2421: -- this cursor gets the object_version_number from core table, so the core
2422: -- table can be updated.
2423: cursor c_posnei_getovn( cp_position_ei_id number) is
2424: select object_version_number
2425: from per_position_extra_info
2426: where position_extra_info_id = cp_position_ei_id;
2427:
2428: l_posnei_data per_position_extra_info%rowtype;
2429: l_proc varchar2(30):='Correct_posnei_Row';

Line 2428: l_posnei_data per_position_extra_info%rowtype;

2424: select object_version_number
2425: from per_position_extra_info
2426: where position_extra_info_id = cp_position_ei_id;
2427:
2428: l_posnei_data per_position_extra_info%rowtype;
2429: l_proc varchar2(30):='Correct_posnei_Row';
2430:
2431: Begin
2432: hr_utility.set_location( 'Entering : ' || l_proc, 10);