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

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

Line 1314: l_posnei_data per_position_extra_info%rowtype;

1310: Procedure Cascade_posnei (
1311: p_post_record in ghr_pa_history%rowtype) is
1312:
1313: l_hist_posnei_data ghr_pa_history%rowtype;
1314: l_posnei_data per_position_extra_info%rowtype;
1315: l_result_code varchar2(30);
1316: l_proc varchar2(30):='Cascade_posnei';
1317:
1318: Begin

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

2369: -- ---------------------------------------------------------------------------
2370: -- {Start Of Comments}
2371: --
2372: -- Description:
2373: -- This procedure applies the record given to the per_position_extra_info table.
2374: --
2375: -- Pre-Requisities:
2376: -- None.
2377: --

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

2375: -- Pre-Requisities:
2376: -- None.
2377: --
2378: -- In Parameters:
2379: -- p_posnei_data -> per_position_extra_info record that is being applied.
2380: --
2381: -- Post Success:
2382: -- per_position_extra_info record will have been applied.
2383: --

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

2378: -- In Parameters:
2379: -- p_posnei_data -> per_position_extra_info record that is being applied.
2380: --
2381: -- Post Success:
2382: -- per_position_extra_info record will have been applied.
2383: --
2384: -- Post Failure:
2385: -- Error would have been displayed to user and exception raised.
2386: --

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

2391: -- Internal Development Use Only.
2392: --
2393: -- {End Of Comments}
2394: -- ---------------------------------------------------------------------------
2395: -- Procedure Correct_posnei_row will update the Per_position_extra_info row in correct mode
2396: Procedure Correct_posnei_row (p_posnei_data in out nocopy per_position_extra_info%rowtype) is
2397:
2398: -- this cursor gets the object_version_number from core table, so the core
2399: -- table can be updated.

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

2392: --
2393: -- {End Of Comments}
2394: -- ---------------------------------------------------------------------------
2395: -- Procedure Correct_posnei_row will update the Per_position_extra_info row in correct mode
2396: Procedure Correct_posnei_row (p_posnei_data in out nocopy per_position_extra_info%rowtype) is
2397:
2398: -- this cursor gets the object_version_number from core table, so the core
2399: -- table can be updated.
2400: cursor c_posnei_getovn( cp_position_ei_id number) is

Line 2402: from per_position_extra_info

2398: -- this cursor gets the object_version_number from core table, so the core
2399: -- table can be updated.
2400: cursor c_posnei_getovn( cp_position_ei_id number) is
2401: select object_version_number
2402: from per_position_extra_info
2403: where position_extra_info_id = cp_position_ei_id;
2404:
2405: l_posnei_data per_position_extra_info%rowtype;
2406: l_proc varchar2(30):='Correct_posnei_Row';

Line 2405: l_posnei_data per_position_extra_info%rowtype;

2401: select object_version_number
2402: from per_position_extra_info
2403: where position_extra_info_id = cp_position_ei_id;
2404:
2405: l_posnei_data per_position_extra_info%rowtype;
2406: l_proc varchar2(30):='Correct_posnei_Row';
2407:
2408: Begin
2409: hr_utility.set_location( 'Entering : ' || l_proc, 10);