74: ,p_chunk in number
75: );
76:
77: procedure archive_code
78: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
79: ,p_effective_date in pay_payroll_actions.effective_date%type
80: );
81:
82: procedure spawn_archive_reports
81:
82: procedure spawn_archive_reports
83: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
84:
85: procedure get_fbt_balance(p_assignment_id in pay_assignment_actions.assignment_id%type
86: ,p_start_date in date
87: ,p_end_date in date
88: ,p_action_sequence out nocopy number);
89:
86: ,p_start_date in date
87: ,p_end_date in date
88: ,p_action_sequence out nocopy number);
89:
90: procedure archive_element_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
91: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
92: ,p_effective_date in date
93: ,p_pre01jul1983_ratio in number
94: ,p_post30jun1983_ratio in number);
87: ,p_end_date in date
88: ,p_action_sequence out nocopy number);
89:
90: procedure archive_element_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
91: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
92: ,p_effective_date in date
93: ,p_pre01jul1983_ratio in number
94: ,p_post30jun1983_ratio in number);
95:
94: ,p_post30jun1983_ratio in number);
95:
96: /*bug8711855 - p_assignment_action_id and p_registered_employer parameter are added to call
97: pay_au_payment_summary.get_retro_lumpsumE_value function */
98: procedure Adjust_lumpsum_E_payments(p_assignment_id in pay_assignment_actions.assignment_id%type);
99:
100: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
101: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type);
102:
96: /*bug8711855 - p_assignment_action_id and p_registered_employer parameter are added to call
97: pay_au_payment_summary.get_retro_lumpsumE_value function */
98: procedure Adjust_lumpsum_E_payments(p_assignment_id in pay_assignment_actions.assignment_id%type);
99:
100: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
101: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type);
102:
103: procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
104: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
97: pay_au_payment_summary.get_retro_lumpsumE_value function */
98: procedure Adjust_lumpsum_E_payments(p_assignment_id in pay_assignment_actions.assignment_id%type);
99:
100: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
101: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type);
102:
103: procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
104: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
105: ,p_effective_date in date
99:
100: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
101: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type);
102:
103: procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
104: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
105: ,p_effective_date in date
106: ,p_pre01jul1983_ratio in number
107: ,p_post30jun1983_ratio in number
100: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
101: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type);
102:
103: procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
104: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
105: ,p_effective_date in date
106: ,p_pre01jul1983_ratio in number
107: ,p_post30jun1983_ratio in number
108: ,p_run_action_sequence in pay_assignment_actions.action_sequence%type);
104: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
105: ,p_effective_date in date
106: ,p_pre01jul1983_ratio in number
107: ,p_post30jun1983_ratio in number
108: ,p_run_action_sequence in pay_assignment_actions.action_sequence%type);
109:
110:
111: /* Bug 3891577 - Procedure to spawn report for Summary Report */
112: procedure spawn_summary_reports