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.PER_QH_MAINTAIN_UPDATE dependencies on HR_PHONE_API

Line 2023: hr_phone_api.create_or_update_phone

2019: IF p_phn_h_phone_number IS NOT NULL THEN
2020: --
2021: l_phone_id:=NULL;
2022: l_phn_object_version_number:=NULL;
2023: hr_phone_api.create_or_update_phone
2024: (p_effective_date => l_creation_date --p_effective_date
2025: ,p_parent_id => p_person_id
2026: ,p_update_mode => l_datetrack_update_mode
2027: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 2045: hr_phone_api.create_or_update_phone

2041: IF p_phn_w_phone_number IS NOT NULL THEN
2042: --
2043: l_phone_id:=NULL;
2044: l_phn_object_version_number:=NULL;
2045: hr_phone_api.create_or_update_phone
2046: (p_effective_date => l_creation_date --p_effective_date
2047: ,p_parent_id => p_person_id
2048: ,p_update_mode => l_datetrack_update_mode
2049: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 2067: hr_phone_api.create_or_update_phone

2063: IF p_phn_m_phone_number IS NOT NULL THEN
2064: --
2065: l_phone_id:=NULL;
2066: l_phn_object_version_number:=NULL;
2067: hr_phone_api.create_or_update_phone
2068: (p_effective_date => l_creation_date --p_effective_date
2069: ,p_parent_id => p_person_id
2070: ,p_update_mode => l_datetrack_update_mode
2071: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 2089: hr_phone_api.create_or_update_phone

2085: IF p_phn_hf_phone_number IS NOT NULL THEN
2086: --
2087: l_phone_id:=NULL;
2088: l_phn_object_version_number:=NULL;
2089: hr_phone_api.create_or_update_phone
2090: (p_effective_date => l_creation_date --p_effective_date
2091: ,p_parent_id => p_person_id
2092: ,p_update_mode => l_datetrack_update_mode
2093: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 2111: hr_phone_api.create_or_update_phone

2107: IF p_phn_wf_phone_number IS NOT NULL THEN
2108: --
2109: l_phone_id:=NULL;
2110: l_phn_object_version_number:=NULL;
2111: hr_phone_api.create_or_update_phone
2112: (p_effective_date => l_creation_date --p_effective_date
2113: ,p_parent_id => p_person_id
2114: ,p_update_mode => l_datetrack_update_mode
2115: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 5864: hr_phone_api.delete_phone(p_phone_id => l_phone_id

5860:
5861: l_phone_id := p_phn_h_phone_id;
5862: l_phn_object_version_number := p_phn_h_object_version_number;
5863:
5864: hr_phone_api.delete_phone(p_phone_id => l_phone_id
5865: ,p_object_version_number => l_phn_object_version_number);
5866:
5867: p_phn_h_phone_id := null;
5868: p_phn_h_object_version_number := null;

Line 5874: hr_phone_api.create_or_update_phone

5870: else
5871: -- end of bug 4584695
5872: l_phone_id := p_phn_h_phone_id;
5873: l_phn_object_version_number := p_phn_h_object_version_number;
5874: hr_phone_api.create_or_update_phone
5875: (p_effective_date => p_effective_date
5876: ,p_parent_id => p_person_id
5877: ,p_update_mode => p_datetrack_update_mode
5878: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 5923: hr_phone_api.delete_phone(p_phone_id => l_phone_id

5919:
5920: l_phone_id := p_phn_w_phone_id ;
5921: l_phn_object_version_number := p_phn_w_object_version_number;
5922:
5923: hr_phone_api.delete_phone(p_phone_id => l_phone_id
5924: ,p_object_version_number => l_phn_object_version_number);
5925:
5926: p_phn_w_phone_id := null;
5927: p_phn_w_object_version_number := null;

Line 5934: hr_phone_api.create_or_update_phone

5930: -- end of bug 4584695
5931:
5932: l_phone_id := p_phn_w_phone_id;
5933: l_phn_object_version_number := p_phn_w_object_version_number;
5934: hr_phone_api.create_or_update_phone
5935: (p_effective_date => p_effective_date
5936: ,p_parent_id => p_person_id
5937: ,p_update_mode => p_datetrack_update_mode
5938: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 5983: hr_phone_api.delete_phone(p_phone_id => l_phone_id

5979:
5980: l_phone_id := p_phn_m_phone_id;
5981: l_phn_object_version_number := p_phn_m_object_version_number;
5982:
5983: hr_phone_api.delete_phone(p_phone_id => l_phone_id
5984: ,p_object_version_number => l_phn_object_version_number);
5985:
5986: p_phn_m_phone_id := null;
5987: p_phn_m_object_version_number := null;

Line 5994: hr_phone_api.create_or_update_phone

5990: -- end of bug 4584695
5991:
5992: l_phone_id := p_phn_m_phone_id;
5993: l_phn_object_version_number := p_phn_m_object_version_number;
5994: hr_phone_api.create_or_update_phone
5995: (p_effective_date => p_effective_date
5996: ,p_parent_id => p_person_id
5997: ,p_update_mode => p_datetrack_update_mode
5998: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 6032: hr_phone_api.create_or_update_phone

6028: <> NVL(p_phn_hf_phone_number,hr_api.g_varchar2) )) THEN
6029: --
6030: l_phone_id := p_phn_hf_phone_id;
6031: l_phn_object_version_number := p_phn_hf_object_version_number;
6032: hr_phone_api.create_or_update_phone
6033: (p_effective_date => p_effective_date
6034: ,p_parent_id => p_person_id
6035: ,p_update_mode => p_datetrack_update_mode
6036: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 6076: hr_phone_api.delete_phone(p_phone_id => l_phone_id

6072: p_phn_wf_phone_number is null ) then
6073: l_phone_id := p_phn_wf_phone_id ;
6074: l_phn_object_version_number := p_phn_wf_object_version_number;
6075:
6076: hr_phone_api.delete_phone(p_phone_id => l_phone_id
6077: ,p_object_version_number => l_phn_object_version_number);
6078:
6079: p_phn_w_phone_id := null;
6080: p_phn_w_object_version_number := null;

Line 6085: hr_phone_api.create_or_update_phone

6081: else
6082: -- end of bug 5301807
6083: l_phone_id := p_phn_wf_phone_id;
6084: l_phn_object_version_number := p_phn_wf_object_version_number;
6085: hr_phone_api.create_or_update_phone
6086: (p_effective_date => p_effective_date
6087: ,p_parent_id => p_person_id
6088: ,p_update_mode => p_datetrack_update_mode
6089: ,p_parent_table => 'PER_ALL_PEOPLE_F'