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_QPE_API dependencies on PAY_QUICKPAY_EXCLUSIONS

Line 6: g_old_rec pay_quickpay_exclusions%ROWTYPE;

2: /* $Header: pyqperhi.pkb 115.2 2004/04/22 07:16 swinton noship $ */
3: --
4: -- Current record structure definition
5: --
6: g_old_rec pay_quickpay_exclusions%ROWTYPE;
7: --
8: -- Global package name
9: --
10: g_package varchar2(30) := ' pay_qpe_api.';

Line 139: (p_rec in pay_quickpay_exclusions%ROWTYPE

135: --
136: -- {End Of Comments}
137: --
138: procedure validate_ele_ent_id
139: (p_rec in pay_quickpay_exclusions%ROWTYPE
140: ) is
141: --
142: v_exists varchar2(1);
143: v_date_earned pay_payroll_actions.date_earned%TYPE;

Line 304: -- not already exist in the pay_quickpay_exclusions table.

300: -- p_rec is the QuickPay Exclusion record to check for.
301: --
302: -- Post Success:
303: -- This procedure ends successfully if the the QuickPay Exclusion does
304: -- not already exist in the pay_quickpay_exclusions table.
305: --
306: -- Post Failure:
307: -- Raises an error if the Quickpay Exclusion p_rec already exists in the
308: -- database.

Line 316: (p_rec in pay_quickpay_exclusions%ROWTYPE

312: --
313: -- {End Of Comments}
314: --
315: procedure validate_row_exists
316: (p_rec in pay_quickpay_exclusions%ROWTYPE
317: ) is
318: --
319: v_exists varchar2(1);
320: v_proc varchar2(72) := g_package||'validate_row_exists';

Line 324: from pay_quickpay_exclusions

320: v_proc varchar2(72) := g_package||'validate_row_exists';
321: --
322: cursor cur_exists is
323: select 'Y'
324: from pay_quickpay_exclusions
325: where element_entry_id = p_rec.element_entry_id
326: and assignment_action_id = p_rec.assignment_action_id;
327: begin
328: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 455: -- (pay_quickpay_exclusions table).

451: -- A Pl/Sql record structure.
452: --
453: -- Post Success:
454: -- The specified row will be inserted into the schema
455: -- (pay_quickpay_exclusions table).
456: --
457: -- Post Failure:
458: -- If an error occurs a standard Oracle error will be raised.
459: --

Line 468: procedure insert_dml(p_rec in out nocopy pay_quickpay_exclusions%ROWTYPE) is

464: -- Internal Development Use Only.
465: --
466: -- {End Of Comments}
467: --
468: procedure insert_dml(p_rec in out nocopy pay_quickpay_exclusions%ROWTYPE) is
469: --
470: v_proc varchar2(72) := g_package||'insert_dml';
471: --
472: begin

Line 475: -- Insert the row into: pay_quickpay_exclusions

471: --
472: begin
473: hr_utility.set_location('Entering:'||v_proc, 5);
474: --
475: -- Insert the row into: pay_quickpay_exclusions
476: --
477: insert into pay_quickpay_exclusions
478: (element_entry_id
479: ,assignment_action_id

Line 477: insert into pay_quickpay_exclusions

473: hr_utility.set_location('Entering:'||v_proc, 5);
474: --
475: -- Insert the row into: pay_quickpay_exclusions
476: --
477: insert into pay_quickpay_exclusions
478: (element_entry_id
479: ,assignment_action_id
480: ,created_by
481: ,creation_date

Line 530: Procedure delete_dml(p_rec in pay_quickpay_exclusions%ROWTYPE) is

526: -- Internal Development Use Only.
527: --
528: -- {End Of Comments}
529: --
530: Procedure delete_dml(p_rec in pay_quickpay_exclusions%ROWTYPE) is
531: --
532: v_proc varchar2(72) := g_package||'delete_dml';
533: --
534: Begin

Line 537: -- Delete the pay_quickpay_exclusions row.

533: --
534: Begin
535: hr_utility.set_location('Entering:'|| v_proc, 5);
536: --
537: -- Delete the pay_quickpay_exclusions row.
538: --
539: delete from pay_quickpay_exclusions
540: where element_entry_id = p_rec.element_entry_id
541: and assignment_action_id = p_rec.assignment_action_id;

Line 539: delete from pay_quickpay_exclusions

535: hr_utility.set_location('Entering:'|| v_proc, 5);
536: --
537: -- Delete the pay_quickpay_exclusions row.
538: --
539: delete from pay_quickpay_exclusions
540: where element_entry_id = p_rec.element_entry_id
541: and assignment_action_id = p_rec.assignment_action_id;
542: --
543: If sql%NOTFOUND then

Line 570: from pay_quickpay_exclusions

566: -- Cursor selects the 'current' row from the HR Schema
567: --
568: Cursor C_Sel1 is
569: select *
570: from pay_quickpay_exclusions
571: where element_entry_id = p_element_entry_id
572: and assignment_action_id = p_assignment_action_id
573: for update nowait;
574: --

Line 606: hr_utility.set_message_token('TABLE_NAME', 'PAY_QUICKPAY_EXCLUSIONS');

602: -- The object is locked therefore we need to supply a meaningful
603: -- error message.
604: --
605: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
606: hr_utility.set_message_token('TABLE_NAME', 'PAY_QUICKPAY_EXCLUSIONS');
607: hr_utility.raise_error;
608: End lck;
609: --
610: -- ----------------------------------------------------------------------------

Line 629: -- pay_quickpay_exclusions%ROWTYPE.

625: -- and p_assignment_action_id.
626: --
627: -- Post Success:
628: -- A record structure will be returned of type
629: -- pay_quickpay_exclusions%ROWTYPE.
630: --
631: -- Post Failure:
632: -- No direct error handling is required within this function. Any possible
633: -- errors within this function will be a PL/SQL value error due to conversion

Line 647: ) return pay_quickpay_exclusions%ROWTYPE is

643: --
644: function convert_args
645: (p_element_entry_id in number
646: ,p_assignment_action_id in number
647: ) return pay_quickpay_exclusions%ROWTYPE is
648: --
649: v_rec pay_quickpay_exclusions%ROWTYPE;
650: v_proc varchar2(72) := g_package||'convert_args';
651: --

Line 649: v_rec pay_quickpay_exclusions%ROWTYPE;

645: (p_element_entry_id in number
646: ,p_assignment_action_id in number
647: ) return pay_quickpay_exclusions%ROWTYPE is
648: --
649: v_rec pay_quickpay_exclusions%ROWTYPE;
650: v_proc varchar2(72) := g_package||'convert_args';
651: --
652: Begin
653: --

Line 695: procedure insert_validate(p_rec in pay_quickpay_exclusions%ROWTYPE) is

691: -- Internal Development Use Only.
692: --
693: -- {End Of Comments}
694: --
695: procedure insert_validate(p_rec in pay_quickpay_exclusions%ROWTYPE) is
696: --
697: v_proc varchar2(72) := g_package||'insert_validate';
698: --
699: begin

Line 756: procedure delete_validate(p_rec in pay_quickpay_exclusions%ROWTYPE) is

752: -- Internal Development Use Only.
753: --
754: -- {End Of Comments}
755: --
756: procedure delete_validate(p_rec in pay_quickpay_exclusions%ROWTYPE) is
757: --
758: v_proc varchar2(72) := g_package||'delete_validate';
759: --
760: begin

Line 777: p_rec in out nocopy pay_quickpay_exclusions%ROWTYPE,

773: -- ----------------------------------------------------------------------------
774: --
775: Procedure ins
776: (
777: p_rec in out nocopy pay_quickpay_exclusions%ROWTYPE,
778: p_validate in boolean default false
779: ) is
780: --
781: v_proc varchar2(72) := g_package||'ins';

Line 829: v_rec pay_quickpay_exclusions%ROWTYPE;

825: ,p_assignment_action_id in number
826: ,p_validate in boolean default false
827: ) is
828: --
829: v_rec pay_quickpay_exclusions%ROWTYPE;
830: v_proc varchar2(72) := g_package||'ins';
831: --
832: Begin
833: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 857: (p_rec in pay_quickpay_exclusions%ROWTYPE

853: -- |---------------------------------< del >----------------------------------|
854: -- ----------------------------------------------------------------------------
855: --
856: procedure del
857: (p_rec in pay_quickpay_exclusions%ROWTYPE
858: ,p_validate in boolean default false
859: ) is
860: --
861: v_proc varchar2(30) := g_package||'del';

Line 930: v_rec pay_quickpay_exclusions%ROWTYPE;

926: ,p_assignment_action_id in number
927: ,p_validate in boolean default false
928: ) is
929: --
930: v_rec pay_quickpay_exclusions%ROWTYPE;
931: v_proc varchar2(72) := g_package||'del';
932: --
933: begin
934: hr_utility.set_location('Entering:'|| v_proc, 5);