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 1552: p_a in per_addresses%rowtype,

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

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

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

Line 1718: p_a in per_addresses%rowtype,

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

Line 4071: l_address_row per_addresses%rowtype;

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

Line 4074: from per_addresses

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