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_SPR_DEL dependencies on PAY_SPR_SHD

Line 52: (p_rec in pay_spr_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in pay_spr_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 60: pay_spr_shd.g_api_dml := true; -- Set the api dml status

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

Line 68: pay_spr_shd.g_api_dml := false; -- Unset the api dml status

64: delete from pay_security_payrolls
65: where security_profile_id = p_rec.security_profile_id
66: and payroll_id = p_rec.payroll_id;
67: --
68: pay_spr_shd.g_api_dml := false; -- Unset the api dml status
69: --
70: hr_utility.set_location(' Leaving:'||l_proc, 10);
71: --
72: Exception

Line 75: pay_spr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 76: pay_spr_shd.constraint_error

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

Line 79: pay_spr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 115: Procedure pre_delete(p_rec in pay_spr_shd.g_rec_type) is

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

Line 157: Procedure post_delete(p_rec in pay_spr_shd.g_rec_type) is

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

Line 180: => pay_spr_shd.g_old_rec.business_group_id

176: => p_rec.security_profile_id
177: ,p_payroll_id
178: => p_rec.payroll_id
179: ,p_business_group_id_o
180: => pay_spr_shd.g_old_rec.business_group_id
181: ,p_request_id_o
182: => pay_spr_shd.g_old_rec.request_id
183: ,p_program_application_id_o
184: => pay_spr_shd.g_old_rec.program_application_id

Line 182: => pay_spr_shd.g_old_rec.request_id

178: => p_rec.payroll_id
179: ,p_business_group_id_o
180: => pay_spr_shd.g_old_rec.business_group_id
181: ,p_request_id_o
182: => pay_spr_shd.g_old_rec.request_id
183: ,p_program_application_id_o
184: => pay_spr_shd.g_old_rec.program_application_id
185: ,p_program_id_o
186: => pay_spr_shd.g_old_rec.program_id

Line 184: => pay_spr_shd.g_old_rec.program_application_id

180: => pay_spr_shd.g_old_rec.business_group_id
181: ,p_request_id_o
182: => pay_spr_shd.g_old_rec.request_id
183: ,p_program_application_id_o
184: => pay_spr_shd.g_old_rec.program_application_id
185: ,p_program_id_o
186: => pay_spr_shd.g_old_rec.program_id
187: ,p_program_update_date_o
188: => pay_spr_shd.g_old_rec.program_update_date

Line 186: => pay_spr_shd.g_old_rec.program_id

182: => pay_spr_shd.g_old_rec.request_id
183: ,p_program_application_id_o
184: => pay_spr_shd.g_old_rec.program_application_id
185: ,p_program_id_o
186: => pay_spr_shd.g_old_rec.program_id
187: ,p_program_update_date_o
188: => pay_spr_shd.g_old_rec.program_update_date
189: ,p_object_version_number_o
190: => pay_spr_shd.g_old_rec.object_version_number

Line 188: => pay_spr_shd.g_old_rec.program_update_date

184: => pay_spr_shd.g_old_rec.program_application_id
185: ,p_program_id_o
186: => pay_spr_shd.g_old_rec.program_id
187: ,p_program_update_date_o
188: => pay_spr_shd.g_old_rec.program_update_date
189: ,p_object_version_number_o
190: => pay_spr_shd.g_old_rec.object_version_number
191: );
192: --

Line 190: => pay_spr_shd.g_old_rec.object_version_number

186: => pay_spr_shd.g_old_rec.program_id
187: ,p_program_update_date_o
188: => pay_spr_shd.g_old_rec.program_update_date
189: ,p_object_version_number_o
190: => pay_spr_shd.g_old_rec.object_version_number
191: );
192: --
193: exception
194: --

Line 210: (p_rec in pay_spr_shd.g_rec_type

206: -- ----------------------------------------------------------------------------
207: -- |---------------------------------< del >----------------------------------|
208: -- ----------------------------------------------------------------------------
209: Procedure del
210: (p_rec in pay_spr_shd.g_rec_type
211: ) is
212: --
213: l_proc varchar2(72) := g_package||'del';
214: --

Line 220: pay_spr_shd.lck

216: hr_utility.set_location('Entering:'||l_proc, 5);
217: --
218: -- We must lock the row which we need to delete.
219: --
220: pay_spr_shd.lck
221: (p_rec.security_profile_id
222: ,p_rec.payroll_id
223: ,p_rec.object_version_number
224: );

Line 259: l_rec pay_spr_shd.g_rec_type;

255: ,p_payroll_id in number
256: ,p_object_version_number in number
257: ) is
258: --
259: l_rec pay_spr_shd.g_rec_type;
260: l_proc varchar2(72) := g_package||'del';
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);