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_DEL dependencies on PAY_CON_SHD

Line 51: Procedure delete_dml(p_rec in pay_con_shd.g_rec_type) is

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

Line 58: pay_con_shd.g_api_dml := true; -- Set the api dml status

54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: pay_con_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the pay_us_contribution_history row.
61: --
62: delete from pay_us_contribution_history

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

61: --
62: delete from pay_us_contribution_history
63: where contr_history_id = p_rec.contr_history_id;
64: --
65: pay_con_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception

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

68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: pay_con_shd.g_api_dml := false; -- Unset the api dml status
73: pay_con_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: pay_con_shd.g_api_dml := false; -- Unset the api dml status

Line 73: pay_con_shd.constraint_error

69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: pay_con_shd.g_api_dml := false; -- Unset the api dml status
73: pay_con_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: pay_con_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;

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

72: pay_con_shd.g_api_dml := false; -- Unset the api dml status
73: pay_con_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: pay_con_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in pay_con_shd.g_rec_type) is

108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in pay_con_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin

Line 154: Procedure post_delete(p_rec in pay_con_shd.g_rec_type) is

150: -- Internal table Handler Use Only.
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(p_rec in pay_con_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin

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

165: --
166: pay_con_rkd.after_delete
167: (
168: p_contr_history_id =>p_rec.contr_history_id
169: ,p_person_id_o =>pay_con_shd.g_old_rec.person_id
170: ,p_date_from_o =>pay_con_shd.g_old_rec.date_from
171: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to
172: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
173: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id

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

166: pay_con_rkd.after_delete
167: (
168: p_contr_history_id =>p_rec.contr_history_id
169: ,p_person_id_o =>pay_con_shd.g_old_rec.person_id
170: ,p_date_from_o =>pay_con_shd.g_old_rec.date_from
171: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to
172: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
173: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
174: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code

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

167: (
168: p_contr_history_id =>p_rec.contr_history_id
169: ,p_person_id_o =>pay_con_shd.g_old_rec.person_id
170: ,p_date_from_o =>pay_con_shd.g_old_rec.date_from
171: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to
172: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
173: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
174: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
175: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr

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

168: p_contr_history_id =>p_rec.contr_history_id
169: ,p_person_id_o =>pay_con_shd.g_old_rec.person_id
170: ,p_date_from_o =>pay_con_shd.g_old_rec.date_from
171: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to
172: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
173: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
174: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
175: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
176: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed

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

169: ,p_person_id_o =>pay_con_shd.g_old_rec.person_id
170: ,p_date_from_o =>pay_con_shd.g_old_rec.date_from
171: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to
172: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
173: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
174: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
175: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
176: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
177: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp

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

170: ,p_date_from_o =>pay_con_shd.g_old_rec.date_from
171: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to
172: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
173: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
174: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
175: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
176: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
177: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
178: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id

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

171: ,p_date_to_o =>pay_con_shd.g_old_rec.date_to
172: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
173: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
174: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
175: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
176: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
177: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
178: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
179: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system

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

172: ,p_contr_type_o =>pay_con_shd.g_old_rec.contr_type
173: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
174: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
175: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
176: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
177: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
178: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
179: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
180: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category

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

173: ,p_business_group_id_o =>pay_con_shd.g_old_rec.business_group_id
174: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
175: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
176: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
177: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
178: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
179: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
180: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
181: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1

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

174: ,p_legislation_code_o =>pay_con_shd.g_old_rec.legislation_code
175: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
176: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
177: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
178: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
179: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
180: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
181: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
182: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2

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

175: ,p_amt_contr_o =>pay_con_shd.g_old_rec.amt_contr
176: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
177: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
178: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
179: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
180: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
181: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
182: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
183: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3

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

176: ,p_max_contr_allowed_o =>pay_con_shd.g_old_rec.max_contr_allowed
177: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
178: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
179: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
180: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
181: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
182: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
183: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
184: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4

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

177: ,p_includable_comp_o =>pay_con_shd.g_old_rec.includable_comp
178: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
179: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
180: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
181: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
182: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
183: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
184: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
185: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5

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

178: ,p_tax_unit_id_o =>pay_con_shd.g_old_rec.tax_unit_id
179: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
180: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
181: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
182: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
183: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
184: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
185: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
186: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6

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

179: ,p_source_system_o =>pay_con_shd.g_old_rec.source_system
180: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
181: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
182: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
183: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
184: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
185: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
186: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
187: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7

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

180: ,p_contr_information_category_o =>pay_con_shd.g_old_rec.contr_information_category
181: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
182: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
183: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
184: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
185: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
186: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
187: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
188: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8

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

181: ,p_contr_information1_o =>pay_con_shd.g_old_rec.contr_information1
182: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
183: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
184: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
185: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
186: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
187: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
188: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
189: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9

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

182: ,p_contr_information2_o =>pay_con_shd.g_old_rec.contr_information2
183: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
184: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
185: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
186: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
187: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
188: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
189: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
190: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10

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

183: ,p_contr_information3_o =>pay_con_shd.g_old_rec.contr_information3
184: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
185: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
186: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
187: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
188: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
189: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
190: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
191: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11

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

184: ,p_contr_information4_o =>pay_con_shd.g_old_rec.contr_information4
185: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
186: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
187: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
188: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
189: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
190: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
191: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
192: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12

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

185: ,p_contr_information5_o =>pay_con_shd.g_old_rec.contr_information5
186: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
187: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
188: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
189: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
190: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
191: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
192: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
193: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13

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

186: ,p_contr_information6_o =>pay_con_shd.g_old_rec.contr_information6
187: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
188: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
189: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
190: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
191: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
192: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
193: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
194: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14

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

187: ,p_contr_information7_o =>pay_con_shd.g_old_rec.contr_information7
188: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
189: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
190: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
191: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
192: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
193: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
194: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
195: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15

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

188: ,p_contr_information8_o =>pay_con_shd.g_old_rec.contr_information8
189: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
190: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
191: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
192: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
193: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
194: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
195: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
196: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16

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

189: ,p_contr_information9_o =>pay_con_shd.g_old_rec.contr_information9
190: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
191: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
192: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
193: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
194: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
195: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
196: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
197: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17

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

190: ,p_contr_information10_o =>pay_con_shd.g_old_rec.contr_information10
191: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
192: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
193: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
194: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
195: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
196: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
197: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
198: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18

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

191: ,p_contr_information11_o =>pay_con_shd.g_old_rec.contr_information11
192: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
193: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
194: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
195: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
196: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
197: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
198: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
199: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19

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

192: ,p_contr_information12_o =>pay_con_shd.g_old_rec.contr_information12
193: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
194: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
195: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
196: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
197: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
198: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
199: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
200: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20

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

193: ,p_contr_information13_o =>pay_con_shd.g_old_rec.contr_information13
194: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
195: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
196: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
197: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
198: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
199: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
200: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
201: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21

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

194: ,p_contr_information14_o =>pay_con_shd.g_old_rec.contr_information14
195: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
196: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
197: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
198: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
199: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
200: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
201: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
202: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22

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

195: ,p_contr_information15_o =>pay_con_shd.g_old_rec.contr_information15
196: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
197: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
198: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
199: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
200: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
201: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
202: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
203: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23

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

196: ,p_contr_information16_o =>pay_con_shd.g_old_rec.contr_information16
197: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
198: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
199: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
200: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
201: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
202: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
203: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
204: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24

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

197: ,p_contr_information17_o =>pay_con_shd.g_old_rec.contr_information17
198: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
199: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
200: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
201: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
202: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
203: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
204: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
205: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25

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

198: ,p_contr_information18_o =>pay_con_shd.g_old_rec.contr_information18
199: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
200: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
201: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
202: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
203: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
204: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
205: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
206: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26

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

199: ,p_contr_information19_o =>pay_con_shd.g_old_rec.contr_information19
200: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
201: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
202: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
203: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
204: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
205: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
206: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
207: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27

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

200: ,p_contr_information20_o =>pay_con_shd.g_old_rec.contr_information20
201: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
202: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
203: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
204: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
205: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
206: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
207: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
208: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28

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

201: ,p_contr_information21_o =>pay_con_shd.g_old_rec.contr_information21
202: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
203: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
204: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
205: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
206: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
207: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
208: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28
209: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29

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

202: ,p_contr_information22_o =>pay_con_shd.g_old_rec.contr_information22
203: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
204: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
205: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
206: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
207: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
208: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28
209: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29
210: ,p_contr_information30_o =>pay_con_shd.g_old_rec.contr_information30

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

203: ,p_contr_information23_o =>pay_con_shd.g_old_rec.contr_information23
204: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
205: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
206: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
207: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
208: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28
209: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29
210: ,p_contr_information30_o =>pay_con_shd.g_old_rec.contr_information30
211: ,p_object_version_number_o =>pay_con_shd.g_old_rec.object_version_number

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

204: ,p_contr_information24_o =>pay_con_shd.g_old_rec.contr_information24
205: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
206: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
207: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
208: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28
209: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29
210: ,p_contr_information30_o =>pay_con_shd.g_old_rec.contr_information30
211: ,p_object_version_number_o =>pay_con_shd.g_old_rec.object_version_number
212: );

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

205: ,p_contr_information25_o =>pay_con_shd.g_old_rec.contr_information25
206: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
207: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
208: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28
209: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29
210: ,p_contr_information30_o =>pay_con_shd.g_old_rec.contr_information30
211: ,p_object_version_number_o =>pay_con_shd.g_old_rec.object_version_number
212: );
213: --

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

206: ,p_contr_information26_o =>pay_con_shd.g_old_rec.contr_information26
207: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
208: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28
209: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29
210: ,p_contr_information30_o =>pay_con_shd.g_old_rec.contr_information30
211: ,p_object_version_number_o =>pay_con_shd.g_old_rec.object_version_number
212: );
213: --
214: exception

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

207: ,p_contr_information27_o =>pay_con_shd.g_old_rec.contr_information27
208: ,p_contr_information28_o =>pay_con_shd.g_old_rec.contr_information28
209: ,p_contr_information29_o =>pay_con_shd.g_old_rec.contr_information29
210: ,p_contr_information30_o =>pay_con_shd.g_old_rec.contr_information30
211: ,p_object_version_number_o =>pay_con_shd.g_old_rec.object_version_number
212: );
213: --
214: exception
215: --

Line 235: p_rec in pay_con_shd.g_rec_type

231: -- |---------------------------------< del >----------------------------------|
232: -- ----------------------------------------------------------------------------
233: Procedure del
234: (
235: p_rec in pay_con_shd.g_rec_type
236: ) is
237: --
238: l_proc varchar2(72) := g_package||'del';
239: --

Line 245: pay_con_shd.lck

241: hr_utility.set_location('Entering:'||l_proc, 5);
242: --
243: -- We must lock the row which we need to delete.
244: --
245: pay_con_shd.lck
246: (
247: p_rec.contr_history_id,
248: p_rec.object_version_number
249: );

Line 277: l_rec pay_con_shd.g_rec_type;

273: p_contr_history_id in number,
274: p_object_version_number in number
275: ) is
276: --
277: l_rec pay_con_shd.g_rec_type;
278: l_proc varchar2(72) := g_package||'del';
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);