DBA Data[Home] [Help]

APPS.PAY_QPQ_API dependencies on PAY_PAYROLL_ACTIONS

Line 175: (p_effective_date in pay_payroll_actions.effective_date%TYPE

171: --
172: -- {End Of Comments}
173: --
174: procedure chk_eff_date
175: (p_effective_date in pay_payroll_actions.effective_date%TYPE
176: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
177: ,p_legislation_code in per_business_groups.legislation_code%TYPE
178: ,p_recal_date_earned in boolean
179: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE

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

175: (p_effective_date in pay_payroll_actions.effective_date%TYPE
176: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
177: ,p_legislation_code in per_business_groups.legislation_code%TYPE
178: ,p_recal_date_earned in boolean
179: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE
180: ,p_time_period_id out nocopy pay_payroll_actions.time_period_id%TYPE
181: ,p_period_name out nocopy per_time_periods.period_name%TYPE
182: ,p_new_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
183: );

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

176: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
177: ,p_legislation_code in per_business_groups.legislation_code%TYPE
178: ,p_recal_date_earned in boolean
179: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE
180: ,p_time_period_id out nocopy pay_payroll_actions.time_period_id%TYPE
181: ,p_period_name out nocopy per_time_periods.period_name%TYPE
182: ,p_new_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
183: );
184: --

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

178: ,p_recal_date_earned in boolean
179: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE
180: ,p_time_period_id out nocopy pay_payroll_actions.time_period_id%TYPE
181: ,p_period_name out nocopy per_time_periods.period_name%TYPE
182: ,p_new_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
183: );
184: --
185: -- ----------------------------------------------------------------------------
186: -- |----------------------------< chk_date_earned >---------------------------|

Line 230: (p_date_earned in pay_payroll_actions.date_earned%TYPE

226: --
227: -- {End Of Comments}
228: --
229: procedure chk_date_earned
230: (p_date_earned in pay_payroll_actions.date_earned%TYPE
231: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
232: ,p_legislation_code in per_business_groups.legislation_code%TYPE
233: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
234: ,p_payroll_id in out nocopy pay_payroll_actions.payroll_id%TYPE

Line 233: ,p_effective_date in pay_payroll_actions.effective_date%TYPE

229: procedure chk_date_earned
230: (p_date_earned in pay_payroll_actions.date_earned%TYPE
231: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
232: ,p_legislation_code in per_business_groups.legislation_code%TYPE
233: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
234: ,p_payroll_id in out nocopy pay_payroll_actions.payroll_id%TYPE
235: ,p_time_period_id in out nocopy pay_payroll_actions.time_period_id%TYPE
236: ,p_period_name in out nocopy per_time_periods.period_name%TYPE
237: );

Line 234: ,p_payroll_id in out nocopy pay_payroll_actions.payroll_id%TYPE

230: (p_date_earned in pay_payroll_actions.date_earned%TYPE
231: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
232: ,p_legislation_code in per_business_groups.legislation_code%TYPE
233: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
234: ,p_payroll_id in out nocopy pay_payroll_actions.payroll_id%TYPE
235: ,p_time_period_id in out nocopy pay_payroll_actions.time_period_id%TYPE
236: ,p_period_name in out nocopy per_time_periods.period_name%TYPE
237: );
238: --

Line 235: ,p_time_period_id in out nocopy pay_payroll_actions.time_period_id%TYPE

231: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
232: ,p_legislation_code in per_business_groups.legislation_code%TYPE
233: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
234: ,p_payroll_id in out nocopy pay_payroll_actions.payroll_id%TYPE
235: ,p_time_period_id in out nocopy pay_payroll_actions.time_period_id%TYPE
236: ,p_period_name in out nocopy per_time_periods.period_name%TYPE
237: );
238: --
239: -- ----------------------------------------------------------------------------

Line 268: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

264: --
265: -- {End Of Comments}
266: --
267: procedure chk_for_con_request
268: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
269: );
270: --
271: -- ----------------------------------------------------------------------------
272: -- |------------------------< return_api_dml_status >-------------------------|

Line 360: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

356: --
357: -- {End Of Comments}
358: --
359: procedure lck
360: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
361: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
362: ,p_a_object_version_number in
363: pay_assignment_actions.object_version_number%TYPE
364: );

Line 361: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE

357: -- {End Of Comments}
358: --
359: procedure lck
360: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
361: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
362: ,p_a_object_version_number in
363: pay_assignment_actions.object_version_number%TYPE
364: );
365: --

Line 938: ,p_df_effective_date out nocopy pay_payroll_actions.

934: -- {End Of Comments}
935: --
936: Procedure default_values
937: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
938: ,p_df_effective_date out nocopy pay_payroll_actions.
939: effective_date%TYPE
940: ,p_df_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
941: ,p_period_name out nocopy per_time_periods.period_name%TYPE
942: ,p_consolidation_set_id out nocopy pay_consolidation_sets.

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

936: Procedure default_values
937: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
938: ,p_df_effective_date out nocopy pay_payroll_actions.
939: effective_date%TYPE
940: ,p_df_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
941: ,p_period_name out nocopy per_time_periods.period_name%TYPE
942: ,p_consolidation_set_id out nocopy pay_consolidation_sets.
943: consolidation_set_id%TYPE
944: ,p_consolidation_set_name out nocopy pay_consolidation_sets.

Line 985: -- manager and the request_id was updated on the pay_payroll_actions table.

981: -- All the arguments are mandatory.
982: --
983: -- Post Success:
984: -- An AOL process request was successfully submitted to the concurrent
985: -- manager and the request_id was updated on the pay_payroll_actions table.
986: -- If this procedure call is successful the caller code must issue a commit.
987: -- This must be done otherwise the concurrent manager will not start the
988: -- request running.
989: --

Line 1004: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

1000: -- Public.
1001: --
1002: -- {End Of Comments}
1003: procedure start_quickpay_process
1004: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
1005: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
1006: ,p_a_object_version_number in pay_assignment_actions.object_version_number%TYPE
1007: ,p_status in out nocopy varchar2
1008: );

Line 1005: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE

1001: --
1002: -- {End Of Comments}
1003: procedure start_quickpay_process
1004: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
1005: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
1006: ,p_a_object_version_number in pay_assignment_actions.object_version_number%TYPE
1007: ,p_status in out nocopy varchar2
1008: );
1009: --

Line 1052: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

1048: --
1049: -- {End Of Comments}
1050: --
1051: procedure wait_quickpay_process
1052: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
1053: ,p_display_run_number out nocopy pay_payroll_actions.
1054: display_run_number%TYPE
1055: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
1056: ,p_process_info out nocopy varchar2

Line 1053: ,p_display_run_number out nocopy pay_payroll_actions.

1049: -- {End Of Comments}
1050: --
1051: procedure wait_quickpay_process
1052: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
1053: ,p_display_run_number out nocopy pay_payroll_actions.
1054: display_run_number%TYPE
1055: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
1056: ,p_process_info out nocopy varchar2
1057: ,p_request_id out nocopy pay_payroll_actions.request_id%TYPE

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

1053: ,p_display_run_number out nocopy pay_payroll_actions.
1054: display_run_number%TYPE
1055: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
1056: ,p_process_info out nocopy varchar2
1057: ,p_request_id out nocopy pay_payroll_actions.request_id%TYPE
1058: );
1059: --
1060:
1061: end pay_qpq_api;