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_PYP_SHD

Line 6068: NVL(per_pyp_shd.g_old_rec.change_date,hr_api.g_date)

6064: END IF;
6065: --
6066: IF (p_pay_proposal_id IS NULL AND p_proposed_salary_n IS NOT NULL) OR
6067: (p_pay_proposal_id IS NOT NULL AND (
6068: NVL(per_pyp_shd.g_old_rec.change_date,hr_api.g_date)
6069: <>NVL(p_change_date,hr_api.g_date)
6070: OR NVL(per_pyp_shd.g_old_rec.proposed_salary_n,hr_api.g_number)
6071: <>NVL(p_proposed_salary_n,hr_api.g_number)
6072: OR NVL(per_pyp_shd.g_old_rec.proposal_reason,hr_api.g_varchar2)

Line 6070: OR NVL(per_pyp_shd.g_old_rec.proposed_salary_n,hr_api.g_number)

6066: IF (p_pay_proposal_id IS NULL AND p_proposed_salary_n IS NOT NULL) OR
6067: (p_pay_proposal_id IS NOT NULL AND (
6068: NVL(per_pyp_shd.g_old_rec.change_date,hr_api.g_date)
6069: <>NVL(p_change_date,hr_api.g_date)
6070: OR NVL(per_pyp_shd.g_old_rec.proposed_salary_n,hr_api.g_number)
6071: <>NVL(p_proposed_salary_n,hr_api.g_number)
6072: OR NVL(per_pyp_shd.g_old_rec.proposal_reason,hr_api.g_varchar2)
6073: <>NVL(p_proposal_reason,hr_api.g_varchar2)
6074: OR NVL(per_pyp_shd.g_old_rec.attribute_category,hr_api.g_varchar2)

Line 6072: OR NVL(per_pyp_shd.g_old_rec.proposal_reason,hr_api.g_varchar2)

6068: NVL(per_pyp_shd.g_old_rec.change_date,hr_api.g_date)
6069: <>NVL(p_change_date,hr_api.g_date)
6070: OR NVL(per_pyp_shd.g_old_rec.proposed_salary_n,hr_api.g_number)
6071: <>NVL(p_proposed_salary_n,hr_api.g_number)
6072: OR NVL(per_pyp_shd.g_old_rec.proposal_reason,hr_api.g_varchar2)
6073: <>NVL(p_proposal_reason,hr_api.g_varchar2)
6074: OR NVL(per_pyp_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
6075: <>NVL(p_pyp_attribute_category,hr_api.g_varchar2)
6076: OR NVL(per_pyp_shd.g_old_rec.attribute1,hr_api.g_varchar2)

Line 6074: OR NVL(per_pyp_shd.g_old_rec.attribute_category,hr_api.g_varchar2)

6070: OR NVL(per_pyp_shd.g_old_rec.proposed_salary_n,hr_api.g_number)
6071: <>NVL(p_proposed_salary_n,hr_api.g_number)
6072: OR NVL(per_pyp_shd.g_old_rec.proposal_reason,hr_api.g_varchar2)
6073: <>NVL(p_proposal_reason,hr_api.g_varchar2)
6074: OR NVL(per_pyp_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
6075: <>NVL(p_pyp_attribute_category,hr_api.g_varchar2)
6076: OR NVL(per_pyp_shd.g_old_rec.attribute1,hr_api.g_varchar2)
6077: <>NVL(p_pyp_attribute1,hr_api.g_varchar2)
6078: OR NVL(per_pyp_shd.g_old_rec.attribute2,hr_api.g_varchar2)

Line 6076: OR NVL(per_pyp_shd.g_old_rec.attribute1,hr_api.g_varchar2)

6072: OR NVL(per_pyp_shd.g_old_rec.proposal_reason,hr_api.g_varchar2)
6073: <>NVL(p_proposal_reason,hr_api.g_varchar2)
6074: OR NVL(per_pyp_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
6075: <>NVL(p_pyp_attribute_category,hr_api.g_varchar2)
6076: OR NVL(per_pyp_shd.g_old_rec.attribute1,hr_api.g_varchar2)
6077: <>NVL(p_pyp_attribute1,hr_api.g_varchar2)
6078: OR NVL(per_pyp_shd.g_old_rec.attribute2,hr_api.g_varchar2)
6079: <>NVL(p_pyp_attribute2,hr_api.g_varchar2)
6080: OR NVL(per_pyp_shd.g_old_rec.attribute3,hr_api.g_varchar2)

Line 6078: OR NVL(per_pyp_shd.g_old_rec.attribute2,hr_api.g_varchar2)

6074: OR NVL(per_pyp_shd.g_old_rec.attribute_category,hr_api.g_varchar2)
6075: <>NVL(p_pyp_attribute_category,hr_api.g_varchar2)
6076: OR NVL(per_pyp_shd.g_old_rec.attribute1,hr_api.g_varchar2)
6077: <>NVL(p_pyp_attribute1,hr_api.g_varchar2)
6078: OR NVL(per_pyp_shd.g_old_rec.attribute2,hr_api.g_varchar2)
6079: <>NVL(p_pyp_attribute2,hr_api.g_varchar2)
6080: OR NVL(per_pyp_shd.g_old_rec.attribute3,hr_api.g_varchar2)
6081: <>NVL(p_pyp_attribute3,hr_api.g_varchar2)
6082: OR NVL(per_pyp_shd.g_old_rec.attribute4,hr_api.g_varchar2)

Line 6080: OR NVL(per_pyp_shd.g_old_rec.attribute3,hr_api.g_varchar2)

6076: OR NVL(per_pyp_shd.g_old_rec.attribute1,hr_api.g_varchar2)
6077: <>NVL(p_pyp_attribute1,hr_api.g_varchar2)
6078: OR NVL(per_pyp_shd.g_old_rec.attribute2,hr_api.g_varchar2)
6079: <>NVL(p_pyp_attribute2,hr_api.g_varchar2)
6080: OR NVL(per_pyp_shd.g_old_rec.attribute3,hr_api.g_varchar2)
6081: <>NVL(p_pyp_attribute3,hr_api.g_varchar2)
6082: OR NVL(per_pyp_shd.g_old_rec.attribute4,hr_api.g_varchar2)
6083: <>NVL(p_pyp_attribute4,hr_api.g_varchar2)
6084: OR NVL(per_pyp_shd.g_old_rec.attribute5,hr_api.g_varchar2)

Line 6082: OR NVL(per_pyp_shd.g_old_rec.attribute4,hr_api.g_varchar2)

6078: OR NVL(per_pyp_shd.g_old_rec.attribute2,hr_api.g_varchar2)
6079: <>NVL(p_pyp_attribute2,hr_api.g_varchar2)
6080: OR NVL(per_pyp_shd.g_old_rec.attribute3,hr_api.g_varchar2)
6081: <>NVL(p_pyp_attribute3,hr_api.g_varchar2)
6082: OR NVL(per_pyp_shd.g_old_rec.attribute4,hr_api.g_varchar2)
6083: <>NVL(p_pyp_attribute4,hr_api.g_varchar2)
6084: OR NVL(per_pyp_shd.g_old_rec.attribute5,hr_api.g_varchar2)
6085: <>NVL(p_pyp_attribute5,hr_api.g_varchar2)
6086: OR NVL(per_pyp_shd.g_old_rec.attribute6,hr_api.g_varchar2)

Line 6084: OR NVL(per_pyp_shd.g_old_rec.attribute5,hr_api.g_varchar2)

6080: OR NVL(per_pyp_shd.g_old_rec.attribute3,hr_api.g_varchar2)
6081: <>NVL(p_pyp_attribute3,hr_api.g_varchar2)
6082: OR NVL(per_pyp_shd.g_old_rec.attribute4,hr_api.g_varchar2)
6083: <>NVL(p_pyp_attribute4,hr_api.g_varchar2)
6084: OR NVL(per_pyp_shd.g_old_rec.attribute5,hr_api.g_varchar2)
6085: <>NVL(p_pyp_attribute5,hr_api.g_varchar2)
6086: OR NVL(per_pyp_shd.g_old_rec.attribute6,hr_api.g_varchar2)
6087: <>NVL(p_pyp_attribute6,hr_api.g_varchar2)
6088: OR NVL(per_pyp_shd.g_old_rec.attribute7,hr_api.g_varchar2)

Line 6086: OR NVL(per_pyp_shd.g_old_rec.attribute6,hr_api.g_varchar2)

6082: OR NVL(per_pyp_shd.g_old_rec.attribute4,hr_api.g_varchar2)
6083: <>NVL(p_pyp_attribute4,hr_api.g_varchar2)
6084: OR NVL(per_pyp_shd.g_old_rec.attribute5,hr_api.g_varchar2)
6085: <>NVL(p_pyp_attribute5,hr_api.g_varchar2)
6086: OR NVL(per_pyp_shd.g_old_rec.attribute6,hr_api.g_varchar2)
6087: <>NVL(p_pyp_attribute6,hr_api.g_varchar2)
6088: OR NVL(per_pyp_shd.g_old_rec.attribute7,hr_api.g_varchar2)
6089: <>NVL(p_pyp_attribute7,hr_api.g_varchar2)
6090: OR NVL(per_pyp_shd.g_old_rec.attribute8,hr_api.g_varchar2)

Line 6088: OR NVL(per_pyp_shd.g_old_rec.attribute7,hr_api.g_varchar2)

6084: OR NVL(per_pyp_shd.g_old_rec.attribute5,hr_api.g_varchar2)
6085: <>NVL(p_pyp_attribute5,hr_api.g_varchar2)
6086: OR NVL(per_pyp_shd.g_old_rec.attribute6,hr_api.g_varchar2)
6087: <>NVL(p_pyp_attribute6,hr_api.g_varchar2)
6088: OR NVL(per_pyp_shd.g_old_rec.attribute7,hr_api.g_varchar2)
6089: <>NVL(p_pyp_attribute7,hr_api.g_varchar2)
6090: OR NVL(per_pyp_shd.g_old_rec.attribute8,hr_api.g_varchar2)
6091: <>NVL(p_pyp_attribute8,hr_api.g_varchar2)
6092: OR NVL(per_pyp_shd.g_old_rec.attribute9,hr_api.g_varchar2)

Line 6090: OR NVL(per_pyp_shd.g_old_rec.attribute8,hr_api.g_varchar2)

6086: OR NVL(per_pyp_shd.g_old_rec.attribute6,hr_api.g_varchar2)
6087: <>NVL(p_pyp_attribute6,hr_api.g_varchar2)
6088: OR NVL(per_pyp_shd.g_old_rec.attribute7,hr_api.g_varchar2)
6089: <>NVL(p_pyp_attribute7,hr_api.g_varchar2)
6090: OR NVL(per_pyp_shd.g_old_rec.attribute8,hr_api.g_varchar2)
6091: <>NVL(p_pyp_attribute8,hr_api.g_varchar2)
6092: OR NVL(per_pyp_shd.g_old_rec.attribute9,hr_api.g_varchar2)
6093: <>NVL(p_pyp_attribute9,hr_api.g_varchar2)
6094: OR NVL(per_pyp_shd.g_old_rec.attribute10,hr_api.g_varchar2)

Line 6092: OR NVL(per_pyp_shd.g_old_rec.attribute9,hr_api.g_varchar2)

6088: OR NVL(per_pyp_shd.g_old_rec.attribute7,hr_api.g_varchar2)
6089: <>NVL(p_pyp_attribute7,hr_api.g_varchar2)
6090: OR NVL(per_pyp_shd.g_old_rec.attribute8,hr_api.g_varchar2)
6091: <>NVL(p_pyp_attribute8,hr_api.g_varchar2)
6092: OR NVL(per_pyp_shd.g_old_rec.attribute9,hr_api.g_varchar2)
6093: <>NVL(p_pyp_attribute9,hr_api.g_varchar2)
6094: OR NVL(per_pyp_shd.g_old_rec.attribute10,hr_api.g_varchar2)
6095: <>NVL(p_pyp_attribute10,hr_api.g_varchar2)
6096: OR NVL(per_pyp_shd.g_old_rec.attribute11,hr_api.g_varchar2)

Line 6094: OR NVL(per_pyp_shd.g_old_rec.attribute10,hr_api.g_varchar2)

6090: OR NVL(per_pyp_shd.g_old_rec.attribute8,hr_api.g_varchar2)
6091: <>NVL(p_pyp_attribute8,hr_api.g_varchar2)
6092: OR NVL(per_pyp_shd.g_old_rec.attribute9,hr_api.g_varchar2)
6093: <>NVL(p_pyp_attribute9,hr_api.g_varchar2)
6094: OR NVL(per_pyp_shd.g_old_rec.attribute10,hr_api.g_varchar2)
6095: <>NVL(p_pyp_attribute10,hr_api.g_varchar2)
6096: OR NVL(per_pyp_shd.g_old_rec.attribute11,hr_api.g_varchar2)
6097: <>NVL(p_pyp_attribute11,hr_api.g_varchar2)
6098: OR NVL(per_pyp_shd.g_old_rec.attribute12,hr_api.g_varchar2)

Line 6096: OR NVL(per_pyp_shd.g_old_rec.attribute11,hr_api.g_varchar2)

6092: OR NVL(per_pyp_shd.g_old_rec.attribute9,hr_api.g_varchar2)
6093: <>NVL(p_pyp_attribute9,hr_api.g_varchar2)
6094: OR NVL(per_pyp_shd.g_old_rec.attribute10,hr_api.g_varchar2)
6095: <>NVL(p_pyp_attribute10,hr_api.g_varchar2)
6096: OR NVL(per_pyp_shd.g_old_rec.attribute11,hr_api.g_varchar2)
6097: <>NVL(p_pyp_attribute11,hr_api.g_varchar2)
6098: OR NVL(per_pyp_shd.g_old_rec.attribute12,hr_api.g_varchar2)
6099: <>NVL(p_pyp_attribute12,hr_api.g_varchar2)
6100: OR NVL(per_pyp_shd.g_old_rec.attribute13,hr_api.g_varchar2)

Line 6098: OR NVL(per_pyp_shd.g_old_rec.attribute12,hr_api.g_varchar2)

6094: OR NVL(per_pyp_shd.g_old_rec.attribute10,hr_api.g_varchar2)
6095: <>NVL(p_pyp_attribute10,hr_api.g_varchar2)
6096: OR NVL(per_pyp_shd.g_old_rec.attribute11,hr_api.g_varchar2)
6097: <>NVL(p_pyp_attribute11,hr_api.g_varchar2)
6098: OR NVL(per_pyp_shd.g_old_rec.attribute12,hr_api.g_varchar2)
6099: <>NVL(p_pyp_attribute12,hr_api.g_varchar2)
6100: OR NVL(per_pyp_shd.g_old_rec.attribute13,hr_api.g_varchar2)
6101: <>NVL(p_pyp_attribute13,hr_api.g_varchar2)
6102: OR NVL(per_pyp_shd.g_old_rec.attribute14,hr_api.g_varchar2)

Line 6100: OR NVL(per_pyp_shd.g_old_rec.attribute13,hr_api.g_varchar2)

6096: OR NVL(per_pyp_shd.g_old_rec.attribute11,hr_api.g_varchar2)
6097: <>NVL(p_pyp_attribute11,hr_api.g_varchar2)
6098: OR NVL(per_pyp_shd.g_old_rec.attribute12,hr_api.g_varchar2)
6099: <>NVL(p_pyp_attribute12,hr_api.g_varchar2)
6100: OR NVL(per_pyp_shd.g_old_rec.attribute13,hr_api.g_varchar2)
6101: <>NVL(p_pyp_attribute13,hr_api.g_varchar2)
6102: OR NVL(per_pyp_shd.g_old_rec.attribute14,hr_api.g_varchar2)
6103: <>NVL(p_pyp_attribute14,hr_api.g_varchar2)
6104: OR NVL(per_pyp_shd.g_old_rec.attribute15,hr_api.g_varchar2)

Line 6102: OR NVL(per_pyp_shd.g_old_rec.attribute14,hr_api.g_varchar2)

6098: OR NVL(per_pyp_shd.g_old_rec.attribute12,hr_api.g_varchar2)
6099: <>NVL(p_pyp_attribute12,hr_api.g_varchar2)
6100: OR NVL(per_pyp_shd.g_old_rec.attribute13,hr_api.g_varchar2)
6101: <>NVL(p_pyp_attribute13,hr_api.g_varchar2)
6102: OR NVL(per_pyp_shd.g_old_rec.attribute14,hr_api.g_varchar2)
6103: <>NVL(p_pyp_attribute14,hr_api.g_varchar2)
6104: OR NVL(per_pyp_shd.g_old_rec.attribute15,hr_api.g_varchar2)
6105: <>NVL(p_pyp_attribute15,hr_api.g_varchar2)
6106: OR NVL(per_pyp_shd.g_old_rec.attribute16,hr_api.g_varchar2)

Line 6104: OR NVL(per_pyp_shd.g_old_rec.attribute15,hr_api.g_varchar2)

6100: OR NVL(per_pyp_shd.g_old_rec.attribute13,hr_api.g_varchar2)
6101: <>NVL(p_pyp_attribute13,hr_api.g_varchar2)
6102: OR NVL(per_pyp_shd.g_old_rec.attribute14,hr_api.g_varchar2)
6103: <>NVL(p_pyp_attribute14,hr_api.g_varchar2)
6104: OR NVL(per_pyp_shd.g_old_rec.attribute15,hr_api.g_varchar2)
6105: <>NVL(p_pyp_attribute15,hr_api.g_varchar2)
6106: OR NVL(per_pyp_shd.g_old_rec.attribute16,hr_api.g_varchar2)
6107: <>NVL(p_pyp_attribute16,hr_api.g_varchar2)
6108: OR NVL(per_pyp_shd.g_old_rec.attribute17,hr_api.g_varchar2)

Line 6106: OR NVL(per_pyp_shd.g_old_rec.attribute16,hr_api.g_varchar2)

6102: OR NVL(per_pyp_shd.g_old_rec.attribute14,hr_api.g_varchar2)
6103: <>NVL(p_pyp_attribute14,hr_api.g_varchar2)
6104: OR NVL(per_pyp_shd.g_old_rec.attribute15,hr_api.g_varchar2)
6105: <>NVL(p_pyp_attribute15,hr_api.g_varchar2)
6106: OR NVL(per_pyp_shd.g_old_rec.attribute16,hr_api.g_varchar2)
6107: <>NVL(p_pyp_attribute16,hr_api.g_varchar2)
6108: OR NVL(per_pyp_shd.g_old_rec.attribute17,hr_api.g_varchar2)
6109: <>NVL(p_pyp_attribute17,hr_api.g_varchar2)
6110: OR NVL(per_pyp_shd.g_old_rec.attribute18,hr_api.g_varchar2)

Line 6108: OR NVL(per_pyp_shd.g_old_rec.attribute17,hr_api.g_varchar2)

6104: OR NVL(per_pyp_shd.g_old_rec.attribute15,hr_api.g_varchar2)
6105: <>NVL(p_pyp_attribute15,hr_api.g_varchar2)
6106: OR NVL(per_pyp_shd.g_old_rec.attribute16,hr_api.g_varchar2)
6107: <>NVL(p_pyp_attribute16,hr_api.g_varchar2)
6108: OR NVL(per_pyp_shd.g_old_rec.attribute17,hr_api.g_varchar2)
6109: <>NVL(p_pyp_attribute17,hr_api.g_varchar2)
6110: OR NVL(per_pyp_shd.g_old_rec.attribute18,hr_api.g_varchar2)
6111: <>NVL(p_pyp_attribute18,hr_api.g_varchar2)
6112: OR NVL(per_pyp_shd.g_old_rec.attribute19,hr_api.g_varchar2)

Line 6110: OR NVL(per_pyp_shd.g_old_rec.attribute18,hr_api.g_varchar2)

6106: OR NVL(per_pyp_shd.g_old_rec.attribute16,hr_api.g_varchar2)
6107: <>NVL(p_pyp_attribute16,hr_api.g_varchar2)
6108: OR NVL(per_pyp_shd.g_old_rec.attribute17,hr_api.g_varchar2)
6109: <>NVL(p_pyp_attribute17,hr_api.g_varchar2)
6110: OR NVL(per_pyp_shd.g_old_rec.attribute18,hr_api.g_varchar2)
6111: <>NVL(p_pyp_attribute18,hr_api.g_varchar2)
6112: OR NVL(per_pyp_shd.g_old_rec.attribute19,hr_api.g_varchar2)
6113: <>NVL(p_pyp_attribute19,hr_api.g_varchar2)
6114: OR NVL(per_pyp_shd.g_old_rec.attribute20,hr_api.g_varchar2)

Line 6112: OR NVL(per_pyp_shd.g_old_rec.attribute19,hr_api.g_varchar2)

6108: OR NVL(per_pyp_shd.g_old_rec.attribute17,hr_api.g_varchar2)
6109: <>NVL(p_pyp_attribute17,hr_api.g_varchar2)
6110: OR NVL(per_pyp_shd.g_old_rec.attribute18,hr_api.g_varchar2)
6111: <>NVL(p_pyp_attribute18,hr_api.g_varchar2)
6112: OR NVL(per_pyp_shd.g_old_rec.attribute19,hr_api.g_varchar2)
6113: <>NVL(p_pyp_attribute19,hr_api.g_varchar2)
6114: OR NVL(per_pyp_shd.g_old_rec.attribute20,hr_api.g_varchar2)
6115: <>NVL(p_pyp_attribute20,hr_api.g_varchar2)
6116: OR NVL(per_pyp_shd.g_old_rec.approved,hr_api.g_varchar2)

Line 6114: OR NVL(per_pyp_shd.g_old_rec.attribute20,hr_api.g_varchar2)

6110: OR NVL(per_pyp_shd.g_old_rec.attribute18,hr_api.g_varchar2)
6111: <>NVL(p_pyp_attribute18,hr_api.g_varchar2)
6112: OR NVL(per_pyp_shd.g_old_rec.attribute19,hr_api.g_varchar2)
6113: <>NVL(p_pyp_attribute19,hr_api.g_varchar2)
6114: OR NVL(per_pyp_shd.g_old_rec.attribute20,hr_api.g_varchar2)
6115: <>NVL(p_pyp_attribute20,hr_api.g_varchar2)
6116: OR NVL(per_pyp_shd.g_old_rec.approved,hr_api.g_varchar2)
6117: <>NVL(p_approved,hr_api.g_varchar2) )) THEN
6118: --

Line 6116: OR NVL(per_pyp_shd.g_old_rec.approved,hr_api.g_varchar2)

6112: OR NVL(per_pyp_shd.g_old_rec.attribute19,hr_api.g_varchar2)
6113: <>NVL(p_pyp_attribute19,hr_api.g_varchar2)
6114: OR NVL(per_pyp_shd.g_old_rec.attribute20,hr_api.g_varchar2)
6115: <>NVL(p_pyp_attribute20,hr_api.g_varchar2)
6116: OR NVL(per_pyp_shd.g_old_rec.approved,hr_api.g_varchar2)
6117: <>NVL(p_approved,hr_api.g_varchar2) )) THEN
6118: --
6119: --
6120: hr_maintain_proposal_api.cre_or_upd_salary_proposal

Line 7227: per_pyp_shd.lck

7223: --
7224: IF p_pay_proposal_id IS NOT NULL THEN
7225: hr_utility.set_location(l_proc, 100);
7226: --
7227: per_pyp_shd.lck
7228: (p_pay_proposal_id => p_pay_proposal_id
7229: ,p_object_version_number => p_pyp_object_version_number);
7230: END IF;
7231: --