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_PWA_DEL dependencies on PAY_PWA_SHD

Line 51: Procedure delete_dml(p_rec in pay_pwa_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_pwa_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 58: pay_pwa_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_pwa_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the pay_wci_accounts row.
61: --
62: delete from pay_wci_accounts

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

61: --
62: delete from pay_wci_accounts
63: where account_id = p_rec.account_id;
64: --
65: pay_pwa_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_pwa_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_pwa_shd.g_api_dml := false; -- Unset the api dml status
73: pay_pwa_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status

Line 73: pay_pwa_shd.constraint_error

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

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

72: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status
73: pay_pwa_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: pay_pwa_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_pwa_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_pwa_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_pwa_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_pwa_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin

Line 169: ,p_business_group_id_o =>pay_pwa_shd.g_old_rec.business_group_id

165: --
166: pay_pwa_rkd.after_delete
167: (
168: p_account_id =>p_rec.account_id
169: ,p_business_group_id_o =>pay_pwa_shd.g_old_rec.business_group_id
170: ,p_carrier_id_o =>pay_pwa_shd.g_old_rec.carrier_id
171: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id
172: ,p_name_o =>pay_pwa_shd.g_old_rec.name
173: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number

Line 170: ,p_carrier_id_o =>pay_pwa_shd.g_old_rec.carrier_id

166: pay_pwa_rkd.after_delete
167: (
168: p_account_id =>p_rec.account_id
169: ,p_business_group_id_o =>pay_pwa_shd.g_old_rec.business_group_id
170: ,p_carrier_id_o =>pay_pwa_shd.g_old_rec.carrier_id
171: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id
172: ,p_name_o =>pay_pwa_shd.g_old_rec.name
173: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number
174: ,p_comments_o =>pay_pwa_shd.g_old_rec.comments

Line 171: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id

167: (
168: p_account_id =>p_rec.account_id
169: ,p_business_group_id_o =>pay_pwa_shd.g_old_rec.business_group_id
170: ,p_carrier_id_o =>pay_pwa_shd.g_old_rec.carrier_id
171: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id
172: ,p_name_o =>pay_pwa_shd.g_old_rec.name
173: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number
174: ,p_comments_o =>pay_pwa_shd.g_old_rec.comments
175: ,p_object_version_number_o =>pay_pwa_shd.g_old_rec.object_version_number

Line 172: ,p_name_o =>pay_pwa_shd.g_old_rec.name

168: p_account_id =>p_rec.account_id
169: ,p_business_group_id_o =>pay_pwa_shd.g_old_rec.business_group_id
170: ,p_carrier_id_o =>pay_pwa_shd.g_old_rec.carrier_id
171: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id
172: ,p_name_o =>pay_pwa_shd.g_old_rec.name
173: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number
174: ,p_comments_o =>pay_pwa_shd.g_old_rec.comments
175: ,p_object_version_number_o =>pay_pwa_shd.g_old_rec.object_version_number
176: );

Line 173: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number

169: ,p_business_group_id_o =>pay_pwa_shd.g_old_rec.business_group_id
170: ,p_carrier_id_o =>pay_pwa_shd.g_old_rec.carrier_id
171: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id
172: ,p_name_o =>pay_pwa_shd.g_old_rec.name
173: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number
174: ,p_comments_o =>pay_pwa_shd.g_old_rec.comments
175: ,p_object_version_number_o =>pay_pwa_shd.g_old_rec.object_version_number
176: );
177: --

Line 174: ,p_comments_o =>pay_pwa_shd.g_old_rec.comments

170: ,p_carrier_id_o =>pay_pwa_shd.g_old_rec.carrier_id
171: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id
172: ,p_name_o =>pay_pwa_shd.g_old_rec.name
173: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number
174: ,p_comments_o =>pay_pwa_shd.g_old_rec.comments
175: ,p_object_version_number_o =>pay_pwa_shd.g_old_rec.object_version_number
176: );
177: --
178: exception

Line 175: ,p_object_version_number_o =>pay_pwa_shd.g_old_rec.object_version_number

171: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id
172: ,p_name_o =>pay_pwa_shd.g_old_rec.name
173: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number
174: ,p_comments_o =>pay_pwa_shd.g_old_rec.comments
175: ,p_object_version_number_o =>pay_pwa_shd.g_old_rec.object_version_number
176: );
177: --
178: exception
179: --

Line 199: p_rec in pay_pwa_shd.g_rec_type

195: -- |---------------------------------< del >----------------------------------|
196: -- ----------------------------------------------------------------------------
197: Procedure del
198: (
199: p_rec in pay_pwa_shd.g_rec_type
200: ) is
201: --
202: l_proc varchar2(72) := g_package||'del';
203: --

Line 209: pay_pwa_shd.lck

205: hr_utility.set_location('Entering:'||l_proc, 5);
206: --
207: -- We must lock the row which we need to delete.
208: --
209: pay_pwa_shd.lck
210: (
211: p_rec.account_id,
212: p_rec.object_version_number
213: );

Line 241: l_rec pay_pwa_shd.g_rec_type;

237: p_account_id in number,
238: p_object_version_number in number
239: ) is
240: --
241: l_rec pay_pwa_shd.g_rec_type;
242: l_proc varchar2(72) := g_package||'del';
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);