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

Line 54: Procedure update_dml(p_rec in out nocopy pay_pwa_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 nocopy pay_pwa_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin

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

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

75: comments = p_rec.comments,
76: object_version_number = p_rec.object_version_number
77: where account_id = p_rec.account_id;
78: --
79: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: Exception

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

82: --
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status
87: pay_pwa_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated

Line 87: pay_pwa_shd.constraint_error

83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status
87: pay_pwa_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status

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

87: pay_pwa_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status
92: pay_pwa_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated

Line 92: pay_pwa_shd.constraint_error

88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status
92: pay_pwa_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status

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

92: pay_pwa_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status
97: pay_pwa_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status

Line 97: pay_pwa_shd.constraint_error

93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status
97: pay_pwa_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;

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

96: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status
97: pay_pwa_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: pay_pwa_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;
102: End update_dml;
103: --
104: -- ----------------------------------------------------------------------------

Line 136: Procedure pre_update(p_rec in pay_pwa_shd.g_rec_type) is

132: -- Internal Row Handler Use Only.
133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_update(p_rec in pay_pwa_shd.g_rec_type) is
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin

Line 178: Procedure post_update(p_rec in pay_pwa_shd.g_rec_type) is

174: -- Internal Row Handler Use Only.
175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure post_update(p_rec in pay_pwa_shd.g_rec_type) is
179: --
180: l_proc varchar2(72) := g_package||'post_update';
181: --
182: Begin

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

196: ,p_name =>p_rec.name
197: ,p_account_number =>p_rec.account_number
198: ,p_comments =>p_rec.comments
199: ,p_object_version_number =>p_rec.object_version_number
200: ,p_business_group_id_o =>pay_pwa_shd.g_old_rec.business_group_id
201: ,p_carrier_id_o =>pay_pwa_shd.g_old_rec.carrier_id
202: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id
203: ,p_name_o =>pay_pwa_shd.g_old_rec.name
204: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number

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

197: ,p_account_number =>p_rec.account_number
198: ,p_comments =>p_rec.comments
199: ,p_object_version_number =>p_rec.object_version_number
200: ,p_business_group_id_o =>pay_pwa_shd.g_old_rec.business_group_id
201: ,p_carrier_id_o =>pay_pwa_shd.g_old_rec.carrier_id
202: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id
203: ,p_name_o =>pay_pwa_shd.g_old_rec.name
204: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number
205: ,p_comments_o =>pay_pwa_shd.g_old_rec.comments

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

198: ,p_comments =>p_rec.comments
199: ,p_object_version_number =>p_rec.object_version_number
200: ,p_business_group_id_o =>pay_pwa_shd.g_old_rec.business_group_id
201: ,p_carrier_id_o =>pay_pwa_shd.g_old_rec.carrier_id
202: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id
203: ,p_name_o =>pay_pwa_shd.g_old_rec.name
204: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number
205: ,p_comments_o =>pay_pwa_shd.g_old_rec.comments
206: ,p_object_version_number_o =>pay_pwa_shd.g_old_rec.object_version_number

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

199: ,p_object_version_number =>p_rec.object_version_number
200: ,p_business_group_id_o =>pay_pwa_shd.g_old_rec.business_group_id
201: ,p_carrier_id_o =>pay_pwa_shd.g_old_rec.carrier_id
202: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id
203: ,p_name_o =>pay_pwa_shd.g_old_rec.name
204: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number
205: ,p_comments_o =>pay_pwa_shd.g_old_rec.comments
206: ,p_object_version_number_o =>pay_pwa_shd.g_old_rec.object_version_number
207: );

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

200: ,p_business_group_id_o =>pay_pwa_shd.g_old_rec.business_group_id
201: ,p_carrier_id_o =>pay_pwa_shd.g_old_rec.carrier_id
202: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id
203: ,p_name_o =>pay_pwa_shd.g_old_rec.name
204: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number
205: ,p_comments_o =>pay_pwa_shd.g_old_rec.comments
206: ,p_object_version_number_o =>pay_pwa_shd.g_old_rec.object_version_number
207: );
208: --

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

201: ,p_carrier_id_o =>pay_pwa_shd.g_old_rec.carrier_id
202: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id
203: ,p_name_o =>pay_pwa_shd.g_old_rec.name
204: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number
205: ,p_comments_o =>pay_pwa_shd.g_old_rec.comments
206: ,p_object_version_number_o =>pay_pwa_shd.g_old_rec.object_version_number
207: );
208: --
209: exception

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

202: ,p_location_id_o =>pay_pwa_shd.g_old_rec.location_id
203: ,p_name_o =>pay_pwa_shd.g_old_rec.name
204: ,p_account_number_o =>pay_pwa_shd.g_old_rec.account_number
205: ,p_comments_o =>pay_pwa_shd.g_old_rec.comments
206: ,p_object_version_number_o =>pay_pwa_shd.g_old_rec.object_version_number
207: );
208: --
209: exception
210: --

Line 268: Procedure convert_defs(p_rec in out nocopy pay_pwa_shd.g_rec_type) is

264: -- Internal Row Handler Use Only.
265: --
266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure convert_defs(p_rec in out nocopy pay_pwa_shd.g_rec_type) is
269: --
270: l_proc varchar2(72) := g_package||'convert_defs';
271: --
272: Begin

Line 283: pay_pwa_shd.g_old_rec.business_group_id;

279: -- is being used then we must set to the 'current' argument value.
280: --
281: If (p_rec.business_group_id = hr_api.g_number) then
282: p_rec.business_group_id :=
283: pay_pwa_shd.g_old_rec.business_group_id;
284: End If;
285: If (p_rec.carrier_id = hr_api.g_number) then
286: p_rec.carrier_id :=
287: pay_pwa_shd.g_old_rec.carrier_id;

Line 287: pay_pwa_shd.g_old_rec.carrier_id;

283: pay_pwa_shd.g_old_rec.business_group_id;
284: End If;
285: If (p_rec.carrier_id = hr_api.g_number) then
286: p_rec.carrier_id :=
287: pay_pwa_shd.g_old_rec.carrier_id;
288: End If;
289: If (p_rec.location_id = hr_api.g_number) then
290: p_rec.location_id :=
291: pay_pwa_shd.g_old_rec.location_id;

Line 291: pay_pwa_shd.g_old_rec.location_id;

287: pay_pwa_shd.g_old_rec.carrier_id;
288: End If;
289: If (p_rec.location_id = hr_api.g_number) then
290: p_rec.location_id :=
291: pay_pwa_shd.g_old_rec.location_id;
292: End If;
293: If (p_rec.name = hr_api.g_varchar2) then
294: p_rec.name :=
295: pay_pwa_shd.g_old_rec.name;

Line 295: pay_pwa_shd.g_old_rec.name;

291: pay_pwa_shd.g_old_rec.location_id;
292: End If;
293: If (p_rec.name = hr_api.g_varchar2) then
294: p_rec.name :=
295: pay_pwa_shd.g_old_rec.name;
296: End If;
297: If (p_rec.account_number = hr_api.g_varchar2) then
298: p_rec.account_number :=
299: pay_pwa_shd.g_old_rec.account_number;

Line 299: pay_pwa_shd.g_old_rec.account_number;

295: pay_pwa_shd.g_old_rec.name;
296: End If;
297: If (p_rec.account_number = hr_api.g_varchar2) then
298: p_rec.account_number :=
299: pay_pwa_shd.g_old_rec.account_number;
300: End If;
301: If (p_rec.comments = hr_api.g_varchar2) then
302: p_rec.comments :=
303: pay_pwa_shd.g_old_rec.comments;

Line 303: pay_pwa_shd.g_old_rec.comments;

299: pay_pwa_shd.g_old_rec.account_number;
300: End If;
301: If (p_rec.comments = hr_api.g_varchar2) then
302: p_rec.comments :=
303: pay_pwa_shd.g_old_rec.comments;
304: End If;
305:
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 316: p_rec in out nocopy pay_pwa_shd.g_rec_type

312: -- |---------------------------------< upd >----------------------------------|
313: -- ----------------------------------------------------------------------------
314: Procedure upd
315: (
316: p_rec in out nocopy pay_pwa_shd.g_rec_type
317: ) is
318: --
319: l_proc varchar2(72) := g_package||'upd';
320: --

Line 326: pay_pwa_shd.lck

322: hr_utility.set_location('Entering:'||l_proc, 5);
323: --
324: -- We must lock the row which we need to update.
325: --
326: pay_pwa_shd.lck
327: (
328: p_rec.account_id,
329: p_rec.object_version_number
330: );

Line 367: l_rec pay_pwa_shd.g_rec_type;

363: p_comments in varchar2 default hr_api.g_varchar2,
364: p_object_version_number in out nocopy number
365: ) is
366: --
367: l_rec pay_pwa_shd.g_rec_type;
368: l_proc varchar2(72) := g_package||'upd';
369: --
370: Begin
371: hr_utility.set_location('Entering:'||l_proc, 5);

Line 377: pay_pwa_shd.convert_args

373: -- Call conversion function to turn arguments into the
374: -- l_rec structure.
375: --
376: l_rec :=
377: pay_pwa_shd.convert_args
378: (
379: p_account_id,
380: hr_api.g_number,
381: hr_api.g_number,