eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MTO_INT dependencies on PER_ADDRESSES

Line 1551: p_a in per_addresses%rowtype,

1547: * when the address inserted is that of the contact.
1548: */
1549: procedure insert_address(p_transfer_name in varchar2,
1550: p_effective_date in date,
1551: p_a in per_addresses%rowtype,
1552: p_contact_name in varchar2 default null,
1553: p_contact_type in varchar2 default null)
1554: is
1555:

Line 1558: l_table_name constant varchar2(30) := 'PER_ADDRESSES';

1554: is
1555:
1556: l_proc varchar2(72) := g_package||'insert_address';
1557: l_name varchar2(30);
1558: l_table_name constant varchar2(30) := 'PER_ADDRESSES';
1559:
1560: begin
1561:
1562: if p_contact_name is null then

Line 1717: p_a in per_addresses%rowtype,

1713: end;
1714:
1715: procedure update_address(p_transfer_name in varchar2,
1716: p_effective_date in date,
1717: p_a in per_addresses%rowtype,
1718: p_contact_name in varchar2 default null,
1719: p_contact_type in varchar2 default null)
1720: is
1721:

Line 4070: l_address_row per_addresses%rowtype;

4066: select pd.*
4067: from per_position_definitions pd
4068: where pd.position_definition_id = p_position_definition_id;
4069: --
4070: l_address_row per_addresses%rowtype;
4071: cursor cur_addr(p_person_id number) is
4072: select *
4073: from per_addresses
4074: where person_id = p_person_id

Line 4073: from per_addresses

4069: --
4070: l_address_row per_addresses%rowtype;
4071: cursor cur_addr(p_person_id number) is
4072: select *
4073: from per_addresses
4074: where person_id = p_person_id
4075: and primary_flag = 'Y'
4076: and l_effdate
4077: between nvl(date_from,l_effdate)