70: ,p_chunk in number
71: );
72:
73: procedure archive_code
74: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
75: ,p_effective_date in pay_payroll_actions.effective_date%type
76: );
77:
78: procedure spawn_archive_reports
77:
78: procedure spawn_archive_reports
79: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
80:
81: procedure get_fbt_balance(p_assignment_id in pay_assignment_actions.assignment_id%type
82: ,p_start_date in date
83: ,p_end_date in date
84: ,p_action_sequence out nocopy number);
85:
82: ,p_start_date in date
83: ,p_end_date in date
84: ,p_action_sequence out nocopy number);
85:
86: procedure archive_element_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
87: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
88: ,p_effective_date in date
89: ,p_pre01jul1983_ratio in number
90: ,p_post30jun1983_ratio in number
83: ,p_end_date in date
84: ,p_action_sequence out nocopy number);
85:
86: procedure archive_element_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
87: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
88: ,p_effective_date in date
89: ,p_pre01jul1983_ratio in number
90: ,p_post30jun1983_ratio in number
91: ,p_allowance_exists out nocopy number);
89: ,p_pre01jul1983_ratio in number
90: ,p_post30jun1983_ratio in number
91: ,p_allowance_exists out nocopy number);
92:
93: procedure Adjust_lumpsum_E_payments(p_assignment_id in pay_assignment_actions.assignment_id%type);
94:
95: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
96: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type);
97:
91: ,p_allowance_exists out nocopy number);
92:
93: procedure Adjust_lumpsum_E_payments(p_assignment_id in pay_assignment_actions.assignment_id%type);
94:
95: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
96: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type);
97:
98: procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
99: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
92:
93: procedure Adjust_lumpsum_E_payments(p_assignment_id in pay_assignment_actions.assignment_id%type);
94:
95: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
96: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type);
97:
98: procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
99: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
100: ,p_effective_date in date
94:
95: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
96: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type);
97:
98: procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
99: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
100: ,p_effective_date in date
101: ,p_pre01jul1983_ratio in number
102: ,p_post30jun1983_ratio in number
95: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
96: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type);
97:
98: procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
99: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
100: ,p_effective_date in date
101: ,p_pre01jul1983_ratio in number
102: ,p_post30jun1983_ratio in number
103: ,p_run_action_sequence in pay_assignment_actions.action_sequence%type);
99: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
100: ,p_effective_date in date
101: ,p_pre01jul1983_ratio in number
102: ,p_post30jun1983_ratio in number
103: ,p_run_action_sequence in pay_assignment_actions.action_sequence%type);
104:
105: /* Bug 3891577 - Procedure to populate Allowance Balances for Summary Report */
106: procedure summary_rep_populate_allowance(p_assignment_id in per_all_assignments_f.assignment_id%type
107: ,p_allowance_exists out nocopy number);