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_QPU_API dependencies on PAY_PAYROLL_ACTIONS

Line 44: -- 2) target_payroll_action_id does not exists in pay_payroll_actions for a

40: -- Post Failure:
41: -- An error is raised if any of the following conditions are found:
42: -- 1) target_payroll_action_id, business_group_id or effective_date are
43: -- not null.
44: -- 2) target_payroll_action_id does not exists in pay_payroll_actions for a
45: -- QuickPay Run.
46: -- 3) The associated Assignment Process has a complete status.
47: -- 4) Another QuickPay Pre-payment or batch Pre-payment process already
48: -- interlocks to the QuickPay Run Assignment Process.

Line 60: pay_payroll_actions.target_payroll_action_id%TYPE

56: -- {End Of Comments}
57: --
58: procedure chk_target_payroll_action_id
59: (p_target_payroll_action_id in
60: pay_payroll_actions.target_payroll_action_id%TYPE
61: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
62: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
63: ) is
64: --

Line 61: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE

57: --
58: procedure chk_target_payroll_action_id
59: (p_target_payroll_action_id in
60: pay_payroll_actions.target_payroll_action_id%TYPE
61: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
62: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
63: ) is
64: --
65: l_exists varchar2(1);

Line 62: ,p_effective_date in pay_payroll_actions.effective_date%TYPE

58: procedure chk_target_payroll_action_id
59: (p_target_payroll_action_id in
60: pay_payroll_actions.target_payroll_action_id%TYPE
61: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
62: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
63: ) is
64: --
65: l_exists varchar2(1);
66: l_proc varchar2(72) := g_package||'chk_target_payroll_action_id';

Line 70: from pay_payroll_actions pya

66: l_proc varchar2(72) := g_package||'chk_target_payroll_action_id';
67: --
68: cursor csr_pay_act is
69: select 'Y'
70: from pay_payroll_actions pya
71: , pay_assignment_actions aga
72: where pya.payroll_action_id = p_target_payroll_action_id
73: and pya.action_type = 'Q'
74: and aga.payroll_action_id = pya.payroll_action_id

Line 79: from pay_payroll_actions pya

75: and aga.action_status in ('C', 'S');
76: --
77: cursor csr_other_qpu is
78: select 'Y'
79: from pay_payroll_actions pya
80: where pya.target_payroll_action_id = p_target_payroll_action_id
81: and pya.action_type = 'U';
82: --
83: cursor csr_no_lck is

Line 84: select /+ INDEX(ppq PAY_PAYROLL_ACTIONS_PK) /

80: where pya.target_payroll_action_id = p_target_payroll_action_id
81: and pya.action_type = 'U';
82: --
83: cursor csr_no_lck is
84: select /*+ INDEX(ppq PAY_PAYROLL_ACTIONS_PK) */
85: 'Y'
86: from pay_payroll_actions ppq
87: , pay_assignment_actions app
88: , pay_action_interlocks ail

Line 86: from pay_payroll_actions ppq

82: --
83: cursor csr_no_lck is
84: select /*+ INDEX(ppq PAY_PAYROLL_ACTIONS_PK) */
85: 'Y'
86: from pay_payroll_actions ppq
87: , pay_assignment_actions app
88: , pay_action_interlocks ail
89: , pay_assignment_actions aqr
90: where aqr.payroll_action_id = p_target_payroll_action_id

Line 98: from pay_payroll_actions pya

94: and ppq.action_type = 'P';
95: --
96: cursor csr_bus_grp is
97: select 'Y'
98: from pay_payroll_actions pya
99: where pya.payroll_action_id = p_target_payroll_action_id
100: and pya.business_group_id = p_business_group_id
101: and pya.effective_date = p_effective_date;
102: --

Line 125: -- Check the target_payroll_action_id exists in pay_payroll_actions

121: ,p_argument_value => p_effective_date
122: );
123: hr_utility.set_location(l_proc, 6);
124: --
125: -- Check the target_payroll_action_id exists in pay_payroll_actions
126: -- and it is for a completed QuickPay Run assignment action.
127: --
128: open csr_pay_act;
129: fetch csr_pay_act into l_exists;

Line 230: (p_org_payment_method_id in pay_payroll_actions.org_payment_method_id%TYPE

226: --
227: -- {End Of Comments}
228: --
229: procedure chk_org_payment_method_id
230: (p_org_payment_method_id in pay_payroll_actions.org_payment_method_id%TYPE
231: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
232: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
233: ) is
234: --

Line 231: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE

227: -- {End Of Comments}
228: --
229: procedure chk_org_payment_method_id
230: (p_org_payment_method_id in pay_payroll_actions.org_payment_method_id%TYPE
231: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
232: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
233: ) is
234: --
235: l_exists varchar2(1);

Line 232: ,p_effective_date in pay_payroll_actions.effective_date%TYPE

228: --
229: procedure chk_org_payment_method_id
230: (p_org_payment_method_id in pay_payroll_actions.org_payment_method_id%TYPE
231: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
232: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
233: ) is
234: --
235: l_exists varchar2(1);
236: l_proc varchar2(72) := g_package||'chk_org_payment_method_id';

Line 394: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

390: --
391: -- {End Of Comments}
392: --
393: procedure chk_cur_task
394: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
395: ) is
396: --
397: v_exists varchar2(1);
398: l_proc varchar2(72) := g_package||'chk_cur_task';

Line 402: from pay_payroll_actions

398: l_proc varchar2(72) := g_package||'chk_cur_task';
399: --
400: cursor sel_task is
401: select 'Y'
402: from pay_payroll_actions
403: where payroll_action_id = p_payroll_action_id
404: and current_task is not null;
405: begin
406: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 436: from pay_payroll_actions pac

432: l_proc varchar2(72) := g_package||'paid_payments';
433: --
434: cursor csr_paid is
435: select 'Y'
436: from pay_payroll_actions pac
437: , pay_assignment_actions aac
438: , pay_action_interlocks aci
439: where aci.locked_action_id = p_assignment_action_id
440: and aac.assignment_action_id = aci.locking_action_id

Line 638: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then

634: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
635: hr_utility.set_message_token('PROCEDURE', l_proc);
636: hr_utility.set_message_token('STEP','20');
637: hr_utility.raise_error;
638: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
639: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
640: hr_utility.set_message_token('PROCEDURE', l_proc);
641: hr_utility.set_message_token('STEP','25');
642: hr_utility.raise_error;

Line 643: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then

639: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
640: hr_utility.set_message_token('PROCEDURE', l_proc);
641: hr_utility.set_message_token('STEP','25');
642: hr_utility.raise_error;
643: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
645: hr_utility.set_message_token('PROCEDURE', l_proc);
646: hr_utility.set_message_token('STEP','30');
647: hr_utility.raise_error;

Line 648: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then

644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
645: hr_utility.set_message_token('PROCEDURE', l_proc);
646: hr_utility.set_message_token('STEP','30');
647: hr_utility.raise_error;
648: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
649: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
650: hr_utility.set_message_token('PROCEDURE', l_proc);
651: hr_utility.set_message_token('STEP','35');
652: hr_utility.raise_error;

Line 653: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then

649: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
650: hr_utility.set_message_token('PROCEDURE', l_proc);
651: hr_utility.set_message_token('STEP','35');
652: hr_utility.raise_error;
653: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
654: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
655: hr_utility.set_message_token('PROCEDURE', l_proc);
656: hr_utility.set_message_token('STEP','40');
657: hr_utility.raise_error;

Line 658: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then

654: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
655: hr_utility.set_message_token('PROCEDURE', l_proc);
656: hr_utility.set_message_token('STEP','40');
657: hr_utility.raise_error;
658: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
659: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
660: hr_utility.set_message_token('PROCEDURE', l_proc);
661: hr_utility.set_message_token('STEP','45');
662: hr_utility.raise_error;

Line 663: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then

659: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
660: hr_utility.set_message_token('PROCEDURE', l_proc);
661: hr_utility.set_message_token('STEP','45');
662: hr_utility.raise_error;
663: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then
664: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
665: hr_utility.set_message_token('PROCEDURE', l_proc);
666: hr_utility.set_message_token('STEP','50');
667: hr_utility.raise_error;

Line 731: ,p_action_type in pay_payroll_actions.action_type%TYPE

727: -- {End Of Comments}
728: --
729: Procedure insert_dml
730: (p_rec in out nocopy g_rec_type
731: ,p_action_type in pay_payroll_actions.action_type%TYPE
732: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
733: ,p_consolidation_set_id in
734: pay_payroll_actions.consolidation_set_id%TYPE
735: ,p_action_population_status in

Line 732: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE

728: --
729: Procedure insert_dml
730: (p_rec in out nocopy g_rec_type
731: ,p_action_type in pay_payroll_actions.action_type%TYPE
732: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
733: ,p_consolidation_set_id in
734: pay_payroll_actions.consolidation_set_id%TYPE
735: ,p_action_population_status in
736: pay_payroll_actions.action_population_status%TYPE

Line 734: pay_payroll_actions.consolidation_set_id%TYPE

730: (p_rec in out nocopy g_rec_type
731: ,p_action_type in pay_payroll_actions.action_type%TYPE
732: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
733: ,p_consolidation_set_id in
734: pay_payroll_actions.consolidation_set_id%TYPE
735: ,p_action_population_status in
736: pay_payroll_actions.action_population_status%TYPE
737: ) is
738: --

Line 736: pay_payroll_actions.action_population_status%TYPE

732: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
733: ,p_consolidation_set_id in
734: pay_payroll_actions.consolidation_set_id%TYPE
735: ,p_action_population_status in
736: pay_payroll_actions.action_population_status%TYPE
737: ) is
738: --
739: l_proc varchar2(72) := g_package||'insert_dml';
740: --

Line 752: -- Insert the row into: pay_payroll_actions

748: -- Set the api dml status
749: --
750: g_api_dml := true;
751: --
752: -- Insert the row into: pay_payroll_actions
753: --
754: insert into pay_payroll_actions
755: (payroll_action_id
756: ,business_group_id

Line 754: insert into pay_payroll_actions

750: g_api_dml := true;
751: --
752: -- Insert the row into: pay_payroll_actions
753: --
754: insert into pay_payroll_actions
755: (payroll_action_id
756: ,business_group_id
757: ,org_payment_method_id
758: ,action_status

Line 861: -- Update the pay_payroll_actions Row

857: -- Set the api dml status
858: --
859: g_api_dml := true;
860: --
861: -- Update the pay_payroll_actions Row
862: --
863: update pay_payroll_actions
864: set action_status = p_rec.action_status
865: , object_version_number = p_rec.object_version_number

Line 863: update pay_payroll_actions

859: g_api_dml := true;
860: --
861: -- Update the pay_payroll_actions Row
862: --
863: update pay_payroll_actions
864: set action_status = p_rec.action_status
865: , object_version_number = p_rec.object_version_number
866: where payroll_action_id = p_rec.payroll_action_id;
867: --

Line 943: -- Delete the pay_payroll_actions row.

939: hr_utility.set_location('Entering:'||l_proc, 5);
940: --
941: g_api_dml := true; -- Set the api dml status
942: --
943: -- Delete the pay_payroll_actions row.
944: --
945: delete from pay_payroll_actions
946: where payroll_action_id = p_rec.payroll_action_id;
947: --

Line 945: delete from pay_payroll_actions

941: g_api_dml := true; -- Set the api dml status
942: --
943: -- Delete the pay_payroll_actions row.
944: --
945: delete from pay_payroll_actions
946: where payroll_action_id = p_rec.payroll_action_id;
947: --
948: g_api_dml := false; -- Unset the api dml status
949: --

Line 1019: ,p_consolidation_set_id out nocopy pay_payroll_actions.

1015: Procedure pre_insert
1016: (p_rec in out nocopy g_rec_type
1017: ,p_action_type out nocopy varchar2
1018: ,p_payroll_id out nocopy number
1019: ,p_consolidation_set_id out nocopy pay_payroll_actions.
1020: consolidation_set_id%TYPE
1021: ,p_action_population_status out nocopy varchar2
1022: ) is
1023: --

Line 1026: Cursor C_Sel1 is select pay_payroll_actions_s.nextval from sys.dual;

1022: ) is
1023: --
1024: l_proc varchar2(72) := g_package||'pre_insert';
1025: --
1026: Cursor C_Sel1 is select pay_payroll_actions_s.nextval from sys.dual;
1027: --
1028: cursor csr_qpq_details (v_target_payroll_action_id number) is
1029: select pya.payroll_id
1030: , pya.consolidation_set_id

Line 1031: from pay_payroll_actions pya

1027: --
1028: cursor csr_qpq_details (v_target_payroll_action_id number) is
1029: select pya.payroll_id
1030: , pya.consolidation_set_id
1031: from pay_payroll_actions pya
1032: where pya.payroll_action_id = v_target_payroll_action_id;
1033: Begin
1034: hr_utility.set_location('Entering:'||l_proc, 5);
1035: --

Line 1307: from pay_payroll_actions pya

1303: , pya.effective_date
1304: , pya.target_payroll_action_id
1305: , aga.object_version_number
1306: , pya.object_version_number
1307: from pay_payroll_actions pya
1308: , pay_assignment_actions aga
1309: where /* Payroll action lock */
1310: pya.payroll_action_id = p_payroll_action_id
1311: and pya.action_type = 'U'

Line 1383: hr_utility.set_message_token('TABLE_NAME', 'pay_payroll_actions');

1379: -- The object is locked therefore we need to supply a meaningful
1380: -- error message.
1381: --
1382: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1383: hr_utility.set_message_token('TABLE_NAME', 'pay_payroll_actions');
1384: hr_utility.raise_error;
1385: End lck;
1386: --
1387: -- ----------------------------------------------------------------------------

Line 1716: l_action_type pay_payroll_actions.action_type%TYPE;

1712: l_proc varchar2(72) := g_package||'ins';
1713: --
1714: -- These variables are set by pre_insert and past to insert_dml
1715: --
1716: l_action_type pay_payroll_actions.action_type%TYPE;
1717: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
1718: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
1719: l_action_population_status pay_payroll_actions.action_population_status%TYPE;
1720: --

Line 1717: l_payroll_id pay_payroll_actions.payroll_id%TYPE;

1713: --
1714: -- These variables are set by pre_insert and past to insert_dml
1715: --
1716: l_action_type pay_payroll_actions.action_type%TYPE;
1717: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
1718: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
1719: l_action_population_status pay_payroll_actions.action_population_status%TYPE;
1720: --
1721: -- These variables are set by post_insert and returned from this procedure

Line 1718: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;

1714: -- These variables are set by pre_insert and past to insert_dml
1715: --
1716: l_action_type pay_payroll_actions.action_type%TYPE;
1717: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
1718: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
1719: l_action_population_status pay_payroll_actions.action_population_status%TYPE;
1720: --
1721: -- These variables are set by post_insert and returned from this procedure
1722: --

Line 1719: l_action_population_status pay_payroll_actions.action_population_status%TYPE;

1715: --
1716: l_action_type pay_payroll_actions.action_type%TYPE;
1717: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
1718: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
1719: l_action_population_status pay_payroll_actions.action_population_status%TYPE;
1720: --
1721: -- These variables are set by post_insert and returned from this procedure
1722: --
1723: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 2071: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

2067: -- |--------------------------< get_latest_status >---------------------------|
2068: -- ----------------------------------------------------------------------------
2069: --
2070: procedure get_latest_status
2071: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
2072: ,p_action_status out nocopy pay_assignment_actions.action_status%TYPE
2073: ) is
2074: l_proc varchar2(72) := g_package||'get_latest_status';
2075: l_argument varchar2(30);

Line 2079: from pay_payroll_actions pya

2075: l_argument varchar2(30);
2076: --
2077: cursor cur_stat is
2078: select aga.action_status
2079: from pay_payroll_actions pya
2080: , pay_assignment_actions aga
2081: where pya.payroll_action_id = p_payroll_action_id
2082: and aga.payroll_action_id = pya.payroll_action_id;
2083: begin