APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_APL_SHD

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

5742: --
5743: hr_utility.set_location(l_proc, 165);
5744: --
5745: IF p_application_id IS NOT NULL AND (
5746: NVL(per_apl_shd.g_old_rec.projected_hire_date,hr_api.g_date)
5747: <> NVL(p_projected_hire_date,hr_api.g_date)
5748: OR NVL(per_apl_shd.g_old_rec.appl_attribute_category,hr_api.g_varchar2)
5749: <> NVL(p_appl_attribute_category,hr_api.g_varchar2)
5750: OR NVL(per_apl_shd.g_old_rec.appl_attribute1,hr_api.g_varchar2)

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

5744: --
5745: IF p_application_id IS NOT NULL AND (
5746: NVL(per_apl_shd.g_old_rec.projected_hire_date,hr_api.g_date)
5747: <> NVL(p_projected_hire_date,hr_api.g_date)
5748: OR NVL(per_apl_shd.g_old_rec.appl_attribute_category,hr_api.g_varchar2)
5749: <> NVL(p_appl_attribute_category,hr_api.g_varchar2)
5750: OR NVL(per_apl_shd.g_old_rec.appl_attribute1,hr_api.g_varchar2)
5751: <> NVL(p_appl_attribute1,hr_api.g_varchar2)
5752: OR NVL(per_apl_shd.g_old_rec.appl_attribute2,hr_api.g_varchar2)

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

5746: NVL(per_apl_shd.g_old_rec.projected_hire_date,hr_api.g_date)
5747: <> NVL(p_projected_hire_date,hr_api.g_date)
5748: OR NVL(per_apl_shd.g_old_rec.appl_attribute_category,hr_api.g_varchar2)
5749: <> NVL(p_appl_attribute_category,hr_api.g_varchar2)
5750: OR NVL(per_apl_shd.g_old_rec.appl_attribute1,hr_api.g_varchar2)
5751: <> NVL(p_appl_attribute1,hr_api.g_varchar2)
5752: OR NVL(per_apl_shd.g_old_rec.appl_attribute2,hr_api.g_varchar2)
5753: <> NVL(p_appl_attribute2,hr_api.g_varchar2)
5754: OR NVL(per_apl_shd.g_old_rec.appl_attribute3,hr_api.g_varchar2)

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

5748: OR NVL(per_apl_shd.g_old_rec.appl_attribute_category,hr_api.g_varchar2)
5749: <> NVL(p_appl_attribute_category,hr_api.g_varchar2)
5750: OR NVL(per_apl_shd.g_old_rec.appl_attribute1,hr_api.g_varchar2)
5751: <> NVL(p_appl_attribute1,hr_api.g_varchar2)
5752: OR NVL(per_apl_shd.g_old_rec.appl_attribute2,hr_api.g_varchar2)
5753: <> NVL(p_appl_attribute2,hr_api.g_varchar2)
5754: OR NVL(per_apl_shd.g_old_rec.appl_attribute3,hr_api.g_varchar2)
5755: <> NVL(p_appl_attribute3,hr_api.g_varchar2)
5756: OR NVL(per_apl_shd.g_old_rec.appl_attribute4,hr_api.g_varchar2)

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

5750: OR NVL(per_apl_shd.g_old_rec.appl_attribute1,hr_api.g_varchar2)
5751: <> NVL(p_appl_attribute1,hr_api.g_varchar2)
5752: OR NVL(per_apl_shd.g_old_rec.appl_attribute2,hr_api.g_varchar2)
5753: <> NVL(p_appl_attribute2,hr_api.g_varchar2)
5754: OR NVL(per_apl_shd.g_old_rec.appl_attribute3,hr_api.g_varchar2)
5755: <> NVL(p_appl_attribute3,hr_api.g_varchar2)
5756: OR NVL(per_apl_shd.g_old_rec.appl_attribute4,hr_api.g_varchar2)
5757: <> NVL(p_appl_attribute4,hr_api.g_varchar2)
5758: OR NVL(per_apl_shd.g_old_rec.appl_attribute5,hr_api.g_varchar2)

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

5752: OR NVL(per_apl_shd.g_old_rec.appl_attribute2,hr_api.g_varchar2)
5753: <> NVL(p_appl_attribute2,hr_api.g_varchar2)
5754: OR NVL(per_apl_shd.g_old_rec.appl_attribute3,hr_api.g_varchar2)
5755: <> NVL(p_appl_attribute3,hr_api.g_varchar2)
5756: OR NVL(per_apl_shd.g_old_rec.appl_attribute4,hr_api.g_varchar2)
5757: <> NVL(p_appl_attribute4,hr_api.g_varchar2)
5758: OR NVL(per_apl_shd.g_old_rec.appl_attribute5,hr_api.g_varchar2)
5759: <> NVL(p_appl_attribute5,hr_api.g_varchar2)
5760: OR NVL(per_apl_shd.g_old_rec.appl_attribute6,hr_api.g_varchar2)

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

5754: OR NVL(per_apl_shd.g_old_rec.appl_attribute3,hr_api.g_varchar2)
5755: <> NVL(p_appl_attribute3,hr_api.g_varchar2)
5756: OR NVL(per_apl_shd.g_old_rec.appl_attribute4,hr_api.g_varchar2)
5757: <> NVL(p_appl_attribute4,hr_api.g_varchar2)
5758: OR NVL(per_apl_shd.g_old_rec.appl_attribute5,hr_api.g_varchar2)
5759: <> NVL(p_appl_attribute5,hr_api.g_varchar2)
5760: OR NVL(per_apl_shd.g_old_rec.appl_attribute6,hr_api.g_varchar2)
5761: <> NVL(p_appl_attribute6,hr_api.g_varchar2)
5762: OR NVL(per_apl_shd.g_old_rec.appl_attribute7,hr_api.g_varchar2)

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

5756: OR NVL(per_apl_shd.g_old_rec.appl_attribute4,hr_api.g_varchar2)
5757: <> NVL(p_appl_attribute4,hr_api.g_varchar2)
5758: OR NVL(per_apl_shd.g_old_rec.appl_attribute5,hr_api.g_varchar2)
5759: <> NVL(p_appl_attribute5,hr_api.g_varchar2)
5760: OR NVL(per_apl_shd.g_old_rec.appl_attribute6,hr_api.g_varchar2)
5761: <> NVL(p_appl_attribute6,hr_api.g_varchar2)
5762: OR NVL(per_apl_shd.g_old_rec.appl_attribute7,hr_api.g_varchar2)
5763: <> NVL(p_appl_attribute7,hr_api.g_varchar2)
5764: OR NVL(per_apl_shd.g_old_rec.appl_attribute8,hr_api.g_varchar2)

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

5758: OR NVL(per_apl_shd.g_old_rec.appl_attribute5,hr_api.g_varchar2)
5759: <> NVL(p_appl_attribute5,hr_api.g_varchar2)
5760: OR NVL(per_apl_shd.g_old_rec.appl_attribute6,hr_api.g_varchar2)
5761: <> NVL(p_appl_attribute6,hr_api.g_varchar2)
5762: OR NVL(per_apl_shd.g_old_rec.appl_attribute7,hr_api.g_varchar2)
5763: <> NVL(p_appl_attribute7,hr_api.g_varchar2)
5764: OR NVL(per_apl_shd.g_old_rec.appl_attribute8,hr_api.g_varchar2)
5765: <> NVL(p_appl_attribute8,hr_api.g_varchar2)
5766: OR NVL(per_apl_shd.g_old_rec.appl_attribute9,hr_api.g_varchar2)

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

5760: OR NVL(per_apl_shd.g_old_rec.appl_attribute6,hr_api.g_varchar2)
5761: <> NVL(p_appl_attribute6,hr_api.g_varchar2)
5762: OR NVL(per_apl_shd.g_old_rec.appl_attribute7,hr_api.g_varchar2)
5763: <> NVL(p_appl_attribute7,hr_api.g_varchar2)
5764: OR NVL(per_apl_shd.g_old_rec.appl_attribute8,hr_api.g_varchar2)
5765: <> NVL(p_appl_attribute8,hr_api.g_varchar2)
5766: OR NVL(per_apl_shd.g_old_rec.appl_attribute9,hr_api.g_varchar2)
5767: <> NVL(p_appl_attribute9,hr_api.g_varchar2)
5768: OR NVL(per_apl_shd.g_old_rec.appl_attribute10,hr_api.g_varchar2)

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

5762: OR NVL(per_apl_shd.g_old_rec.appl_attribute7,hr_api.g_varchar2)
5763: <> NVL(p_appl_attribute7,hr_api.g_varchar2)
5764: OR NVL(per_apl_shd.g_old_rec.appl_attribute8,hr_api.g_varchar2)
5765: <> NVL(p_appl_attribute8,hr_api.g_varchar2)
5766: OR NVL(per_apl_shd.g_old_rec.appl_attribute9,hr_api.g_varchar2)
5767: <> NVL(p_appl_attribute9,hr_api.g_varchar2)
5768: OR NVL(per_apl_shd.g_old_rec.appl_attribute10,hr_api.g_varchar2)
5769: <> NVL(p_appl_attribute10,hr_api.g_varchar2)
5770: OR NVL(per_apl_shd.g_old_rec.appl_attribute11,hr_api.g_varchar2)

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

5764: OR NVL(per_apl_shd.g_old_rec.appl_attribute8,hr_api.g_varchar2)
5765: <> NVL(p_appl_attribute8,hr_api.g_varchar2)
5766: OR NVL(per_apl_shd.g_old_rec.appl_attribute9,hr_api.g_varchar2)
5767: <> NVL(p_appl_attribute9,hr_api.g_varchar2)
5768: OR NVL(per_apl_shd.g_old_rec.appl_attribute10,hr_api.g_varchar2)
5769: <> NVL(p_appl_attribute10,hr_api.g_varchar2)
5770: OR NVL(per_apl_shd.g_old_rec.appl_attribute11,hr_api.g_varchar2)
5771: <> NVL(p_appl_attribute11,hr_api.g_varchar2)
5772: OR NVL(per_apl_shd.g_old_rec.appl_attribute12,hr_api.g_varchar2)

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

5766: OR NVL(per_apl_shd.g_old_rec.appl_attribute9,hr_api.g_varchar2)
5767: <> NVL(p_appl_attribute9,hr_api.g_varchar2)
5768: OR NVL(per_apl_shd.g_old_rec.appl_attribute10,hr_api.g_varchar2)
5769: <> NVL(p_appl_attribute10,hr_api.g_varchar2)
5770: OR NVL(per_apl_shd.g_old_rec.appl_attribute11,hr_api.g_varchar2)
5771: <> NVL(p_appl_attribute11,hr_api.g_varchar2)
5772: OR NVL(per_apl_shd.g_old_rec.appl_attribute12,hr_api.g_varchar2)
5773: <> NVL(p_appl_attribute12,hr_api.g_varchar2)
5774: OR NVL(per_apl_shd.g_old_rec.appl_attribute13,hr_api.g_varchar2)

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

5768: OR NVL(per_apl_shd.g_old_rec.appl_attribute10,hr_api.g_varchar2)
5769: <> NVL(p_appl_attribute10,hr_api.g_varchar2)
5770: OR NVL(per_apl_shd.g_old_rec.appl_attribute11,hr_api.g_varchar2)
5771: <> NVL(p_appl_attribute11,hr_api.g_varchar2)
5772: OR NVL(per_apl_shd.g_old_rec.appl_attribute12,hr_api.g_varchar2)
5773: <> NVL(p_appl_attribute12,hr_api.g_varchar2)
5774: OR NVL(per_apl_shd.g_old_rec.appl_attribute13,hr_api.g_varchar2)
5775: <> NVL(p_appl_attribute13,hr_api.g_varchar2)
5776: OR NVL(per_apl_shd.g_old_rec.appl_attribute14,hr_api.g_varchar2)

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

5770: OR NVL(per_apl_shd.g_old_rec.appl_attribute11,hr_api.g_varchar2)
5771: <> NVL(p_appl_attribute11,hr_api.g_varchar2)
5772: OR NVL(per_apl_shd.g_old_rec.appl_attribute12,hr_api.g_varchar2)
5773: <> NVL(p_appl_attribute12,hr_api.g_varchar2)
5774: OR NVL(per_apl_shd.g_old_rec.appl_attribute13,hr_api.g_varchar2)
5775: <> NVL(p_appl_attribute13,hr_api.g_varchar2)
5776: OR NVL(per_apl_shd.g_old_rec.appl_attribute14,hr_api.g_varchar2)
5777: <> NVL(p_appl_attribute14,hr_api.g_varchar2)
5778: OR NVL(per_apl_shd.g_old_rec.appl_attribute15,hr_api.g_varchar2)

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

5772: OR NVL(per_apl_shd.g_old_rec.appl_attribute12,hr_api.g_varchar2)
5773: <> NVL(p_appl_attribute12,hr_api.g_varchar2)
5774: OR NVL(per_apl_shd.g_old_rec.appl_attribute13,hr_api.g_varchar2)
5775: <> NVL(p_appl_attribute13,hr_api.g_varchar2)
5776: OR NVL(per_apl_shd.g_old_rec.appl_attribute14,hr_api.g_varchar2)
5777: <> NVL(p_appl_attribute14,hr_api.g_varchar2)
5778: OR NVL(per_apl_shd.g_old_rec.appl_attribute15,hr_api.g_varchar2)
5779: <> NVL(p_appl_attribute15,hr_api.g_varchar2)
5780: OR NVL(per_apl_shd.g_old_rec.appl_attribute16,hr_api.g_varchar2)

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

5774: OR NVL(per_apl_shd.g_old_rec.appl_attribute13,hr_api.g_varchar2)
5775: <> NVL(p_appl_attribute13,hr_api.g_varchar2)
5776: OR NVL(per_apl_shd.g_old_rec.appl_attribute14,hr_api.g_varchar2)
5777: <> NVL(p_appl_attribute14,hr_api.g_varchar2)
5778: OR NVL(per_apl_shd.g_old_rec.appl_attribute15,hr_api.g_varchar2)
5779: <> NVL(p_appl_attribute15,hr_api.g_varchar2)
5780: OR NVL(per_apl_shd.g_old_rec.appl_attribute16,hr_api.g_varchar2)
5781: <> NVL(p_appl_attribute16,hr_api.g_varchar2)
5782: OR NVL(per_apl_shd.g_old_rec.appl_attribute17,hr_api.g_varchar2)

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

5776: OR NVL(per_apl_shd.g_old_rec.appl_attribute14,hr_api.g_varchar2)
5777: <> NVL(p_appl_attribute14,hr_api.g_varchar2)
5778: OR NVL(per_apl_shd.g_old_rec.appl_attribute15,hr_api.g_varchar2)
5779: <> NVL(p_appl_attribute15,hr_api.g_varchar2)
5780: OR NVL(per_apl_shd.g_old_rec.appl_attribute16,hr_api.g_varchar2)
5781: <> NVL(p_appl_attribute16,hr_api.g_varchar2)
5782: OR NVL(per_apl_shd.g_old_rec.appl_attribute17,hr_api.g_varchar2)
5783: <> NVL(p_appl_attribute17,hr_api.g_varchar2)
5784: OR NVL(per_apl_shd.g_old_rec.appl_attribute18,hr_api.g_varchar2)

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

5778: OR NVL(per_apl_shd.g_old_rec.appl_attribute15,hr_api.g_varchar2)
5779: <> NVL(p_appl_attribute15,hr_api.g_varchar2)
5780: OR NVL(per_apl_shd.g_old_rec.appl_attribute16,hr_api.g_varchar2)
5781: <> NVL(p_appl_attribute16,hr_api.g_varchar2)
5782: OR NVL(per_apl_shd.g_old_rec.appl_attribute17,hr_api.g_varchar2)
5783: <> NVL(p_appl_attribute17,hr_api.g_varchar2)
5784: OR NVL(per_apl_shd.g_old_rec.appl_attribute18,hr_api.g_varchar2)
5785: <> NVL(p_appl_attribute18,hr_api.g_varchar2)
5786: OR NVL(per_apl_shd.g_old_rec.appl_attribute19,hr_api.g_varchar2)

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

5780: OR NVL(per_apl_shd.g_old_rec.appl_attribute16,hr_api.g_varchar2)
5781: <> NVL(p_appl_attribute16,hr_api.g_varchar2)
5782: OR NVL(per_apl_shd.g_old_rec.appl_attribute17,hr_api.g_varchar2)
5783: <> NVL(p_appl_attribute17,hr_api.g_varchar2)
5784: OR NVL(per_apl_shd.g_old_rec.appl_attribute18,hr_api.g_varchar2)
5785: <> NVL(p_appl_attribute18,hr_api.g_varchar2)
5786: OR NVL(per_apl_shd.g_old_rec.appl_attribute19,hr_api.g_varchar2)
5787: <> NVL(p_appl_attribute19,hr_api.g_varchar2)
5788: OR NVL(per_apl_shd.g_old_rec.appl_attribute20,hr_api.g_varchar2)

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

5782: OR NVL(per_apl_shd.g_old_rec.appl_attribute17,hr_api.g_varchar2)
5783: <> NVL(p_appl_attribute17,hr_api.g_varchar2)
5784: OR NVL(per_apl_shd.g_old_rec.appl_attribute18,hr_api.g_varchar2)
5785: <> NVL(p_appl_attribute18,hr_api.g_varchar2)
5786: OR NVL(per_apl_shd.g_old_rec.appl_attribute19,hr_api.g_varchar2)
5787: <> NVL(p_appl_attribute19,hr_api.g_varchar2)
5788: OR NVL(per_apl_shd.g_old_rec.appl_attribute20,hr_api.g_varchar2)
5789: <> NVL(p_appl_attribute20,hr_api.g_varchar2)
5790: OR NVL(per_apl_shd.g_old_rec.current_employer,hr_api.g_varchar2)

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

5784: OR NVL(per_apl_shd.g_old_rec.appl_attribute18,hr_api.g_varchar2)
5785: <> NVL(p_appl_attribute18,hr_api.g_varchar2)
5786: OR NVL(per_apl_shd.g_old_rec.appl_attribute19,hr_api.g_varchar2)
5787: <> NVL(p_appl_attribute19,hr_api.g_varchar2)
5788: OR NVL(per_apl_shd.g_old_rec.appl_attribute20,hr_api.g_varchar2)
5789: <> NVL(p_appl_attribute20,hr_api.g_varchar2)
5790: OR NVL(per_apl_shd.g_old_rec.current_employer,hr_api.g_varchar2)
5791: <> NVL(p_current_employer,hr_api.g_varchar2)
5792: OR NVL(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2)

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

5786: OR NVL(per_apl_shd.g_old_rec.appl_attribute19,hr_api.g_varchar2)
5787: <> NVL(p_appl_attribute19,hr_api.g_varchar2)
5788: OR NVL(per_apl_shd.g_old_rec.appl_attribute20,hr_api.g_varchar2)
5789: <> NVL(p_appl_attribute20,hr_api.g_varchar2)
5790: OR NVL(per_apl_shd.g_old_rec.current_employer,hr_api.g_varchar2)
5791: <> NVL(p_current_employer,hr_api.g_varchar2)
5792: OR NVL(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2)
5793: <> NVL(p_termination_reason,hr_api.g_varchar2)) THEN
5794: --

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

5788: OR NVL(per_apl_shd.g_old_rec.appl_attribute20,hr_api.g_varchar2)
5789: <> NVL(p_appl_attribute20,hr_api.g_varchar2)
5790: OR NVL(per_apl_shd.g_old_rec.current_employer,hr_api.g_varchar2)
5791: <> NVL(p_current_employer,hr_api.g_varchar2)
5792: OR NVL(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2)
5793: <> NVL(p_termination_reason,hr_api.g_varchar2)) THEN
5794: --
5795: --
5796: hr_utility.set_location(l_proc, 170);

Line 7211: per_apl_shd.lck

7207: --
7208: IF p_application_id IS NOT NULL THEN
7209: hr_utility.set_location(l_proc, 30);
7210: --
7211: per_apl_shd.lck
7212: (p_application_id => p_application_id
7213: ,p_object_version_number => p_app_object_version_number);
7214: END IF;
7215: --