DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on HR_PHONE_API

Line 1990: hr_phone_api.create_or_update_phone

1986: IF p_phn_h_phone_number IS NOT NULL THEN
1987: --
1988: l_phone_id:=NULL;
1989: l_phn_object_version_number:=NULL;
1990: hr_phone_api.create_or_update_phone
1991: (p_effective_date => l_creation_date --p_effective_date
1992: ,p_parent_id => p_person_id
1993: ,p_update_mode => l_datetrack_update_mode
1994: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 2012: hr_phone_api.create_or_update_phone

2008: IF p_phn_w_phone_number IS NOT NULL THEN
2009: --
2010: l_phone_id:=NULL;
2011: l_phn_object_version_number:=NULL;
2012: hr_phone_api.create_or_update_phone
2013: (p_effective_date => l_creation_date --p_effective_date
2014: ,p_parent_id => p_person_id
2015: ,p_update_mode => l_datetrack_update_mode
2016: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 2034: hr_phone_api.create_or_update_phone

2030: IF p_phn_m_phone_number IS NOT NULL THEN
2031: --
2032: l_phone_id:=NULL;
2033: l_phn_object_version_number:=NULL;
2034: hr_phone_api.create_or_update_phone
2035: (p_effective_date => l_creation_date --p_effective_date
2036: ,p_parent_id => p_person_id
2037: ,p_update_mode => l_datetrack_update_mode
2038: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 2056: hr_phone_api.create_or_update_phone

2052: IF p_phn_hf_phone_number IS NOT NULL THEN
2053: --
2054: l_phone_id:=NULL;
2055: l_phn_object_version_number:=NULL;
2056: hr_phone_api.create_or_update_phone
2057: (p_effective_date => l_creation_date --p_effective_date
2058: ,p_parent_id => p_person_id
2059: ,p_update_mode => l_datetrack_update_mode
2060: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 2078: hr_phone_api.create_or_update_phone

2074: IF p_phn_wf_phone_number IS NOT NULL THEN
2075: --
2076: l_phone_id:=NULL;
2077: l_phn_object_version_number:=NULL;
2078: hr_phone_api.create_or_update_phone
2079: (p_effective_date => l_creation_date --p_effective_date
2080: ,p_parent_id => p_person_id
2081: ,p_update_mode => l_datetrack_update_mode
2082: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 5824: hr_phone_api.delete_phone(p_phone_id => l_phone_id

5820:
5821: l_phone_id := p_phn_h_phone_id;
5822: l_phn_object_version_number := p_phn_h_object_version_number;
5823:
5824: hr_phone_api.delete_phone(p_phone_id => l_phone_id
5825: ,p_object_version_number => l_phn_object_version_number);
5826:
5827: p_phn_h_phone_id := null;
5828: p_phn_h_object_version_number := null;

Line 5834: hr_phone_api.create_or_update_phone

5830: else
5831: -- end of bug 4584695
5832: l_phone_id := p_phn_h_phone_id;
5833: l_phn_object_version_number := p_phn_h_object_version_number;
5834: hr_phone_api.create_or_update_phone
5835: (p_effective_date => p_effective_date
5836: ,p_parent_id => p_person_id
5837: ,p_update_mode => p_datetrack_update_mode
5838: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 5883: hr_phone_api.delete_phone(p_phone_id => l_phone_id

5879:
5880: l_phone_id := p_phn_w_phone_id ;
5881: l_phn_object_version_number := p_phn_w_object_version_number;
5882:
5883: hr_phone_api.delete_phone(p_phone_id => l_phone_id
5884: ,p_object_version_number => l_phn_object_version_number);
5885:
5886: p_phn_w_phone_id := null;
5887: p_phn_w_object_version_number := null;

Line 5894: hr_phone_api.create_or_update_phone

5890: -- end of bug 4584695
5891:
5892: l_phone_id := p_phn_w_phone_id;
5893: l_phn_object_version_number := p_phn_w_object_version_number;
5894: hr_phone_api.create_or_update_phone
5895: (p_effective_date => p_effective_date
5896: ,p_parent_id => p_person_id
5897: ,p_update_mode => p_datetrack_update_mode
5898: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 5943: hr_phone_api.delete_phone(p_phone_id => l_phone_id

5939:
5940: l_phone_id := p_phn_m_phone_id;
5941: l_phn_object_version_number := p_phn_m_object_version_number;
5942:
5943: hr_phone_api.delete_phone(p_phone_id => l_phone_id
5944: ,p_object_version_number => l_phn_object_version_number);
5945:
5946: p_phn_m_phone_id := null;
5947: p_phn_m_object_version_number := null;

Line 5954: hr_phone_api.create_or_update_phone

5950: -- end of bug 4584695
5951:
5952: l_phone_id := p_phn_m_phone_id;
5953: l_phn_object_version_number := p_phn_m_object_version_number;
5954: hr_phone_api.create_or_update_phone
5955: (p_effective_date => p_effective_date
5956: ,p_parent_id => p_person_id
5957: ,p_update_mode => p_datetrack_update_mode
5958: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 5992: hr_phone_api.create_or_update_phone

5988: <> NVL(p_phn_hf_phone_number,hr_api.g_varchar2) )) THEN
5989: --
5990: l_phone_id := p_phn_hf_phone_id;
5991: l_phn_object_version_number := p_phn_hf_object_version_number;
5992: hr_phone_api.create_or_update_phone
5993: (p_effective_date => p_effective_date
5994: ,p_parent_id => p_person_id
5995: ,p_update_mode => p_datetrack_update_mode
5996: ,p_parent_table => 'PER_ALL_PEOPLE_F'

Line 6036: hr_phone_api.delete_phone(p_phone_id => l_phone_id

6032: p_phn_wf_phone_number is null ) then
6033: l_phone_id := p_phn_wf_phone_id ;
6034: l_phn_object_version_number := p_phn_wf_object_version_number;
6035:
6036: hr_phone_api.delete_phone(p_phone_id => l_phone_id
6037: ,p_object_version_number => l_phn_object_version_number);
6038:
6039: p_phn_w_phone_id := null;
6040: p_phn_w_object_version_number := null;

Line 6045: hr_phone_api.create_or_update_phone

6041: else
6042: -- end of bug 5301807
6043: l_phone_id := p_phn_wf_phone_id;
6044: l_phn_object_version_number := p_phn_wf_object_version_number;
6045: hr_phone_api.create_or_update_phone
6046: (p_effective_date => p_effective_date
6047: ,p_parent_id => p_person_id
6048: ,p_update_mode => p_datetrack_update_mode
6049: ,p_parent_table => 'PER_ALL_PEOPLE_F'