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.PAY_CON_UPD dependencies on PAY_CON_SHD

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

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

Line 65: pay_con_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: pay_con_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the pay_us_contribution_history Row
68: --
69: update pay_us_contribution_history

Line 117: pay_con_shd.g_api_dml := false; -- Unset the api dml status

113: contr_information30 = p_rec.contr_information30,
114: object_version_number = p_rec.object_version_number
115: where contr_history_id = p_rec.contr_history_id;
116: --
117: pay_con_shd.g_api_dml := false; -- Unset the api dml status
118: --
119: hr_utility.set_location(' Leaving:'||l_proc, 10);
120: --
121: Exception

Line 124: pay_con_shd.g_api_dml := false; -- Unset the api dml status

120: --
121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: pay_con_shd.g_api_dml := false; -- Unset the api dml status
125: pay_con_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated

Line 125: pay_con_shd.constraint_error

121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: pay_con_shd.g_api_dml := false; -- Unset the api dml status
125: pay_con_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: pay_con_shd.g_api_dml := false; -- Unset the api dml status

Line 129: pay_con_shd.g_api_dml := false; -- Unset the api dml status

125: pay_con_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: pay_con_shd.g_api_dml := false; -- Unset the api dml status
130: pay_con_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated

Line 130: pay_con_shd.constraint_error

126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: pay_con_shd.g_api_dml := false; -- Unset the api dml status
130: pay_con_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: pay_con_shd.g_api_dml := false; -- Unset the api dml status

Line 134: pay_con_shd.g_api_dml := false; -- Unset the api dml status

130: pay_con_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: pay_con_shd.g_api_dml := false; -- Unset the api dml status
135: pay_con_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When Others Then
138: pay_con_shd.g_api_dml := false; -- Unset the api dml status

Line 135: pay_con_shd.constraint_error

131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: pay_con_shd.g_api_dml := false; -- Unset the api dml status
135: pay_con_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When Others Then
138: pay_con_shd.g_api_dml := false; -- Unset the api dml status
139: Raise;

Line 138: pay_con_shd.g_api_dml := false; -- Unset the api dml status

134: pay_con_shd.g_api_dml := false; -- Unset the api dml status
135: pay_con_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When Others Then
138: pay_con_shd.g_api_dml := false; -- Unset the api dml status
139: Raise;
140: End update_dml;
141: --
142: -- ----------------------------------------------------------------------------

Line 174: Procedure pre_update(p_rec in pay_con_shd.g_rec_type) is

170: -- Internal Row Handler Use Only.
171: --
172: -- {End Of Comments}
173: -- ----------------------------------------------------------------------------
174: Procedure pre_update(p_rec in pay_con_shd.g_rec_type) is
175: --
176: l_proc varchar2(72) := g_package||'pre_update';
177: --
178: Begin

Line 216: Procedure post_update(p_rec in pay_con_shd.g_rec_type) is

212: -- Internal Row Handler Use Only.
213: --
214: -- {End Of Comments}
215: -- ----------------------------------------------------------------------------
216: Procedure post_update(p_rec in pay_con_shd.g_rec_type) is
217: --
218: l_proc varchar2(72) := g_package||'post_update';
219: --
220: Begin

Line 274: ,p_person_id_o =>pay_con_shd.g_old_rec.person_id

270: ,p_contr_information28 =>p_rec.contr_information28
271: ,p_contr_information29 =>p_rec.contr_information29
272: ,p_contr_information30 =>p_rec.contr_information30
273: ,p_object_version_number =>p_rec.object_version_number
274: ,p_person_id_o =>pay_con_shd.g_old_rec.person_id
275: ,p_date_from_o =>pay_con_shd.g_old_rec.date_from
276: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to
277: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
278: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id

Line 275: ,p_date_from_o =>pay_con_shd.g_old_rec.date_from

271: ,p_contr_information29 =>p_rec.contr_information29
272: ,p_contr_information30 =>p_rec.contr_information30
273: ,p_object_version_number =>p_rec.object_version_number
274: ,p_person_id_o =>pay_con_shd.g_old_rec.person_id
275: ,p_date_from_o =>pay_con_shd.g_old_rec.date_from
276: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to
277: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
278: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
279: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code

Line 276: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to

272: ,p_contr_information30 =>p_rec.contr_information30
273: ,p_object_version_number =>p_rec.object_version_number
274: ,p_person_id_o =>pay_con_shd.g_old_rec.person_id
275: ,p_date_from_o =>pay_con_shd.g_old_rec.date_from
276: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to
277: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
278: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
279: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
280: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr

Line 277: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type

273: ,p_object_version_number =>p_rec.object_version_number
274: ,p_person_id_o =>pay_con_shd.g_old_rec.person_id
275: ,p_date_from_o =>pay_con_shd.g_old_rec.date_from
276: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to
277: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
278: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
279: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
280: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
281: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed

Line 278: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id

274: ,p_person_id_o =>pay_con_shd.g_old_rec.person_id
275: ,p_date_from_o =>pay_con_shd.g_old_rec.date_from
276: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to
277: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
278: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
279: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
280: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
281: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
282: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp

Line 279: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code

275: ,p_date_from_o =>pay_con_shd.g_old_rec.date_from
276: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to
277: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
278: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
279: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
280: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
281: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
282: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
283: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id

Line 280: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr

276: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to
277: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
278: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
279: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
280: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
281: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
282: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
283: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
284: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system

Line 281: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed

277: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
278: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
279: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
280: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
281: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
282: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
283: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
284: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
285: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category

Line 282: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp

278: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
279: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
280: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
281: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
282: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
283: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
284: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
285: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
286: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1

Line 283: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id

279: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
280: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
281: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
282: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
283: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
284: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
285: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
286: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
287: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2

Line 284: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system

280: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
281: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
282: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
283: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
284: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
285: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
286: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
287: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
288: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3

Line 285: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category

281: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
282: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
283: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
284: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
285: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
286: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
287: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
288: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
289: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4

Line 286: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1

282: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
283: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
284: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
285: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
286: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
287: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
288: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
289: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
290: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5

Line 287: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2

283: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
284: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
285: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
286: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
287: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
288: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
289: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
290: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
291: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6

Line 288: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3

284: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
285: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
286: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
287: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
288: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
289: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
290: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
291: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
292: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7

Line 289: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4

285: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
286: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
287: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
288: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
289: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
290: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
291: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
292: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
293: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8

Line 290: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5

286: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
287: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
288: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
289: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
290: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
291: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
292: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
293: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
294: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9

Line 291: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6

287: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
288: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
289: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
290: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
291: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
292: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
293: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
294: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
295: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10

Line 292: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7

288: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
289: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
290: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
291: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
292: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
293: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
294: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
295: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
296: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11

Line 293: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8

289: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
290: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
291: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
292: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
293: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
294: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
295: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
296: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
297: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12

Line 294: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9

290: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
291: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
292: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
293: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
294: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
295: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
296: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
297: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
298: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13

Line 295: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10

291: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
292: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
293: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
294: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
295: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
296: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
297: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
298: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
299: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14

Line 296: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11

292: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
293: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
294: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
295: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
296: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
297: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
298: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
299: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
300: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15

Line 297: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12

293: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
294: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
295: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
296: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
297: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
298: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
299: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
300: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
301: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16

Line 298: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13

294: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
295: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
296: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
297: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
298: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
299: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
300: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
301: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
302: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17

Line 299: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14

295: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
296: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
297: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
298: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
299: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
300: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
301: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
302: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
303: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18

Line 300: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15

296: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
297: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
298: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
299: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
300: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
301: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
302: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
303: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
304: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19

Line 301: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16

297: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
298: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
299: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
300: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
301: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
302: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
303: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
304: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
305: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20

Line 302: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17

298: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
299: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
300: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
301: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
302: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
303: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
304: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
305: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
306: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21

Line 303: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18

299: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
300: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
301: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
302: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
303: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
304: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
305: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
306: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
307: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22

Line 304: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19

300: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
301: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
302: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
303: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
304: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
305: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
306: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
307: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
308: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23

Line 305: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20

301: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
302: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
303: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
304: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
305: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
306: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
307: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
308: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
309: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24

Line 306: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21

302: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
303: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
304: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
305: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
306: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
307: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
308: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
309: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
310: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25

Line 307: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22

303: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
304: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
305: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
306: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
307: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
308: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
309: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
310: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
311: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26

Line 308: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23

304: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
305: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
306: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
307: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
308: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
309: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
310: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
311: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
312: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27

Line 309: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24

305: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
306: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
307: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
308: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
309: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
310: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
311: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
312: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
313: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28

Line 310: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25

306: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
307: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
308: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
309: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
310: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
311: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
312: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
313: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28
314: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29

Line 311: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26

307: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
308: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
309: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
310: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
311: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
312: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
313: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28
314: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29
315: ,p_contr_information30_o =>pay_con_shd.g_old_rec.contr_information30

Line 312: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27

308: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
309: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
310: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
311: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
312: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
313: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28
314: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29
315: ,p_contr_information30_o =>pay_con_shd.g_old_rec.contr_information30
316: ,p_object_version_number_o =>pay_con_shd.g_old_rec.object_version_number

Line 313: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28

309: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
310: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
311: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
312: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
313: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28
314: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29
315: ,p_contr_information30_o =>pay_con_shd.g_old_rec.contr_information30
316: ,p_object_version_number_o =>pay_con_shd.g_old_rec.object_version_number
317: );

Line 314: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29

310: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
311: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
312: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
313: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28
314: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29
315: ,p_contr_information30_o =>pay_con_shd.g_old_rec.contr_information30
316: ,p_object_version_number_o =>pay_con_shd.g_old_rec.object_version_number
317: );
318: --

Line 315: ,p_contr_information30_o =>pay_con_shd.g_old_rec.contr_information30

311: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
312: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
313: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28
314: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29
315: ,p_contr_information30_o =>pay_con_shd.g_old_rec.contr_information30
316: ,p_object_version_number_o =>pay_con_shd.g_old_rec.object_version_number
317: );
318: --
319: exception

Line 316: ,p_object_version_number_o =>pay_con_shd.g_old_rec.object_version_number

312: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
313: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28
314: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29
315: ,p_contr_information30_o =>pay_con_shd.g_old_rec.contr_information30
316: ,p_object_version_number_o =>pay_con_shd.g_old_rec.object_version_number
317: );
318: --
319: exception
320: --

Line 378: Procedure convert_defs(p_rec in out pay_con_shd.g_rec_type) is

374: -- Internal Row Handler Use Only.
375: --
376: -- {End Of Comments}
377: -- ----------------------------------------------------------------------------
378: Procedure convert_defs(p_rec in out pay_con_shd.g_rec_type) is
379: --
380: l_proc varchar2(72) := g_package||'convert_defs';
381: --
382: Begin

Line 393: pay_con_shd.g_old_rec.person_id;

389: -- is being used then we must set to the 'current' argument value.
390: --
391: If (p_rec.person_id = hr_api.g_number) then
392: p_rec.person_id :=
393: pay_con_shd.g_old_rec.person_id;
394: End If;
395: If (p_rec.date_from = hr_api.g_date) then
396: p_rec.date_from :=
397: pay_con_shd.g_old_rec.date_from;

Line 397: pay_con_shd.g_old_rec.date_from;

393: pay_con_shd.g_old_rec.person_id;
394: End If;
395: If (p_rec.date_from = hr_api.g_date) then
396: p_rec.date_from :=
397: pay_con_shd.g_old_rec.date_from;
398: End If;
399: If (p_rec.date_to = hr_api.g_date) then
400: p_rec.date_to :=
401: pay_con_shd.g_old_rec.date_to;

Line 401: pay_con_shd.g_old_rec.date_to;

397: pay_con_shd.g_old_rec.date_from;
398: End If;
399: If (p_rec.date_to = hr_api.g_date) then
400: p_rec.date_to :=
401: pay_con_shd.g_old_rec.date_to;
402: End If;
403: If (p_rec.contr_type = hr_api.g_varchar2) then
404: p_rec.contr_type :=
405: pay_con_shd.g_old_rec.contr_type;

Line 405: pay_con_shd.g_old_rec.contr_type;

401: pay_con_shd.g_old_rec.date_to;
402: End If;
403: If (p_rec.contr_type = hr_api.g_varchar2) then
404: p_rec.contr_type :=
405: pay_con_shd.g_old_rec.contr_type;
406: End If;
407: If (p_rec.business_group_id = hr_api.g_number) then
408: p_rec.business_group_id :=
409: pay_con_shd.g_old_rec.business_group_id;

Line 409: pay_con_shd.g_old_rec.business_group_id;

405: pay_con_shd.g_old_rec.contr_type;
406: End If;
407: If (p_rec.business_group_id = hr_api.g_number) then
408: p_rec.business_group_id :=
409: pay_con_shd.g_old_rec.business_group_id;
410: End If;
411: If (p_rec.legislation_code = hr_api.g_varchar2) then
412: p_rec.legislation_code :=
413: pay_con_shd.g_old_rec.legislation_code;

Line 413: pay_con_shd.g_old_rec.legislation_code;

409: pay_con_shd.g_old_rec.business_group_id;
410: End If;
411: If (p_rec.legislation_code = hr_api.g_varchar2) then
412: p_rec.legislation_code :=
413: pay_con_shd.g_old_rec.legislation_code;
414: End If;
415: If (p_rec.amt_contr = hr_api.g_number) then
416: p_rec.amt_contr :=
417: pay_con_shd.g_old_rec.amt_contr;

Line 417: pay_con_shd.g_old_rec.amt_contr;

413: pay_con_shd.g_old_rec.legislation_code;
414: End If;
415: If (p_rec.amt_contr = hr_api.g_number) then
416: p_rec.amt_contr :=
417: pay_con_shd.g_old_rec.amt_contr;
418: End If;
419: If (p_rec.max_contr_allowed = hr_api.g_number) then
420: p_rec.max_contr_allowed :=
421: pay_con_shd.g_old_rec.max_contr_allowed;

Line 421: pay_con_shd.g_old_rec.max_contr_allowed;

417: pay_con_shd.g_old_rec.amt_contr;
418: End If;
419: If (p_rec.max_contr_allowed = hr_api.g_number) then
420: p_rec.max_contr_allowed :=
421: pay_con_shd.g_old_rec.max_contr_allowed;
422: End If;
423: If (p_rec.includable_comp = hr_api.g_number) then
424: p_rec.includable_comp :=
425: pay_con_shd.g_old_rec.includable_comp;

Line 425: pay_con_shd.g_old_rec.includable_comp;

421: pay_con_shd.g_old_rec.max_contr_allowed;
422: End If;
423: If (p_rec.includable_comp = hr_api.g_number) then
424: p_rec.includable_comp :=
425: pay_con_shd.g_old_rec.includable_comp;
426: End If;
427: If (p_rec.tax_unit_id = hr_api.g_number) then
428: p_rec.tax_unit_id :=
429: pay_con_shd.g_old_rec.tax_unit_id;

Line 429: pay_con_shd.g_old_rec.tax_unit_id;

425: pay_con_shd.g_old_rec.includable_comp;
426: End If;
427: If (p_rec.tax_unit_id = hr_api.g_number) then
428: p_rec.tax_unit_id :=
429: pay_con_shd.g_old_rec.tax_unit_id;
430: End If;
431: If (p_rec.source_system = hr_api.g_varchar2) then
432: p_rec.source_system :=
433: pay_con_shd.g_old_rec.source_system;

Line 433: pay_con_shd.g_old_rec.source_system;

429: pay_con_shd.g_old_rec.tax_unit_id;
430: End If;
431: If (p_rec.source_system = hr_api.g_varchar2) then
432: p_rec.source_system :=
433: pay_con_shd.g_old_rec.source_system;
434: End If;
435: If (p_rec.contr_information_category = hr_api.g_varchar2) then
436: p_rec.contr_information_category :=
437: pay_con_shd.g_old_rec.contr_information_category;

Line 437: pay_con_shd.g_old_rec.contr_information_category;

433: pay_con_shd.g_old_rec.source_system;
434: End If;
435: If (p_rec.contr_information_category = hr_api.g_varchar2) then
436: p_rec.contr_information_category :=
437: pay_con_shd.g_old_rec.contr_information_category;
438: End If;
439: If (p_rec.contr_information1 = hr_api.g_varchar2) then
440: p_rec.contr_information1 :=
441: pay_con_shd.g_old_rec.contr_information1;

Line 441: pay_con_shd.g_old_rec.contr_information1;

437: pay_con_shd.g_old_rec.contr_information_category;
438: End If;
439: If (p_rec.contr_information1 = hr_api.g_varchar2) then
440: p_rec.contr_information1 :=
441: pay_con_shd.g_old_rec.contr_information1;
442: End If;
443: If (p_rec.contr_information2 = hr_api.g_varchar2) then
444: p_rec.contr_information2 :=
445: pay_con_shd.g_old_rec.contr_information2;

Line 445: pay_con_shd.g_old_rec.contr_information2;

441: pay_con_shd.g_old_rec.contr_information1;
442: End If;
443: If (p_rec.contr_information2 = hr_api.g_varchar2) then
444: p_rec.contr_information2 :=
445: pay_con_shd.g_old_rec.contr_information2;
446: End If;
447: If (p_rec.contr_information3 = hr_api.g_varchar2) then
448: p_rec.contr_information3 :=
449: pay_con_shd.g_old_rec.contr_information3;

Line 449: pay_con_shd.g_old_rec.contr_information3;

445: pay_con_shd.g_old_rec.contr_information2;
446: End If;
447: If (p_rec.contr_information3 = hr_api.g_varchar2) then
448: p_rec.contr_information3 :=
449: pay_con_shd.g_old_rec.contr_information3;
450: End If;
451: If (p_rec.contr_information4 = hr_api.g_varchar2) then
452: p_rec.contr_information4 :=
453: pay_con_shd.g_old_rec.contr_information4;

Line 453: pay_con_shd.g_old_rec.contr_information4;

449: pay_con_shd.g_old_rec.contr_information3;
450: End If;
451: If (p_rec.contr_information4 = hr_api.g_varchar2) then
452: p_rec.contr_information4 :=
453: pay_con_shd.g_old_rec.contr_information4;
454: End If;
455: If (p_rec.contr_information5 = hr_api.g_varchar2) then
456: p_rec.contr_information5 :=
457: pay_con_shd.g_old_rec.contr_information5;

Line 457: pay_con_shd.g_old_rec.contr_information5;

453: pay_con_shd.g_old_rec.contr_information4;
454: End If;
455: If (p_rec.contr_information5 = hr_api.g_varchar2) then
456: p_rec.contr_information5 :=
457: pay_con_shd.g_old_rec.contr_information5;
458: End If;
459: If (p_rec.contr_information6 = hr_api.g_varchar2) then
460: p_rec.contr_information6 :=
461: pay_con_shd.g_old_rec.contr_information6;

Line 461: pay_con_shd.g_old_rec.contr_information6;

457: pay_con_shd.g_old_rec.contr_information5;
458: End If;
459: If (p_rec.contr_information6 = hr_api.g_varchar2) then
460: p_rec.contr_information6 :=
461: pay_con_shd.g_old_rec.contr_information6;
462: End If;
463: If (p_rec.contr_information7 = hr_api.g_varchar2) then
464: p_rec.contr_information7 :=
465: pay_con_shd.g_old_rec.contr_information7;

Line 465: pay_con_shd.g_old_rec.contr_information7;

461: pay_con_shd.g_old_rec.contr_information6;
462: End If;
463: If (p_rec.contr_information7 = hr_api.g_varchar2) then
464: p_rec.contr_information7 :=
465: pay_con_shd.g_old_rec.contr_information7;
466: End If;
467: If (p_rec.contr_information8 = hr_api.g_varchar2) then
468: p_rec.contr_information8 :=
469: pay_con_shd.g_old_rec.contr_information8;

Line 469: pay_con_shd.g_old_rec.contr_information8;

465: pay_con_shd.g_old_rec.contr_information7;
466: End If;
467: If (p_rec.contr_information8 = hr_api.g_varchar2) then
468: p_rec.contr_information8 :=
469: pay_con_shd.g_old_rec.contr_information8;
470: End If;
471: If (p_rec.contr_information9 = hr_api.g_varchar2) then
472: p_rec.contr_information9 :=
473: pay_con_shd.g_old_rec.contr_information9;

Line 473: pay_con_shd.g_old_rec.contr_information9;

469: pay_con_shd.g_old_rec.contr_information8;
470: End If;
471: If (p_rec.contr_information9 = hr_api.g_varchar2) then
472: p_rec.contr_information9 :=
473: pay_con_shd.g_old_rec.contr_information9;
474: End If;
475: If (p_rec.contr_information10 = hr_api.g_varchar2) then
476: p_rec.contr_information10 :=
477: pay_con_shd.g_old_rec.contr_information10;

Line 477: pay_con_shd.g_old_rec.contr_information10;

473: pay_con_shd.g_old_rec.contr_information9;
474: End If;
475: If (p_rec.contr_information10 = hr_api.g_varchar2) then
476: p_rec.contr_information10 :=
477: pay_con_shd.g_old_rec.contr_information10;
478: End If;
479: If (p_rec.contr_information11 = hr_api.g_varchar2) then
480: p_rec.contr_information11 :=
481: pay_con_shd.g_old_rec.contr_information11;

Line 481: pay_con_shd.g_old_rec.contr_information11;

477: pay_con_shd.g_old_rec.contr_information10;
478: End If;
479: If (p_rec.contr_information11 = hr_api.g_varchar2) then
480: p_rec.contr_information11 :=
481: pay_con_shd.g_old_rec.contr_information11;
482: End If;
483: If (p_rec.contr_information12 = hr_api.g_varchar2) then
484: p_rec.contr_information12 :=
485: pay_con_shd.g_old_rec.contr_information12;

Line 485: pay_con_shd.g_old_rec.contr_information12;

481: pay_con_shd.g_old_rec.contr_information11;
482: End If;
483: If (p_rec.contr_information12 = hr_api.g_varchar2) then
484: p_rec.contr_information12 :=
485: pay_con_shd.g_old_rec.contr_information12;
486: End If;
487: If (p_rec.contr_information13 = hr_api.g_varchar2) then
488: p_rec.contr_information13 :=
489: pay_con_shd.g_old_rec.contr_information13;

Line 489: pay_con_shd.g_old_rec.contr_information13;

485: pay_con_shd.g_old_rec.contr_information12;
486: End If;
487: If (p_rec.contr_information13 = hr_api.g_varchar2) then
488: p_rec.contr_information13 :=
489: pay_con_shd.g_old_rec.contr_information13;
490: End If;
491: If (p_rec.contr_information14 = hr_api.g_varchar2) then
492: p_rec.contr_information14 :=
493: pay_con_shd.g_old_rec.contr_information14;

Line 493: pay_con_shd.g_old_rec.contr_information14;

489: pay_con_shd.g_old_rec.contr_information13;
490: End If;
491: If (p_rec.contr_information14 = hr_api.g_varchar2) then
492: p_rec.contr_information14 :=
493: pay_con_shd.g_old_rec.contr_information14;
494: End If;
495: If (p_rec.contr_information15 = hr_api.g_varchar2) then
496: p_rec.contr_information15 :=
497: pay_con_shd.g_old_rec.contr_information15;

Line 497: pay_con_shd.g_old_rec.contr_information15;

493: pay_con_shd.g_old_rec.contr_information14;
494: End If;
495: If (p_rec.contr_information15 = hr_api.g_varchar2) then
496: p_rec.contr_information15 :=
497: pay_con_shd.g_old_rec.contr_information15;
498: End If;
499: If (p_rec.contr_information16 = hr_api.g_varchar2) then
500: p_rec.contr_information16 :=
501: pay_con_shd.g_old_rec.contr_information16;

Line 501: pay_con_shd.g_old_rec.contr_information16;

497: pay_con_shd.g_old_rec.contr_information15;
498: End If;
499: If (p_rec.contr_information16 = hr_api.g_varchar2) then
500: p_rec.contr_information16 :=
501: pay_con_shd.g_old_rec.contr_information16;
502: End If;
503: If (p_rec.contr_information17 = hr_api.g_varchar2) then
504: p_rec.contr_information17 :=
505: pay_con_shd.g_old_rec.contr_information17;

Line 505: pay_con_shd.g_old_rec.contr_information17;

501: pay_con_shd.g_old_rec.contr_information16;
502: End If;
503: If (p_rec.contr_information17 = hr_api.g_varchar2) then
504: p_rec.contr_information17 :=
505: pay_con_shd.g_old_rec.contr_information17;
506: End If;
507: If (p_rec.contr_information18 = hr_api.g_varchar2) then
508: p_rec.contr_information18 :=
509: pay_con_shd.g_old_rec.contr_information18;

Line 509: pay_con_shd.g_old_rec.contr_information18;

505: pay_con_shd.g_old_rec.contr_information17;
506: End If;
507: If (p_rec.contr_information18 = hr_api.g_varchar2) then
508: p_rec.contr_information18 :=
509: pay_con_shd.g_old_rec.contr_information18;
510: End If;
511: If (p_rec.contr_information19 = hr_api.g_varchar2) then
512: p_rec.contr_information19 :=
513: pay_con_shd.g_old_rec.contr_information19;

Line 513: pay_con_shd.g_old_rec.contr_information19;

509: pay_con_shd.g_old_rec.contr_information18;
510: End If;
511: If (p_rec.contr_information19 = hr_api.g_varchar2) then
512: p_rec.contr_information19 :=
513: pay_con_shd.g_old_rec.contr_information19;
514: End If;
515: If (p_rec.contr_information20 = hr_api.g_varchar2) then
516: p_rec.contr_information20 :=
517: pay_con_shd.g_old_rec.contr_information20;

Line 517: pay_con_shd.g_old_rec.contr_information20;

513: pay_con_shd.g_old_rec.contr_information19;
514: End If;
515: If (p_rec.contr_information20 = hr_api.g_varchar2) then
516: p_rec.contr_information20 :=
517: pay_con_shd.g_old_rec.contr_information20;
518: End If;
519: If (p_rec.contr_information21 = hr_api.g_varchar2) then
520: p_rec.contr_information21 :=
521: pay_con_shd.g_old_rec.contr_information21;

Line 521: pay_con_shd.g_old_rec.contr_information21;

517: pay_con_shd.g_old_rec.contr_information20;
518: End If;
519: If (p_rec.contr_information21 = hr_api.g_varchar2) then
520: p_rec.contr_information21 :=
521: pay_con_shd.g_old_rec.contr_information21;
522: End If;
523: If (p_rec.contr_information22 = hr_api.g_varchar2) then
524: p_rec.contr_information22 :=
525: pay_con_shd.g_old_rec.contr_information22;

Line 525: pay_con_shd.g_old_rec.contr_information22;

521: pay_con_shd.g_old_rec.contr_information21;
522: End If;
523: If (p_rec.contr_information22 = hr_api.g_varchar2) then
524: p_rec.contr_information22 :=
525: pay_con_shd.g_old_rec.contr_information22;
526: End If;
527: If (p_rec.contr_information23 = hr_api.g_varchar2) then
528: p_rec.contr_information23 :=
529: pay_con_shd.g_old_rec.contr_information23;

Line 529: pay_con_shd.g_old_rec.contr_information23;

525: pay_con_shd.g_old_rec.contr_information22;
526: End If;
527: If (p_rec.contr_information23 = hr_api.g_varchar2) then
528: p_rec.contr_information23 :=
529: pay_con_shd.g_old_rec.contr_information23;
530: End If;
531: If (p_rec.contr_information24 = hr_api.g_varchar2) then
532: p_rec.contr_information24 :=
533: pay_con_shd.g_old_rec.contr_information24;

Line 533: pay_con_shd.g_old_rec.contr_information24;

529: pay_con_shd.g_old_rec.contr_information23;
530: End If;
531: If (p_rec.contr_information24 = hr_api.g_varchar2) then
532: p_rec.contr_information24 :=
533: pay_con_shd.g_old_rec.contr_information24;
534: End If;
535: If (p_rec.contr_information25 = hr_api.g_varchar2) then
536: p_rec.contr_information25 :=
537: pay_con_shd.g_old_rec.contr_information25;

Line 537: pay_con_shd.g_old_rec.contr_information25;

533: pay_con_shd.g_old_rec.contr_information24;
534: End If;
535: If (p_rec.contr_information25 = hr_api.g_varchar2) then
536: p_rec.contr_information25 :=
537: pay_con_shd.g_old_rec.contr_information25;
538: End If;
539: If (p_rec.contr_information26 = hr_api.g_varchar2) then
540: p_rec.contr_information26 :=
541: pay_con_shd.g_old_rec.contr_information26;

Line 541: pay_con_shd.g_old_rec.contr_information26;

537: pay_con_shd.g_old_rec.contr_information25;
538: End If;
539: If (p_rec.contr_information26 = hr_api.g_varchar2) then
540: p_rec.contr_information26 :=
541: pay_con_shd.g_old_rec.contr_information26;
542: End If;
543: If (p_rec.contr_information27 = hr_api.g_varchar2) then
544: p_rec.contr_information27 :=
545: pay_con_shd.g_old_rec.contr_information27;

Line 545: pay_con_shd.g_old_rec.contr_information27;

541: pay_con_shd.g_old_rec.contr_information26;
542: End If;
543: If (p_rec.contr_information27 = hr_api.g_varchar2) then
544: p_rec.contr_information27 :=
545: pay_con_shd.g_old_rec.contr_information27;
546: End If;
547: If (p_rec.contr_information28 = hr_api.g_varchar2) then
548: p_rec.contr_information28 :=
549: pay_con_shd.g_old_rec.contr_information28;

Line 549: pay_con_shd.g_old_rec.contr_information28;

545: pay_con_shd.g_old_rec.contr_information27;
546: End If;
547: If (p_rec.contr_information28 = hr_api.g_varchar2) then
548: p_rec.contr_information28 :=
549: pay_con_shd.g_old_rec.contr_information28;
550: End If;
551: If (p_rec.contr_information29 = hr_api.g_varchar2) then
552: p_rec.contr_information29 :=
553: pay_con_shd.g_old_rec.contr_information29;

Line 553: pay_con_shd.g_old_rec.contr_information29;

549: pay_con_shd.g_old_rec.contr_information28;
550: End If;
551: If (p_rec.contr_information29 = hr_api.g_varchar2) then
552: p_rec.contr_information29 :=
553: pay_con_shd.g_old_rec.contr_information29;
554: End If;
555: If (p_rec.contr_information30 = hr_api.g_varchar2) then
556: p_rec.contr_information30 :=
557: pay_con_shd.g_old_rec.contr_information30;

Line 557: pay_con_shd.g_old_rec.contr_information30;

553: pay_con_shd.g_old_rec.contr_information29;
554: End If;
555: If (p_rec.contr_information30 = hr_api.g_varchar2) then
556: p_rec.contr_information30 :=
557: pay_con_shd.g_old_rec.contr_information30;
558: End If;
559:
560: --
561: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 570: p_rec in out pay_con_shd.g_rec_type

566: -- |---------------------------------< upd >----------------------------------|
567: -- ----------------------------------------------------------------------------
568: Procedure upd
569: (
570: p_rec in out pay_con_shd.g_rec_type
571: ) is
572: --
573: l_proc varchar2(72) := g_package||'upd';
574: --

Line 580: pay_con_shd.lck

576: hr_utility.set_location('Entering:'||l_proc, 5);
577: --
578: -- We must lock the row which we need to update.
579: --
580: pay_con_shd.lck
581: (
582: p_rec.contr_history_id,
583: p_rec.object_version_number
584: );

Line 659: l_rec pay_con_shd.g_rec_type;

655: p_contr_information30 in varchar2 default hr_api.g_varchar2,
656: p_object_version_number in out number
657: ) is
658: --
659: l_rec pay_con_shd.g_rec_type;
660: l_proc varchar2(72) := g_package||'upd';
661: --
662: Begin
663: hr_utility.set_location('Entering:'||l_proc, 5);

Line 669: pay_con_shd.convert_args

665: -- Call conversion function to turn arguments into the
666: -- l_rec structure.
667: --
668: l_rec :=
669: pay_con_shd.convert_args
670: (
671: p_contr_history_id,
672: p_person_id,
673: p_date_from,