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

Line 64: pi_payroll_action_id in pay_payroll_actions.payroll_action_id%type

60: || value names. The check is only meaningful for the US legislation.
61: */
62:
63: (
64: pi_payroll_action_id in pay_payroll_actions.payroll_action_id%type
65: -- The "in" parameter used to identify Payroll Action
66: ) is
67:
68: -- Trace variables used for debugging

Line 91: select /*+ ORDERED INDEX(PAY_ACTION PAY_PAYROLL_ACTIONS_PK)

87: -- separately, otherwise look only for entries without that requirement.
88:
89: ) is
90:
91: select /*+ ORDERED INDEX(PAY_ACTION PAY_PAYROLL_ACTIONS_PK)
92: INDEX(ASGT_ACTION PAY_ASSIGNMENT_ACTIONS_N50)
93: INDEX(QP_INCL PAY_QUICKPAY_INCLUSIONS_FK2)
94: INDEX(ENTRY PAY_ELEMENT_ENTRIES_F_PK)
95: INDEX(LINK PAY_ELEMENT_LINKS_F_PK)

Line 103: from pay_payroll_actions PAY_ACTION,

99: USE_NL(PAY_ACTION, ASGT_ACTION) USE_NL(ASGT_ACTION, QP_INCL)
100: USE_NL(QP_INCL, ENTRY) USE_NL(ENTRY, LINK) USE_NL(LINK, ELEMENT)
101: USE_NL(ELEMENT, CLASS) USE_NL(CLASS, ENTVAL) */
102: count (*) TOTAL_OF_ROWS
103: from pay_payroll_actions PAY_ACTION,
104: pay_assignment_actions ASGT_ACTION,
105: pay_quickpay_inclusions QP_INCL,
106: pay_element_entries_f ENTRY,
107: pay_element_links_f LINK,

Line 187: select /*+ ORDERED INDEX(PAY_ACTION PAY_PAYROLL_ACTIONS_PK)

183: -- separately, otherwise look only for entries without that requirement.
184:
185: ) is
186:
187: select /*+ ORDERED INDEX(PAY_ACTION PAY_PAYROLL_ACTIONS_PK)
188: INDEX(ASGT_ACTION PAY_ASSIGNMENT_ACTIONS_N50)
189: INDEX(ENTRY PAY_ELEMENT_ENTRIES_F_N50)
190: INDEX(LINK PAY_ELEMENT_LINKS_F_PK)
191: INDEX(ELEMENT PAY_ELEMENT_TYPES_F_PK)

Line 198: from pay_payroll_actions PAY_ACTION,

194: USE_NL(PAY_ACTION, ASGT_ACTION) USE_NL(ENTRY, LINK)
195: USE_NL(LINK, ELEMENT) USE_NL(ELEMENT, CLASS)
196: USE_NL(CLASS, ENTVAL) */
197: count (*) TOTAL_OF_ROWS
198: from pay_payroll_actions PAY_ACTION,
199: pay_assignment_actions ASGT_ACTION,
200: pay_element_entries_f ENTRY,
201: pay_element_links_f LINK,
202: pay_element_types_f ELEMENT,

Line 532: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE

528: -- {End Of Comments}
529: --
530: procedure chk_assignment
531: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
532: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
533: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
534: ) is
535: --
536: v_exists varchar2(1);

Line 533: ,p_effective_date in pay_payroll_actions.effective_date%TYPE

529: --
530: procedure chk_assignment
531: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
532: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
533: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
534: ) is
535: --
536: v_exists varchar2(1);
537: v_proc varchar2(72) := g_package||'chk_assignment';

Line 809: ,p_effective_date in pay_payroll_actions.effective_date%TYPE

805: -- {End Of Comments}
806: --
807: function get_date_earned_for_gb
808: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
809: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
810: ) return pay_payroll_actions.date_earned%TYPE is
811: --
812: -- Cursor definitions
813: --

Line 810: ) return pay_payroll_actions.date_earned%TYPE is

806: --
807: function get_date_earned_for_gb
808: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
809: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
810: ) return pay_payroll_actions.date_earned%TYPE is
811: --
812: -- Cursor definitions
813: --
814: -- Used to find the start and end dates of the matching period

Line 943: (p_effective_date in pay_payroll_actions.effective_date%TYPE

939: --
940: -- {End Of Comments}
941: --
942: procedure chk_eff_date_for_gb
943: (p_effective_date in pay_payroll_actions.effective_date%TYPE
944: ,p_time_period_id in pay_payroll_actions.time_period_id%TYPE
945: ) is
946: --
947: v_exists varchar2(1);

Line 944: ,p_time_period_id in pay_payroll_actions.time_period_id%TYPE

940: -- {End Of Comments}
941: --
942: procedure chk_eff_date_for_gb
943: (p_effective_date in pay_payroll_actions.effective_date%TYPE
944: ,p_time_period_id in pay_payroll_actions.time_period_id%TYPE
945: ) is
946: --
947: v_exists varchar2(1);
948: v_proc varchar2(72) := g_package||'chk_eff_date_for_gb';

Line 977: (p_effective_date in pay_payroll_actions.effective_date%TYPE

973: -- |-----------------------------< chk_eff_date >-----------------------------|
974: -- ----------------------------------------------------------------------------
975: --
976: procedure chk_eff_date
977: (p_effective_date in pay_payroll_actions.effective_date%TYPE
978: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
979: ,p_legislation_code in per_business_groups.legislation_code%TYPE
980: ,p_recal_date_earned in boolean
981: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE

Line 981: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE

977: (p_effective_date in pay_payroll_actions.effective_date%TYPE
978: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
979: ,p_legislation_code in per_business_groups.legislation_code%TYPE
980: ,p_recal_date_earned in boolean
981: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE
982: ,p_time_period_id out nocopy pay_payroll_actions.time_period_id%TYPE
983: ,p_period_name out nocopy per_time_periods.period_name%TYPE
984: ,p_new_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
985: ) is

Line 982: ,p_time_period_id out nocopy pay_payroll_actions.time_period_id%TYPE

978: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
979: ,p_legislation_code in per_business_groups.legislation_code%TYPE
980: ,p_recal_date_earned in boolean
981: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE
982: ,p_time_period_id out nocopy pay_payroll_actions.time_period_id%TYPE
983: ,p_period_name out nocopy per_time_periods.period_name%TYPE
984: ,p_new_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
985: ) is
986: --

Line 984: ,p_new_date_earned out nocopy pay_payroll_actions.date_earned%TYPE

980: ,p_recal_date_earned in boolean
981: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE
982: ,p_time_period_id out nocopy pay_payroll_actions.time_period_id%TYPE
983: ,p_period_name out nocopy per_time_periods.period_name%TYPE
984: ,p_new_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
985: ) is
986: --
987: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
988: v_eff_time_period_id per_time_periods.time_period_id%TYPE;

Line 987: v_payroll_id pay_payroll_actions.payroll_id%TYPE;

983: ,p_period_name out nocopy per_time_periods.period_name%TYPE
984: ,p_new_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
985: ) is
986: --
987: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
988: v_eff_time_period_id per_time_periods.time_period_id%TYPE;
989: v_eff_time_period_name per_time_periods.period_name%TYPE;
990: v_new_date_earned pay_payroll_actions.date_earned%TYPE;
991: v_proc varchar2(72) := g_package||'chk_eff_date';

Line 990: v_new_date_earned pay_payroll_actions.date_earned%TYPE;

986: --
987: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
988: v_eff_time_period_id per_time_periods.time_period_id%TYPE;
989: v_eff_time_period_name per_time_periods.period_name%TYPE;
990: v_new_date_earned pay_payroll_actions.date_earned%TYPE;
991: v_proc varchar2(72) := g_package||'chk_eff_date';
992: v_rule_mode pay_legislation_rules.rule_mode%type;
993: --
994: -- Used to find out if the assingment is on a payroll as p_effective_date

Line 1144: (p_date_earned in pay_payroll_actions.date_earned%TYPE

1140: --
1141: -- {End Of Comments}
1142: --
1143: procedure chk_date_earned_for_gb
1144: (p_date_earned in pay_payroll_actions.date_earned%TYPE
1145: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
1146: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1147: ) is
1148: --

Line 1146: ,p_effective_date in pay_payroll_actions.effective_date%TYPE

1142: --
1143: procedure chk_date_earned_for_gb
1144: (p_date_earned in pay_payroll_actions.date_earned%TYPE
1145: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
1146: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1147: ) is
1148: --
1149: v_df_date_earned pay_payroll_actions.date_earned%TYPE;
1150: v_proc varchar2(72) := g_package||'chk_date_earned_for_gb';

Line 1149: v_df_date_earned pay_payroll_actions.date_earned%TYPE;

1145: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
1146: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1147: ) is
1148: --
1149: v_df_date_earned pay_payroll_actions.date_earned%TYPE;
1150: v_proc varchar2(72) := g_package||'chk_date_earned_for_gb';
1151: --
1152: begin
1153: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 1180: (p_date_earned in pay_payroll_actions.date_earned%TYPE

1176: -- |----------------------------< chk_date_earned >---------------------------|
1177: -- ----------------------------------------------------------------------------
1178: --
1179: procedure chk_date_earned
1180: (p_date_earned in pay_payroll_actions.date_earned%TYPE
1181: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
1182: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1183: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1184: ) is

Line 1183: ,p_effective_date in pay_payroll_actions.effective_date%TYPE

1179: procedure chk_date_earned
1180: (p_date_earned in pay_payroll_actions.date_earned%TYPE
1181: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
1182: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1183: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1184: ) is
1185: --
1186: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
1187: v_not_used_period_id per_time_periods.time_period_id%TYPE;

Line 1186: v_payroll_id pay_payroll_actions.payroll_id%TYPE;

1182: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1183: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1184: ) is
1185: --
1186: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
1187: v_not_used_period_id per_time_periods.time_period_id%TYPE;
1188: v_not_used_period_name per_time_periods.period_name%TYPE;
1189: v_proc varchar2(72) := g_package||'chk_date_earned';
1190: v_argument varchar2(30);

Line 1304: (p_effective_date in pay_payroll_actions.effective_date%TYPE

1300: --
1301: -- {End Of Comments}
1302: --
1303: procedure chk_eff_earned_payroll
1304: (p_effective_date in pay_payroll_actions.effective_date%TYPE
1305: ,p_date_earned in pay_payroll_actions.date_earned%TYPE
1306: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
1307: ,p_raise_error in boolean
1308: ,p_same_payroll out nocopy boolean

Line 1305: ,p_date_earned in pay_payroll_actions.date_earned%TYPE

1301: -- {End Of Comments}
1302: --
1303: procedure chk_eff_earned_payroll
1304: (p_effective_date in pay_payroll_actions.effective_date%TYPE
1305: ,p_date_earned in pay_payroll_actions.date_earned%TYPE
1306: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
1307: ,p_raise_error in boolean
1308: ,p_same_payroll out nocopy boolean
1309: ) is

Line 1471: (p_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE

1467: --
1468: -- {End Of Comments}
1469: --
1470: Procedure chk_legislative_parameters
1471: (p_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE
1472: ,p_action_status varchar2
1473: ,p_legislation_code per_business_groups.legislation_code%TYPE
1474: ) Is
1475: --

Line 1562: ,p_effective_date in pay_payroll_actions.effective_date%TYPE

1558: -- b) Foreign key to pay_run_types_f.
1559: --
1560: Procedure chk_run_type
1561: ( p_run_type_id in pay_run_types_f.run_type_id%type
1562: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1563: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
1564: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1565: )
1566: --

Line 1563: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE

1559: --
1560: Procedure chk_run_type
1561: ( p_run_type_id in pay_run_types_f.run_type_id%type
1562: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1563: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
1564: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1565: )
1566: --
1567: IS

Line 1653: -- p_current_task set to the pay_payroll_actions.current_task of the

1649: -- Pre Conditions:
1650: -- None.
1651: --
1652: -- In Arguments:
1653: -- p_current_task set to the pay_payroll_actions.current_task of the
1654: -- current payroll_action.
1655: --
1656: -- Post Success:
1657: -- The current_task for this QuickPay Run is null. (Update or delete can

Line 1666: (p_current_task in pay_payroll_actions.current_task%TYPE

1662: --
1663: -- {End Of Comments}
1664: --
1665: procedure chk_cur_task
1666: (p_current_task in pay_payroll_actions.current_task%TYPE
1667: ) is
1668: --
1669: v_proc varchar2(72) := g_package||'chk_cur_task';
1670: --

Line 1689: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

1685: -- |-------------------------< chk_for_con_request >--------------------------|
1686: -- ----------------------------------------------------------------------------
1687: --
1688: procedure chk_for_con_request
1689: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
1690: ) is
1691: --
1692: v_request_id pay_payroll_actions.request_id%TYPE;
1693: v_bl boolean;

Line 1692: v_request_id pay_payroll_actions.request_id%TYPE;

1688: procedure chk_for_con_request
1689: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
1690: ) is
1691: --
1692: v_request_id pay_payroll_actions.request_id%TYPE;
1693: v_bl boolean;
1694: v_phase varchar2(255);
1695: v_status varchar2(255);
1696: v_dev_phase varchar2(255);

Line 1703: from pay_payroll_actions

1699: v_proc varchar2(72) := g_package||'chk_for_con_request';
1700: --
1701: cursor sel_reqt is
1702: select request_id
1703: from pay_payroll_actions
1704: where payroll_action_id = p_payroll_action_id;
1705: begin
1706: hr_utility.set_location('Entering:'|| v_proc, 5);
1707: --

Line 1714: -- A row could not be found in pay_payroll_actions

1710: open sel_reqt;
1711: fetch sel_reqt into v_request_id;
1712: if sel_reqt%notfound then
1713: close sel_reqt;
1714: -- A row could not be found in pay_payroll_actions
1715: -- with an id of p_payroll_action_id.
1716: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1717: hr_utility.raise_error;
1718: end if;

Line 1782: (p_business_group_id in pay_payroll_actions.business_group_id%TYPE

1778: --
1779: -- {End Of Comments}
1780: --
1781: function get_legislation_code
1782: (p_business_group_id in pay_payroll_actions.business_group_id%TYPE
1783: ) return varchar2 is
1784: --
1785: cursor cur_leg is
1786: select legislation_code

Line 1901: elsif (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then

1897: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1898: hr_utility.set_message_token('PROCEDURE', v_proc);
1899: hr_utility.set_message_token('STEP','20');
1900: hr_utility.raise_error;
1901: elsif (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK1') Then
1902: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1903: hr_utility.set_message_token('PROCEDURE', v_proc);
1904: hr_utility.set_message_token('STEP','25');
1905: hr_utility.raise_error;

Line 1906: elsif (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then

1902: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1903: hr_utility.set_message_token('PROCEDURE', v_proc);
1904: hr_utility.set_message_token('STEP','25');
1905: hr_utility.raise_error;
1906: elsif (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK2') Then
1907: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1908: hr_utility.set_message_token('PROCEDURE', v_proc);
1909: hr_utility.set_message_token('STEP','30');
1910: hr_utility.raise_error;

Line 1911: elsif (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then

1907: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1908: hr_utility.set_message_token('PROCEDURE', v_proc);
1909: hr_utility.set_message_token('STEP','30');
1910: hr_utility.raise_error;
1911: elsif (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK5') Then
1912: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1913: hr_utility.set_message_token('PROCEDURE', v_proc);
1914: hr_utility.set_message_token('STEP','35');
1915: hr_utility.raise_error;

Line 1916: elsif (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then

1912: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1913: hr_utility.set_message_token('PROCEDURE', v_proc);
1914: hr_utility.set_message_token('STEP','35');
1915: hr_utility.raise_error;
1916: elsif (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK6') Then
1917: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1918: hr_utility.set_message_token('PROCEDURE', v_proc);
1919: hr_utility.set_message_token('STEP','40');
1920: hr_utility.raise_error;

Line 1921: elsif (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then

1917: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1918: hr_utility.set_message_token('PROCEDURE', v_proc);
1919: hr_utility.set_message_token('STEP','40');
1920: hr_utility.raise_error;
1921: elsif (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK7') Then
1922: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1923: hr_utility.set_message_token('PROCEDURE', v_proc);
1924: hr_utility.set_message_token('STEP','45');
1925: hr_utility.raise_error;

Line 1926: elsif (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then

1922: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1923: hr_utility.set_message_token('PROCEDURE', v_proc);
1924: hr_utility.set_message_token('STEP','45');
1925: hr_utility.raise_error;
1926: elsif (p_constraint_name = 'PAY_PAYROLL_ACTIONS_FK8') Then
1927: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1928: hr_utility.set_message_token('PROCEDURE', v_proc);
1929: hr_utility.set_message_token('STEP','50');
1930: hr_utility.raise_error;

Line 2113: ,p_action_type out nocopy pay_payroll_actions.action_type%TYPE

2109: -- {End Of Comments}
2110: --
2111: Procedure pre_insert
2112: (p_rec in out nocopy g_rec_type
2113: ,p_action_type out nocopy pay_payroll_actions.action_type%TYPE
2114: ,p_action_population_status out nocopy
2115: pay_payroll_actions.action_population_status%TYPE
2116: ) is
2117: --

Line 2115: pay_payroll_actions.action_population_status%TYPE

2111: Procedure pre_insert
2112: (p_rec in out nocopy g_rec_type
2113: ,p_action_type out nocopy pay_payroll_actions.action_type%TYPE
2114: ,p_action_population_status out nocopy
2115: pay_payroll_actions.action_population_status%TYPE
2116: ) is
2117: --
2118: v_proc varchar2(72) := g_package||'pre_insert';
2119: --

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

2116: ) is
2117: --
2118: v_proc varchar2(72) := g_package||'pre_insert';
2119: --
2120: Cursor C_Sel1 is select pay_payroll_actions_s.nextval from sys.dual;
2121: --
2122: Begin
2123: hr_utility.set_location('Entering:'|| v_proc, 5);
2124: --

Line 2427: ,p_action_type in pay_payroll_actions.action_type%TYPE

2423: --
2424: -- {End Of Comments}
2425: Procedure insert_dml
2426: (p_rec in out nocopy g_rec_type
2427: ,p_action_type in pay_payroll_actions.action_type%TYPE
2428: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
2429: ,p_time_period_id in pay_payroll_actions.time_period_id%TYPE
2430: ,p_action_population_status in
2431: pay_payroll_actions.action_population_status%TYPE

Line 2428: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE

2424: -- {End Of Comments}
2425: Procedure insert_dml
2426: (p_rec in out nocopy g_rec_type
2427: ,p_action_type in pay_payroll_actions.action_type%TYPE
2428: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
2429: ,p_time_period_id in pay_payroll_actions.time_period_id%TYPE
2430: ,p_action_population_status in
2431: pay_payroll_actions.action_population_status%TYPE
2432: ) is

Line 2429: ,p_time_period_id in pay_payroll_actions.time_period_id%TYPE

2425: Procedure insert_dml
2426: (p_rec in out nocopy g_rec_type
2427: ,p_action_type in pay_payroll_actions.action_type%TYPE
2428: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
2429: ,p_time_period_id in pay_payroll_actions.time_period_id%TYPE
2430: ,p_action_population_status in
2431: pay_payroll_actions.action_population_status%TYPE
2432: ) is
2433: --

Line 2431: pay_payroll_actions.action_population_status%TYPE

2427: ,p_action_type in pay_payroll_actions.action_type%TYPE
2428: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
2429: ,p_time_period_id in pay_payroll_actions.time_period_id%TYPE
2430: ,p_action_population_status in
2431: pay_payroll_actions.action_population_status%TYPE
2432: ) is
2433: --
2434: v_proc varchar2(72) := g_package||'insert_dml';
2435: --

Line 2442: -- Insert the row into: pay_payroll_actions

2438: p_rec.object_version_number := 1; -- Initialise the object version
2439: --
2440: g_api_dml := true; -- Set the api dml status
2441: --
2442: -- Insert the row into: pay_payroll_actions
2443: --
2444: insert into pay_payroll_actions
2445: (payroll_action_id
2446: ,action_type

Line 2444: insert into pay_payroll_actions

2440: g_api_dml := true; -- Set the api dml status
2441: --
2442: -- Insert the row into: pay_payroll_actions
2443: --
2444: insert into pay_payroll_actions
2445: (payroll_action_id
2446: ,action_type
2447: ,business_group_id
2448: ,consolidation_set_id

Line 2573: -- Update the pay_payroll_actions Row

2569: -- Set the api dml status
2570: --
2571: g_api_dml := true;
2572: --
2573: -- Update the pay_payroll_actions Row
2574: --
2575: update pay_payroll_actions set
2576: business_group_id = p_rec.business_group_id
2577: ,consolidation_set_id = p_rec.consolidation_set_id

Line 2575: update pay_payroll_actions set

2571: g_api_dml := true;
2572: --
2573: -- Update the pay_payroll_actions Row
2574: --
2575: update pay_payroll_actions set
2576: business_group_id = p_rec.business_group_id
2577: ,consolidation_set_id = p_rec.consolidation_set_id
2578: ,action_status = p_rec.action_status
2579: ,effective_date = p_rec.effective_date

Line 2677: -- Delete the pay_payroll_actions row.

2673: -- Set the api dml status
2674: --
2675: g_api_dml := true;
2676: --
2677: -- Delete the pay_payroll_actions row.
2678: --
2679: delete from pay_payroll_actions
2680: where payroll_action_id = p_rec.payroll_action_id;
2681: --

Line 2679: delete from pay_payroll_actions

2675: g_api_dml := true;
2676: --
2677: -- Delete the pay_payroll_actions row.
2678: --
2679: delete from pay_payroll_actions
2680: where payroll_action_id = p_rec.payroll_action_id;
2681: --
2682: -- Unset the api dml status
2683: --

Line 2765: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

2761: --
2762: -- {End Of Comments}
2763: --
2764: procedure lck_general
2765: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
2766: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
2767: ,p_a_object_version_number in
2768: pay_assignment_actions.object_version_number%TYPE
2769: ,p_only_action_type in pay_payroll_actions.action_type%TYPE

Line 2766: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE

2762: -- {End Of Comments}
2763: --
2764: procedure lck_general
2765: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
2766: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
2767: ,p_a_object_version_number in
2768: pay_assignment_actions.object_version_number%TYPE
2769: ,p_only_action_type in pay_payroll_actions.action_type%TYPE
2770: ,p_actual_action_type out nocopy pay_payroll_actions.action_type%TYPE

Line 2769: ,p_only_action_type in pay_payroll_actions.action_type%TYPE

2765: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
2766: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
2767: ,p_a_object_version_number in
2768: pay_assignment_actions.object_version_number%TYPE
2769: ,p_only_action_type in pay_payroll_actions.action_type%TYPE
2770: ,p_actual_action_type out nocopy pay_payroll_actions.action_type%TYPE
2771: ,p_a_action_status out nocopy pay_assignment_actions.
2772: action_status%TYPE
2773: ) is

Line 2770: ,p_actual_action_type out nocopy pay_payroll_actions.action_type%TYPE

2766: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
2767: ,p_a_object_version_number in
2768: pay_assignment_actions.object_version_number%TYPE
2769: ,p_only_action_type in pay_payroll_actions.action_type%TYPE
2770: ,p_actual_action_type out nocopy pay_payroll_actions.action_type%TYPE
2771: ,p_a_action_status out nocopy pay_assignment_actions.
2772: action_status%TYPE
2773: ) is
2774: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;

Line 2777: -- (Locks pay_payroll_actions first, then pay_assignment_actions.)

2773: ) is
2774: v_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
2775: --
2776: -- Cursor selects the 'current' row from the HR Schema
2777: -- (Locks pay_payroll_actions first, then pay_assignment_actions.)
2778: --
2779: Cursor C_Sel1 is
2780: select pya.payroll_action_id
2781: , pya.business_group_id

Line 2796: from pay_payroll_actions pya

2792: , pya.object_version_number
2793: , pya.action_type
2794: , aga.action_status
2795: , aga.object_version_number
2796: from pay_payroll_actions pya
2797: , pay_assignment_actions aga
2798: where /* Payroll action lock */
2799: pya.payroll_action_id = p_payroll_action_id
2800: and ( pya.action_type = p_only_action_type

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

2884: -- The object is locked therefore we need to supply a meaningful
2885: -- error message.
2886: --
2887: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
2888: hr_utility.set_message_token('TABLE_NAME', 'pay_payroll_actions');
2889: hr_utility.raise_error;
2890: End lck_general;
2891: --
2892: -- ----------------------------------------------------------------------------

Line 2897: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

2893: -- |---------------------------------< lck >----------------------------------|
2894: -- ----------------------------------------------------------------------------
2895: --
2896: procedure lck
2897: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
2898: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
2899: ,p_a_object_version_number in
2900: pay_assignment_actions.object_version_number%TYPE
2901: ) is

Line 2898: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE

2894: -- ----------------------------------------------------------------------------
2895: --
2896: procedure lck
2897: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
2898: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
2899: ,p_a_object_version_number in
2900: pay_assignment_actions.object_version_number%TYPE
2901: ) is
2902: v_unwanted_type pay_payroll_actions.action_type%TYPE;

Line 2902: v_unwanted_type pay_payroll_actions.action_type%TYPE;

2898: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
2899: ,p_a_object_version_number in
2900: pay_assignment_actions.object_version_number%TYPE
2901: ) is
2902: v_unwanted_type pay_payroll_actions.action_type%TYPE;
2903: v_unwanted_status pay_assignment_actions.action_status%TYPE;
2904: begin
2905: --
2906: -- Lock the row only if it is a QuickPay Run action

Line 3128: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE

3124: --
3125: procedure insert_validate
3126: (p_rec in out nocopy g_rec_type
3127: ,p_assignment_id in number
3128: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE
3129: ,p_time_period_id out nocopy pay_payroll_actions.time_period_id%TYPE
3130: ) is
3131: --
3132: v_unused_return_b boolean;

Line 3129: ,p_time_period_id out nocopy pay_payroll_actions.time_period_id%TYPE

3125: procedure insert_validate
3126: (p_rec in out nocopy g_rec_type
3127: ,p_assignment_id in number
3128: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE
3129: ,p_time_period_id out nocopy pay_payroll_actions.time_period_id%TYPE
3130: ) is
3131: --
3132: v_unused_return_b boolean;
3133: v_unused_return_d date;

Line 3136: v_payroll_id pay_payroll_actions.payroll_id%TYPE;

3132: v_unused_return_b boolean;
3133: v_unused_return_d date;
3134: v_legislation_code per_business_groups.legislation_code%TYPE;
3135: v_unused_return_nam per_time_periods.period_name%TYPE;
3136: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
3137: v_time_period_id pay_payroll_actions.time_period_id%TYPE;
3138: v_proc varchar2(72) := g_package||'insert_validate';
3139: --
3140: Begin

Line 3137: v_time_period_id pay_payroll_actions.time_period_id%TYPE;

3133: v_unused_return_d date;
3134: v_legislation_code per_business_groups.legislation_code%TYPE;
3135: v_unused_return_nam per_time_periods.period_name%TYPE;
3136: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
3137: v_time_period_id pay_payroll_actions.time_period_id%TYPE;
3138: v_proc varchar2(72) := g_package||'insert_validate';
3139: --
3140: Begin
3141: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 3412: v_payroll_id pay_payroll_actions.payroll_id%TYPE;

3408: v_proc varchar2(72) := g_package||'ins';
3409: --
3410: -- These variables are set by insert_validate and past to insert_dml
3411: --
3412: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
3413: v_time_period_id pay_payroll_actions.time_period_id%TYPE;
3414: --
3415: -- These variables are set by pre_insert and past to insert_dml
3416: --

Line 3413: v_time_period_id pay_payroll_actions.time_period_id%TYPE;

3409: --
3410: -- These variables are set by insert_validate and past to insert_dml
3411: --
3412: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
3413: v_time_period_id pay_payroll_actions.time_period_id%TYPE;
3414: --
3415: -- These variables are set by pre_insert and past to insert_dml
3416: --
3417: v_action_type pay_payroll_actions.action_type%TYPE;

Line 3417: v_action_type pay_payroll_actions.action_type%TYPE;

3413: v_time_period_id pay_payroll_actions.time_period_id%TYPE;
3414: --
3415: -- These variables are set by pre_insert and past to insert_dml
3416: --
3417: v_action_type pay_payroll_actions.action_type%TYPE;
3418: v_action_population_status pay_payroll_actions.action_population_status%TYPE;
3419: --
3420: -- These variables are set by post_insert and returned from this procedure
3421: --

Line 3418: v_action_population_status pay_payroll_actions.action_population_status%TYPE;

3414: --
3415: -- These variables are set by pre_insert and past to insert_dml
3416: --
3417: v_action_type pay_payroll_actions.action_type%TYPE;
3418: v_action_population_status pay_payroll_actions.action_population_status%TYPE;
3419: --
3420: -- These variables are set by post_insert and returned from this procedure
3421: --
3422: v_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 3808: ,p_df_effective_date out nocopy pay_payroll_actions.

3804: -- ----------------------------------------------------------------------------
3805: --
3806: procedure default_values
3807: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
3808: ,p_df_effective_date out nocopy pay_payroll_actions.
3809: effective_date%TYPE
3810: ,p_df_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
3811: ,p_period_name out nocopy per_time_periods.period_name%TYPE
3812: ,p_consolidation_set_id out nocopy pay_consolidation_sets.

Line 3810: ,p_df_date_earned out nocopy pay_payroll_actions.date_earned%TYPE

3806: procedure default_values
3807: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
3808: ,p_df_effective_date out nocopy pay_payroll_actions.
3809: effective_date%TYPE
3810: ,p_df_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
3811: ,p_period_name out nocopy per_time_periods.period_name%TYPE
3812: ,p_consolidation_set_id out nocopy pay_consolidation_sets.
3813: consolidation_set_id%TYPE
3814: ,p_consolidation_set_name out nocopy pay_consolidation_sets.

Line 3892: v_df_effective_date pay_payroll_actions.effective_date%TYPE;

3888: -- The Form or Database session effective date.
3889: v_eff_date date;
3890: --
3891: -- Working value which is used to set the out argument p_df_effective_date.
3892: v_df_effective_date pay_payroll_actions.effective_date%TYPE;
3893: --
3894: -- Working value which is used to set the out argument p_df_date_earned.
3895: v_df_date_earned pay_payroll_actions.date_earned%TYPE;
3896: --

Line 3895: v_df_date_earned pay_payroll_actions.date_earned%TYPE;

3891: -- Working value which is used to set the out argument p_df_effective_date.
3892: v_df_effective_date pay_payroll_actions.effective_date%TYPE;
3893: --
3894: -- Working value which is used to set the out argument p_df_date_earned.
3895: v_df_date_earned pay_payroll_actions.date_earned%TYPE;
3896: --
3897: -- Working value which is used to set the out argument p_period_name;
3898: v_df_period_name per_time_periods.period_name%TYPE;
3899: --

Line 4107: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

4103: --
4104: -- {End Of Comments}
4105: --
4106: procedure get_latest_status
4107: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
4108: ,p_p_action_status out nocopy pay_payroll_actions.action_status%TYPE
4109: ,p_display_run_number out nocopy pay_payroll_actions.
4110: display_run_number%TYPE
4111: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE

Line 4108: ,p_p_action_status out nocopy pay_payroll_actions.action_status%TYPE

4104: -- {End Of Comments}
4105: --
4106: procedure get_latest_status
4107: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
4108: ,p_p_action_status out nocopy pay_payroll_actions.action_status%TYPE
4109: ,p_display_run_number out nocopy pay_payroll_actions.
4110: display_run_number%TYPE
4111: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
4112: ) is

Line 4109: ,p_display_run_number out nocopy pay_payroll_actions.

4105: --
4106: procedure get_latest_status
4107: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
4108: ,p_p_action_status out nocopy pay_payroll_actions.action_status%TYPE
4109: ,p_display_run_number out nocopy pay_payroll_actions.
4110: display_run_number%TYPE
4111: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
4112: ) is
4113: v_proc varchar2(72) := g_package||'get_latest_status';

Line 4120: from pay_payroll_actions pya

4116: cursor cur_stat is
4117: select pya.action_status
4118: , pya.display_run_number
4119: , aga.action_status
4120: from pay_payroll_actions pya
4121: , pay_assignment_actions aga
4122: where pya.payroll_action_id = p_payroll_action_id
4123: and aga.payroll_action_id = pya.payroll_action_id;
4124: begin

Line 4158: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

4154: -- |--------------------------< start_quickpay_process >----------------------|
4155: -- ----------------------------------------------------------------------------
4156: --
4157: procedure start_quickpay_process
4158: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
4159: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
4160: ,p_a_object_version_number in pay_assignment_actions.
4161: object_version_number%TYPE
4162: ,p_status in out nocopy varchar2

Line 4159: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE

4155: -- ----------------------------------------------------------------------------
4156: --
4157: procedure start_quickpay_process
4158: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
4159: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
4160: ,p_a_object_version_number in pay_assignment_actions.
4161: object_version_number%TYPE
4162: ,p_status in out nocopy varchar2
4163: ) is

Line 4165: v_request_id pay_payroll_actions.request_id%TYPE;

4161: object_version_number%TYPE
4162: ,p_status in out nocopy varchar2
4163: ) is
4164: v_proc varchar2(72) := g_package||'start_quickpay_process';
4165: v_request_id pay_payroll_actions.request_id%TYPE;
4166: v_action_type pay_payroll_actions.action_type%TYPE;
4167: v_a_action_status pay_assignment_actions.action_status%TYPE;
4168: v_leg_code per_business_groups.legislation_code%TYPE;
4169: v_process_name varchar2(30);

Line 4166: v_action_type pay_payroll_actions.action_type%TYPE;

4162: ,p_status in out nocopy varchar2
4163: ) is
4164: v_proc varchar2(72) := g_package||'start_quickpay_process';
4165: v_request_id pay_payroll_actions.request_id%TYPE;
4166: v_action_type pay_payroll_actions.action_type%TYPE;
4167: v_a_action_status pay_assignment_actions.action_status%TYPE;
4168: v_leg_code per_business_groups.legislation_code%TYPE;
4169: v_process_name varchar2(30);
4170: v_first_arg varchar2(30);

Line 4195: pay_payroll_actions PACT

4191: FROM pay_element_types_f ET,
4192: pay_element_links_f EL,
4193: pay_element_entries_f EE,
4194: pay_assignment_actions ACT,
4195: pay_payroll_actions PACT
4196: WHERE ACT.assignment_action_id = v_asactid
4197: AND PACT.payroll_action_id = p_payroll_action_id
4198: AND EE.assignment_id = ACT.assignment_id
4199: AND ((p_use_qpay_excl_model = 'N'

Line 4250: pay_payroll_actions PACT,

4246: FROM pay_element_types_f ET,
4247: pay_element_links_f EL,
4248: pay_element_entries_f EE,
4249: pay_assignment_actions ACT,
4250: pay_payroll_actions PACT,
4251: pay_element_entry_values_f EEV
4252: WHERE PACT.payroll_action_id = p_payroll_action_id
4253: and PACT.payroll_action_id = ACT.payroll_action_id
4254: and ACT.action_status not in ('C', 'S')

Line 4304: from pay_payroll_actions ppa,

4300: AND EE.effective_end_date = nvl(EEV.effective_end_date,
4301: EE.effective_end_date)
4302: AND ET.processing_type = 'R'
4303: AND EXISTS ( select ''
4304: from pay_payroll_actions ppa,
4305: per_time_periods ptp,
4306: pay_element_entries_f pee
4307: where pee.element_entry_id = EE.element_entry_id
4308: and ppa.payroll_action_id = ACT.payroll_action_id

Line 4346: pay_payroll_actions ppa

4342: --
4343: select pbg.legislation_code
4344: into v_leg_code
4345: from per_business_groups_perf pbg,
4346: pay_payroll_actions ppa
4347: where ppa.payroll_action_id = p_payroll_action_id
4348: and pbg.business_group_id = ppa.business_group_id;
4349: --
4350: -- Bugfix for 2177986: Unable to process separate payment elements in QuickPay.

Line 4451: update pay_payroll_actions

4447: --
4448: -- Request has been accepted update payroll_actions
4449: -- with the request details.
4450: --
4451: update pay_payroll_actions
4452: set request_id = v_request_id
4453: where payroll_action_id = p_payroll_action_id;
4454: --
4455: end if;

Line 4467: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

4463: -- |--------------------------< wait_quickpay_process >-----------------------|
4464: -- ----------------------------------------------------------------------------
4465: --
4466: procedure wait_quickpay_process
4467: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
4468: ,p_display_run_number out nocopy pay_payroll_actions.
4469: display_run_number%TYPE
4470: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
4471: ,p_process_info out nocopy varchar2

Line 4468: ,p_display_run_number out nocopy pay_payroll_actions.

4464: -- ----------------------------------------------------------------------------
4465: --
4466: procedure wait_quickpay_process
4467: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
4468: ,p_display_run_number out nocopy pay_payroll_actions.
4469: display_run_number%TYPE
4470: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
4471: ,p_process_info out nocopy varchar2
4472: ,p_request_id out nocopy pay_payroll_actions.request_id%TYPE

Line 4472: ,p_request_id out nocopy pay_payroll_actions.request_id%TYPE

4468: ,p_display_run_number out nocopy pay_payroll_actions.
4469: display_run_number%TYPE
4470: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
4471: ,p_process_info out nocopy varchar2
4472: ,p_request_id out nocopy pay_payroll_actions.request_id%TYPE
4473: ) is
4474: v_wait boolean;
4475: v_phase varchar2(255);
4476: v_status varchar2(255);

Line 4482: v_request_id pay_payroll_actions.request_id%TYPE;

4478: v_dev_status varchar2(255);
4479: v_message varchar2(255);
4480: v_max_wait_sec number;
4481: v_interval_wait_sec number;
4482: v_request_id pay_payroll_actions.request_id%TYPE;
4483: v_p_action_status pay_payroll_actions.action_status%TYPE;
4484: v_proc varchar2(72) := g_package||'start_quickpay_run';
4485: --
4486: cursor cur_req is

Line 4483: v_p_action_status pay_payroll_actions.action_status%TYPE;

4479: v_message varchar2(255);
4480: v_max_wait_sec number;
4481: v_interval_wait_sec number;
4482: v_request_id pay_payroll_actions.request_id%TYPE;
4483: v_p_action_status pay_payroll_actions.action_status%TYPE;
4484: v_proc varchar2(72) := g_package||'start_quickpay_run';
4485: --
4486: cursor cur_req is
4487: select request_id

Line 4488: from pay_payroll_actions

4484: v_proc varchar2(72) := g_package||'start_quickpay_run';
4485: --
4486: cursor cur_req is
4487: select request_id
4488: from pay_payroll_actions
4489: where payroll_action_id = p_payroll_action_id;
4490: --
4491: cursor cur_max is
4492: select fnd_number.canonical_to_number(parameter_value)

Line 4527: -- not be in pay_payroll_actions in the first place.)

4523: hr_utility.set_location(v_proc, 7);
4524: --
4525: -- Check the request_id has been set. A value of zero means the submit
4526: -- request was not accepted by the concurrent manager. (This value should
4527: -- not be in pay_payroll_actions in the first place.)
4528: --
4529: if (v_request_id is null) or (v_request_id = 0) then
4530: -- Error: You have attempted to wait for a request to finish, when no
4531: -- request has been submitted for this QuickPay Run or QuickPay