50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy pay_pma_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: pay_pma_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the pay_ca_pmed_accounts Row
68: --
69: update pay_ca_pmed_accounts
107: attribute30 = p_rec.attribute30,
108: object_version_number = p_rec.object_version_number
109: where source_id = p_rec.source_id;
110: --
111: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
112: --
113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: --
115: Exception
114: --
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
119: pay_pma_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
119: pay_pma_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
119: pay_pma_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
124: pay_pma_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
124: pay_pma_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
124: pay_pma_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
129: pay_pma_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
129: pay_pma_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
133: Raise;
128: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
129: pay_pma_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
133: Raise;
134: End update_dml;
135: --
136: -- ----------------------------------------------------------------------------
164: -- Internal Row Handler Use Only.
165: --
166: -- {End Of Comments}
167: -- ----------------------------------------------------------------------------
168: Procedure pre_update(p_rec in pay_pma_shd.g_rec_type) is
169: --
170: l_proc varchar2(72) := g_package||'pre_update';
171: --
172: Begin
206: -- Internal Row Handler Use Only.
207: --
208: -- {End Of Comments}
209: -- ----------------------------------------------------------------------------
210: Procedure post_update(p_rec in pay_pma_shd.g_rec_type) is
211: --
212: l_proc varchar2(72) := g_package||'post_update';
213: --
214: Begin
258: ,p_attribute28 =>p_rec.attribute28
259: ,p_attribute29 =>p_rec.attribute29
260: ,p_attribute30 =>p_rec.attribute30
261: ,p_object_version_number =>p_rec.object_version_number
262: ,p_organization_id_o =>pay_pma_shd.g_old_rec.organization_id
263: ,p_account_number_o =>pay_pma_shd.g_old_rec.account_number
264: ,p_enabled_o =>pay_pma_shd.g_old_rec.enabled
265: ,p_description_o =>pay_pma_shd.g_old_rec.description
266: ,p_business_group_id_o =>pay_pma_shd.g_old_rec.business_group_id
259: ,p_attribute29 =>p_rec.attribute29
260: ,p_attribute30 =>p_rec.attribute30
261: ,p_object_version_number =>p_rec.object_version_number
262: ,p_organization_id_o =>pay_pma_shd.g_old_rec.organization_id
263: ,p_account_number_o =>pay_pma_shd.g_old_rec.account_number
264: ,p_enabled_o =>pay_pma_shd.g_old_rec.enabled
265: ,p_description_o =>pay_pma_shd.g_old_rec.description
266: ,p_business_group_id_o =>pay_pma_shd.g_old_rec.business_group_id
267: ,p_attribute_category_o =>pay_pma_shd.g_old_rec.attribute_category
260: ,p_attribute30 =>p_rec.attribute30
261: ,p_object_version_number =>p_rec.object_version_number
262: ,p_organization_id_o =>pay_pma_shd.g_old_rec.organization_id
263: ,p_account_number_o =>pay_pma_shd.g_old_rec.account_number
264: ,p_enabled_o =>pay_pma_shd.g_old_rec.enabled
265: ,p_description_o =>pay_pma_shd.g_old_rec.description
266: ,p_business_group_id_o =>pay_pma_shd.g_old_rec.business_group_id
267: ,p_attribute_category_o =>pay_pma_shd.g_old_rec.attribute_category
268: ,p_attribute1_o =>pay_pma_shd.g_old_rec.attribute1
261: ,p_object_version_number =>p_rec.object_version_number
262: ,p_organization_id_o =>pay_pma_shd.g_old_rec.organization_id
263: ,p_account_number_o =>pay_pma_shd.g_old_rec.account_number
264: ,p_enabled_o =>pay_pma_shd.g_old_rec.enabled
265: ,p_description_o =>pay_pma_shd.g_old_rec.description
266: ,p_business_group_id_o =>pay_pma_shd.g_old_rec.business_group_id
267: ,p_attribute_category_o =>pay_pma_shd.g_old_rec.attribute_category
268: ,p_attribute1_o =>pay_pma_shd.g_old_rec.attribute1
269: ,p_attribute2_o =>pay_pma_shd.g_old_rec.attribute2
262: ,p_organization_id_o =>pay_pma_shd.g_old_rec.organization_id
263: ,p_account_number_o =>pay_pma_shd.g_old_rec.account_number
264: ,p_enabled_o =>pay_pma_shd.g_old_rec.enabled
265: ,p_description_o =>pay_pma_shd.g_old_rec.description
266: ,p_business_group_id_o =>pay_pma_shd.g_old_rec.business_group_id
267: ,p_attribute_category_o =>pay_pma_shd.g_old_rec.attribute_category
268: ,p_attribute1_o =>pay_pma_shd.g_old_rec.attribute1
269: ,p_attribute2_o =>pay_pma_shd.g_old_rec.attribute2
270: ,p_attribute3_o =>pay_pma_shd.g_old_rec.attribute3
263: ,p_account_number_o =>pay_pma_shd.g_old_rec.account_number
264: ,p_enabled_o =>pay_pma_shd.g_old_rec.enabled
265: ,p_description_o =>pay_pma_shd.g_old_rec.description
266: ,p_business_group_id_o =>pay_pma_shd.g_old_rec.business_group_id
267: ,p_attribute_category_o =>pay_pma_shd.g_old_rec.attribute_category
268: ,p_attribute1_o =>pay_pma_shd.g_old_rec.attribute1
269: ,p_attribute2_o =>pay_pma_shd.g_old_rec.attribute2
270: ,p_attribute3_o =>pay_pma_shd.g_old_rec.attribute3
271: ,p_attribute4_o =>pay_pma_shd.g_old_rec.attribute4
264: ,p_enabled_o =>pay_pma_shd.g_old_rec.enabled
265: ,p_description_o =>pay_pma_shd.g_old_rec.description
266: ,p_business_group_id_o =>pay_pma_shd.g_old_rec.business_group_id
267: ,p_attribute_category_o =>pay_pma_shd.g_old_rec.attribute_category
268: ,p_attribute1_o =>pay_pma_shd.g_old_rec.attribute1
269: ,p_attribute2_o =>pay_pma_shd.g_old_rec.attribute2
270: ,p_attribute3_o =>pay_pma_shd.g_old_rec.attribute3
271: ,p_attribute4_o =>pay_pma_shd.g_old_rec.attribute4
272: ,p_attribute5_o =>pay_pma_shd.g_old_rec.attribute5
265: ,p_description_o =>pay_pma_shd.g_old_rec.description
266: ,p_business_group_id_o =>pay_pma_shd.g_old_rec.business_group_id
267: ,p_attribute_category_o =>pay_pma_shd.g_old_rec.attribute_category
268: ,p_attribute1_o =>pay_pma_shd.g_old_rec.attribute1
269: ,p_attribute2_o =>pay_pma_shd.g_old_rec.attribute2
270: ,p_attribute3_o =>pay_pma_shd.g_old_rec.attribute3
271: ,p_attribute4_o =>pay_pma_shd.g_old_rec.attribute4
272: ,p_attribute5_o =>pay_pma_shd.g_old_rec.attribute5
273: ,p_attribute6_o =>pay_pma_shd.g_old_rec.attribute6
266: ,p_business_group_id_o =>pay_pma_shd.g_old_rec.business_group_id
267: ,p_attribute_category_o =>pay_pma_shd.g_old_rec.attribute_category
268: ,p_attribute1_o =>pay_pma_shd.g_old_rec.attribute1
269: ,p_attribute2_o =>pay_pma_shd.g_old_rec.attribute2
270: ,p_attribute3_o =>pay_pma_shd.g_old_rec.attribute3
271: ,p_attribute4_o =>pay_pma_shd.g_old_rec.attribute4
272: ,p_attribute5_o =>pay_pma_shd.g_old_rec.attribute5
273: ,p_attribute6_o =>pay_pma_shd.g_old_rec.attribute6
274: ,p_attribute7_o =>pay_pma_shd.g_old_rec.attribute7
267: ,p_attribute_category_o =>pay_pma_shd.g_old_rec.attribute_category
268: ,p_attribute1_o =>pay_pma_shd.g_old_rec.attribute1
269: ,p_attribute2_o =>pay_pma_shd.g_old_rec.attribute2
270: ,p_attribute3_o =>pay_pma_shd.g_old_rec.attribute3
271: ,p_attribute4_o =>pay_pma_shd.g_old_rec.attribute4
272: ,p_attribute5_o =>pay_pma_shd.g_old_rec.attribute5
273: ,p_attribute6_o =>pay_pma_shd.g_old_rec.attribute6
274: ,p_attribute7_o =>pay_pma_shd.g_old_rec.attribute7
275: ,p_attribute8_o =>pay_pma_shd.g_old_rec.attribute8
268: ,p_attribute1_o =>pay_pma_shd.g_old_rec.attribute1
269: ,p_attribute2_o =>pay_pma_shd.g_old_rec.attribute2
270: ,p_attribute3_o =>pay_pma_shd.g_old_rec.attribute3
271: ,p_attribute4_o =>pay_pma_shd.g_old_rec.attribute4
272: ,p_attribute5_o =>pay_pma_shd.g_old_rec.attribute5
273: ,p_attribute6_o =>pay_pma_shd.g_old_rec.attribute6
274: ,p_attribute7_o =>pay_pma_shd.g_old_rec.attribute7
275: ,p_attribute8_o =>pay_pma_shd.g_old_rec.attribute8
276: ,p_attribute9_o =>pay_pma_shd.g_old_rec.attribute9
269: ,p_attribute2_o =>pay_pma_shd.g_old_rec.attribute2
270: ,p_attribute3_o =>pay_pma_shd.g_old_rec.attribute3
271: ,p_attribute4_o =>pay_pma_shd.g_old_rec.attribute4
272: ,p_attribute5_o =>pay_pma_shd.g_old_rec.attribute5
273: ,p_attribute6_o =>pay_pma_shd.g_old_rec.attribute6
274: ,p_attribute7_o =>pay_pma_shd.g_old_rec.attribute7
275: ,p_attribute8_o =>pay_pma_shd.g_old_rec.attribute8
276: ,p_attribute9_o =>pay_pma_shd.g_old_rec.attribute9
277: ,p_attribute10_o =>pay_pma_shd.g_old_rec.attribute10
270: ,p_attribute3_o =>pay_pma_shd.g_old_rec.attribute3
271: ,p_attribute4_o =>pay_pma_shd.g_old_rec.attribute4
272: ,p_attribute5_o =>pay_pma_shd.g_old_rec.attribute5
273: ,p_attribute6_o =>pay_pma_shd.g_old_rec.attribute6
274: ,p_attribute7_o =>pay_pma_shd.g_old_rec.attribute7
275: ,p_attribute8_o =>pay_pma_shd.g_old_rec.attribute8
276: ,p_attribute9_o =>pay_pma_shd.g_old_rec.attribute9
277: ,p_attribute10_o =>pay_pma_shd.g_old_rec.attribute10
278: ,p_attribute11_o =>pay_pma_shd.g_old_rec.attribute11
271: ,p_attribute4_o =>pay_pma_shd.g_old_rec.attribute4
272: ,p_attribute5_o =>pay_pma_shd.g_old_rec.attribute5
273: ,p_attribute6_o =>pay_pma_shd.g_old_rec.attribute6
274: ,p_attribute7_o =>pay_pma_shd.g_old_rec.attribute7
275: ,p_attribute8_o =>pay_pma_shd.g_old_rec.attribute8
276: ,p_attribute9_o =>pay_pma_shd.g_old_rec.attribute9
277: ,p_attribute10_o =>pay_pma_shd.g_old_rec.attribute10
278: ,p_attribute11_o =>pay_pma_shd.g_old_rec.attribute11
279: ,p_attribute12_o =>pay_pma_shd.g_old_rec.attribute12
272: ,p_attribute5_o =>pay_pma_shd.g_old_rec.attribute5
273: ,p_attribute6_o =>pay_pma_shd.g_old_rec.attribute6
274: ,p_attribute7_o =>pay_pma_shd.g_old_rec.attribute7
275: ,p_attribute8_o =>pay_pma_shd.g_old_rec.attribute8
276: ,p_attribute9_o =>pay_pma_shd.g_old_rec.attribute9
277: ,p_attribute10_o =>pay_pma_shd.g_old_rec.attribute10
278: ,p_attribute11_o =>pay_pma_shd.g_old_rec.attribute11
279: ,p_attribute12_o =>pay_pma_shd.g_old_rec.attribute12
280: ,p_attribute13_o =>pay_pma_shd.g_old_rec.attribute13
273: ,p_attribute6_o =>pay_pma_shd.g_old_rec.attribute6
274: ,p_attribute7_o =>pay_pma_shd.g_old_rec.attribute7
275: ,p_attribute8_o =>pay_pma_shd.g_old_rec.attribute8
276: ,p_attribute9_o =>pay_pma_shd.g_old_rec.attribute9
277: ,p_attribute10_o =>pay_pma_shd.g_old_rec.attribute10
278: ,p_attribute11_o =>pay_pma_shd.g_old_rec.attribute11
279: ,p_attribute12_o =>pay_pma_shd.g_old_rec.attribute12
280: ,p_attribute13_o =>pay_pma_shd.g_old_rec.attribute13
281: ,p_attribute14_o =>pay_pma_shd.g_old_rec.attribute14
274: ,p_attribute7_o =>pay_pma_shd.g_old_rec.attribute7
275: ,p_attribute8_o =>pay_pma_shd.g_old_rec.attribute8
276: ,p_attribute9_o =>pay_pma_shd.g_old_rec.attribute9
277: ,p_attribute10_o =>pay_pma_shd.g_old_rec.attribute10
278: ,p_attribute11_o =>pay_pma_shd.g_old_rec.attribute11
279: ,p_attribute12_o =>pay_pma_shd.g_old_rec.attribute12
280: ,p_attribute13_o =>pay_pma_shd.g_old_rec.attribute13
281: ,p_attribute14_o =>pay_pma_shd.g_old_rec.attribute14
282: ,p_attribute15_o =>pay_pma_shd.g_old_rec.attribute15
275: ,p_attribute8_o =>pay_pma_shd.g_old_rec.attribute8
276: ,p_attribute9_o =>pay_pma_shd.g_old_rec.attribute9
277: ,p_attribute10_o =>pay_pma_shd.g_old_rec.attribute10
278: ,p_attribute11_o =>pay_pma_shd.g_old_rec.attribute11
279: ,p_attribute12_o =>pay_pma_shd.g_old_rec.attribute12
280: ,p_attribute13_o =>pay_pma_shd.g_old_rec.attribute13
281: ,p_attribute14_o =>pay_pma_shd.g_old_rec.attribute14
282: ,p_attribute15_o =>pay_pma_shd.g_old_rec.attribute15
283: ,p_attribute16_o =>pay_pma_shd.g_old_rec.attribute16
276: ,p_attribute9_o =>pay_pma_shd.g_old_rec.attribute9
277: ,p_attribute10_o =>pay_pma_shd.g_old_rec.attribute10
278: ,p_attribute11_o =>pay_pma_shd.g_old_rec.attribute11
279: ,p_attribute12_o =>pay_pma_shd.g_old_rec.attribute12
280: ,p_attribute13_o =>pay_pma_shd.g_old_rec.attribute13
281: ,p_attribute14_o =>pay_pma_shd.g_old_rec.attribute14
282: ,p_attribute15_o =>pay_pma_shd.g_old_rec.attribute15
283: ,p_attribute16_o =>pay_pma_shd.g_old_rec.attribute16
284: ,p_attribute17_o =>pay_pma_shd.g_old_rec.attribute17
277: ,p_attribute10_o =>pay_pma_shd.g_old_rec.attribute10
278: ,p_attribute11_o =>pay_pma_shd.g_old_rec.attribute11
279: ,p_attribute12_o =>pay_pma_shd.g_old_rec.attribute12
280: ,p_attribute13_o =>pay_pma_shd.g_old_rec.attribute13
281: ,p_attribute14_o =>pay_pma_shd.g_old_rec.attribute14
282: ,p_attribute15_o =>pay_pma_shd.g_old_rec.attribute15
283: ,p_attribute16_o =>pay_pma_shd.g_old_rec.attribute16
284: ,p_attribute17_o =>pay_pma_shd.g_old_rec.attribute17
285: ,p_attribute18_o =>pay_pma_shd.g_old_rec.attribute18
278: ,p_attribute11_o =>pay_pma_shd.g_old_rec.attribute11
279: ,p_attribute12_o =>pay_pma_shd.g_old_rec.attribute12
280: ,p_attribute13_o =>pay_pma_shd.g_old_rec.attribute13
281: ,p_attribute14_o =>pay_pma_shd.g_old_rec.attribute14
282: ,p_attribute15_o =>pay_pma_shd.g_old_rec.attribute15
283: ,p_attribute16_o =>pay_pma_shd.g_old_rec.attribute16
284: ,p_attribute17_o =>pay_pma_shd.g_old_rec.attribute17
285: ,p_attribute18_o =>pay_pma_shd.g_old_rec.attribute18
286: ,p_attribute19_o =>pay_pma_shd.g_old_rec.attribute19
279: ,p_attribute12_o =>pay_pma_shd.g_old_rec.attribute12
280: ,p_attribute13_o =>pay_pma_shd.g_old_rec.attribute13
281: ,p_attribute14_o =>pay_pma_shd.g_old_rec.attribute14
282: ,p_attribute15_o =>pay_pma_shd.g_old_rec.attribute15
283: ,p_attribute16_o =>pay_pma_shd.g_old_rec.attribute16
284: ,p_attribute17_o =>pay_pma_shd.g_old_rec.attribute17
285: ,p_attribute18_o =>pay_pma_shd.g_old_rec.attribute18
286: ,p_attribute19_o =>pay_pma_shd.g_old_rec.attribute19
287: ,p_attribute20_o =>pay_pma_shd.g_old_rec.attribute20
280: ,p_attribute13_o =>pay_pma_shd.g_old_rec.attribute13
281: ,p_attribute14_o =>pay_pma_shd.g_old_rec.attribute14
282: ,p_attribute15_o =>pay_pma_shd.g_old_rec.attribute15
283: ,p_attribute16_o =>pay_pma_shd.g_old_rec.attribute16
284: ,p_attribute17_o =>pay_pma_shd.g_old_rec.attribute17
285: ,p_attribute18_o =>pay_pma_shd.g_old_rec.attribute18
286: ,p_attribute19_o =>pay_pma_shd.g_old_rec.attribute19
287: ,p_attribute20_o =>pay_pma_shd.g_old_rec.attribute20
288: ,p_attribute21_o =>pay_pma_shd.g_old_rec.attribute21
281: ,p_attribute14_o =>pay_pma_shd.g_old_rec.attribute14
282: ,p_attribute15_o =>pay_pma_shd.g_old_rec.attribute15
283: ,p_attribute16_o =>pay_pma_shd.g_old_rec.attribute16
284: ,p_attribute17_o =>pay_pma_shd.g_old_rec.attribute17
285: ,p_attribute18_o =>pay_pma_shd.g_old_rec.attribute18
286: ,p_attribute19_o =>pay_pma_shd.g_old_rec.attribute19
287: ,p_attribute20_o =>pay_pma_shd.g_old_rec.attribute20
288: ,p_attribute21_o =>pay_pma_shd.g_old_rec.attribute21
289: ,p_attribute22_o =>pay_pma_shd.g_old_rec.attribute22
282: ,p_attribute15_o =>pay_pma_shd.g_old_rec.attribute15
283: ,p_attribute16_o =>pay_pma_shd.g_old_rec.attribute16
284: ,p_attribute17_o =>pay_pma_shd.g_old_rec.attribute17
285: ,p_attribute18_o =>pay_pma_shd.g_old_rec.attribute18
286: ,p_attribute19_o =>pay_pma_shd.g_old_rec.attribute19
287: ,p_attribute20_o =>pay_pma_shd.g_old_rec.attribute20
288: ,p_attribute21_o =>pay_pma_shd.g_old_rec.attribute21
289: ,p_attribute22_o =>pay_pma_shd.g_old_rec.attribute22
290: ,p_attribute23_o =>pay_pma_shd.g_old_rec.attribute23
283: ,p_attribute16_o =>pay_pma_shd.g_old_rec.attribute16
284: ,p_attribute17_o =>pay_pma_shd.g_old_rec.attribute17
285: ,p_attribute18_o =>pay_pma_shd.g_old_rec.attribute18
286: ,p_attribute19_o =>pay_pma_shd.g_old_rec.attribute19
287: ,p_attribute20_o =>pay_pma_shd.g_old_rec.attribute20
288: ,p_attribute21_o =>pay_pma_shd.g_old_rec.attribute21
289: ,p_attribute22_o =>pay_pma_shd.g_old_rec.attribute22
290: ,p_attribute23_o =>pay_pma_shd.g_old_rec.attribute23
291: ,p_attribute24_o =>pay_pma_shd.g_old_rec.attribute24
284: ,p_attribute17_o =>pay_pma_shd.g_old_rec.attribute17
285: ,p_attribute18_o =>pay_pma_shd.g_old_rec.attribute18
286: ,p_attribute19_o =>pay_pma_shd.g_old_rec.attribute19
287: ,p_attribute20_o =>pay_pma_shd.g_old_rec.attribute20
288: ,p_attribute21_o =>pay_pma_shd.g_old_rec.attribute21
289: ,p_attribute22_o =>pay_pma_shd.g_old_rec.attribute22
290: ,p_attribute23_o =>pay_pma_shd.g_old_rec.attribute23
291: ,p_attribute24_o =>pay_pma_shd.g_old_rec.attribute24
292: ,p_attribute25_o =>pay_pma_shd.g_old_rec.attribute25
285: ,p_attribute18_o =>pay_pma_shd.g_old_rec.attribute18
286: ,p_attribute19_o =>pay_pma_shd.g_old_rec.attribute19
287: ,p_attribute20_o =>pay_pma_shd.g_old_rec.attribute20
288: ,p_attribute21_o =>pay_pma_shd.g_old_rec.attribute21
289: ,p_attribute22_o =>pay_pma_shd.g_old_rec.attribute22
290: ,p_attribute23_o =>pay_pma_shd.g_old_rec.attribute23
291: ,p_attribute24_o =>pay_pma_shd.g_old_rec.attribute24
292: ,p_attribute25_o =>pay_pma_shd.g_old_rec.attribute25
293: ,p_attribute26_o =>pay_pma_shd.g_old_rec.attribute26
286: ,p_attribute19_o =>pay_pma_shd.g_old_rec.attribute19
287: ,p_attribute20_o =>pay_pma_shd.g_old_rec.attribute20
288: ,p_attribute21_o =>pay_pma_shd.g_old_rec.attribute21
289: ,p_attribute22_o =>pay_pma_shd.g_old_rec.attribute22
290: ,p_attribute23_o =>pay_pma_shd.g_old_rec.attribute23
291: ,p_attribute24_o =>pay_pma_shd.g_old_rec.attribute24
292: ,p_attribute25_o =>pay_pma_shd.g_old_rec.attribute25
293: ,p_attribute26_o =>pay_pma_shd.g_old_rec.attribute26
294: ,p_attribute27_o =>pay_pma_shd.g_old_rec.attribute27
287: ,p_attribute20_o =>pay_pma_shd.g_old_rec.attribute20
288: ,p_attribute21_o =>pay_pma_shd.g_old_rec.attribute21
289: ,p_attribute22_o =>pay_pma_shd.g_old_rec.attribute22
290: ,p_attribute23_o =>pay_pma_shd.g_old_rec.attribute23
291: ,p_attribute24_o =>pay_pma_shd.g_old_rec.attribute24
292: ,p_attribute25_o =>pay_pma_shd.g_old_rec.attribute25
293: ,p_attribute26_o =>pay_pma_shd.g_old_rec.attribute26
294: ,p_attribute27_o =>pay_pma_shd.g_old_rec.attribute27
295: ,p_attribute28_o =>pay_pma_shd.g_old_rec.attribute28
288: ,p_attribute21_o =>pay_pma_shd.g_old_rec.attribute21
289: ,p_attribute22_o =>pay_pma_shd.g_old_rec.attribute22
290: ,p_attribute23_o =>pay_pma_shd.g_old_rec.attribute23
291: ,p_attribute24_o =>pay_pma_shd.g_old_rec.attribute24
292: ,p_attribute25_o =>pay_pma_shd.g_old_rec.attribute25
293: ,p_attribute26_o =>pay_pma_shd.g_old_rec.attribute26
294: ,p_attribute27_o =>pay_pma_shd.g_old_rec.attribute27
295: ,p_attribute28_o =>pay_pma_shd.g_old_rec.attribute28
296: ,p_attribute29_o =>pay_pma_shd.g_old_rec.attribute29
289: ,p_attribute22_o =>pay_pma_shd.g_old_rec.attribute22
290: ,p_attribute23_o =>pay_pma_shd.g_old_rec.attribute23
291: ,p_attribute24_o =>pay_pma_shd.g_old_rec.attribute24
292: ,p_attribute25_o =>pay_pma_shd.g_old_rec.attribute25
293: ,p_attribute26_o =>pay_pma_shd.g_old_rec.attribute26
294: ,p_attribute27_o =>pay_pma_shd.g_old_rec.attribute27
295: ,p_attribute28_o =>pay_pma_shd.g_old_rec.attribute28
296: ,p_attribute29_o =>pay_pma_shd.g_old_rec.attribute29
297: ,p_attribute30_o =>pay_pma_shd.g_old_rec.attribute30
290: ,p_attribute23_o =>pay_pma_shd.g_old_rec.attribute23
291: ,p_attribute24_o =>pay_pma_shd.g_old_rec.attribute24
292: ,p_attribute25_o =>pay_pma_shd.g_old_rec.attribute25
293: ,p_attribute26_o =>pay_pma_shd.g_old_rec.attribute26
294: ,p_attribute27_o =>pay_pma_shd.g_old_rec.attribute27
295: ,p_attribute28_o =>pay_pma_shd.g_old_rec.attribute28
296: ,p_attribute29_o =>pay_pma_shd.g_old_rec.attribute29
297: ,p_attribute30_o =>pay_pma_shd.g_old_rec.attribute30
298: ,p_object_version_number_o =>pay_pma_shd.g_old_rec.object_version_number
291: ,p_attribute24_o =>pay_pma_shd.g_old_rec.attribute24
292: ,p_attribute25_o =>pay_pma_shd.g_old_rec.attribute25
293: ,p_attribute26_o =>pay_pma_shd.g_old_rec.attribute26
294: ,p_attribute27_o =>pay_pma_shd.g_old_rec.attribute27
295: ,p_attribute28_o =>pay_pma_shd.g_old_rec.attribute28
296: ,p_attribute29_o =>pay_pma_shd.g_old_rec.attribute29
297: ,p_attribute30_o =>pay_pma_shd.g_old_rec.attribute30
298: ,p_object_version_number_o =>pay_pma_shd.g_old_rec.object_version_number
299: );
292: ,p_attribute25_o =>pay_pma_shd.g_old_rec.attribute25
293: ,p_attribute26_o =>pay_pma_shd.g_old_rec.attribute26
294: ,p_attribute27_o =>pay_pma_shd.g_old_rec.attribute27
295: ,p_attribute28_o =>pay_pma_shd.g_old_rec.attribute28
296: ,p_attribute29_o =>pay_pma_shd.g_old_rec.attribute29
297: ,p_attribute30_o =>pay_pma_shd.g_old_rec.attribute30
298: ,p_object_version_number_o =>pay_pma_shd.g_old_rec.object_version_number
299: );
300: --
293: ,p_attribute26_o =>pay_pma_shd.g_old_rec.attribute26
294: ,p_attribute27_o =>pay_pma_shd.g_old_rec.attribute27
295: ,p_attribute28_o =>pay_pma_shd.g_old_rec.attribute28
296: ,p_attribute29_o =>pay_pma_shd.g_old_rec.attribute29
297: ,p_attribute30_o =>pay_pma_shd.g_old_rec.attribute30
298: ,p_object_version_number_o =>pay_pma_shd.g_old_rec.object_version_number
299: );
300: --
301: exception
294: ,p_attribute27_o =>pay_pma_shd.g_old_rec.attribute27
295: ,p_attribute28_o =>pay_pma_shd.g_old_rec.attribute28
296: ,p_attribute29_o =>pay_pma_shd.g_old_rec.attribute29
297: ,p_attribute30_o =>pay_pma_shd.g_old_rec.attribute30
298: ,p_object_version_number_o =>pay_pma_shd.g_old_rec.object_version_number
299: );
300: --
301: exception
302: --
356: -- Internal Row Handler Use Only.
357: --
358: -- {End Of Comments}
359: -- ----------------------------------------------------------------------------
360: Procedure convert_defs(p_rec in out nocopy pay_pma_shd.g_rec_type) is
361: --
362: l_proc varchar2(72) := g_package||'convert_defs';
363: --
364: Begin
371: -- is being used then we must set to the 'current' argument value.
372: --
373: If (p_rec.organization_id = hr_api.g_number) then
374: p_rec.organization_id :=
375: pay_pma_shd.g_old_rec.organization_id;
376: End If;
377: If (p_rec.account_number = hr_api.g_varchar2) then
378: p_rec.account_number :=
379: pay_pma_shd.g_old_rec.account_number;
375: pay_pma_shd.g_old_rec.organization_id;
376: End If;
377: If (p_rec.account_number = hr_api.g_varchar2) then
378: p_rec.account_number :=
379: pay_pma_shd.g_old_rec.account_number;
380: End If;
381: If (p_rec.enabled = hr_api.g_varchar2) then
382: p_rec.enabled :=
383: pay_pma_shd.g_old_rec.enabled;
379: pay_pma_shd.g_old_rec.account_number;
380: End If;
381: If (p_rec.enabled = hr_api.g_varchar2) then
382: p_rec.enabled :=
383: pay_pma_shd.g_old_rec.enabled;
384: End If;
385: If (p_rec.description = hr_api.g_varchar2) then
386: p_rec.description :=
387: pay_pma_shd.g_old_rec.description;
383: pay_pma_shd.g_old_rec.enabled;
384: End If;
385: If (p_rec.description = hr_api.g_varchar2) then
386: p_rec.description :=
387: pay_pma_shd.g_old_rec.description;
388: End If;
389: If (p_rec.business_group_id = hr_api.g_number) then
390: p_rec.business_group_id :=
391: pay_pma_shd.g_old_rec.business_group_id;
387: pay_pma_shd.g_old_rec.description;
388: End If;
389: If (p_rec.business_group_id = hr_api.g_number) then
390: p_rec.business_group_id :=
391: pay_pma_shd.g_old_rec.business_group_id;
392: End If;
393: If (p_rec.attribute_category = hr_api.g_varchar2) then
394: p_rec.attribute_category :=
395: pay_pma_shd.g_old_rec.attribute_category;
391: pay_pma_shd.g_old_rec.business_group_id;
392: End If;
393: If (p_rec.attribute_category = hr_api.g_varchar2) then
394: p_rec.attribute_category :=
395: pay_pma_shd.g_old_rec.attribute_category;
396: End If;
397: If (p_rec.attribute1 = hr_api.g_varchar2) then
398: p_rec.attribute1 :=
399: pay_pma_shd.g_old_rec.attribute1;
395: pay_pma_shd.g_old_rec.attribute_category;
396: End If;
397: If (p_rec.attribute1 = hr_api.g_varchar2) then
398: p_rec.attribute1 :=
399: pay_pma_shd.g_old_rec.attribute1;
400: End If;
401: If (p_rec.attribute2 = hr_api.g_varchar2) then
402: p_rec.attribute2 :=
403: pay_pma_shd.g_old_rec.attribute2;
399: pay_pma_shd.g_old_rec.attribute1;
400: End If;
401: If (p_rec.attribute2 = hr_api.g_varchar2) then
402: p_rec.attribute2 :=
403: pay_pma_shd.g_old_rec.attribute2;
404: End If;
405: If (p_rec.attribute3 = hr_api.g_varchar2) then
406: p_rec.attribute3 :=
407: pay_pma_shd.g_old_rec.attribute3;
403: pay_pma_shd.g_old_rec.attribute2;
404: End If;
405: If (p_rec.attribute3 = hr_api.g_varchar2) then
406: p_rec.attribute3 :=
407: pay_pma_shd.g_old_rec.attribute3;
408: End If;
409: If (p_rec.attribute4 = hr_api.g_varchar2) then
410: p_rec.attribute4 :=
411: pay_pma_shd.g_old_rec.attribute4;
407: pay_pma_shd.g_old_rec.attribute3;
408: End If;
409: If (p_rec.attribute4 = hr_api.g_varchar2) then
410: p_rec.attribute4 :=
411: pay_pma_shd.g_old_rec.attribute4;
412: End If;
413: If (p_rec.attribute5 = hr_api.g_varchar2) then
414: p_rec.attribute5 :=
415: pay_pma_shd.g_old_rec.attribute5;
411: pay_pma_shd.g_old_rec.attribute4;
412: End If;
413: If (p_rec.attribute5 = hr_api.g_varchar2) then
414: p_rec.attribute5 :=
415: pay_pma_shd.g_old_rec.attribute5;
416: End If;
417: If (p_rec.attribute6 = hr_api.g_varchar2) then
418: p_rec.attribute6 :=
419: pay_pma_shd.g_old_rec.attribute6;
415: pay_pma_shd.g_old_rec.attribute5;
416: End If;
417: If (p_rec.attribute6 = hr_api.g_varchar2) then
418: p_rec.attribute6 :=
419: pay_pma_shd.g_old_rec.attribute6;
420: End If;
421: If (p_rec.attribute7 = hr_api.g_varchar2) then
422: p_rec.attribute7 :=
423: pay_pma_shd.g_old_rec.attribute7;
419: pay_pma_shd.g_old_rec.attribute6;
420: End If;
421: If (p_rec.attribute7 = hr_api.g_varchar2) then
422: p_rec.attribute7 :=
423: pay_pma_shd.g_old_rec.attribute7;
424: End If;
425: If (p_rec.attribute8 = hr_api.g_varchar2) then
426: p_rec.attribute8 :=
427: pay_pma_shd.g_old_rec.attribute8;
423: pay_pma_shd.g_old_rec.attribute7;
424: End If;
425: If (p_rec.attribute8 = hr_api.g_varchar2) then
426: p_rec.attribute8 :=
427: pay_pma_shd.g_old_rec.attribute8;
428: End If;
429: If (p_rec.attribute9 = hr_api.g_varchar2) then
430: p_rec.attribute9 :=
431: pay_pma_shd.g_old_rec.attribute9;
427: pay_pma_shd.g_old_rec.attribute8;
428: End If;
429: If (p_rec.attribute9 = hr_api.g_varchar2) then
430: p_rec.attribute9 :=
431: pay_pma_shd.g_old_rec.attribute9;
432: End If;
433: If (p_rec.attribute10 = hr_api.g_varchar2) then
434: p_rec.attribute10 :=
435: pay_pma_shd.g_old_rec.attribute10;
431: pay_pma_shd.g_old_rec.attribute9;
432: End If;
433: If (p_rec.attribute10 = hr_api.g_varchar2) then
434: p_rec.attribute10 :=
435: pay_pma_shd.g_old_rec.attribute10;
436: End If;
437: If (p_rec.attribute11 = hr_api.g_varchar2) then
438: p_rec.attribute11 :=
439: pay_pma_shd.g_old_rec.attribute11;
435: pay_pma_shd.g_old_rec.attribute10;
436: End If;
437: If (p_rec.attribute11 = hr_api.g_varchar2) then
438: p_rec.attribute11 :=
439: pay_pma_shd.g_old_rec.attribute11;
440: End If;
441: If (p_rec.attribute12 = hr_api.g_varchar2) then
442: p_rec.attribute12 :=
443: pay_pma_shd.g_old_rec.attribute12;
439: pay_pma_shd.g_old_rec.attribute11;
440: End If;
441: If (p_rec.attribute12 = hr_api.g_varchar2) then
442: p_rec.attribute12 :=
443: pay_pma_shd.g_old_rec.attribute12;
444: End If;
445: If (p_rec.attribute13 = hr_api.g_varchar2) then
446: p_rec.attribute13 :=
447: pay_pma_shd.g_old_rec.attribute13;
443: pay_pma_shd.g_old_rec.attribute12;
444: End If;
445: If (p_rec.attribute13 = hr_api.g_varchar2) then
446: p_rec.attribute13 :=
447: pay_pma_shd.g_old_rec.attribute13;
448: End If;
449: If (p_rec.attribute14 = hr_api.g_varchar2) then
450: p_rec.attribute14 :=
451: pay_pma_shd.g_old_rec.attribute14;
447: pay_pma_shd.g_old_rec.attribute13;
448: End If;
449: If (p_rec.attribute14 = hr_api.g_varchar2) then
450: p_rec.attribute14 :=
451: pay_pma_shd.g_old_rec.attribute14;
452: End If;
453: If (p_rec.attribute15 = hr_api.g_varchar2) then
454: p_rec.attribute15 :=
455: pay_pma_shd.g_old_rec.attribute15;
451: pay_pma_shd.g_old_rec.attribute14;
452: End If;
453: If (p_rec.attribute15 = hr_api.g_varchar2) then
454: p_rec.attribute15 :=
455: pay_pma_shd.g_old_rec.attribute15;
456: End If;
457: If (p_rec.attribute16 = hr_api.g_varchar2) then
458: p_rec.attribute16 :=
459: pay_pma_shd.g_old_rec.attribute16;
455: pay_pma_shd.g_old_rec.attribute15;
456: End If;
457: If (p_rec.attribute16 = hr_api.g_varchar2) then
458: p_rec.attribute16 :=
459: pay_pma_shd.g_old_rec.attribute16;
460: End If;
461: If (p_rec.attribute17 = hr_api.g_varchar2) then
462: p_rec.attribute17 :=
463: pay_pma_shd.g_old_rec.attribute17;
459: pay_pma_shd.g_old_rec.attribute16;
460: End If;
461: If (p_rec.attribute17 = hr_api.g_varchar2) then
462: p_rec.attribute17 :=
463: pay_pma_shd.g_old_rec.attribute17;
464: End If;
465: If (p_rec.attribute18 = hr_api.g_varchar2) then
466: p_rec.attribute18 :=
467: pay_pma_shd.g_old_rec.attribute18;
463: pay_pma_shd.g_old_rec.attribute17;
464: End If;
465: If (p_rec.attribute18 = hr_api.g_varchar2) then
466: p_rec.attribute18 :=
467: pay_pma_shd.g_old_rec.attribute18;
468: End If;
469: If (p_rec.attribute19 = hr_api.g_varchar2) then
470: p_rec.attribute19 :=
471: pay_pma_shd.g_old_rec.attribute19;
467: pay_pma_shd.g_old_rec.attribute18;
468: End If;
469: If (p_rec.attribute19 = hr_api.g_varchar2) then
470: p_rec.attribute19 :=
471: pay_pma_shd.g_old_rec.attribute19;
472: End If;
473: If (p_rec.attribute20 = hr_api.g_varchar2) then
474: p_rec.attribute20 :=
475: pay_pma_shd.g_old_rec.attribute20;
471: pay_pma_shd.g_old_rec.attribute19;
472: End If;
473: If (p_rec.attribute20 = hr_api.g_varchar2) then
474: p_rec.attribute20 :=
475: pay_pma_shd.g_old_rec.attribute20;
476: End If;
477: If (p_rec.attribute21 = hr_api.g_varchar2) then
478: p_rec.attribute21 :=
479: pay_pma_shd.g_old_rec.attribute21;
475: pay_pma_shd.g_old_rec.attribute20;
476: End If;
477: If (p_rec.attribute21 = hr_api.g_varchar2) then
478: p_rec.attribute21 :=
479: pay_pma_shd.g_old_rec.attribute21;
480: End If;
481: If (p_rec.attribute22 = hr_api.g_varchar2) then
482: p_rec.attribute22 :=
483: pay_pma_shd.g_old_rec.attribute22;
479: pay_pma_shd.g_old_rec.attribute21;
480: End If;
481: If (p_rec.attribute22 = hr_api.g_varchar2) then
482: p_rec.attribute22 :=
483: pay_pma_shd.g_old_rec.attribute22;
484: End If;
485: If (p_rec.attribute23 = hr_api.g_varchar2) then
486: p_rec.attribute23 :=
487: pay_pma_shd.g_old_rec.attribute23;
483: pay_pma_shd.g_old_rec.attribute22;
484: End If;
485: If (p_rec.attribute23 = hr_api.g_varchar2) then
486: p_rec.attribute23 :=
487: pay_pma_shd.g_old_rec.attribute23;
488: End If;
489: If (p_rec.attribute24 = hr_api.g_varchar2) then
490: p_rec.attribute24 :=
491: pay_pma_shd.g_old_rec.attribute24;
487: pay_pma_shd.g_old_rec.attribute23;
488: End If;
489: If (p_rec.attribute24 = hr_api.g_varchar2) then
490: p_rec.attribute24 :=
491: pay_pma_shd.g_old_rec.attribute24;
492: End If;
493: If (p_rec.attribute25 = hr_api.g_varchar2) then
494: p_rec.attribute25 :=
495: pay_pma_shd.g_old_rec.attribute25;
491: pay_pma_shd.g_old_rec.attribute24;
492: End If;
493: If (p_rec.attribute25 = hr_api.g_varchar2) then
494: p_rec.attribute25 :=
495: pay_pma_shd.g_old_rec.attribute25;
496: End If;
497: If (p_rec.attribute26 = hr_api.g_varchar2) then
498: p_rec.attribute26 :=
499: pay_pma_shd.g_old_rec.attribute26;
495: pay_pma_shd.g_old_rec.attribute25;
496: End If;
497: If (p_rec.attribute26 = hr_api.g_varchar2) then
498: p_rec.attribute26 :=
499: pay_pma_shd.g_old_rec.attribute26;
500: End If;
501: If (p_rec.attribute27 = hr_api.g_varchar2) then
502: p_rec.attribute27 :=
503: pay_pma_shd.g_old_rec.attribute27;
499: pay_pma_shd.g_old_rec.attribute26;
500: End If;
501: If (p_rec.attribute27 = hr_api.g_varchar2) then
502: p_rec.attribute27 :=
503: pay_pma_shd.g_old_rec.attribute27;
504: End If;
505: If (p_rec.attribute28 = hr_api.g_varchar2) then
506: p_rec.attribute28 :=
507: pay_pma_shd.g_old_rec.attribute28;
503: pay_pma_shd.g_old_rec.attribute27;
504: End If;
505: If (p_rec.attribute28 = hr_api.g_varchar2) then
506: p_rec.attribute28 :=
507: pay_pma_shd.g_old_rec.attribute28;
508: End If;
509: If (p_rec.attribute29 = hr_api.g_varchar2) then
510: p_rec.attribute29 :=
511: pay_pma_shd.g_old_rec.attribute29;
507: pay_pma_shd.g_old_rec.attribute28;
508: End If;
509: If (p_rec.attribute29 = hr_api.g_varchar2) then
510: p_rec.attribute29 :=
511: pay_pma_shd.g_old_rec.attribute29;
512: End If;
513: If (p_rec.attribute30 = hr_api.g_varchar2) then
514: p_rec.attribute30 :=
515: pay_pma_shd.g_old_rec.attribute30;
511: pay_pma_shd.g_old_rec.attribute29;
512: End If;
513: If (p_rec.attribute30 = hr_api.g_varchar2) then
514: p_rec.attribute30 :=
515: pay_pma_shd.g_old_rec.attribute30;
516: End If;
517:
518: --
519: hr_utility.set_location(' Leaving:'||l_proc, 10);
524: -- |---------------------------------< upd >----------------------------------|
525: -- ----------------------------------------------------------------------------
526: Procedure upd
527: (
528: p_rec in out nocopy pay_pma_shd.g_rec_type
529: ) is
530: --
531: l_proc varchar2(72) := g_package||'upd';
532: --
534: hr_utility.set_location('Entering:'||l_proc, 5);
535: --
536: -- We must lock the row which we need to update.
537: --
538: pay_pma_shd.lck
539: (
540: p_rec.source_id,
541: p_rec.object_version_number
542: );
607: p_attribute30 in varchar2 default hr_api.g_varchar2,
608: p_object_version_number in out nocopy number
609: ) is
610: --
611: l_rec pay_pma_shd.g_rec_type;
612: l_proc varchar2(72) := g_package||'upd';
613: --
614: Begin
615: hr_utility.set_location('Entering:'||l_proc, 5);
617: -- Call conversion function to turn arguments into the
618: -- l_rec structure.
619: --
620: l_rec :=
621: pay_pma_shd.convert_args
622: (
623: p_organization_id,
624: p_source_id,
625: p_account_number,