APPS.GHR_HISTORY_CASCADE dependencies on PER_ADDRESSES

Line 61: Procedure correct_addresses_row( p_addr_data in out nocopy per_addresses%rowtype);

57: p_asgn_data in out nocopy per_all_assignments_f%rowtype);
58:
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);

Line 1601: -- This procedure cascades data changes in per_addresses core application table.

1597: -- ---------------------------------------------------------------------------
1598: -- {Start Of Comments}
1599: --
1600: -- Description:
1601: -- This procedure cascades data changes in per_addresses core application table.
1602: -- Since extra information tables are not date-tracked by core, cascade of these
1603: -- tables simply re-applies the most recent record in history according to
1604: -- the sysdate. This is necessary because update to database will have applied
1605: -- any changes to this table regardless of effective date of the action. So, this

Line 1633: l_addresses_data per_addresses%rowtype;

1629: Procedure Cascade_addresses (
1630: p_post_record in ghr_pa_history%rowtype) is
1631:
1632: l_hist_addresses_data ghr_pa_history%rowtype;
1633: l_addresses_data per_addresses%rowtype;
1634: l_result_code varchar2(30);
1635: l_proc varchar2(30):='Cascade_addresses';
1636:
1637: Begin

Line 2748: -- This procedure applies the record given to the per_addresses table.

2744: -- ---------------------------------------------------------------------------
2745: -- {Start Of Comments}
2746: --
2747: -- Description:
2748: -- This procedure applies the record given to the per_addresses table.
2749: --
2750: -- Pre-Requisities:
2751: -- None.
2752: --

Line 2754: -- p_addr_data -> per_addresses record that is being applied.

2750: -- Pre-Requisities:
2751: -- None.
2752: --
2753: -- In Parameters:
2754: -- p_addr_data -> per_addresses record that is being applied.
2755: --
2756: -- Post Success:
2757: -- per_addresses record will have been applied.
2758: --

Line 2757: -- per_addresses record will have been applied.

2753: -- In Parameters:
2754: -- p_addr_data -> per_addresses record that is being applied.
2755: --
2756: -- Post Success:
2757: -- per_addresses record will have been applied.
2758: --
2759: -- Post Failure:
2760: -- Error would have been displayed to user and exception raised.
2761: --

Line 2770: Procedure correct_addresses_row( p_addr_data in out nocopy per_addresses%rowtype) is

2766: -- Internal Development Use Only.
2767: --
2768: -- {End Of Comments}
2769: -- ---------------------------------------------------------------------------
2770: Procedure correct_addresses_row( p_addr_data in out nocopy per_addresses%rowtype) is
2771:
2772: -- this cursor gets the object_version_number from core table, so the core
2773: -- table can be updated.
2774: cursor c_addr is

Line 2776: from per_addresses

2772: -- this cursor gets the object_version_number from core table, so the core
2773: -- table can be updated.
2774: cursor c_addr is
2775: select object_version_number
2776: from per_addresses
2777: where address_id = p_addr_data.address_id;
2778:
2779: l_addr_data per_addresses%rowtype;
2780: l_session_var ghr_history_api.g_session_var_type;

Line 2779: l_addr_data per_addresses%rowtype;

2775: select object_version_number
2776: from per_addresses
2777: where address_id = p_addr_data.address_id;
2778:
2779: l_addr_data per_addresses%rowtype;
2780: l_session_var ghr_history_api.g_session_var_type;
2781: l_proc varchar2(30):='correct_addresses_row';
2782:
2783: Begin