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 225: (p_date_earned in pay_payroll_actions.date_earned%TYPE

221: --
222: -- {End Of Comments}
223: --
224: procedure chk_date_earned
225: (p_date_earned in pay_payroll_actions.date_earned%TYPE
226: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
227: ,p_legislation_code in per_business_groups.legislation_code%TYPE
228: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
229: );

Line 228: ,p_effective_date in pay_payroll_actions.effective_date%TYPE

224: procedure chk_date_earned
225: (p_date_earned in pay_payroll_actions.date_earned%TYPE
226: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
227: ,p_legislation_code in per_business_groups.legislation_code%TYPE
228: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
229: );
230: --
231: -- ----------------------------------------------------------------------------
232: -- |-------------------------< chk_for_con_request >--------------------------|

Line 260: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

256: --
257: -- {End Of Comments}
258: --
259: procedure chk_for_con_request
260: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
261: );
262: --
263: -- ----------------------------------------------------------------------------
264: -- |------------------------< return_api_dml_status >-------------------------|

Line 352: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

348: --
349: -- {End Of Comments}
350: --
351: procedure lck
352: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
353: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
354: ,p_a_object_version_number in
355: pay_assignment_actions.object_version_number%TYPE
356: );

Line 353: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE

349: -- {End Of Comments}
350: --
351: procedure lck
352: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
353: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
354: ,p_a_object_version_number in
355: pay_assignment_actions.object_version_number%TYPE
356: );
357: --

Line 930: ,p_df_effective_date out nocopy pay_payroll_actions.

926: -- {End Of Comments}
927: --
928: Procedure default_values
929: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
930: ,p_df_effective_date out nocopy pay_payroll_actions.
931: effective_date%TYPE
932: ,p_df_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
933: ,p_period_name out nocopy per_time_periods.period_name%TYPE
934: ,p_consolidation_set_id out nocopy pay_consolidation_sets.

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

928: Procedure default_values
929: (p_assignment_id in pay_assignment_actions.assignment_id%TYPE
930: ,p_df_effective_date out nocopy pay_payroll_actions.
931: effective_date%TYPE
932: ,p_df_date_earned out nocopy pay_payroll_actions.date_earned%TYPE
933: ,p_period_name out nocopy per_time_periods.period_name%TYPE
934: ,p_consolidation_set_id out nocopy pay_consolidation_sets.
935: consolidation_set_id%TYPE
936: ,p_consolidation_set_name out nocopy pay_consolidation_sets.

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

973: -- All the arguments are mandatory.
974: --
975: -- Post Success:
976: -- An AOL process request was successfully submitted to the concurrent
977: -- manager and the request_id was updated on the pay_payroll_actions table.
978: -- If this procedure call is successful the caller code must issue a commit.
979: -- This must be done otherwise the concurrent manager will not start the
980: -- request running.
981: --

Line 996: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

992: -- Public.
993: --
994: -- {End Of Comments}
995: procedure start_quickpay_process
996: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
997: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
998: ,p_a_object_version_number in pay_assignment_actions.object_version_number%TYPE
999: ,p_status in out nocopy varchar2
1000: );

Line 997: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE

993: --
994: -- {End Of Comments}
995: procedure start_quickpay_process
996: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
997: ,p_p_object_version_number in pay_payroll_actions.object_version_number%TYPE
998: ,p_a_object_version_number in pay_assignment_actions.object_version_number%TYPE
999: ,p_status in out nocopy varchar2
1000: );
1001: --

Line 1044: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

1040: --
1041: -- {End Of Comments}
1042: --
1043: procedure wait_quickpay_process
1044: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
1045: ,p_display_run_number out nocopy pay_payroll_actions.
1046: display_run_number%TYPE
1047: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
1048: ,p_process_info out nocopy varchar2

Line 1045: ,p_display_run_number out nocopy pay_payroll_actions.

1041: -- {End Of Comments}
1042: --
1043: procedure wait_quickpay_process
1044: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
1045: ,p_display_run_number out nocopy pay_payroll_actions.
1046: display_run_number%TYPE
1047: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
1048: ,p_process_info out nocopy varchar2
1049: ,p_request_id out nocopy pay_payroll_actions.request_id%TYPE

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

1045: ,p_display_run_number out nocopy pay_payroll_actions.
1046: display_run_number%TYPE
1047: ,p_a_action_status out nocopy pay_assignment_actions.action_status%TYPE
1048: ,p_process_info out nocopy varchar2
1049: ,p_request_id out nocopy pay_payroll_actions.request_id%TYPE
1050: );
1051: --
1052:
1053: end pay_qpq_api;