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 5838: per_phn_shd.lck

5834: hr_utility.set_location(l_proc, 185);
5835: -- home phone
5836: --
5837: IF p_phn_h_phone_id IS NOT NULL THEN
5838: per_phn_shd.lck
5839: (p_phone_id => p_phn_h_phone_id
5840: ,p_object_version_number => p_phn_h_object_version_number);
5841: END IF;
5842: --

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

5841: END IF;
5842: --
5843: IF (p_phn_h_phone_id IS NULL AND p_phn_h_phone_number IS NOT NULL) OR
5844: (p_phn_h_phone_id IS NOT NULL AND (
5845: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5846: <> NVL(p_phn_h_date_from,hr_api.g_date)
5847: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5848: <> NVL(p_phn_h_date_to,hr_api.g_date)
5849: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

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

5843: IF (p_phn_h_phone_id IS NULL AND p_phn_h_phone_number IS NOT NULL) OR
5844: (p_phn_h_phone_id IS NOT NULL AND (
5845: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5846: <> NVL(p_phn_h_date_from,hr_api.g_date)
5847: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5848: <> NVL(p_phn_h_date_to,hr_api.g_date)
5849: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5850: <> NVL(p_phn_h_phone_number,hr_api.g_varchar2) )) THEN
5851: --

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

5845: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5846: <> NVL(p_phn_h_date_from,hr_api.g_date)
5847: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5848: <> NVL(p_phn_h_date_to,hr_api.g_date)
5849: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5850: <> NVL(p_phn_h_phone_number,hr_api.g_varchar2) )) THEN
5851: --
5852:
5853: -- added for the bug 4584695

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

5853: -- added for the bug 4584695
5854: -- added the if condition that checks whether to call the delete api or the create_update api
5855: -- and assigns the value null to the return parameters as they record is getting deleted
5856:
5857: if (NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5858: <> NVL(p_phn_h_phone_number,hr_api.g_varchar2) and
5859: p_phn_h_phone_number is null ) then
5860:
5861: l_phone_id := p_phn_h_phone_id;

Line 5897: per_phn_shd.lck

5893: --
5894: -- work phone
5895: --
5896: IF p_phn_w_phone_id IS NOT NULL THEN
5897: per_phn_shd.lck
5898: (p_phone_id => p_phn_w_phone_id
5899: ,p_object_version_number => p_phn_w_object_version_number);
5900: END IF;
5901: --

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

5900: END IF;
5901: --
5902: IF (p_phn_w_phone_id IS NULL AND p_phn_w_phone_number IS NOT NULL) OR
5903: (p_phn_w_phone_id IS NOT NULL AND (
5904: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5905: <> NVL(p_phn_w_date_from,hr_api.g_date)
5906: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5907: <> NVL(p_phn_w_date_to,hr_api.g_date)
5908: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

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

5902: IF (p_phn_w_phone_id IS NULL AND p_phn_w_phone_number IS NOT NULL) OR
5903: (p_phn_w_phone_id IS NOT NULL AND (
5904: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5905: <> NVL(p_phn_w_date_from,hr_api.g_date)
5906: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5907: <> NVL(p_phn_w_date_to,hr_api.g_date)
5908: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5909: <> NVL(p_phn_w_phone_number,hr_api.g_varchar2) )) THEN
5910: --

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

5904: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5905: <> NVL(p_phn_w_date_from,hr_api.g_date)
5906: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5907: <> NVL(p_phn_w_date_to,hr_api.g_date)
5908: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5909: <> NVL(p_phn_w_phone_number,hr_api.g_varchar2) )) THEN
5910: --
5911:
5912: -- added for the bug 4584695

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

5912: -- added for the bug 4584695
5913: -- added the if condition that checks whether to call the delete api or the create_update api
5914: -- and assigns the value null to the return parameters as they record is getting deleted
5915:
5916: if (NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5917: <> NVL(p_phn_w_phone_number ,hr_api.g_varchar2) and
5918: p_phn_w_phone_number is null ) then
5919:
5920: l_phone_id := p_phn_w_phone_id ;

Line 5957: per_phn_shd.lck

5953: --
5954: -- mobile phone
5955: --
5956: IF p_phn_m_phone_id IS NOT NULL THEN
5957: per_phn_shd.lck
5958: (p_phone_id => p_phn_m_phone_id
5959: ,p_object_version_number => p_phn_m_object_version_number);
5960: END IF;
5961: --

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

5960: END IF;
5961: --
5962: IF (p_phn_m_phone_id IS NULL AND p_phn_m_phone_number IS NOT NULL) OR
5963: (p_phn_m_phone_id IS NOT NULL AND (
5964: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5965: <> NVL(p_phn_m_date_from,hr_api.g_date)
5966: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5967: <> NVL(p_phn_m_date_to,hr_api.g_date)
5968: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

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

5962: IF (p_phn_m_phone_id IS NULL AND p_phn_m_phone_number IS NOT NULL) OR
5963: (p_phn_m_phone_id IS NOT NULL AND (
5964: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5965: <> NVL(p_phn_m_date_from,hr_api.g_date)
5966: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5967: <> NVL(p_phn_m_date_to,hr_api.g_date)
5968: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5969: <> NVL(p_phn_m_phone_number,hr_api.g_varchar2) )) THEN
5970: --

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

5964: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
5965: <> NVL(p_phn_m_date_from,hr_api.g_date)
5966: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
5967: <> NVL(p_phn_m_date_to,hr_api.g_date)
5968: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5969: <> NVL(p_phn_m_phone_number,hr_api.g_varchar2) )) THEN
5970: --
5971:
5972: -- added for the bug 4584695

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

5972: -- added for the bug 4584695
5973: -- added the if condition that checks whether to call the delete api or the create_update api
5974: -- and assigns the value null to the return parameters as they record is getting deleted
5975:
5976: if (NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
5977: <> NVL(p_phn_m_phone_number,hr_api.g_varchar2) and
5978: p_phn_m_phone_number is null ) then
5979:
5980: l_phone_id := p_phn_m_phone_id;

Line 6016: per_phn_shd.lck

6012: --
6013: -- home fax
6014: --
6015: IF p_phn_hf_phone_id IS NOT NULL THEN
6016: per_phn_shd.lck
6017: (p_phone_id => p_phn_hf_phone_id
6018: ,p_object_version_number => p_phn_hf_object_version_number);
6019: END IF;
6020: --

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

6019: END IF;
6020: --
6021: IF (p_phn_hf_phone_id IS NULL AND p_phn_hf_phone_number IS NOT NULL) OR
6022: (p_phn_hf_phone_id IS NOT NULL AND (
6023: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
6024: <> NVL(p_phn_hf_date_from,hr_api.g_date)
6025: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
6026: <> NVL(p_phn_hf_date_to,hr_api.g_date)
6027: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

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

6021: IF (p_phn_hf_phone_id IS NULL AND p_phn_hf_phone_number IS NOT NULL) OR
6022: (p_phn_hf_phone_id IS NOT NULL AND (
6023: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
6024: <> NVL(p_phn_hf_date_from,hr_api.g_date)
6025: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
6026: <> NVL(p_phn_hf_date_to,hr_api.g_date)
6027: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
6028: <> NVL(p_phn_hf_phone_number,hr_api.g_varchar2) )) THEN
6029: --

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

6023: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
6024: <> NVL(p_phn_hf_date_from,hr_api.g_date)
6025: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
6026: <> NVL(p_phn_hf_date_to,hr_api.g_date)
6027: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
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;

Line 6053: per_phn_shd.lck

6049: --
6050: -- work fax
6051: --
6052: IF p_phn_wf_phone_id IS NOT NULL THEN
6053: per_phn_shd.lck
6054: (p_phone_id => p_phn_wf_phone_id
6055: ,p_object_version_number => p_phn_wf_object_version_number);
6056: END IF;
6057: --

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

6056: END IF;
6057: --
6058: IF (p_phn_wf_phone_id IS NULL AND p_phn_wf_phone_number IS NOT NULL) OR
6059: (p_phn_wf_phone_id IS NOT NULL AND (
6060: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
6061: <> NVL(p_phn_wf_date_from,hr_api.g_date)
6062: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
6063: <> NVL(p_phn_wf_date_to,hr_api.g_date)
6064: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)

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

6058: IF (p_phn_wf_phone_id IS NULL AND p_phn_wf_phone_number IS NOT NULL) OR
6059: (p_phn_wf_phone_id IS NOT NULL AND (
6060: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
6061: <> NVL(p_phn_wf_date_from,hr_api.g_date)
6062: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
6063: <> NVL(p_phn_wf_date_to,hr_api.g_date)
6064: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
6065: <> NVL(p_phn_wf_phone_number,hr_api.g_varchar2) )) THEN
6066: --

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

6060: NVL(per_phn_shd.g_old_rec.date_from,hr_api.g_date)
6061: <> NVL(p_phn_wf_date_from,hr_api.g_date)
6062: OR NVL(per_phn_shd.g_old_rec.date_to,hr_api.g_date)
6063: <> NVL(p_phn_wf_date_to,hr_api.g_date)
6064: OR NVL(per_phn_shd.g_old_rec.phone_number,hr_api.g_varchar2)
6065: <> NVL(p_phn_wf_phone_number,hr_api.g_varchar2) )) THEN
6066: --
6067: -- added for the bug 5301807
6068: -- added the if condition that checks whether to call the delete api or the create_update api

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

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

Line 7227: per_phn_shd.lck

7223: --
7224: IF p_phn_h_phone_id IS NOT NULL THEN
7225: hr_utility.set_location(l_proc, 50);
7226: --
7227: per_phn_shd.lck
7228: (p_phone_id => p_phn_h_phone_id
7229: ,p_object_version_number => p_phn_h_object_version_number);
7230: END IF;
7231: --

Line 7235: per_phn_shd.lck

7231: --
7232: IF p_phn_w_phone_id IS NOT NULL THEN
7233: hr_utility.set_location(l_proc, 60);
7234: --
7235: per_phn_shd.lck
7236: (p_phone_id => p_phn_w_phone_id
7237: ,p_object_version_number => p_phn_w_object_version_number);
7238: END IF;
7239: --

Line 7243: per_phn_shd.lck

7239: --
7240: IF p_phn_m_phone_id IS NOT NULL THEN
7241: hr_utility.set_location(l_proc, 70);
7242: --
7243: per_phn_shd.lck
7244: (p_phone_id => p_phn_m_phone_id
7245: ,p_object_version_number => p_phn_m_object_version_number);
7246: END IF;
7247: --

Line 7251: per_phn_shd.lck

7247: --
7248: IF p_phn_hf_phone_id IS NOT NULL THEN
7249: hr_utility.set_location(l_proc, 80);
7250: --
7251: per_phn_shd.lck
7252: (p_phone_id => p_phn_hf_phone_id
7253: ,p_object_version_number => p_phn_hf_object_version_number);
7254: END IF;
7255: --

Line 7259: per_phn_shd.lck

7255: --
7256: IF p_phn_wf_phone_id IS NOT NULL THEN
7257: hr_utility.set_location(l_proc, 90);
7258: --
7259: per_phn_shd.lck
7260: (p_phone_id => p_phn_wf_phone_id
7261: ,p_object_version_number => p_phn_wf_object_version_number);
7262: END IF;
7263: --