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_BTH_UPD dependencies on PAY_BTH_SHD

Line 55: (p_rec in out nocopy pay_bth_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pay_bth_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 66: pay_bth_shd.g_api_dml := true; -- Set the api dml status

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: pay_bth_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the pay_batch_headers Row
69: --
70: update pay_batch_headers

Line 90: pay_bth_shd.g_api_dml := false; -- Unset the api dml status

86: ,REJECT_ENTRY_NOT_REMOVED = p_rec.REJECT_ENTRY_NOT_REMOVED
87: ,ROLLBACK_ENTRY_UPDATES = p_rec.ROLLBACK_ENTRY_UPDATES
88: where batch_id = p_rec.batch_id;
89: --
90: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: --
94: Exception

Line 97: pay_bth_shd.g_api_dml := false; -- Unset the api dml status

93: --
94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
98: pay_bth_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated

Line 98: pay_bth_shd.constraint_error

94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
98: pay_bth_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: pay_bth_shd.g_api_dml := false; -- Unset the api dml status

Line 102: pay_bth_shd.g_api_dml := false; -- Unset the api dml status

98: pay_bth_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
103: pay_bth_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated

Line 103: pay_bth_shd.constraint_error

99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
103: pay_bth_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: pay_bth_shd.g_api_dml := false; -- Unset the api dml status

Line 107: pay_bth_shd.g_api_dml := false; -- Unset the api dml status

103: pay_bth_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
108: pay_bth_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: pay_bth_shd.g_api_dml := false; -- Unset the api dml status

Line 108: pay_bth_shd.constraint_error

104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
108: pay_bth_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;

Line 111: pay_bth_shd.g_api_dml := false; -- Unset the api dml status

107: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
108: pay_bth_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: pay_bth_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;
113: End update_dml;
114: --
115: -- ----------------------------------------------------------------------------

Line 148: (p_rec in pay_bth_shd.g_rec_type

144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure pre_update
148: (p_rec in pay_bth_shd.g_rec_type
149: ) is
150: --
151: l_proc varchar2(72) := g_package||'pre_update';
152: --

Line 193: ,p_rec in pay_bth_shd.g_rec_type

189: -- {End Of Comments}
190: -- ----------------------------------------------------------------------------
191: Procedure post_update
192: (p_session_date in date
193: ,p_rec in pay_bth_shd.g_rec_type
194: ) is
195: --
196: l_proc varchar2(72) := g_package||'post_update';
197: --

Line 238: => pay_bth_shd.g_old_rec.business_group_id

234: => p_rec.REJECT_ENTRY_NOT_REMOVED
235: ,p_ROLLBACK_ENTRY_UPDATES
236: => p_rec.ROLLBACK_ENTRY_UPDATES
237: ,p_business_group_id_o
238: => pay_bth_shd.g_old_rec.business_group_id
239: ,p_batch_name_o
240: => pay_bth_shd.g_old_rec.batch_name
241: ,p_batch_status_o
242: => pay_bth_shd.g_old_rec.batch_status

Line 240: => pay_bth_shd.g_old_rec.batch_name

236: => p_rec.ROLLBACK_ENTRY_UPDATES
237: ,p_business_group_id_o
238: => pay_bth_shd.g_old_rec.business_group_id
239: ,p_batch_name_o
240: => pay_bth_shd.g_old_rec.batch_name
241: ,p_batch_status_o
242: => pay_bth_shd.g_old_rec.batch_status
243: ,p_action_if_exists_o
244: => pay_bth_shd.g_old_rec.action_if_exists

Line 242: => pay_bth_shd.g_old_rec.batch_status

238: => pay_bth_shd.g_old_rec.business_group_id
239: ,p_batch_name_o
240: => pay_bth_shd.g_old_rec.batch_name
241: ,p_batch_status_o
242: => pay_bth_shd.g_old_rec.batch_status
243: ,p_action_if_exists_o
244: => pay_bth_shd.g_old_rec.action_if_exists
245: ,p_batch_reference_o
246: => pay_bth_shd.g_old_rec.batch_reference

Line 244: => pay_bth_shd.g_old_rec.action_if_exists

240: => pay_bth_shd.g_old_rec.batch_name
241: ,p_batch_status_o
242: => pay_bth_shd.g_old_rec.batch_status
243: ,p_action_if_exists_o
244: => pay_bth_shd.g_old_rec.action_if_exists
245: ,p_batch_reference_o
246: => pay_bth_shd.g_old_rec.batch_reference
247: ,p_batch_source_o
248: => pay_bth_shd.g_old_rec.batch_source

Line 246: => pay_bth_shd.g_old_rec.batch_reference

242: => pay_bth_shd.g_old_rec.batch_status
243: ,p_action_if_exists_o
244: => pay_bth_shd.g_old_rec.action_if_exists
245: ,p_batch_reference_o
246: => pay_bth_shd.g_old_rec.batch_reference
247: ,p_batch_source_o
248: => pay_bth_shd.g_old_rec.batch_source
249: ,p_batch_type_o
250: => pay_bth_shd.g_old_rec.batch_type

Line 248: => pay_bth_shd.g_old_rec.batch_source

244: => pay_bth_shd.g_old_rec.action_if_exists
245: ,p_batch_reference_o
246: => pay_bth_shd.g_old_rec.batch_reference
247: ,p_batch_source_o
248: => pay_bth_shd.g_old_rec.batch_source
249: ,p_batch_type_o
250: => pay_bth_shd.g_old_rec.batch_type
251: ,p_comments_o
252: => pay_bth_shd.g_old_rec.comments

Line 250: => pay_bth_shd.g_old_rec.batch_type

246: => pay_bth_shd.g_old_rec.batch_reference
247: ,p_batch_source_o
248: => pay_bth_shd.g_old_rec.batch_source
249: ,p_batch_type_o
250: => pay_bth_shd.g_old_rec.batch_type
251: ,p_comments_o
252: => pay_bth_shd.g_old_rec.comments
253: ,p_date_effective_changes_o
254: => pay_bth_shd.g_old_rec.date_effective_changes

Line 252: => pay_bth_shd.g_old_rec.comments

248: => pay_bth_shd.g_old_rec.batch_source
249: ,p_batch_type_o
250: => pay_bth_shd.g_old_rec.batch_type
251: ,p_comments_o
252: => pay_bth_shd.g_old_rec.comments
253: ,p_date_effective_changes_o
254: => pay_bth_shd.g_old_rec.date_effective_changes
255: ,p_purge_after_transfer_o
256: => pay_bth_shd.g_old_rec.purge_after_transfer

Line 254: => pay_bth_shd.g_old_rec.date_effective_changes

250: => pay_bth_shd.g_old_rec.batch_type
251: ,p_comments_o
252: => pay_bth_shd.g_old_rec.comments
253: ,p_date_effective_changes_o
254: => pay_bth_shd.g_old_rec.date_effective_changes
255: ,p_purge_after_transfer_o
256: => pay_bth_shd.g_old_rec.purge_after_transfer
257: ,p_reject_if_future_changes_o
258: => pay_bth_shd.g_old_rec.reject_if_future_changes

Line 256: => pay_bth_shd.g_old_rec.purge_after_transfer

252: => pay_bth_shd.g_old_rec.comments
253: ,p_date_effective_changes_o
254: => pay_bth_shd.g_old_rec.date_effective_changes
255: ,p_purge_after_transfer_o
256: => pay_bth_shd.g_old_rec.purge_after_transfer
257: ,p_reject_if_future_changes_o
258: => pay_bth_shd.g_old_rec.reject_if_future_changes
259: ,p_object_version_number_o
260: => pay_bth_shd.g_old_rec.object_version_number

Line 258: => pay_bth_shd.g_old_rec.reject_if_future_changes

254: => pay_bth_shd.g_old_rec.date_effective_changes
255: ,p_purge_after_transfer_o
256: => pay_bth_shd.g_old_rec.purge_after_transfer
257: ,p_reject_if_future_changes_o
258: => pay_bth_shd.g_old_rec.reject_if_future_changes
259: ,p_object_version_number_o
260: => pay_bth_shd.g_old_rec.object_version_number
261: ,p_reject_if_results_exists_o
262: => pay_bth_shd.g_old_rec.reject_if_results_exists

Line 260: => pay_bth_shd.g_old_rec.object_version_number

256: => pay_bth_shd.g_old_rec.purge_after_transfer
257: ,p_reject_if_future_changes_o
258: => pay_bth_shd.g_old_rec.reject_if_future_changes
259: ,p_object_version_number_o
260: => pay_bth_shd.g_old_rec.object_version_number
261: ,p_reject_if_results_exists_o
262: => pay_bth_shd.g_old_rec.reject_if_results_exists
263: ,p_purge_after_rollback_o
264: => pay_bth_shd.g_old_rec.purge_after_rollback

Line 262: => pay_bth_shd.g_old_rec.reject_if_results_exists

258: => pay_bth_shd.g_old_rec.reject_if_future_changes
259: ,p_object_version_number_o
260: => pay_bth_shd.g_old_rec.object_version_number
261: ,p_reject_if_results_exists_o
262: => pay_bth_shd.g_old_rec.reject_if_results_exists
263: ,p_purge_after_rollback_o
264: => pay_bth_shd.g_old_rec.purge_after_rollback
265: ,p_REJECT_ENTRY_NOT_REMOVED_o
266: => pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED

Line 264: => pay_bth_shd.g_old_rec.purge_after_rollback

260: => pay_bth_shd.g_old_rec.object_version_number
261: ,p_reject_if_results_exists_o
262: => pay_bth_shd.g_old_rec.reject_if_results_exists
263: ,p_purge_after_rollback_o
264: => pay_bth_shd.g_old_rec.purge_after_rollback
265: ,p_REJECT_ENTRY_NOT_REMOVED_o
266: => pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED
267: ,p_ROLLBACK_ENTRY_UPDATES_o
268: => pay_bth_shd.g_old_rec.ROLLBACK_ENTRY_UPDATES

Line 266: => pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED

262: => pay_bth_shd.g_old_rec.reject_if_results_exists
263: ,p_purge_after_rollback_o
264: => pay_bth_shd.g_old_rec.purge_after_rollback
265: ,p_REJECT_ENTRY_NOT_REMOVED_o
266: => pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED
267: ,p_ROLLBACK_ENTRY_UPDATES_o
268: => pay_bth_shd.g_old_rec.ROLLBACK_ENTRY_UPDATES
269: );
270: --

Line 268: => pay_bth_shd.g_old_rec.ROLLBACK_ENTRY_UPDATES

264: => pay_bth_shd.g_old_rec.purge_after_rollback
265: ,p_REJECT_ENTRY_NOT_REMOVED_o
266: => pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED
267: ,p_ROLLBACK_ENTRY_UPDATES_o
268: => pay_bth_shd.g_old_rec.ROLLBACK_ENTRY_UPDATES
269: );
270: --
271: exception
272: --

Line 328: (p_rec in out nocopy pay_bth_shd.g_rec_type

324: --
325: -- {End Of Comments}
326: -- ----------------------------------------------------------------------------
327: Procedure convert_defs
328: (p_rec in out nocopy pay_bth_shd.g_rec_type
329: ) is
330: --
331: Begin
332: --

Line 340: pay_bth_shd.g_old_rec.business_group_id;

336: -- is being used then we must set to the 'current' argument value.
337: --
338: If (p_rec.business_group_id = hr_api.g_number) then
339: p_rec.business_group_id :=
340: pay_bth_shd.g_old_rec.business_group_id;
341: End If;
342: If (p_rec.batch_name = hr_api.g_varchar2) then
343: p_rec.batch_name :=
344: pay_bth_shd.g_old_rec.batch_name;

Line 344: pay_bth_shd.g_old_rec.batch_name;

340: pay_bth_shd.g_old_rec.business_group_id;
341: End If;
342: If (p_rec.batch_name = hr_api.g_varchar2) then
343: p_rec.batch_name :=
344: pay_bth_shd.g_old_rec.batch_name;
345: End If;
346: If (p_rec.batch_status = hr_api.g_varchar2) then
347: p_rec.batch_status :=
348: pay_bth_shd.g_old_rec.batch_status;

Line 348: pay_bth_shd.g_old_rec.batch_status;

344: pay_bth_shd.g_old_rec.batch_name;
345: End If;
346: If (p_rec.batch_status = hr_api.g_varchar2) then
347: p_rec.batch_status :=
348: pay_bth_shd.g_old_rec.batch_status;
349: End If;
350: If (p_rec.action_if_exists = hr_api.g_varchar2) then
351: p_rec.action_if_exists :=
352: pay_bth_shd.g_old_rec.action_if_exists;

Line 352: pay_bth_shd.g_old_rec.action_if_exists;

348: pay_bth_shd.g_old_rec.batch_status;
349: End If;
350: If (p_rec.action_if_exists = hr_api.g_varchar2) then
351: p_rec.action_if_exists :=
352: pay_bth_shd.g_old_rec.action_if_exists;
353: End If;
354: If (p_rec.batch_reference = hr_api.g_varchar2) then
355: p_rec.batch_reference :=
356: pay_bth_shd.g_old_rec.batch_reference;

Line 356: pay_bth_shd.g_old_rec.batch_reference;

352: pay_bth_shd.g_old_rec.action_if_exists;
353: End If;
354: If (p_rec.batch_reference = hr_api.g_varchar2) then
355: p_rec.batch_reference :=
356: pay_bth_shd.g_old_rec.batch_reference;
357: End If;
358: If (p_rec.batch_source = hr_api.g_varchar2) then
359: p_rec.batch_source :=
360: pay_bth_shd.g_old_rec.batch_source;

Line 360: pay_bth_shd.g_old_rec.batch_source;

356: pay_bth_shd.g_old_rec.batch_reference;
357: End If;
358: If (p_rec.batch_source = hr_api.g_varchar2) then
359: p_rec.batch_source :=
360: pay_bth_shd.g_old_rec.batch_source;
361: End If;
362: If (p_rec.batch_type = hr_api.g_varchar2) then
363: p_rec.batch_type :=
364: pay_bth_shd.g_old_rec.batch_type;

Line 364: pay_bth_shd.g_old_rec.batch_type;

360: pay_bth_shd.g_old_rec.batch_source;
361: End If;
362: If (p_rec.batch_type = hr_api.g_varchar2) then
363: p_rec.batch_type :=
364: pay_bth_shd.g_old_rec.batch_type;
365: End If;
366: If (p_rec.comments = hr_api.g_varchar2) then
367: p_rec.comments :=
368: pay_bth_shd.g_old_rec.comments;

Line 368: pay_bth_shd.g_old_rec.comments;

364: pay_bth_shd.g_old_rec.batch_type;
365: End If;
366: If (p_rec.comments = hr_api.g_varchar2) then
367: p_rec.comments :=
368: pay_bth_shd.g_old_rec.comments;
369: End If;
370: If (p_rec.date_effective_changes = hr_api.g_varchar2) then
371: p_rec.date_effective_changes :=
372: pay_bth_shd.g_old_rec.date_effective_changes;

Line 372: pay_bth_shd.g_old_rec.date_effective_changes;

368: pay_bth_shd.g_old_rec.comments;
369: End If;
370: If (p_rec.date_effective_changes = hr_api.g_varchar2) then
371: p_rec.date_effective_changes :=
372: pay_bth_shd.g_old_rec.date_effective_changes;
373: End If;
374: If (p_rec.purge_after_transfer = hr_api.g_varchar2) then
375: p_rec.purge_after_transfer :=
376: pay_bth_shd.g_old_rec.purge_after_transfer;

Line 376: pay_bth_shd.g_old_rec.purge_after_transfer;

372: pay_bth_shd.g_old_rec.date_effective_changes;
373: End If;
374: If (p_rec.purge_after_transfer = hr_api.g_varchar2) then
375: p_rec.purge_after_transfer :=
376: pay_bth_shd.g_old_rec.purge_after_transfer;
377: End If;
378: If (p_rec.reject_if_future_changes = hr_api.g_varchar2) then
379: p_rec.reject_if_future_changes :=
380: pay_bth_shd.g_old_rec.reject_if_future_changes;

Line 380: pay_bth_shd.g_old_rec.reject_if_future_changes;

376: pay_bth_shd.g_old_rec.purge_after_transfer;
377: End If;
378: If (p_rec.reject_if_future_changes = hr_api.g_varchar2) then
379: p_rec.reject_if_future_changes :=
380: pay_bth_shd.g_old_rec.reject_if_future_changes;
381: End If;
382: If (p_rec.reject_if_results_exists = hr_api.g_varchar2) then
383: p_rec.reject_if_results_exists :=
384: pay_bth_shd.g_old_rec.reject_if_results_exists;

Line 384: pay_bth_shd.g_old_rec.reject_if_results_exists;

380: pay_bth_shd.g_old_rec.reject_if_future_changes;
381: End If;
382: If (p_rec.reject_if_results_exists = hr_api.g_varchar2) then
383: p_rec.reject_if_results_exists :=
384: pay_bth_shd.g_old_rec.reject_if_results_exists;
385: End If;
386: If (p_rec.purge_after_rollback = hr_api.g_varchar2) then
387: p_rec.purge_after_rollback :=
388: pay_bth_shd.g_old_rec.purge_after_rollback;

Line 388: pay_bth_shd.g_old_rec.purge_after_rollback;

384: pay_bth_shd.g_old_rec.reject_if_results_exists;
385: End If;
386: If (p_rec.purge_after_rollback = hr_api.g_varchar2) then
387: p_rec.purge_after_rollback :=
388: pay_bth_shd.g_old_rec.purge_after_rollback;
389: End If;
390: If (p_rec.REJECT_ENTRY_NOT_REMOVED = hr_api.g_varchar2) then
391: p_rec.REJECT_ENTRY_NOT_REMOVED :=
392: pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED;

Line 392: pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED;

388: pay_bth_shd.g_old_rec.purge_after_rollback;
389: End If;
390: If (p_rec.REJECT_ENTRY_NOT_REMOVED = hr_api.g_varchar2) then
391: p_rec.REJECT_ENTRY_NOT_REMOVED :=
392: pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED;
393: End If;
394: If (p_rec.ROLLBACK_ENTRY_UPDATES = hr_api.g_varchar2) then
395: p_rec.ROLLBACK_ENTRY_UPDATES :=
396: pay_bth_shd.g_old_rec.ROLLBACK_ENTRY_UPDATES;

Line 396: pay_bth_shd.g_old_rec.ROLLBACK_ENTRY_UPDATES;

392: pay_bth_shd.g_old_rec.REJECT_ENTRY_NOT_REMOVED;
393: End If;
394: If (p_rec.ROLLBACK_ENTRY_UPDATES = hr_api.g_varchar2) then
395: p_rec.ROLLBACK_ENTRY_UPDATES :=
396: pay_bth_shd.g_old_rec.ROLLBACK_ENTRY_UPDATES;
397: End If;
398: --
399: End convert_defs;
400: --

Line 406: ,p_rec in out nocopy pay_bth_shd.g_rec_type

402: -- |---------------------------------< upd >----------------------------------|
403: -- ----------------------------------------------------------------------------
404: Procedure upd
405: (p_session_date in date
406: ,p_rec in out nocopy pay_bth_shd.g_rec_type
407: ) is
408: --
409: l_proc varchar2(72) := g_package||'upd';
410: --

Line 416: pay_bth_shd.lck

412: hr_utility.set_location('Entering:'||l_proc, 5);
413: --
414: -- We must lock the row which we need to update.
415: --
416: pay_bth_shd.lck
417: (p_rec.batch_id
418: ,p_rec.object_version_number
419: );
420: --

Line 472: l_rec pay_bth_shd.g_rec_type;

468: ,p_REJECT_ENTRY_NOT_REMOVED in varchar2 default hr_api.g_varchar2
469: ,p_ROLLBACK_ENTRY_UPDATES in varchar2 default hr_api.g_varchar2
470: ) is
471: --
472: l_rec pay_bth_shd.g_rec_type;
473: l_proc varchar2(72) := g_package||'upd';
474: --
475: Begin
476: hr_utility.set_location('Entering:'||l_proc, 5);

Line 482: pay_bth_shd.convert_args

478: -- Call conversion function to turn arguments into the
479: -- l_rec structure.
480: --
481: l_rec :=
482: pay_bth_shd.convert_args
483: (p_batch_id
484: ,hr_api.g_number
485: ,p_batch_name
486: ,p_batch_status