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_APL_SHD

Line 5706: NVL(per_apl_shd.g_old_rec.projected_hire_date,hr_api.g_date)

5702: --
5703: hr_utility.set_location(l_proc, 165);
5704: --
5705: IF p_application_id IS NOT NULL AND (
5706: NVL(per_apl_shd.g_old_rec.projected_hire_date,hr_api.g_date)
5707: <> NVL(p_projected_hire_date,hr_api.g_date)
5708: OR NVL(per_apl_shd.g_old_rec.appl_attribute_category,hr_api.g_varchar2)
5709: <> NVL(p_appl_attribute_category,hr_api.g_varchar2)
5710: OR NVL(per_apl_shd.g_old_rec.appl_attribute1,hr_api.g_varchar2)

Line 5708: OR NVL(per_apl_shd.g_old_rec.appl_attribute_category,hr_api.g_varchar2)

5704: --
5705: IF p_application_id IS NOT NULL AND (
5706: NVL(per_apl_shd.g_old_rec.projected_hire_date,hr_api.g_date)
5707: <> NVL(p_projected_hire_date,hr_api.g_date)
5708: OR NVL(per_apl_shd.g_old_rec.appl_attribute_category,hr_api.g_varchar2)
5709: <> NVL(p_appl_attribute_category,hr_api.g_varchar2)
5710: OR NVL(per_apl_shd.g_old_rec.appl_attribute1,hr_api.g_varchar2)
5711: <> NVL(p_appl_attribute1,hr_api.g_varchar2)
5712: OR NVL(per_apl_shd.g_old_rec.appl_attribute2,hr_api.g_varchar2)

Line 5710: OR NVL(per_apl_shd.g_old_rec.appl_attribute1,hr_api.g_varchar2)

5706: NVL(per_apl_shd.g_old_rec.projected_hire_date,hr_api.g_date)
5707: <> NVL(p_projected_hire_date,hr_api.g_date)
5708: OR NVL(per_apl_shd.g_old_rec.appl_attribute_category,hr_api.g_varchar2)
5709: <> NVL(p_appl_attribute_category,hr_api.g_varchar2)
5710: OR NVL(per_apl_shd.g_old_rec.appl_attribute1,hr_api.g_varchar2)
5711: <> NVL(p_appl_attribute1,hr_api.g_varchar2)
5712: OR NVL(per_apl_shd.g_old_rec.appl_attribute2,hr_api.g_varchar2)
5713: <> NVL(p_appl_attribute2,hr_api.g_varchar2)
5714: OR NVL(per_apl_shd.g_old_rec.appl_attribute3,hr_api.g_varchar2)

Line 5712: OR NVL(per_apl_shd.g_old_rec.appl_attribute2,hr_api.g_varchar2)

5708: OR NVL(per_apl_shd.g_old_rec.appl_attribute_category,hr_api.g_varchar2)
5709: <> NVL(p_appl_attribute_category,hr_api.g_varchar2)
5710: OR NVL(per_apl_shd.g_old_rec.appl_attribute1,hr_api.g_varchar2)
5711: <> NVL(p_appl_attribute1,hr_api.g_varchar2)
5712: OR NVL(per_apl_shd.g_old_rec.appl_attribute2,hr_api.g_varchar2)
5713: <> NVL(p_appl_attribute2,hr_api.g_varchar2)
5714: OR NVL(per_apl_shd.g_old_rec.appl_attribute3,hr_api.g_varchar2)
5715: <> NVL(p_appl_attribute3,hr_api.g_varchar2)
5716: OR NVL(per_apl_shd.g_old_rec.appl_attribute4,hr_api.g_varchar2)

Line 5714: OR NVL(per_apl_shd.g_old_rec.appl_attribute3,hr_api.g_varchar2)

5710: OR NVL(per_apl_shd.g_old_rec.appl_attribute1,hr_api.g_varchar2)
5711: <> NVL(p_appl_attribute1,hr_api.g_varchar2)
5712: OR NVL(per_apl_shd.g_old_rec.appl_attribute2,hr_api.g_varchar2)
5713: <> NVL(p_appl_attribute2,hr_api.g_varchar2)
5714: OR NVL(per_apl_shd.g_old_rec.appl_attribute3,hr_api.g_varchar2)
5715: <> NVL(p_appl_attribute3,hr_api.g_varchar2)
5716: OR NVL(per_apl_shd.g_old_rec.appl_attribute4,hr_api.g_varchar2)
5717: <> NVL(p_appl_attribute4,hr_api.g_varchar2)
5718: OR NVL(per_apl_shd.g_old_rec.appl_attribute5,hr_api.g_varchar2)

Line 5716: OR NVL(per_apl_shd.g_old_rec.appl_attribute4,hr_api.g_varchar2)

5712: OR NVL(per_apl_shd.g_old_rec.appl_attribute2,hr_api.g_varchar2)
5713: <> NVL(p_appl_attribute2,hr_api.g_varchar2)
5714: OR NVL(per_apl_shd.g_old_rec.appl_attribute3,hr_api.g_varchar2)
5715: <> NVL(p_appl_attribute3,hr_api.g_varchar2)
5716: OR NVL(per_apl_shd.g_old_rec.appl_attribute4,hr_api.g_varchar2)
5717: <> NVL(p_appl_attribute4,hr_api.g_varchar2)
5718: OR NVL(per_apl_shd.g_old_rec.appl_attribute5,hr_api.g_varchar2)
5719: <> NVL(p_appl_attribute5,hr_api.g_varchar2)
5720: OR NVL(per_apl_shd.g_old_rec.appl_attribute6,hr_api.g_varchar2)

Line 5718: OR NVL(per_apl_shd.g_old_rec.appl_attribute5,hr_api.g_varchar2)

5714: OR NVL(per_apl_shd.g_old_rec.appl_attribute3,hr_api.g_varchar2)
5715: <> NVL(p_appl_attribute3,hr_api.g_varchar2)
5716: OR NVL(per_apl_shd.g_old_rec.appl_attribute4,hr_api.g_varchar2)
5717: <> NVL(p_appl_attribute4,hr_api.g_varchar2)
5718: OR NVL(per_apl_shd.g_old_rec.appl_attribute5,hr_api.g_varchar2)
5719: <> NVL(p_appl_attribute5,hr_api.g_varchar2)
5720: OR NVL(per_apl_shd.g_old_rec.appl_attribute6,hr_api.g_varchar2)
5721: <> NVL(p_appl_attribute6,hr_api.g_varchar2)
5722: OR NVL(per_apl_shd.g_old_rec.appl_attribute7,hr_api.g_varchar2)

Line 5720: OR NVL(per_apl_shd.g_old_rec.appl_attribute6,hr_api.g_varchar2)

5716: OR NVL(per_apl_shd.g_old_rec.appl_attribute4,hr_api.g_varchar2)
5717: <> NVL(p_appl_attribute4,hr_api.g_varchar2)
5718: OR NVL(per_apl_shd.g_old_rec.appl_attribute5,hr_api.g_varchar2)
5719: <> NVL(p_appl_attribute5,hr_api.g_varchar2)
5720: OR NVL(per_apl_shd.g_old_rec.appl_attribute6,hr_api.g_varchar2)
5721: <> NVL(p_appl_attribute6,hr_api.g_varchar2)
5722: OR NVL(per_apl_shd.g_old_rec.appl_attribute7,hr_api.g_varchar2)
5723: <> NVL(p_appl_attribute7,hr_api.g_varchar2)
5724: OR NVL(per_apl_shd.g_old_rec.appl_attribute8,hr_api.g_varchar2)

Line 5722: OR NVL(per_apl_shd.g_old_rec.appl_attribute7,hr_api.g_varchar2)

5718: OR NVL(per_apl_shd.g_old_rec.appl_attribute5,hr_api.g_varchar2)
5719: <> NVL(p_appl_attribute5,hr_api.g_varchar2)
5720: OR NVL(per_apl_shd.g_old_rec.appl_attribute6,hr_api.g_varchar2)
5721: <> NVL(p_appl_attribute6,hr_api.g_varchar2)
5722: OR NVL(per_apl_shd.g_old_rec.appl_attribute7,hr_api.g_varchar2)
5723: <> NVL(p_appl_attribute7,hr_api.g_varchar2)
5724: OR NVL(per_apl_shd.g_old_rec.appl_attribute8,hr_api.g_varchar2)
5725: <> NVL(p_appl_attribute8,hr_api.g_varchar2)
5726: OR NVL(per_apl_shd.g_old_rec.appl_attribute9,hr_api.g_varchar2)

Line 5724: OR NVL(per_apl_shd.g_old_rec.appl_attribute8,hr_api.g_varchar2)

5720: OR NVL(per_apl_shd.g_old_rec.appl_attribute6,hr_api.g_varchar2)
5721: <> NVL(p_appl_attribute6,hr_api.g_varchar2)
5722: OR NVL(per_apl_shd.g_old_rec.appl_attribute7,hr_api.g_varchar2)
5723: <> NVL(p_appl_attribute7,hr_api.g_varchar2)
5724: OR NVL(per_apl_shd.g_old_rec.appl_attribute8,hr_api.g_varchar2)
5725: <> NVL(p_appl_attribute8,hr_api.g_varchar2)
5726: OR NVL(per_apl_shd.g_old_rec.appl_attribute9,hr_api.g_varchar2)
5727: <> NVL(p_appl_attribute9,hr_api.g_varchar2)
5728: OR NVL(per_apl_shd.g_old_rec.appl_attribute10,hr_api.g_varchar2)

Line 5726: OR NVL(per_apl_shd.g_old_rec.appl_attribute9,hr_api.g_varchar2)

5722: OR NVL(per_apl_shd.g_old_rec.appl_attribute7,hr_api.g_varchar2)
5723: <> NVL(p_appl_attribute7,hr_api.g_varchar2)
5724: OR NVL(per_apl_shd.g_old_rec.appl_attribute8,hr_api.g_varchar2)
5725: <> NVL(p_appl_attribute8,hr_api.g_varchar2)
5726: OR NVL(per_apl_shd.g_old_rec.appl_attribute9,hr_api.g_varchar2)
5727: <> NVL(p_appl_attribute9,hr_api.g_varchar2)
5728: OR NVL(per_apl_shd.g_old_rec.appl_attribute10,hr_api.g_varchar2)
5729: <> NVL(p_appl_attribute10,hr_api.g_varchar2)
5730: OR NVL(per_apl_shd.g_old_rec.appl_attribute11,hr_api.g_varchar2)

Line 5728: OR NVL(per_apl_shd.g_old_rec.appl_attribute10,hr_api.g_varchar2)

5724: OR NVL(per_apl_shd.g_old_rec.appl_attribute8,hr_api.g_varchar2)
5725: <> NVL(p_appl_attribute8,hr_api.g_varchar2)
5726: OR NVL(per_apl_shd.g_old_rec.appl_attribute9,hr_api.g_varchar2)
5727: <> NVL(p_appl_attribute9,hr_api.g_varchar2)
5728: OR NVL(per_apl_shd.g_old_rec.appl_attribute10,hr_api.g_varchar2)
5729: <> NVL(p_appl_attribute10,hr_api.g_varchar2)
5730: OR NVL(per_apl_shd.g_old_rec.appl_attribute11,hr_api.g_varchar2)
5731: <> NVL(p_appl_attribute11,hr_api.g_varchar2)
5732: OR NVL(per_apl_shd.g_old_rec.appl_attribute12,hr_api.g_varchar2)

Line 5730: OR NVL(per_apl_shd.g_old_rec.appl_attribute11,hr_api.g_varchar2)

5726: OR NVL(per_apl_shd.g_old_rec.appl_attribute9,hr_api.g_varchar2)
5727: <> NVL(p_appl_attribute9,hr_api.g_varchar2)
5728: OR NVL(per_apl_shd.g_old_rec.appl_attribute10,hr_api.g_varchar2)
5729: <> NVL(p_appl_attribute10,hr_api.g_varchar2)
5730: OR NVL(per_apl_shd.g_old_rec.appl_attribute11,hr_api.g_varchar2)
5731: <> NVL(p_appl_attribute11,hr_api.g_varchar2)
5732: OR NVL(per_apl_shd.g_old_rec.appl_attribute12,hr_api.g_varchar2)
5733: <> NVL(p_appl_attribute12,hr_api.g_varchar2)
5734: OR NVL(per_apl_shd.g_old_rec.appl_attribute13,hr_api.g_varchar2)

Line 5732: OR NVL(per_apl_shd.g_old_rec.appl_attribute12,hr_api.g_varchar2)

5728: OR NVL(per_apl_shd.g_old_rec.appl_attribute10,hr_api.g_varchar2)
5729: <> NVL(p_appl_attribute10,hr_api.g_varchar2)
5730: OR NVL(per_apl_shd.g_old_rec.appl_attribute11,hr_api.g_varchar2)
5731: <> NVL(p_appl_attribute11,hr_api.g_varchar2)
5732: OR NVL(per_apl_shd.g_old_rec.appl_attribute12,hr_api.g_varchar2)
5733: <> NVL(p_appl_attribute12,hr_api.g_varchar2)
5734: OR NVL(per_apl_shd.g_old_rec.appl_attribute13,hr_api.g_varchar2)
5735: <> NVL(p_appl_attribute13,hr_api.g_varchar2)
5736: OR NVL(per_apl_shd.g_old_rec.appl_attribute14,hr_api.g_varchar2)

Line 5734: OR NVL(per_apl_shd.g_old_rec.appl_attribute13,hr_api.g_varchar2)

5730: OR NVL(per_apl_shd.g_old_rec.appl_attribute11,hr_api.g_varchar2)
5731: <> NVL(p_appl_attribute11,hr_api.g_varchar2)
5732: OR NVL(per_apl_shd.g_old_rec.appl_attribute12,hr_api.g_varchar2)
5733: <> NVL(p_appl_attribute12,hr_api.g_varchar2)
5734: OR NVL(per_apl_shd.g_old_rec.appl_attribute13,hr_api.g_varchar2)
5735: <> NVL(p_appl_attribute13,hr_api.g_varchar2)
5736: OR NVL(per_apl_shd.g_old_rec.appl_attribute14,hr_api.g_varchar2)
5737: <> NVL(p_appl_attribute14,hr_api.g_varchar2)
5738: OR NVL(per_apl_shd.g_old_rec.appl_attribute15,hr_api.g_varchar2)

Line 5736: OR NVL(per_apl_shd.g_old_rec.appl_attribute14,hr_api.g_varchar2)

5732: OR NVL(per_apl_shd.g_old_rec.appl_attribute12,hr_api.g_varchar2)
5733: <> NVL(p_appl_attribute12,hr_api.g_varchar2)
5734: OR NVL(per_apl_shd.g_old_rec.appl_attribute13,hr_api.g_varchar2)
5735: <> NVL(p_appl_attribute13,hr_api.g_varchar2)
5736: OR NVL(per_apl_shd.g_old_rec.appl_attribute14,hr_api.g_varchar2)
5737: <> NVL(p_appl_attribute14,hr_api.g_varchar2)
5738: OR NVL(per_apl_shd.g_old_rec.appl_attribute15,hr_api.g_varchar2)
5739: <> NVL(p_appl_attribute15,hr_api.g_varchar2)
5740: OR NVL(per_apl_shd.g_old_rec.appl_attribute16,hr_api.g_varchar2)

Line 5738: OR NVL(per_apl_shd.g_old_rec.appl_attribute15,hr_api.g_varchar2)

5734: OR NVL(per_apl_shd.g_old_rec.appl_attribute13,hr_api.g_varchar2)
5735: <> NVL(p_appl_attribute13,hr_api.g_varchar2)
5736: OR NVL(per_apl_shd.g_old_rec.appl_attribute14,hr_api.g_varchar2)
5737: <> NVL(p_appl_attribute14,hr_api.g_varchar2)
5738: OR NVL(per_apl_shd.g_old_rec.appl_attribute15,hr_api.g_varchar2)
5739: <> NVL(p_appl_attribute15,hr_api.g_varchar2)
5740: OR NVL(per_apl_shd.g_old_rec.appl_attribute16,hr_api.g_varchar2)
5741: <> NVL(p_appl_attribute16,hr_api.g_varchar2)
5742: OR NVL(per_apl_shd.g_old_rec.appl_attribute17,hr_api.g_varchar2)

Line 5740: OR NVL(per_apl_shd.g_old_rec.appl_attribute16,hr_api.g_varchar2)

5736: OR NVL(per_apl_shd.g_old_rec.appl_attribute14,hr_api.g_varchar2)
5737: <> NVL(p_appl_attribute14,hr_api.g_varchar2)
5738: OR NVL(per_apl_shd.g_old_rec.appl_attribute15,hr_api.g_varchar2)
5739: <> NVL(p_appl_attribute15,hr_api.g_varchar2)
5740: OR NVL(per_apl_shd.g_old_rec.appl_attribute16,hr_api.g_varchar2)
5741: <> NVL(p_appl_attribute16,hr_api.g_varchar2)
5742: OR NVL(per_apl_shd.g_old_rec.appl_attribute17,hr_api.g_varchar2)
5743: <> NVL(p_appl_attribute17,hr_api.g_varchar2)
5744: OR NVL(per_apl_shd.g_old_rec.appl_attribute18,hr_api.g_varchar2)

Line 5742: OR NVL(per_apl_shd.g_old_rec.appl_attribute17,hr_api.g_varchar2)

5738: OR NVL(per_apl_shd.g_old_rec.appl_attribute15,hr_api.g_varchar2)
5739: <> NVL(p_appl_attribute15,hr_api.g_varchar2)
5740: OR NVL(per_apl_shd.g_old_rec.appl_attribute16,hr_api.g_varchar2)
5741: <> NVL(p_appl_attribute16,hr_api.g_varchar2)
5742: OR NVL(per_apl_shd.g_old_rec.appl_attribute17,hr_api.g_varchar2)
5743: <> NVL(p_appl_attribute17,hr_api.g_varchar2)
5744: OR NVL(per_apl_shd.g_old_rec.appl_attribute18,hr_api.g_varchar2)
5745: <> NVL(p_appl_attribute18,hr_api.g_varchar2)
5746: OR NVL(per_apl_shd.g_old_rec.appl_attribute19,hr_api.g_varchar2)

Line 5744: OR NVL(per_apl_shd.g_old_rec.appl_attribute18,hr_api.g_varchar2)

5740: OR NVL(per_apl_shd.g_old_rec.appl_attribute16,hr_api.g_varchar2)
5741: <> NVL(p_appl_attribute16,hr_api.g_varchar2)
5742: OR NVL(per_apl_shd.g_old_rec.appl_attribute17,hr_api.g_varchar2)
5743: <> NVL(p_appl_attribute17,hr_api.g_varchar2)
5744: OR NVL(per_apl_shd.g_old_rec.appl_attribute18,hr_api.g_varchar2)
5745: <> NVL(p_appl_attribute18,hr_api.g_varchar2)
5746: OR NVL(per_apl_shd.g_old_rec.appl_attribute19,hr_api.g_varchar2)
5747: <> NVL(p_appl_attribute19,hr_api.g_varchar2)
5748: OR NVL(per_apl_shd.g_old_rec.appl_attribute20,hr_api.g_varchar2)

Line 5746: OR NVL(per_apl_shd.g_old_rec.appl_attribute19,hr_api.g_varchar2)

5742: OR NVL(per_apl_shd.g_old_rec.appl_attribute17,hr_api.g_varchar2)
5743: <> NVL(p_appl_attribute17,hr_api.g_varchar2)
5744: OR NVL(per_apl_shd.g_old_rec.appl_attribute18,hr_api.g_varchar2)
5745: <> NVL(p_appl_attribute18,hr_api.g_varchar2)
5746: OR NVL(per_apl_shd.g_old_rec.appl_attribute19,hr_api.g_varchar2)
5747: <> NVL(p_appl_attribute19,hr_api.g_varchar2)
5748: OR NVL(per_apl_shd.g_old_rec.appl_attribute20,hr_api.g_varchar2)
5749: <> NVL(p_appl_attribute20,hr_api.g_varchar2)
5750: OR NVL(per_apl_shd.g_old_rec.current_employer,hr_api.g_varchar2)

Line 5748: OR NVL(per_apl_shd.g_old_rec.appl_attribute20,hr_api.g_varchar2)

5744: OR NVL(per_apl_shd.g_old_rec.appl_attribute18,hr_api.g_varchar2)
5745: <> NVL(p_appl_attribute18,hr_api.g_varchar2)
5746: OR NVL(per_apl_shd.g_old_rec.appl_attribute19,hr_api.g_varchar2)
5747: <> NVL(p_appl_attribute19,hr_api.g_varchar2)
5748: OR NVL(per_apl_shd.g_old_rec.appl_attribute20,hr_api.g_varchar2)
5749: <> NVL(p_appl_attribute20,hr_api.g_varchar2)
5750: OR NVL(per_apl_shd.g_old_rec.current_employer,hr_api.g_varchar2)
5751: <> NVL(p_current_employer,hr_api.g_varchar2)
5752: OR NVL(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2)

Line 5750: OR NVL(per_apl_shd.g_old_rec.current_employer,hr_api.g_varchar2)

5746: OR NVL(per_apl_shd.g_old_rec.appl_attribute19,hr_api.g_varchar2)
5747: <> NVL(p_appl_attribute19,hr_api.g_varchar2)
5748: OR NVL(per_apl_shd.g_old_rec.appl_attribute20,hr_api.g_varchar2)
5749: <> NVL(p_appl_attribute20,hr_api.g_varchar2)
5750: OR NVL(per_apl_shd.g_old_rec.current_employer,hr_api.g_varchar2)
5751: <> NVL(p_current_employer,hr_api.g_varchar2)
5752: OR NVL(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2)
5753: <> NVL(p_termination_reason,hr_api.g_varchar2)) THEN
5754: --

Line 5752: OR NVL(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2)

5748: OR NVL(per_apl_shd.g_old_rec.appl_attribute20,hr_api.g_varchar2)
5749: <> NVL(p_appl_attribute20,hr_api.g_varchar2)
5750: OR NVL(per_apl_shd.g_old_rec.current_employer,hr_api.g_varchar2)
5751: <> NVL(p_current_employer,hr_api.g_varchar2)
5752: OR NVL(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2)
5753: <> NVL(p_termination_reason,hr_api.g_varchar2)) THEN
5754: --
5755: --
5756: hr_utility.set_location(l_proc, 170);

Line 7171: per_apl_shd.lck

7167: --
7168: IF p_application_id IS NOT NULL THEN
7169: hr_utility.set_location(l_proc, 30);
7170: --
7171: per_apl_shd.lck
7172: (p_application_id => p_application_id
7173: ,p_object_version_number => p_app_object_version_number);
7174: END IF;
7175: --