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

1574: -- ---------------------------------------------------------------------------
1575: -- {Start Of Comments}
1576: --
1577: -- Description:
1578: -- This procedure cascades data changes in per_addresses core application table.
1579: -- Since extra information tables are not date-tracked by core, cascade of these
1580: -- tables simply re-applies the most recent record in history according to
1581: -- the sysdate. This is necessary because update to database will have applied
1582: -- any changes to this table regardless of effective date of the action. So, this

Line 1610: l_addresses_data per_addresses%rowtype;

1606: Procedure Cascade_addresses (
1607: p_post_record in ghr_pa_history%rowtype) is
1608:
1609: l_hist_addresses_data ghr_pa_history%rowtype;
1610: l_addresses_data per_addresses%rowtype;
1611: l_result_code varchar2(30);
1612: l_proc varchar2(30):='Cascade_addresses';
1613:
1614: Begin

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

2718: -- ---------------------------------------------------------------------------
2719: -- {Start Of Comments}
2720: --
2721: -- Description:
2722: -- This procedure applies the record given to the per_addresses table.
2723: --
2724: -- Pre-Requisities:
2725: -- None.
2726: --

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

2724: -- Pre-Requisities:
2725: -- None.
2726: --
2727: -- In Parameters:
2728: -- p_addr_data -> per_addresses record that is being applied.
2729: --
2730: -- Post Success:
2731: -- per_addresses record will have been applied.
2732: --

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

2727: -- In Parameters:
2728: -- p_addr_data -> per_addresses record that is being applied.
2729: --
2730: -- Post Success:
2731: -- per_addresses record will have been applied.
2732: --
2733: -- Post Failure:
2734: -- Error would have been displayed to user and exception raised.
2735: --

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

2740: -- Internal Development Use Only.
2741: --
2742: -- {End Of Comments}
2743: -- ---------------------------------------------------------------------------
2744: Procedure correct_addresses_row( p_addr_data in out nocopy per_addresses%rowtype) is
2745:
2746: -- this cursor gets the object_version_number from core table, so the core
2747: -- table can be updated.
2748: cursor c_addr is

Line 2750: from per_addresses

2746: -- this cursor gets the object_version_number from core table, so the core
2747: -- table can be updated.
2748: cursor c_addr is
2749: select object_version_number
2750: from per_addresses
2751: where address_id = p_addr_data.address_id;
2752:
2753: l_addr_data per_addresses%rowtype;
2754: l_session_var ghr_history_api.g_session_var_type;

Line 2753: l_addr_data per_addresses%rowtype;

2749: select object_version_number
2750: from per_addresses
2751: where address_id = p_addr_data.address_id;
2752:
2753: l_addr_data per_addresses%rowtype;
2754: l_session_var ghr_history_api.g_session_var_type;
2755: l_proc varchar2(30):='correct_addresses_row';
2756:
2757: Begin