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 PER_PHN_SHD

Line 5798: per_phn_shd.lck

5794: hr_utility.set_location(l_proc, 185);
5795: -- home phone
5796: --
5797: IF p_phn_h_phone_id IS NOT NULL THEN
5798: per_phn_shd.lck
5799: (p_phone_id => p_phn_h_phone_id
5800: ,p_object_version_number => p_phn_h_object_version_number);
5801: END IF;
5802: --

Line 5805: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)

5801: END IF;
5802: --
5803: IF (p_phn_h_phone_id IS NULL AND p_phn_h_phone_number IS NOT NULL) OR
5804: (p_phn_h_phone_id IS NOT NULL AND (
5805: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5806: <> NVL(p_phn_h_date_from,hr_api.g_date)
5807: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5808: <> NVL(p_phn_h_date_to,hr_api.g_date)
5809: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

Line 5807: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)

5803: IF (p_phn_h_phone_id IS NULL AND p_phn_h_phone_number IS NOT NULL) OR
5804: (p_phn_h_phone_id IS NOT NULL AND (
5805: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5806: <> NVL(p_phn_h_date_from,hr_api.g_date)
5807: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5808: <> NVL(p_phn_h_date_to,hr_api.g_date)
5809: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5810: <> NVL(p_phn_h_phone_number,hr_api.g_varchar2) )) THEN
5811: --

Line 5809: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

5805: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5806: <> NVL(p_phn_h_date_from,hr_api.g_date)
5807: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5808: <> NVL(p_phn_h_date_to,hr_api.g_date)
5809: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5810: <> NVL(p_phn_h_phone_number,hr_api.g_varchar2) )) THEN
5811: --
5812:
5813: -- added for the bug 4584695

Line 5817: if (NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

5813: -- added for the bug 4584695
5814: -- added the if condition that checks whether to call the delete api or the create_update api
5815: -- and assigns the value null to the return parameters as they record is getting deleted
5816:
5817: if (NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5818: <> NVL(p_phn_h_phone_number,hr_api.g_varchar2) and
5819: p_phn_h_phone_number is null ) then
5820:
5821: l_phone_id := p_phn_h_phone_id;

Line 5857: per_phn_shd.lck

5853: --
5854: -- work phone
5855: --
5856: IF p_phn_w_phone_id IS NOT NULL THEN
5857: per_phn_shd.lck
5858: (p_phone_id => p_phn_w_phone_id
5859: ,p_object_version_number => p_phn_w_object_version_number);
5860: END IF;
5861: --

Line 5864: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)

5860: END IF;
5861: --
5862: IF (p_phn_w_phone_id IS NULL AND p_phn_w_phone_number IS NOT NULL) OR
5863: (p_phn_w_phone_id IS NOT NULL AND (
5864: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5865: <> NVL(p_phn_w_date_from,hr_api.g_date)
5866: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5867: <> NVL(p_phn_w_date_to,hr_api.g_date)
5868: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

Line 5866: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)

5862: IF (p_phn_w_phone_id IS NULL AND p_phn_w_phone_number IS NOT NULL) OR
5863: (p_phn_w_phone_id IS NOT NULL AND (
5864: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5865: <> NVL(p_phn_w_date_from,hr_api.g_date)
5866: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5867: <> NVL(p_phn_w_date_to,hr_api.g_date)
5868: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5869: <> NVL(p_phn_w_phone_number,hr_api.g_varchar2) )) THEN
5870: --

Line 5868: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

5864: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5865: <> NVL(p_phn_w_date_from,hr_api.g_date)
5866: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5867: <> NVL(p_phn_w_date_to,hr_api.g_date)
5868: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5869: <> NVL(p_phn_w_phone_number,hr_api.g_varchar2) )) THEN
5870: --
5871:
5872: -- added for the bug 4584695

Line 5876: if (NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

5872: -- added for the bug 4584695
5873: -- added the if condition that checks whether to call the delete api or the create_update api
5874: -- and assigns the value null to the return parameters as they record is getting deleted
5875:
5876: if (NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5877: <> NVL(p_phn_w_phone_number ,hr_api.g_varchar2) and
5878: p_phn_w_phone_number is null ) then
5879:
5880: l_phone_id := p_phn_w_phone_id ;

Line 5917: per_phn_shd.lck

5913: --
5914: -- mobile phone
5915: --
5916: IF p_phn_m_phone_id IS NOT NULL THEN
5917: per_phn_shd.lck
5918: (p_phone_id => p_phn_m_phone_id
5919: ,p_object_version_number => p_phn_m_object_version_number);
5920: END IF;
5921: --

Line 5924: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)

5920: END IF;
5921: --
5922: IF (p_phn_m_phone_id IS NULL AND p_phn_m_phone_number IS NOT NULL) OR
5923: (p_phn_m_phone_id IS NOT NULL AND (
5924: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5925: <> NVL(p_phn_m_date_from,hr_api.g_date)
5926: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5927: <> NVL(p_phn_m_date_to,hr_api.g_date)
5928: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

Line 5926: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)

5922: IF (p_phn_m_phone_id IS NULL AND p_phn_m_phone_number IS NOT NULL) OR
5923: (p_phn_m_phone_id IS NOT NULL AND (
5924: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5925: <> NVL(p_phn_m_date_from,hr_api.g_date)
5926: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5927: <> NVL(p_phn_m_date_to,hr_api.g_date)
5928: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5929: <> NVL(p_phn_m_phone_number,hr_api.g_varchar2) )) THEN
5930: --

Line 5928: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

5924: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5925: <> NVL(p_phn_m_date_from,hr_api.g_date)
5926: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5927: <> NVL(p_phn_m_date_to,hr_api.g_date)
5928: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5929: <> NVL(p_phn_m_phone_number,hr_api.g_varchar2) )) THEN
5930: --
5931:
5932: -- added for the bug 4584695

Line 5936: if (NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

5932: -- added for the bug 4584695
5933: -- added the if condition that checks whether to call the delete api or the create_update api
5934: -- and assigns the value null to the return parameters as they record is getting deleted
5935:
5936: if (NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5937: <> NVL(p_phn_m_phone_number,hr_api.g_varchar2) and
5938: p_phn_m_phone_number is null ) then
5939:
5940: l_phone_id := p_phn_m_phone_id;

Line 5976: per_phn_shd.lck

5972: --
5973: -- home fax
5974: --
5975: IF p_phn_hf_phone_id IS NOT NULL THEN
5976: per_phn_shd.lck
5977: (p_phone_id => p_phn_hf_phone_id
5978: ,p_object_version_number => p_phn_hf_object_version_number);
5979: END IF;
5980: --

Line 5983: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)

5979: END IF;
5980: --
5981: IF (p_phn_hf_phone_id IS NULL AND p_phn_hf_phone_number IS NOT NULL) OR
5982: (p_phn_hf_phone_id IS NOT NULL AND (
5983: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5984: <> NVL(p_phn_hf_date_from,hr_api.g_date)
5985: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5986: <> NVL(p_phn_hf_date_to,hr_api.g_date)
5987: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

Line 5985: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)

5981: IF (p_phn_hf_phone_id IS NULL AND p_phn_hf_phone_number IS NOT NULL) OR
5982: (p_phn_hf_phone_id IS NOT NULL AND (
5983: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5984: <> NVL(p_phn_hf_date_from,hr_api.g_date)
5985: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5986: <> NVL(p_phn_hf_date_to,hr_api.g_date)
5987: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5988: <> NVL(p_phn_hf_phone_number,hr_api.g_varchar2) )) THEN
5989: --

Line 5987: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

5983: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5984: <> NVL(p_phn_hf_date_from,hr_api.g_date)
5985: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5986: <> NVL(p_phn_hf_date_to,hr_api.g_date)
5987: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
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;

Line 6013: per_phn_shd.lck

6009: --
6010: -- work fax
6011: --
6012: IF p_phn_wf_phone_id IS NOT NULL THEN
6013: per_phn_shd.lck
6014: (p_phone_id => p_phn_wf_phone_id
6015: ,p_object_version_number => p_phn_wf_object_version_number);
6016: END IF;
6017: --

Line 6020: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)

6016: END IF;
6017: --
6018: IF (p_phn_wf_phone_id IS NULL AND p_phn_wf_phone_number IS NOT NULL) OR
6019: (p_phn_wf_phone_id IS NOT NULL AND (
6020: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
6021: <> NVL(p_phn_wf_date_from,hr_api.g_date)
6022: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
6023: <> NVL(p_phn_wf_date_to,hr_api.g_date)
6024: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

Line 6022: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)

6018: IF (p_phn_wf_phone_id IS NULL AND p_phn_wf_phone_number IS NOT NULL) OR
6019: (p_phn_wf_phone_id IS NOT NULL AND (
6020: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
6021: <> NVL(p_phn_wf_date_from,hr_api.g_date)
6022: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
6023: <> NVL(p_phn_wf_date_to,hr_api.g_date)
6024: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
6025: <> NVL(p_phn_wf_phone_number,hr_api.g_varchar2) )) THEN
6026: --

Line 6024: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

6020: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
6021: <> NVL(p_phn_wf_date_from,hr_api.g_date)
6022: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
6023: <> NVL(p_phn_wf_date_to,hr_api.g_date)
6024: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
6025: <> NVL(p_phn_wf_phone_number,hr_api.g_varchar2) )) THEN
6026: --
6027: -- added for the bug 5301807
6028: -- added the if condition that checks whether to call the delete api or the create_update api

Line 6030: if (NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

6026: --
6027: -- added for the bug 5301807
6028: -- added the if condition that checks whether to call the delete api or the create_update api
6029: -- and assigns the value null to the return parameters as the record is getting deleted
6030: if (NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
6031: <> NVL(p_phn_wf_phone_number,hr_api.g_varchar2) and
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;

Line 7187: per_phn_shd.lck

7183: --
7184: IF p_phn_h_phone_id IS NOT NULL THEN
7185: hr_utility.set_location(l_proc, 50);
7186: --
7187: per_phn_shd.lck
7188: (p_phone_id => p_phn_h_phone_id
7189: ,p_object_version_number => p_phn_h_object_version_number);
7190: END IF;
7191: --

Line 7195: per_phn_shd.lck

7191: --
7192: IF p_phn_w_phone_id IS NOT NULL THEN
7193: hr_utility.set_location(l_proc, 60);
7194: --
7195: per_phn_shd.lck
7196: (p_phone_id => p_phn_w_phone_id
7197: ,p_object_version_number => p_phn_w_object_version_number);
7198: END IF;
7199: --

Line 7203: per_phn_shd.lck

7199: --
7200: IF p_phn_m_phone_id IS NOT NULL THEN
7201: hr_utility.set_location(l_proc, 70);
7202: --
7203: per_phn_shd.lck
7204: (p_phone_id => p_phn_m_phone_id
7205: ,p_object_version_number => p_phn_m_object_version_number);
7206: END IF;
7207: --

Line 7211: per_phn_shd.lck

7207: --
7208: IF p_phn_hf_phone_id IS NOT NULL THEN
7209: hr_utility.set_location(l_proc, 80);
7210: --
7211: per_phn_shd.lck
7212: (p_phone_id => p_phn_hf_phone_id
7213: ,p_object_version_number => p_phn_hf_object_version_number);
7214: END IF;
7215: --

Line 7219: per_phn_shd.lck

7215: --
7216: IF p_phn_wf_phone_id IS NOT NULL THEN
7217: hr_utility.set_location(l_proc, 90);
7218: --
7219: per_phn_shd.lck
7220: (p_phone_id => p_phn_wf_phone_id
7221: ,p_object_version_number => p_phn_wf_object_version_number);
7222: END IF;
7223: --