APPS.GHR_HISTORY_CASCADE dependencies on PER_PERSON_ANALYSES

Line 63: Procedure correct_perana_row( p_perana_data in out nocopy per_person_analyses%rowtype);

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);
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);

Line 1649: -- This procedure cascades data changes in per_person_analyses core application table.

1645: -- ---------------------------------------------------------------------------
1646: -- {Start Of Comments}
1647: --
1648: -- Description:
1649: -- This procedure cascades data changes in per_person_analyses core application table.
1650: -- Since this table is not date-tracked by core, cascade of these
1651: -- tables simply re-applies the most recent record in history according to
1652: -- the sysdate. This is necessary because update to database will have applied
1653: -- any changes to this table regardless of effective date of the action. So, this

Line 1681: l_perana_data per_person_analyses%rowtype;

1677: Procedure Cascade_perana (
1678: p_post_record in ghr_pa_history%rowtype) is
1679:
1680: l_hist_perana_data ghr_pa_history%rowtype;
1681: l_perana_data per_person_analyses%rowtype;
1682: l_result_code varchar2(30);
1683: l_proc varchar2(30):='Cascade_perana';
1684:
1685: Begin

Line 2813: -- This procedure applies the record given to the per_person_analyses table.

2809: -- ---------------------------------------------------------------------------
2810: -- {Start Of Comments}
2811: --
2812: -- Description:
2813: -- This procedure applies the record given to the per_person_analyses table.
2814: --
2815: -- Pre-Requisities:
2816: -- None.
2817: --

Line 2819: -- p_perana_data -> per_person_analyses record that is being applied.

2815: -- Pre-Requisities:
2816: -- None.
2817: --
2818: -- In Parameters:
2819: -- p_perana_data -> per_person_analyses record that is being applied.
2820: --
2821: -- Post Success:
2822: -- per_person_analyses record will have been applied.
2823: --

Line 2822: -- per_person_analyses record will have been applied.

2818: -- In Parameters:
2819: -- p_perana_data -> per_person_analyses record that is being applied.
2820: --
2821: -- Post Success:
2822: -- per_person_analyses record will have been applied.
2823: --
2824: -- Post Failure:
2825: -- Error would have been displayed to user and exception raised.
2826: --

Line 2835: Procedure correct_perana_row( p_perana_data in out nocopy per_person_analyses%rowtype) is

2831: -- Internal Development Use Only.
2832: --
2833: -- {End Of Comments}
2834: -- ---------------------------------------------------------------------------
2835: Procedure correct_perana_row( p_perana_data in out nocopy per_person_analyses%rowtype) is
2836:
2837: -- this cursor gets the object_version_number from core table, so the core
2838: -- table can be updated.
2839: cursor c_perana is

Line 2841: from per_person_analyses

2837: -- this cursor gets the object_version_number from core table, so the core
2838: -- table can be updated.
2839: cursor c_perana is
2840: select object_version_number
2841: from per_person_analyses
2842: where person_analysis_id = p_perana_data.person_analysis_id;
2843:
2844: l_perana_data per_person_analyses%rowtype;
2845: l_session_var ghr_history_api.g_session_var_type;

Line 2844: l_perana_data per_person_analyses%rowtype;

2840: select object_version_number
2841: from per_person_analyses
2842: where person_analysis_id = p_perana_data.person_analysis_id;
2843:
2844: l_perana_data per_person_analyses%rowtype;
2845: l_session_var ghr_history_api.g_session_var_type;
2846: l_proc varchar2(30):='correct_perana_row';
2847:
2848: Begin