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

1668: -- ---------------------------------------------------------------------------
1669: -- {Start Of Comments}
1670: --
1671: -- Description:
1672: -- This procedure cascades data changes in per_person_analyses core application table.
1673: -- Since this table is not date-tracked by core, cascade of these
1674: -- tables simply re-applies the most recent record in history according to
1675: -- the sysdate. This is necessary because update to database will have applied
1676: -- any changes to this table regardless of effective date of the action. So, this

Line 1704: l_perana_data per_person_analyses%rowtype;

1700: Procedure Cascade_perana (
1701: p_post_record in ghr_pa_history%rowtype) is
1702:
1703: l_hist_perana_data ghr_pa_history%rowtype;
1704: l_perana_data per_person_analyses%rowtype;
1705: l_result_code varchar2(30);
1706: l_proc varchar2(30):='Cascade_perana';
1707:
1708: Begin

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

2835: -- ---------------------------------------------------------------------------
2836: -- {Start Of Comments}
2837: --
2838: -- Description:
2839: -- This procedure applies the record given to the per_person_analyses table.
2840: --
2841: -- Pre-Requisities:
2842: -- None.
2843: --

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

2841: -- Pre-Requisities:
2842: -- None.
2843: --
2844: -- In Parameters:
2845: -- p_perana_data -> per_person_analyses record that is being applied.
2846: --
2847: -- Post Success:
2848: -- per_person_analyses record will have been applied.
2849: --

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

2844: -- In Parameters:
2845: -- p_perana_data -> per_person_analyses record that is being applied.
2846: --
2847: -- Post Success:
2848: -- per_person_analyses record will have been applied.
2849: --
2850: -- Post Failure:
2851: -- Error would have been displayed to user and exception raised.
2852: --

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

2857: -- Internal Development Use Only.
2858: --
2859: -- {End Of Comments}
2860: -- ---------------------------------------------------------------------------
2861: Procedure correct_perana_row( p_perana_data in out nocopy per_person_analyses%rowtype) is
2862:
2863: -- this cursor gets the object_version_number from core table, so the core
2864: -- table can be updated.
2865: cursor c_perana is

Line 2867: from per_person_analyses

2863: -- this cursor gets the object_version_number from core table, so the core
2864: -- table can be updated.
2865: cursor c_perana is
2866: select object_version_number
2867: from per_person_analyses
2868: where person_analysis_id = p_perana_data.person_analysis_id;
2869:
2870: l_perana_data per_person_analyses%rowtype;
2871: l_session_var ghr_history_api.g_session_var_type;

Line 2870: l_perana_data per_person_analyses%rowtype;

2866: select object_version_number
2867: from per_person_analyses
2868: where person_analysis_id = p_perana_data.person_analysis_id;
2869:
2870: l_perana_data per_person_analyses%rowtype;
2871: l_session_var ghr_history_api.g_session_var_type;
2872: l_proc varchar2(30):='correct_perana_row';
2873:
2874: Begin