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

Line 44: from pay_payroll_actions pac,

40: l_tax_unit_id number;
41:
42: cursor c_qpaction is
43: select act.assignment_action_id
44: from pay_payroll_actions pac,
45: pay_assignment_actions act
46: where pac.payroll_action_id = p_payroll_action_id
47: and act.payroll_action_id = pac.target_payroll_action_id
48: and act.source_action_id is null;

Line 53: pay_payroll_actions pac

49:
50: cursor c_asgid is
51: select act.assignment_id
52: from pay_assignment_actions act,
53: pay_payroll_actions pac
54: where pac.payroll_action_id = p_payroll_action_id
55: and act.payroll_action_id = pac.target_payroll_action_id
56: and act.source_action_id is null;
57:

Line 62: from pay_payroll_actions ppa

58: cursor c_qppaction is
59: select pac.assignment_action_id,pac.tax_unit_id
60: from pay_assignment_actions pac
61: where pac.payroll_action_id = (select ppa.payroll_action_id
62: from pay_payroll_actions ppa
63: where ppa.target_payroll_action_id = (select ppa.target_payroll_action_id
64: from pay_payroll_actions ppa
65: where ppa.payroll_action_id = p_payroll_action_id)
66: and ppa.action_type = 'U'

Line 64: from pay_payroll_actions ppa

60: from pay_assignment_actions pac
61: where pac.payroll_action_id = (select ppa.payroll_action_id
62: from pay_payroll_actions ppa
63: where ppa.target_payroll_action_id = (select ppa.target_payroll_action_id
64: from pay_payroll_actions ppa
65: where ppa.payroll_action_id = p_payroll_action_id)
66: and ppa.action_type = 'U'
67: and ppa.action_status = 'C');
68:

Line 133: update pay_payroll_actions pac

129: hr_utility.set_location(' qppsassact :',60);
130: -- Update the payroll actions table with the
131: -- appropriate date_earned value.
132: hr_utility.set_location('qppsassact',70);
133: update pay_payroll_actions pac
134: set pac.date_earned = (
135: select pa2.date_earned
136: from pay_payroll_actions pa2,
137: pay_assignment_actions act

Line 136: from pay_payroll_actions pa2,

132: hr_utility.set_location('qppsassact',70);
133: update pay_payroll_actions pac
134: set pac.date_earned = (
135: select pa2.date_earned
136: from pay_payroll_actions pa2,
137: pay_assignment_actions act
138: where act.assignment_action_id = l_qpp_locked_action_id
139: and pa2.payroll_action_id = act.payroll_action_id)
140:

Line 156: update pay_payroll_actions pac

152: --
153: -- update the action_population_status to indicate
154: -- an action has been successfully inserted.
155: hr_utility.set_location('qppsassact',75);
156: update pay_payroll_actions pac
157: set pac.action_population_status = 'C'
158: where pac.payroll_action_id = p_payroll_action_id;
159:
160: hr_utility.set_location('Leaving : qppsassact',80);

Line 262: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

258: --
259: -- {End Of Comments}
260: --
261: procedure chk_cur_task
262: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
263: ) is
264: --
265: v_exists varchar2(1);
266: l_proc varchar2(72) := g_package||'chk_cur_task';

Line 270: from pay_payroll_actions

266: l_proc varchar2(72) := g_package||'chk_cur_task';
267: --
268: cursor sel_task is
269: select 'Y'
270: from pay_payroll_actions
271: where payroll_action_id = p_payroll_action_id
272: and current_task is not null;
273: begin
274: hr_utility.set_location('Entering:'|| l_proc, 5);

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

391: -- Post Failure:
392: -- An error is raised if any of the following conditions are found:
393: -- 1) target_payroll_action_id, business_group_id or effective_date are
394: -- not null.
395: -- 2) target_payroll_action_id does not exists in pay_payroll_actions for a
396: -- QuickPay Run.
397: -- 3) The associated Assignment Process has a complete status.
398: -- 4) Another QuickPay Archival run already
399: -- interlocks to the QuickPay Run Assignment Process.

Line 412: pay_payroll_actions.target_payroll_action_id%TYPE

408: -- {End Of Comments}
409: --
410: procedure chk_target_payroll_action_id
411: (p_target_payroll_action_id in
412: pay_payroll_actions.target_payroll_action_id%TYPE
413: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
414: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
415: ) is
416: --

Line 413: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE

409: --
410: procedure chk_target_payroll_action_id
411: (p_target_payroll_action_id in
412: pay_payroll_actions.target_payroll_action_id%TYPE
413: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
414: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
415: ) is
416: --
417: l_exists varchar2(1);

Line 414: ,p_effective_date in pay_payroll_actions.effective_date%TYPE

410: procedure chk_target_payroll_action_id
411: (p_target_payroll_action_id in
412: pay_payroll_actions.target_payroll_action_id%TYPE
413: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
414: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
415: ) is
416: --
417: l_exists varchar2(1);
418: l_proc varchar2(72) := g_package||'chk_target_payroll_action_id';

Line 423: from pay_payroll_actions pya

419: --
420: cursor csr_pay_act is
421:
422: select 'Y'
423: from pay_payroll_actions pya
424: , pay_assignment_actions aga
425: where pya.payroll_action_id = p_target_payroll_action_id
426: and pya.action_type = 'Q'
427: and aga.payroll_action_id = pya.payroll_action_id

Line 433: from pay_payroll_actions pya

429: --
430:
431: cursor csr_bus_grp is
432: select 'Y'
433: from pay_payroll_actions pya
434: where pya.payroll_action_id = p_target_payroll_action_id
435: and pya.business_group_id = p_business_group_id
436: and pya.effective_date = p_effective_date;
437: --

Line 462: -- Check the target_payroll_action_id exists in pay_payroll_actions

458:
459: );
460: hr_utility.set_location(l_proc, 6);
461: --
462: -- Check the target_payroll_action_id exists in pay_payroll_actions
463: -- and it is for a completed QuickPay Run assignment action.
464: --
465: open csr_pay_act;
466: fetch csr_pay_act into l_exists;

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

596: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
597: hr_utility.set_message_token('PROCEDURE', l_proc);
598: hr_utility.set_message_token('STEP','20');
599: hr_utility.raise_error;
600: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
601: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
602:
603: hr_utility.set_message_token('PROCEDURE', l_proc);
604: hr_utility.set_message_token('STEP','25');

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

602:
603: hr_utility.set_message_token('PROCEDURE', l_proc);
604: hr_utility.set_message_token('STEP','25');
605: hr_utility.raise_error;
606: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
608: hr_utility.set_message_token('PROCEDURE', l_proc);
609: hr_utility.set_message_token('STEP','30');
610: hr_utility.raise_error;

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

607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
608: hr_utility.set_message_token('PROCEDURE', l_proc);
609: hr_utility.set_message_token('STEP','30');
610: hr_utility.raise_error;
611: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
612: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
613: hr_utility.set_message_token('PROCEDURE', l_proc);
614: hr_utility.set_message_token('STEP','35');
615: hr_utility.raise_error;

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

613: hr_utility.set_message_token('PROCEDURE', l_proc);
614: hr_utility.set_message_token('STEP','35');
615: hr_utility.raise_error;
616:
617: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
618: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
619: hr_utility.set_message_token('PROCEDURE', l_proc);
620: hr_utility.set_message_token('STEP','40');
621: hr_utility.raise_error;

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

618: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
619: hr_utility.set_message_token('PROCEDURE', l_proc);
620: hr_utility.set_message_token('STEP','40');
621: hr_utility.raise_error;
622: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
623: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
624: hr_utility.set_message_token('PROCEDURE', l_proc);
625: hr_utility.set_message_token('STEP','45');
626: hr_utility.raise_error;

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

623: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
624: hr_utility.set_message_token('PROCEDURE', l_proc);
625: hr_utility.set_message_token('STEP','45');
626: hr_utility.raise_error;
627: ElsIf (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then
628: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
629: hr_utility.set_message_token('PROCEDURE', l_proc);
630:
631: hr_utility.set_message_token('STEP','50');

Line 665: from pay_payroll_actions pya

661: , pya.effective_date
662: , pya.target_payroll_action_id
663: , aga.object_version_number
664: , pya.object_version_number
665: from pay_payroll_actions pya
666: , pay_assignment_actions aga
667: where /* Payroll action lock */
668: pya.payroll_action_id = p_payroll_action_id
669: and pya.action_type = 'X'

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

737: -- The object is locked therefore we need to supply a meaningful
738: -- error message.
739: --
740: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
741: hr_utility.set_message_token('TABLE_NAME', 'pay_payroll_actions');
742: hr_utility.raise_error;
743: End lck;
744: --
745: -- ----------------------------------------------------------------------------

Line 876: -- Update the pay_payroll_actions Row

872: -- Set the api dml status
873: --
874: g_api_dml := true;
875: --
876: -- Update the pay_payroll_actions Row
877: --
878: update pay_payroll_actions
879: set action_status = p_rec.action_status
880: , object_version_number = p_rec.object_version_number

Line 878: update pay_payroll_actions

874: g_api_dml := true;
875: --
876: -- Update the pay_payroll_actions Row
877: --
878: update pay_payroll_actions
879: set action_status = p_rec.action_status
880: , object_version_number = p_rec.object_version_number
881: where payroll_action_id = p_rec.payroll_action_id;
882: --

Line 966: ,p_action_type in pay_payroll_actions.action_type%TYPE

962: -- {End Of Comments}
963: --
964: Procedure insert_dml
965: (p_rec in out nocopy g_rec_type
966: ,p_action_type in pay_payroll_actions.action_type%TYPE
967: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
968: ,p_consolidation_set_id in
969: pay_payroll_actions.consolidation_set_id%TYPE
970: ,p_action_population_status in

Line 967: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE

963: --
964: Procedure insert_dml
965: (p_rec in out nocopy g_rec_type
966: ,p_action_type in pay_payroll_actions.action_type%TYPE
967: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
968: ,p_consolidation_set_id in
969: pay_payroll_actions.consolidation_set_id%TYPE
970: ,p_action_population_status in
971: pay_payroll_actions.action_population_status%TYPE

Line 969: pay_payroll_actions.consolidation_set_id%TYPE

965: (p_rec in out nocopy g_rec_type
966: ,p_action_type in pay_payroll_actions.action_type%TYPE
967: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
968: ,p_consolidation_set_id in
969: pay_payroll_actions.consolidation_set_id%TYPE
970: ,p_action_population_status in
971: pay_payroll_actions.action_population_status%TYPE
972: ) is
973: --

Line 971: pay_payroll_actions.action_population_status%TYPE

967: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
968: ,p_consolidation_set_id in
969: pay_payroll_actions.consolidation_set_id%TYPE
970: ,p_action_population_status in
971: pay_payroll_actions.action_population_status%TYPE
972: ) is
973: --
974: l_proc varchar2(72) := g_package||'insert_dml';
975: --

Line 988: -- Insert the row into: pay_payroll_actions

984: -- Set the api dml status
985: --
986: g_api_dml := true;
987: --
988: -- Insert the row into: pay_payroll_actions
989: --
990: insert into pay_payroll_actions
991: (payroll_action_id
992: ,business_group_id

Line 990: insert into pay_payroll_actions

986: g_api_dml := true;
987: --
988: -- Insert the row into: pay_payroll_actions
989: --
990: insert into pay_payroll_actions
991: (payroll_action_id
992: ,business_group_id
993: ,org_payment_method_id
994: ,action_status

Line 1139: ,p_consolidation_set_id out nocopy pay_payroll_actions.

1135: Procedure pre_insert
1136: (p_rec in out nocopy g_rec_type
1137: ,p_action_type out nocopy varchar2
1138: ,p_payroll_id out nocopy number
1139: ,p_consolidation_set_id out nocopy pay_payroll_actions.
1140: consolidation_set_id%TYPE
1141: ,p_action_population_status out nocopy varchar2
1142: ) is
1143: --

Line 1146: Cursor C_next_id is select pay_payroll_actions_s.nextval from sys.dual;

1142: ) is
1143: --
1144: l_proc varchar2(72) := g_package||'pre_insert';
1145: --
1146: Cursor C_next_id is select pay_payroll_actions_s.nextval from sys.dual;
1147: --
1148: cursor csr_qpq_details (v_target_payroll_action_id number) is
1149: select pya.payroll_id
1150: , pya.consolidation_set_id

Line 1151: from pay_payroll_actions pya

1147: --
1148: cursor csr_qpq_details (v_target_payroll_action_id number) is
1149: select pya.payroll_id
1150: , pya.consolidation_set_id
1151: from pay_payroll_actions pya
1152: where pya.payroll_action_id = v_target_payroll_action_id;
1153: Begin
1154: hr_utility.set_location('Entering:'||l_proc, 5);
1155: --

Line 1574: l_action_type pay_payroll_actions.action_type%TYPE;

1570: l_proc varchar2(72) := g_package||'ins';
1571: --
1572: -- These variables are set by pre_insert and past to insert_dml
1573: --
1574: l_action_type pay_payroll_actions.action_type%TYPE;
1575: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
1576: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
1577: l_action_population_status pay_payroll_actions.action_population_status%TYPE;
1578:

Line 1575: l_payroll_id pay_payroll_actions.payroll_id%TYPE;

1571: --
1572: -- These variables are set by pre_insert and past to insert_dml
1573: --
1574: l_action_type pay_payroll_actions.action_type%TYPE;
1575: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
1576: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
1577: l_action_population_status pay_payroll_actions.action_population_status%TYPE;
1578:
1579: --

Line 1576: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;

1572: -- These variables are set by pre_insert and past to insert_dml
1573: --
1574: l_action_type pay_payroll_actions.action_type%TYPE;
1575: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
1576: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
1577: l_action_population_status pay_payroll_actions.action_population_status%TYPE;
1578:
1579: --
1580: -- These variables are set by post_insert and returned from this procedure

Line 1577: l_action_population_status pay_payroll_actions.action_population_status%TYPE;

1573: --
1574: l_action_type pay_payroll_actions.action_type%TYPE;
1575: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
1576: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
1577: l_action_population_status pay_payroll_actions.action_population_status%TYPE;
1578:
1579: --
1580: -- These variables are set by post_insert and returned from this procedure
1581: --