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_QPI_API dependencies on PAY_QUICKPAY_INCLUSIONS

Line 6: g_old_rec pay_quickpay_inclusions%ROWTYPE;

2: /* $Header: pyqpirhi.pkb 115.5 2004/05/20 07:26:29 nbristow ship $ */
3: --
4: -- Current record structure definition
5: --
6: g_old_rec pay_quickpay_inclusions%ROWTYPE;
7: --
8: -- Global package name
9: --
10: g_package varchar2(30) := ' pay_qpi_api.';

Line 141: (p_rec in pay_quickpay_inclusions%ROWTYPE

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

Line 418: -- not already exist in the pay_quickpay_inclusions table.

414: -- p_rec is the QuickPay Inclusion record to check for.
415: --
416: -- Post Success:
417: -- This procedure ends successfully if the the QuickPay Inclusion does
418: -- not already exist in the pay_quickpay_inclusions table.
419: --
420: -- Post Failure:
421: -- Raises an error if the Quickpay Inclusion p_rec already exists in the
422: -- database.

Line 430: (p_rec in pay_quickpay_inclusions%ROWTYPE

426: --
427: -- {End Of Comments}
428: --
429: procedure validate_row_exists
430: (p_rec in pay_quickpay_inclusions%ROWTYPE
431: ) is
432: --
433: v_exists varchar2(1);
434: v_proc varchar2(72) := g_package||'validate_row_exists';

Line 438: from pay_quickpay_inclusions

434: v_proc varchar2(72) := g_package||'validate_row_exists';
435: --
436: cursor cur_exists is
437: select 'Y'
438: from pay_quickpay_inclusions
439: where element_entry_id = p_rec.element_entry_id
440: and assignment_action_id = p_rec.assignment_action_id;
441: begin
442: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 564: -- (pay_quickpay_inclusions table).

560: -- A Pl/Sql record structure.
561: --
562: -- Post Success:
563: -- The specified row will be inserted into the schema
564: -- (pay_quickpay_inclusions table).
565: --
566: -- Post Failure:
567: -- If an error occurs a standard Oracle error will be raised.
568: --

Line 577: procedure insert_dml(p_rec in out nocopy pay_quickpay_inclusions%ROWTYPE) is

573: -- Internal Development Use Only.
574: --
575: -- {End Of Comments}
576: --
577: procedure insert_dml(p_rec in out nocopy pay_quickpay_inclusions%ROWTYPE) is
578: --
579: v_proc varchar2(72) := g_package||'insert_dml';
580: --
581: begin

Line 584: -- Insert the row into: pay_quickpay_inclusions

580: --
581: begin
582: hr_utility.set_location('Entering:'||v_proc, 5);
583: --
584: -- Insert the row into: pay_quickpay_inclusions
585: --
586: insert into pay_quickpay_inclusions
587: (element_entry_id
588: ,assignment_action_id

Line 586: insert into pay_quickpay_inclusions

582: hr_utility.set_location('Entering:'||v_proc, 5);
583: --
584: -- Insert the row into: pay_quickpay_inclusions
585: --
586: insert into pay_quickpay_inclusions
587: (element_entry_id
588: ,assignment_action_id
589: )
590: values

Line 629: Procedure delete_dml(p_rec in pay_quickpay_inclusions%ROWTYPE) is

625: -- Internal Development Use Only.
626: --
627: -- {End Of Comments}
628: --
629: Procedure delete_dml(p_rec in pay_quickpay_inclusions%ROWTYPE) is
630: --
631: v_proc varchar2(72) := g_package||'delete_dml';
632: --
633: Begin

Line 636: -- Delete the pay_quickpay_inclusions row.

632: --
633: Begin
634: hr_utility.set_location('Entering:'|| v_proc, 5);
635: --
636: -- Delete the pay_quickpay_inclusions row.
637: --
638: delete from pay_quickpay_inclusions
639: where element_entry_id = p_rec.element_entry_id
640: and assignment_action_id = p_rec.assignment_action_id;

Line 638: delete from pay_quickpay_inclusions

634: hr_utility.set_location('Entering:'|| v_proc, 5);
635: --
636: -- Delete the pay_quickpay_inclusions row.
637: --
638: delete from pay_quickpay_inclusions
639: where element_entry_id = p_rec.element_entry_id
640: and assignment_action_id = p_rec.assignment_action_id;
641: --
642: If sql%NOTFOUND then

Line 669: from pay_quickpay_inclusions

665: -- Cursor selects the 'current' row from the HR Schema
666: --
667: Cursor C_Sel1 is
668: select *
669: from pay_quickpay_inclusions
670: where element_entry_id = p_element_entry_id
671: and assignment_action_id = p_assignment_action_id
672: for update nowait;
673: --

Line 705: hr_utility.set_message_token('TABLE_NAME', 'pay_quickpay_inclusions');

701: -- The object is locked therefore we need to supply a meaningful
702: -- error message.
703: --
704: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
705: hr_utility.set_message_token('TABLE_NAME', 'pay_quickpay_inclusions');
706: hr_utility.raise_error;
707: End lck;
708: --
709: -- ----------------------------------------------------------------------------

Line 728: -- pay_quickpay_inclusions%ROWTYPE.

724: -- and p_assignment_action_id.
725: --
726: -- Post Success:
727: -- A record structure will be returned of type
728: -- pay_quickpay_inclusions%ROWTYPE.
729: --
730: -- Post Failure:
731: -- No direct error handling is required within this function. Any possible
732: -- errors within this function will be a PL/SQL value error due to conversion

Line 746: ) return pay_quickpay_inclusions%ROWTYPE is

742: --
743: function convert_args
744: (p_element_entry_id in number
745: ,p_assignment_action_id in number
746: ) return pay_quickpay_inclusions%ROWTYPE is
747: --
748: v_rec pay_quickpay_inclusions%ROWTYPE;
749: v_proc varchar2(72) := g_package||'convert_args';
750: --

Line 748: v_rec pay_quickpay_inclusions%ROWTYPE;

744: (p_element_entry_id in number
745: ,p_assignment_action_id in number
746: ) return pay_quickpay_inclusions%ROWTYPE is
747: --
748: v_rec pay_quickpay_inclusions%ROWTYPE;
749: v_proc varchar2(72) := g_package||'convert_args';
750: --
751: Begin
752: --

Line 794: procedure insert_validate(p_rec in pay_quickpay_inclusions%ROWTYPE) is

790: -- Internal Development Use Only.
791: --
792: -- {End Of Comments}
793: --
794: procedure insert_validate(p_rec in pay_quickpay_inclusions%ROWTYPE) is
795: --
796: v_proc varchar2(72) := g_package||'insert_validate';
797: --
798: begin

Line 856: procedure delete_validate(p_rec in pay_quickpay_inclusions%ROWTYPE) is

852: -- Internal Development Use Only.
853: --
854: -- {End Of Comments}
855: --
856: procedure delete_validate(p_rec in pay_quickpay_inclusions%ROWTYPE) is
857: --
858: v_proc varchar2(72) := g_package||'delete_validate';
859: --
860: begin

Line 878: p_rec in out nocopy pay_quickpay_inclusions%ROWTYPE,

874: -- ----------------------------------------------------------------------------
875: --
876: Procedure ins
877: (
878: p_rec in out nocopy pay_quickpay_inclusions%ROWTYPE,
879: p_validate in boolean default false
880: ) is
881: --
882: v_proc varchar2(72) := g_package||'ins';

Line 930: v_rec pay_quickpay_inclusions%ROWTYPE;

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

Line 991: insert into pay_quickpay_inclusions

987: hr_utility.set_location(v_proc, 7);
988: --
989: -- Insert the default quickpay inclusions
990: --
991: insert into pay_quickpay_inclusions
992: (element_entry_id
993: ,assignment_action_id)
994: select distinct
995: ent.element_entry_id

Line 1096: (p_rec in pay_quickpay_inclusions%ROWTYPE

1092: -- |---------------------------------< del >----------------------------------|
1093: -- ----------------------------------------------------------------------------
1094: --
1095: procedure del
1096: (p_rec in pay_quickpay_inclusions%ROWTYPE
1097: ,p_validate in boolean default false
1098: ) is
1099: --
1100: v_proc varchar2(30) := g_package||'del';

Line 1169: v_rec pay_quickpay_inclusions%ROWTYPE;

1165: ,p_assignment_action_id in number
1166: ,p_validate in boolean default false
1167: ) is
1168: --
1169: v_rec pay_quickpay_inclusions%ROWTYPE;
1170: v_proc varchar2(72) := g_package||'del';
1171: --
1172: begin
1173: hr_utility.set_location('Entering:'|| v_proc, 5);