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_PPC_UPD dependencies on PER_PPC_SHD

Line 54: Procedure update_dml(p_rec in out nocopy per_ppc_shd.g_rec_type) is

50: -- Internal Table Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_ppc_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

Line 65: per_ppc_shd.g_api_dml := true; -- Set the api dml status

61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: per_ppc_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the per_pay_proposal_components Row
68: --
69: update per_pay_proposal_components

Line 101: per_ppc_shd.g_api_dml := false; -- Unset the api dml status

97: attribute20 = p_rec.attribute20,
98: object_version_number = p_rec.object_version_number
99: where component_id = p_rec.component_id;
100: --
101: per_ppc_shd.g_api_dml := false; -- Unset the api dml status
102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: --
105: Exception

Line 108: per_ppc_shd.g_api_dml := false; -- Unset the api dml status

104: --
105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: per_ppc_shd.g_api_dml := false; -- Unset the api dml status
109: per_ppc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated

Line 109: per_ppc_shd.constraint_error

105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: per_ppc_shd.g_api_dml := false; -- Unset the api dml status
109: per_ppc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: per_ppc_shd.g_api_dml := false; -- Unset the api dml status

Line 113: per_ppc_shd.g_api_dml := false; -- Unset the api dml status

109: per_ppc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: per_ppc_shd.g_api_dml := false; -- Unset the api dml status
114: per_ppc_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated

Line 114: per_ppc_shd.constraint_error

110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: per_ppc_shd.g_api_dml := false; -- Unset the api dml status
114: per_ppc_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: per_ppc_shd.g_api_dml := false; -- Unset the api dml status

Line 118: per_ppc_shd.g_api_dml := false; -- Unset the api dml status

114: per_ppc_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: per_ppc_shd.g_api_dml := false; -- Unset the api dml status
119: per_ppc_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: per_ppc_shd.g_api_dml := false; -- Unset the api dml status

Line 119: per_ppc_shd.constraint_error

115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: per_ppc_shd.g_api_dml := false; -- Unset the api dml status
119: per_ppc_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: per_ppc_shd.g_api_dml := false; -- Unset the api dml status
123: Raise;

Line 122: per_ppc_shd.g_api_dml := false; -- Unset the api dml status

118: per_ppc_shd.g_api_dml := false; -- Unset the api dml status
119: per_ppc_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: per_ppc_shd.g_api_dml := false; -- Unset the api dml status
123: Raise;
124: End update_dml;
125: --
126: -- ----------------------------------------------------------------------------

Line 158: Procedure pre_update(p_rec in per_ppc_shd.g_rec_type) is

154: -- Internal Table Handler Use Only.
155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure pre_update(p_rec in per_ppc_shd.g_rec_type) is
159: --
160: l_proc varchar2(72) := g_package||'pre_update';
161: --
162: Begin

Line 201: (p_rec in per_ppc_shd.g_rec_type

197: --
198: -- {End Of Comments}
199: -- ----------------------------------------------------------------------------
200: Procedure post_update
201: (p_rec in per_ppc_shd.g_rec_type
202: ,p_validation_strength in varchar2
203: )
204: is
205: --

Line 245: p_pay_proposal_id_o => per_ppc_shd.g_old_rec.pay_proposal_id,

241: p_attribute19 => p_rec.attribute19,
242: p_attribute20 => p_rec.attribute20,
243: p_object_version_number => p_rec.object_version_number,
244: p_validation_strength => p_validation_strength,
245: p_pay_proposal_id_o => per_ppc_shd.g_old_rec.pay_proposal_id,
246: p_business_group_id_o => per_ppc_shd.g_old_rec.business_group_id,
247: p_approved_o => per_ppc_shd.g_old_rec.approved,
248: p_component_reason_o => per_ppc_shd.g_old_rec.component_reason,
249: p_change_amount_n_o => per_ppc_shd.g_old_rec.change_amount_n,

Line 246: p_business_group_id_o => per_ppc_shd.g_old_rec.business_group_id,

242: p_attribute20 => p_rec.attribute20,
243: p_object_version_number => p_rec.object_version_number,
244: p_validation_strength => p_validation_strength,
245: p_pay_proposal_id_o => per_ppc_shd.g_old_rec.pay_proposal_id,
246: p_business_group_id_o => per_ppc_shd.g_old_rec.business_group_id,
247: p_approved_o => per_ppc_shd.g_old_rec.approved,
248: p_component_reason_o => per_ppc_shd.g_old_rec.component_reason,
249: p_change_amount_n_o => per_ppc_shd.g_old_rec.change_amount_n,
250: p_change_percentage_o => per_ppc_shd.g_old_rec.change_percentage,

Line 247: p_approved_o => per_ppc_shd.g_old_rec.approved,

243: p_object_version_number => p_rec.object_version_number,
244: p_validation_strength => p_validation_strength,
245: p_pay_proposal_id_o => per_ppc_shd.g_old_rec.pay_proposal_id,
246: p_business_group_id_o => per_ppc_shd.g_old_rec.business_group_id,
247: p_approved_o => per_ppc_shd.g_old_rec.approved,
248: p_component_reason_o => per_ppc_shd.g_old_rec.component_reason,
249: p_change_amount_n_o => per_ppc_shd.g_old_rec.change_amount_n,
250: p_change_percentage_o => per_ppc_shd.g_old_rec.change_percentage,
251: p_comments_o => per_ppc_shd.g_old_rec.comments,

Line 248: p_component_reason_o => per_ppc_shd.g_old_rec.component_reason,

244: p_validation_strength => p_validation_strength,
245: p_pay_proposal_id_o => per_ppc_shd.g_old_rec.pay_proposal_id,
246: p_business_group_id_o => per_ppc_shd.g_old_rec.business_group_id,
247: p_approved_o => per_ppc_shd.g_old_rec.approved,
248: p_component_reason_o => per_ppc_shd.g_old_rec.component_reason,
249: p_change_amount_n_o => per_ppc_shd.g_old_rec.change_amount_n,
250: p_change_percentage_o => per_ppc_shd.g_old_rec.change_percentage,
251: p_comments_o => per_ppc_shd.g_old_rec.comments,
252: p_attribute_category_o => per_ppc_shd.g_old_rec.attribute_category,

Line 249: p_change_amount_n_o => per_ppc_shd.g_old_rec.change_amount_n,

245: p_pay_proposal_id_o => per_ppc_shd.g_old_rec.pay_proposal_id,
246: p_business_group_id_o => per_ppc_shd.g_old_rec.business_group_id,
247: p_approved_o => per_ppc_shd.g_old_rec.approved,
248: p_component_reason_o => per_ppc_shd.g_old_rec.component_reason,
249: p_change_amount_n_o => per_ppc_shd.g_old_rec.change_amount_n,
250: p_change_percentage_o => per_ppc_shd.g_old_rec.change_percentage,
251: p_comments_o => per_ppc_shd.g_old_rec.comments,
252: p_attribute_category_o => per_ppc_shd.g_old_rec.attribute_category,
253: p_attribute1_o => per_ppc_shd.g_old_rec.attribute1,

Line 250: p_change_percentage_o => per_ppc_shd.g_old_rec.change_percentage,

246: p_business_group_id_o => per_ppc_shd.g_old_rec.business_group_id,
247: p_approved_o => per_ppc_shd.g_old_rec.approved,
248: p_component_reason_o => per_ppc_shd.g_old_rec.component_reason,
249: p_change_amount_n_o => per_ppc_shd.g_old_rec.change_amount_n,
250: p_change_percentage_o => per_ppc_shd.g_old_rec.change_percentage,
251: p_comments_o => per_ppc_shd.g_old_rec.comments,
252: p_attribute_category_o => per_ppc_shd.g_old_rec.attribute_category,
253: p_attribute1_o => per_ppc_shd.g_old_rec.attribute1,
254: p_attribute2_o => per_ppc_shd.g_old_rec.attribute2,

Line 251: p_comments_o => per_ppc_shd.g_old_rec.comments,

247: p_approved_o => per_ppc_shd.g_old_rec.approved,
248: p_component_reason_o => per_ppc_shd.g_old_rec.component_reason,
249: p_change_amount_n_o => per_ppc_shd.g_old_rec.change_amount_n,
250: p_change_percentage_o => per_ppc_shd.g_old_rec.change_percentage,
251: p_comments_o => per_ppc_shd.g_old_rec.comments,
252: p_attribute_category_o => per_ppc_shd.g_old_rec.attribute_category,
253: p_attribute1_o => per_ppc_shd.g_old_rec.attribute1,
254: p_attribute2_o => per_ppc_shd.g_old_rec.attribute2,
255: p_attribute3_o => per_ppc_shd.g_old_rec.attribute3,

Line 252: p_attribute_category_o => per_ppc_shd.g_old_rec.attribute_category,

248: p_component_reason_o => per_ppc_shd.g_old_rec.component_reason,
249: p_change_amount_n_o => per_ppc_shd.g_old_rec.change_amount_n,
250: p_change_percentage_o => per_ppc_shd.g_old_rec.change_percentage,
251: p_comments_o => per_ppc_shd.g_old_rec.comments,
252: p_attribute_category_o => per_ppc_shd.g_old_rec.attribute_category,
253: p_attribute1_o => per_ppc_shd.g_old_rec.attribute1,
254: p_attribute2_o => per_ppc_shd.g_old_rec.attribute2,
255: p_attribute3_o => per_ppc_shd.g_old_rec.attribute3,
256: p_attribute4_o => per_ppc_shd.g_old_rec.attribute4,

Line 253: p_attribute1_o => per_ppc_shd.g_old_rec.attribute1,

249: p_change_amount_n_o => per_ppc_shd.g_old_rec.change_amount_n,
250: p_change_percentage_o => per_ppc_shd.g_old_rec.change_percentage,
251: p_comments_o => per_ppc_shd.g_old_rec.comments,
252: p_attribute_category_o => per_ppc_shd.g_old_rec.attribute_category,
253: p_attribute1_o => per_ppc_shd.g_old_rec.attribute1,
254: p_attribute2_o => per_ppc_shd.g_old_rec.attribute2,
255: p_attribute3_o => per_ppc_shd.g_old_rec.attribute3,
256: p_attribute4_o => per_ppc_shd.g_old_rec.attribute4,
257: p_attribute5_o => per_ppc_shd.g_old_rec.attribute5,

Line 254: p_attribute2_o => per_ppc_shd.g_old_rec.attribute2,

250: p_change_percentage_o => per_ppc_shd.g_old_rec.change_percentage,
251: p_comments_o => per_ppc_shd.g_old_rec.comments,
252: p_attribute_category_o => per_ppc_shd.g_old_rec.attribute_category,
253: p_attribute1_o => per_ppc_shd.g_old_rec.attribute1,
254: p_attribute2_o => per_ppc_shd.g_old_rec.attribute2,
255: p_attribute3_o => per_ppc_shd.g_old_rec.attribute3,
256: p_attribute4_o => per_ppc_shd.g_old_rec.attribute4,
257: p_attribute5_o => per_ppc_shd.g_old_rec.attribute5,
258: p_attribute6_o => per_ppc_shd.g_old_rec.attribute6,

Line 255: p_attribute3_o => per_ppc_shd.g_old_rec.attribute3,

251: p_comments_o => per_ppc_shd.g_old_rec.comments,
252: p_attribute_category_o => per_ppc_shd.g_old_rec.attribute_category,
253: p_attribute1_o => per_ppc_shd.g_old_rec.attribute1,
254: p_attribute2_o => per_ppc_shd.g_old_rec.attribute2,
255: p_attribute3_o => per_ppc_shd.g_old_rec.attribute3,
256: p_attribute4_o => per_ppc_shd.g_old_rec.attribute4,
257: p_attribute5_o => per_ppc_shd.g_old_rec.attribute5,
258: p_attribute6_o => per_ppc_shd.g_old_rec.attribute6,
259: p_attribute7_o => per_ppc_shd.g_old_rec.attribute7,

Line 256: p_attribute4_o => per_ppc_shd.g_old_rec.attribute4,

252: p_attribute_category_o => per_ppc_shd.g_old_rec.attribute_category,
253: p_attribute1_o => per_ppc_shd.g_old_rec.attribute1,
254: p_attribute2_o => per_ppc_shd.g_old_rec.attribute2,
255: p_attribute3_o => per_ppc_shd.g_old_rec.attribute3,
256: p_attribute4_o => per_ppc_shd.g_old_rec.attribute4,
257: p_attribute5_o => per_ppc_shd.g_old_rec.attribute5,
258: p_attribute6_o => per_ppc_shd.g_old_rec.attribute6,
259: p_attribute7_o => per_ppc_shd.g_old_rec.attribute7,
260: p_attribute8_o => per_ppc_shd.g_old_rec.attribute8,

Line 257: p_attribute5_o => per_ppc_shd.g_old_rec.attribute5,

253: p_attribute1_o => per_ppc_shd.g_old_rec.attribute1,
254: p_attribute2_o => per_ppc_shd.g_old_rec.attribute2,
255: p_attribute3_o => per_ppc_shd.g_old_rec.attribute3,
256: p_attribute4_o => per_ppc_shd.g_old_rec.attribute4,
257: p_attribute5_o => per_ppc_shd.g_old_rec.attribute5,
258: p_attribute6_o => per_ppc_shd.g_old_rec.attribute6,
259: p_attribute7_o => per_ppc_shd.g_old_rec.attribute7,
260: p_attribute8_o => per_ppc_shd.g_old_rec.attribute8,
261: p_attribute9_o => per_ppc_shd.g_old_rec.attribute9,

Line 258: p_attribute6_o => per_ppc_shd.g_old_rec.attribute6,

254: p_attribute2_o => per_ppc_shd.g_old_rec.attribute2,
255: p_attribute3_o => per_ppc_shd.g_old_rec.attribute3,
256: p_attribute4_o => per_ppc_shd.g_old_rec.attribute4,
257: p_attribute5_o => per_ppc_shd.g_old_rec.attribute5,
258: p_attribute6_o => per_ppc_shd.g_old_rec.attribute6,
259: p_attribute7_o => per_ppc_shd.g_old_rec.attribute7,
260: p_attribute8_o => per_ppc_shd.g_old_rec.attribute8,
261: p_attribute9_o => per_ppc_shd.g_old_rec.attribute9,
262: p_attribute10_o => per_ppc_shd.g_old_rec.attribute10,

Line 259: p_attribute7_o => per_ppc_shd.g_old_rec.attribute7,

255: p_attribute3_o => per_ppc_shd.g_old_rec.attribute3,
256: p_attribute4_o => per_ppc_shd.g_old_rec.attribute4,
257: p_attribute5_o => per_ppc_shd.g_old_rec.attribute5,
258: p_attribute6_o => per_ppc_shd.g_old_rec.attribute6,
259: p_attribute7_o => per_ppc_shd.g_old_rec.attribute7,
260: p_attribute8_o => per_ppc_shd.g_old_rec.attribute8,
261: p_attribute9_o => per_ppc_shd.g_old_rec.attribute9,
262: p_attribute10_o => per_ppc_shd.g_old_rec.attribute10,
263: p_attribute11_o => per_ppc_shd.g_old_rec.attribute11,

Line 260: p_attribute8_o => per_ppc_shd.g_old_rec.attribute8,

256: p_attribute4_o => per_ppc_shd.g_old_rec.attribute4,
257: p_attribute5_o => per_ppc_shd.g_old_rec.attribute5,
258: p_attribute6_o => per_ppc_shd.g_old_rec.attribute6,
259: p_attribute7_o => per_ppc_shd.g_old_rec.attribute7,
260: p_attribute8_o => per_ppc_shd.g_old_rec.attribute8,
261: p_attribute9_o => per_ppc_shd.g_old_rec.attribute9,
262: p_attribute10_o => per_ppc_shd.g_old_rec.attribute10,
263: p_attribute11_o => per_ppc_shd.g_old_rec.attribute11,
264: p_attribute12_o => per_ppc_shd.g_old_rec.attribute12,

Line 261: p_attribute9_o => per_ppc_shd.g_old_rec.attribute9,

257: p_attribute5_o => per_ppc_shd.g_old_rec.attribute5,
258: p_attribute6_o => per_ppc_shd.g_old_rec.attribute6,
259: p_attribute7_o => per_ppc_shd.g_old_rec.attribute7,
260: p_attribute8_o => per_ppc_shd.g_old_rec.attribute8,
261: p_attribute9_o => per_ppc_shd.g_old_rec.attribute9,
262: p_attribute10_o => per_ppc_shd.g_old_rec.attribute10,
263: p_attribute11_o => per_ppc_shd.g_old_rec.attribute11,
264: p_attribute12_o => per_ppc_shd.g_old_rec.attribute12,
265: p_attribute13_o => per_ppc_shd.g_old_rec.attribute13,

Line 262: p_attribute10_o => per_ppc_shd.g_old_rec.attribute10,

258: p_attribute6_o => per_ppc_shd.g_old_rec.attribute6,
259: p_attribute7_o => per_ppc_shd.g_old_rec.attribute7,
260: p_attribute8_o => per_ppc_shd.g_old_rec.attribute8,
261: p_attribute9_o => per_ppc_shd.g_old_rec.attribute9,
262: p_attribute10_o => per_ppc_shd.g_old_rec.attribute10,
263: p_attribute11_o => per_ppc_shd.g_old_rec.attribute11,
264: p_attribute12_o => per_ppc_shd.g_old_rec.attribute12,
265: p_attribute13_o => per_ppc_shd.g_old_rec.attribute13,
266: p_attribute14_o => per_ppc_shd.g_old_rec.attribute14,

Line 263: p_attribute11_o => per_ppc_shd.g_old_rec.attribute11,

259: p_attribute7_o => per_ppc_shd.g_old_rec.attribute7,
260: p_attribute8_o => per_ppc_shd.g_old_rec.attribute8,
261: p_attribute9_o => per_ppc_shd.g_old_rec.attribute9,
262: p_attribute10_o => per_ppc_shd.g_old_rec.attribute10,
263: p_attribute11_o => per_ppc_shd.g_old_rec.attribute11,
264: p_attribute12_o => per_ppc_shd.g_old_rec.attribute12,
265: p_attribute13_o => per_ppc_shd.g_old_rec.attribute13,
266: p_attribute14_o => per_ppc_shd.g_old_rec.attribute14,
267: p_attribute15_o => per_ppc_shd.g_old_rec.attribute15,

Line 264: p_attribute12_o => per_ppc_shd.g_old_rec.attribute12,

260: p_attribute8_o => per_ppc_shd.g_old_rec.attribute8,
261: p_attribute9_o => per_ppc_shd.g_old_rec.attribute9,
262: p_attribute10_o => per_ppc_shd.g_old_rec.attribute10,
263: p_attribute11_o => per_ppc_shd.g_old_rec.attribute11,
264: p_attribute12_o => per_ppc_shd.g_old_rec.attribute12,
265: p_attribute13_o => per_ppc_shd.g_old_rec.attribute13,
266: p_attribute14_o => per_ppc_shd.g_old_rec.attribute14,
267: p_attribute15_o => per_ppc_shd.g_old_rec.attribute15,
268: p_attribute16_o => per_ppc_shd.g_old_rec.attribute16,

Line 265: p_attribute13_o => per_ppc_shd.g_old_rec.attribute13,

261: p_attribute9_o => per_ppc_shd.g_old_rec.attribute9,
262: p_attribute10_o => per_ppc_shd.g_old_rec.attribute10,
263: p_attribute11_o => per_ppc_shd.g_old_rec.attribute11,
264: p_attribute12_o => per_ppc_shd.g_old_rec.attribute12,
265: p_attribute13_o => per_ppc_shd.g_old_rec.attribute13,
266: p_attribute14_o => per_ppc_shd.g_old_rec.attribute14,
267: p_attribute15_o => per_ppc_shd.g_old_rec.attribute15,
268: p_attribute16_o => per_ppc_shd.g_old_rec.attribute16,
269: p_attribute17_o => per_ppc_shd.g_old_rec.attribute17,

Line 266: p_attribute14_o => per_ppc_shd.g_old_rec.attribute14,

262: p_attribute10_o => per_ppc_shd.g_old_rec.attribute10,
263: p_attribute11_o => per_ppc_shd.g_old_rec.attribute11,
264: p_attribute12_o => per_ppc_shd.g_old_rec.attribute12,
265: p_attribute13_o => per_ppc_shd.g_old_rec.attribute13,
266: p_attribute14_o => per_ppc_shd.g_old_rec.attribute14,
267: p_attribute15_o => per_ppc_shd.g_old_rec.attribute15,
268: p_attribute16_o => per_ppc_shd.g_old_rec.attribute16,
269: p_attribute17_o => per_ppc_shd.g_old_rec.attribute17,
270: p_attribute18_o => per_ppc_shd.g_old_rec.attribute18,

Line 267: p_attribute15_o => per_ppc_shd.g_old_rec.attribute15,

263: p_attribute11_o => per_ppc_shd.g_old_rec.attribute11,
264: p_attribute12_o => per_ppc_shd.g_old_rec.attribute12,
265: p_attribute13_o => per_ppc_shd.g_old_rec.attribute13,
266: p_attribute14_o => per_ppc_shd.g_old_rec.attribute14,
267: p_attribute15_o => per_ppc_shd.g_old_rec.attribute15,
268: p_attribute16_o => per_ppc_shd.g_old_rec.attribute16,
269: p_attribute17_o => per_ppc_shd.g_old_rec.attribute17,
270: p_attribute18_o => per_ppc_shd.g_old_rec.attribute18,
271: p_attribute19_o => per_ppc_shd.g_old_rec.attribute19,

Line 268: p_attribute16_o => per_ppc_shd.g_old_rec.attribute16,

264: p_attribute12_o => per_ppc_shd.g_old_rec.attribute12,
265: p_attribute13_o => per_ppc_shd.g_old_rec.attribute13,
266: p_attribute14_o => per_ppc_shd.g_old_rec.attribute14,
267: p_attribute15_o => per_ppc_shd.g_old_rec.attribute15,
268: p_attribute16_o => per_ppc_shd.g_old_rec.attribute16,
269: p_attribute17_o => per_ppc_shd.g_old_rec.attribute17,
270: p_attribute18_o => per_ppc_shd.g_old_rec.attribute18,
271: p_attribute19_o => per_ppc_shd.g_old_rec.attribute19,
272: p_attribute20_o => per_ppc_shd.g_old_rec.attribute20,

Line 269: p_attribute17_o => per_ppc_shd.g_old_rec.attribute17,

265: p_attribute13_o => per_ppc_shd.g_old_rec.attribute13,
266: p_attribute14_o => per_ppc_shd.g_old_rec.attribute14,
267: p_attribute15_o => per_ppc_shd.g_old_rec.attribute15,
268: p_attribute16_o => per_ppc_shd.g_old_rec.attribute16,
269: p_attribute17_o => per_ppc_shd.g_old_rec.attribute17,
270: p_attribute18_o => per_ppc_shd.g_old_rec.attribute18,
271: p_attribute19_o => per_ppc_shd.g_old_rec.attribute19,
272: p_attribute20_o => per_ppc_shd.g_old_rec.attribute20,
273: p_object_version_number_o => per_ppc_shd.g_old_rec.object_version_number

Line 270: p_attribute18_o => per_ppc_shd.g_old_rec.attribute18,

266: p_attribute14_o => per_ppc_shd.g_old_rec.attribute14,
267: p_attribute15_o => per_ppc_shd.g_old_rec.attribute15,
268: p_attribute16_o => per_ppc_shd.g_old_rec.attribute16,
269: p_attribute17_o => per_ppc_shd.g_old_rec.attribute17,
270: p_attribute18_o => per_ppc_shd.g_old_rec.attribute18,
271: p_attribute19_o => per_ppc_shd.g_old_rec.attribute19,
272: p_attribute20_o => per_ppc_shd.g_old_rec.attribute20,
273: p_object_version_number_o => per_ppc_shd.g_old_rec.object_version_number
274: );

Line 271: p_attribute19_o => per_ppc_shd.g_old_rec.attribute19,

267: p_attribute15_o => per_ppc_shd.g_old_rec.attribute15,
268: p_attribute16_o => per_ppc_shd.g_old_rec.attribute16,
269: p_attribute17_o => per_ppc_shd.g_old_rec.attribute17,
270: p_attribute18_o => per_ppc_shd.g_old_rec.attribute18,
271: p_attribute19_o => per_ppc_shd.g_old_rec.attribute19,
272: p_attribute20_o => per_ppc_shd.g_old_rec.attribute20,
273: p_object_version_number_o => per_ppc_shd.g_old_rec.object_version_number
274: );
275: exception

Line 272: p_attribute20_o => per_ppc_shd.g_old_rec.attribute20,

268: p_attribute16_o => per_ppc_shd.g_old_rec.attribute16,
269: p_attribute17_o => per_ppc_shd.g_old_rec.attribute17,
270: p_attribute18_o => per_ppc_shd.g_old_rec.attribute18,
271: p_attribute19_o => per_ppc_shd.g_old_rec.attribute19,
272: p_attribute20_o => per_ppc_shd.g_old_rec.attribute20,
273: p_object_version_number_o => per_ppc_shd.g_old_rec.object_version_number
274: );
275: exception
276: when hr_api.cannot_find_prog_unit then

Line 273: p_object_version_number_o => per_ppc_shd.g_old_rec.object_version_number

269: p_attribute17_o => per_ppc_shd.g_old_rec.attribute17,
270: p_attribute18_o => per_ppc_shd.g_old_rec.attribute18,
271: p_attribute19_o => per_ppc_shd.g_old_rec.attribute19,
272: p_attribute20_o => per_ppc_shd.g_old_rec.attribute20,
273: p_object_version_number_o => per_ppc_shd.g_old_rec.object_version_number
274: );
275: exception
276: when hr_api.cannot_find_prog_unit then
277: hr_api.cannot_find_prog_unit_error

Line 331: Procedure convert_defs(p_rec in out nocopy per_ppc_shd.g_rec_type) is

327: -- Internal Table Handler Use Only.
328: --
329: -- {End Of Comments}
330: -- ----------------------------------------------------------------------------
331: Procedure convert_defs(p_rec in out nocopy per_ppc_shd.g_rec_type) is
332: --
333: l_proc varchar2(72) := g_package||'convert_defs';
334: --
335: Begin

Line 346: per_ppc_shd.g_old_rec.pay_proposal_id;

342: -- is being used then we must set to the 'current' argument value.
343: --
344: If (p_rec.pay_proposal_id = hr_api.g_number) then
345: p_rec.pay_proposal_id :=
346: per_ppc_shd.g_old_rec.pay_proposal_id;
347: End If;
348: If (p_rec.business_group_id = hr_api.g_number) then
349: p_rec.business_group_id :=
350: per_ppc_shd.g_old_rec.business_group_id;

Line 350: per_ppc_shd.g_old_rec.business_group_id;

346: per_ppc_shd.g_old_rec.pay_proposal_id;
347: End If;
348: If (p_rec.business_group_id = hr_api.g_number) then
349: p_rec.business_group_id :=
350: per_ppc_shd.g_old_rec.business_group_id;
351: End If;
352: If (p_rec.approved = hr_api.g_varchar2) then
353: p_rec.approved :=
354: per_ppc_shd.g_old_rec.approved;

Line 354: per_ppc_shd.g_old_rec.approved;

350: per_ppc_shd.g_old_rec.business_group_id;
351: End If;
352: If (p_rec.approved = hr_api.g_varchar2) then
353: p_rec.approved :=
354: per_ppc_shd.g_old_rec.approved;
355: End If;
356: If (p_rec.component_reason = hr_api.g_varchar2) then
357: p_rec.component_reason :=
358: per_ppc_shd.g_old_rec.component_reason;

Line 358: per_ppc_shd.g_old_rec.component_reason;

354: per_ppc_shd.g_old_rec.approved;
355: End If;
356: If (p_rec.component_reason = hr_api.g_varchar2) then
357: p_rec.component_reason :=
358: per_ppc_shd.g_old_rec.component_reason;
359: End If;
360: If (p_rec.change_amount_n = hr_api.g_number) then
361: p_rec.change_amount_n :=
362: per_ppc_shd.g_old_rec.change_amount_n;

Line 362: per_ppc_shd.g_old_rec.change_amount_n;

358: per_ppc_shd.g_old_rec.component_reason;
359: End If;
360: If (p_rec.change_amount_n = hr_api.g_number) then
361: p_rec.change_amount_n :=
362: per_ppc_shd.g_old_rec.change_amount_n;
363: End If;
364: If (p_rec.change_percentage = hr_api.g_number) then
365: p_rec.change_percentage :=
366: per_ppc_shd.g_old_rec.change_percentage;

Line 366: per_ppc_shd.g_old_rec.change_percentage;

362: per_ppc_shd.g_old_rec.change_amount_n;
363: End If;
364: If (p_rec.change_percentage = hr_api.g_number) then
365: p_rec.change_percentage :=
366: per_ppc_shd.g_old_rec.change_percentage;
367: End If;
368: If (p_rec.comments = hr_api.g_varchar2) then
369: p_rec.comments :=
370: per_ppc_shd.g_old_rec.comments;

Line 370: per_ppc_shd.g_old_rec.comments;

366: per_ppc_shd.g_old_rec.change_percentage;
367: End If;
368: If (p_rec.comments = hr_api.g_varchar2) then
369: p_rec.comments :=
370: per_ppc_shd.g_old_rec.comments;
371: End If;
372: If (p_rec.attribute_category = hr_api.g_varchar2) then
373: p_rec.attribute_category :=
374: per_ppc_shd.g_old_rec.attribute_category;

Line 374: per_ppc_shd.g_old_rec.attribute_category;

370: per_ppc_shd.g_old_rec.comments;
371: End If;
372: If (p_rec.attribute_category = hr_api.g_varchar2) then
373: p_rec.attribute_category :=
374: per_ppc_shd.g_old_rec.attribute_category;
375: End If;
376: If (p_rec.attribute1 = hr_api.g_varchar2) then
377: p_rec.attribute1 :=
378: per_ppc_shd.g_old_rec.attribute1;

Line 378: per_ppc_shd.g_old_rec.attribute1;

374: per_ppc_shd.g_old_rec.attribute_category;
375: End If;
376: If (p_rec.attribute1 = hr_api.g_varchar2) then
377: p_rec.attribute1 :=
378: per_ppc_shd.g_old_rec.attribute1;
379: End If;
380: If (p_rec.attribute2 = hr_api.g_varchar2) then
381: p_rec.attribute2 :=
382: per_ppc_shd.g_old_rec.attribute2;

Line 382: per_ppc_shd.g_old_rec.attribute2;

378: per_ppc_shd.g_old_rec.attribute1;
379: End If;
380: If (p_rec.attribute2 = hr_api.g_varchar2) then
381: p_rec.attribute2 :=
382: per_ppc_shd.g_old_rec.attribute2;
383: End If;
384: If (p_rec.attribute3 = hr_api.g_varchar2) then
385: p_rec.attribute3 :=
386: per_ppc_shd.g_old_rec.attribute3;

Line 386: per_ppc_shd.g_old_rec.attribute3;

382: per_ppc_shd.g_old_rec.attribute2;
383: End If;
384: If (p_rec.attribute3 = hr_api.g_varchar2) then
385: p_rec.attribute3 :=
386: per_ppc_shd.g_old_rec.attribute3;
387: End If;
388: If (p_rec.attribute4 = hr_api.g_varchar2) then
389: p_rec.attribute4 :=
390: per_ppc_shd.g_old_rec.attribute4;

Line 390: per_ppc_shd.g_old_rec.attribute4;

386: per_ppc_shd.g_old_rec.attribute3;
387: End If;
388: If (p_rec.attribute4 = hr_api.g_varchar2) then
389: p_rec.attribute4 :=
390: per_ppc_shd.g_old_rec.attribute4;
391: End If;
392: If (p_rec.attribute5 = hr_api.g_varchar2) then
393: p_rec.attribute5 :=
394: per_ppc_shd.g_old_rec.attribute5;

Line 394: per_ppc_shd.g_old_rec.attribute5;

390: per_ppc_shd.g_old_rec.attribute4;
391: End If;
392: If (p_rec.attribute5 = hr_api.g_varchar2) then
393: p_rec.attribute5 :=
394: per_ppc_shd.g_old_rec.attribute5;
395: End If;
396: If (p_rec.attribute6 = hr_api.g_varchar2) then
397: p_rec.attribute6 :=
398: per_ppc_shd.g_old_rec.attribute6;

Line 398: per_ppc_shd.g_old_rec.attribute6;

394: per_ppc_shd.g_old_rec.attribute5;
395: End If;
396: If (p_rec.attribute6 = hr_api.g_varchar2) then
397: p_rec.attribute6 :=
398: per_ppc_shd.g_old_rec.attribute6;
399: End If;
400: If (p_rec.attribute7 = hr_api.g_varchar2) then
401: p_rec.attribute7 :=
402: per_ppc_shd.g_old_rec.attribute7;

Line 402: per_ppc_shd.g_old_rec.attribute7;

398: per_ppc_shd.g_old_rec.attribute6;
399: End If;
400: If (p_rec.attribute7 = hr_api.g_varchar2) then
401: p_rec.attribute7 :=
402: per_ppc_shd.g_old_rec.attribute7;
403: End If;
404: If (p_rec.attribute8 = hr_api.g_varchar2) then
405: p_rec.attribute8 :=
406: per_ppc_shd.g_old_rec.attribute8;

Line 406: per_ppc_shd.g_old_rec.attribute8;

402: per_ppc_shd.g_old_rec.attribute7;
403: End If;
404: If (p_rec.attribute8 = hr_api.g_varchar2) then
405: p_rec.attribute8 :=
406: per_ppc_shd.g_old_rec.attribute8;
407: End If;
408: If (p_rec.attribute9 = hr_api.g_varchar2) then
409: p_rec.attribute9 :=
410: per_ppc_shd.g_old_rec.attribute9;

Line 410: per_ppc_shd.g_old_rec.attribute9;

406: per_ppc_shd.g_old_rec.attribute8;
407: End If;
408: If (p_rec.attribute9 = hr_api.g_varchar2) then
409: p_rec.attribute9 :=
410: per_ppc_shd.g_old_rec.attribute9;
411: End If;
412: If (p_rec.attribute10 = hr_api.g_varchar2) then
413: p_rec.attribute10 :=
414: per_ppc_shd.g_old_rec.attribute10;

Line 414: per_ppc_shd.g_old_rec.attribute10;

410: per_ppc_shd.g_old_rec.attribute9;
411: End If;
412: If (p_rec.attribute10 = hr_api.g_varchar2) then
413: p_rec.attribute10 :=
414: per_ppc_shd.g_old_rec.attribute10;
415: End If;
416: If (p_rec.attribute11 = hr_api.g_varchar2) then
417: p_rec.attribute11 :=
418: per_ppc_shd.g_old_rec.attribute11;

Line 418: per_ppc_shd.g_old_rec.attribute11;

414: per_ppc_shd.g_old_rec.attribute10;
415: End If;
416: If (p_rec.attribute11 = hr_api.g_varchar2) then
417: p_rec.attribute11 :=
418: per_ppc_shd.g_old_rec.attribute11;
419: End If;
420: If (p_rec.attribute12 = hr_api.g_varchar2) then
421: p_rec.attribute12 :=
422: per_ppc_shd.g_old_rec.attribute12;

Line 422: per_ppc_shd.g_old_rec.attribute12;

418: per_ppc_shd.g_old_rec.attribute11;
419: End If;
420: If (p_rec.attribute12 = hr_api.g_varchar2) then
421: p_rec.attribute12 :=
422: per_ppc_shd.g_old_rec.attribute12;
423: End If;
424: If (p_rec.attribute13 = hr_api.g_varchar2) then
425: p_rec.attribute13 :=
426: per_ppc_shd.g_old_rec.attribute13;

Line 426: per_ppc_shd.g_old_rec.attribute13;

422: per_ppc_shd.g_old_rec.attribute12;
423: End If;
424: If (p_rec.attribute13 = hr_api.g_varchar2) then
425: p_rec.attribute13 :=
426: per_ppc_shd.g_old_rec.attribute13;
427: End If;
428: If (p_rec.attribute14 = hr_api.g_varchar2) then
429: p_rec.attribute14 :=
430: per_ppc_shd.g_old_rec.attribute14;

Line 430: per_ppc_shd.g_old_rec.attribute14;

426: per_ppc_shd.g_old_rec.attribute13;
427: End If;
428: If (p_rec.attribute14 = hr_api.g_varchar2) then
429: p_rec.attribute14 :=
430: per_ppc_shd.g_old_rec.attribute14;
431: End If;
432: If (p_rec.attribute15 = hr_api.g_varchar2) then
433: p_rec.attribute15 :=
434: per_ppc_shd.g_old_rec.attribute15;

Line 434: per_ppc_shd.g_old_rec.attribute15;

430: per_ppc_shd.g_old_rec.attribute14;
431: End If;
432: If (p_rec.attribute15 = hr_api.g_varchar2) then
433: p_rec.attribute15 :=
434: per_ppc_shd.g_old_rec.attribute15;
435: End If;
436: If (p_rec.attribute16 = hr_api.g_varchar2) then
437: p_rec.attribute16 :=
438: per_ppc_shd.g_old_rec.attribute16;

Line 438: per_ppc_shd.g_old_rec.attribute16;

434: per_ppc_shd.g_old_rec.attribute15;
435: End If;
436: If (p_rec.attribute16 = hr_api.g_varchar2) then
437: p_rec.attribute16 :=
438: per_ppc_shd.g_old_rec.attribute16;
439: End If;
440: If (p_rec.attribute17 = hr_api.g_varchar2) then
441: p_rec.attribute17 :=
442: per_ppc_shd.g_old_rec.attribute17;

Line 442: per_ppc_shd.g_old_rec.attribute17;

438: per_ppc_shd.g_old_rec.attribute16;
439: End If;
440: If (p_rec.attribute17 = hr_api.g_varchar2) then
441: p_rec.attribute17 :=
442: per_ppc_shd.g_old_rec.attribute17;
443: End If;
444: If (p_rec.attribute18 = hr_api.g_varchar2) then
445: p_rec.attribute18 :=
446: per_ppc_shd.g_old_rec.attribute18;

Line 446: per_ppc_shd.g_old_rec.attribute18;

442: per_ppc_shd.g_old_rec.attribute17;
443: End If;
444: If (p_rec.attribute18 = hr_api.g_varchar2) then
445: p_rec.attribute18 :=
446: per_ppc_shd.g_old_rec.attribute18;
447: End If;
448: If (p_rec.attribute19 = hr_api.g_varchar2) then
449: p_rec.attribute19 :=
450: per_ppc_shd.g_old_rec.attribute19;

Line 450: per_ppc_shd.g_old_rec.attribute19;

446: per_ppc_shd.g_old_rec.attribute18;
447: End If;
448: If (p_rec.attribute19 = hr_api.g_varchar2) then
449: p_rec.attribute19 :=
450: per_ppc_shd.g_old_rec.attribute19;
451: End If;
452: If (p_rec.attribute20 = hr_api.g_varchar2) then
453: p_rec.attribute20 :=
454: per_ppc_shd.g_old_rec.attribute20;

Line 454: per_ppc_shd.g_old_rec.attribute20;

450: per_ppc_shd.g_old_rec.attribute19;
451: End If;
452: If (p_rec.attribute20 = hr_api.g_varchar2) then
453: p_rec.attribute20 :=
454: per_ppc_shd.g_old_rec.attribute20;
455: End If;
456:
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 467: p_rec in out nocopy per_ppc_shd.g_rec_type,

463: -- |---------------------------------< upd >----------------------------------|
464: -- ----------------------------------------------------------------------------
465: Procedure upd
466: (
467: p_rec in out nocopy per_ppc_shd.g_rec_type,
468: p_validation_strength in varchar2 default 'STRONG',
469: p_validate in boolean default false
470: ) is
471: --

Line 488: per_ppc_shd.lck

484: End If;
485: --
486: -- We must lock the row which we need to update.
487: --
488: per_ppc_shd.lck
489: (
490: p_rec.component_id,
491: p_rec.object_version_number
492: );

Line 568: l_rec per_ppc_shd.g_rec_type;

564: p_validation_strength in varchar2 default 'STRONG',
565: p_validate in boolean default false
566: ) is
567: --
568: l_rec per_ppc_shd.g_rec_type;
569: l_proc varchar2(72) := g_package||'upd';
570: --
571: Begin
572: hr_utility.set_location('Entering:'||l_proc, 5);

Line 578: per_ppc_shd.convert_args

574: -- Call conversion function to turn arguments into the
575: -- l_rec structure.
576: --
577: l_rec :=
578: per_ppc_shd.convert_args
579: (
580: p_component_id,
581: hr_api.g_number,
582: hr_api.g_number,