[Home] [Help]
33:
34: begin
35:
36: IF g_debug THEN
37: hr_utility.trace('Entering:' || g_package || 'get_au_rec_balances');
38: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);
39: END IF;
40:
41: /* Call to this function below implements Batch Balance Retrieval for better performance */
34: begin
35:
36: IF g_debug THEN
37: hr_utility.trace('Entering:' || g_package || 'get_au_rec_balances');
38: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);
39: END IF;
40:
41: /* Call to this function below implements Batch Balance Retrieval for better performance */
42:
53: /* pay_balance_pkg.get_value ( p_assignment_action_id => p_assignment_action_id
54: , p_defined_balance_lst => g_balance_value_tab );*/
55:
56: IF g_debug THEN
57: hr_utility.trace('Balance values for RUN dimension');
58: hr_utility.trace('-------------------------------------');
59: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
60: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
61: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
54: , p_defined_balance_lst => g_balance_value_tab );*/
55:
56: IF g_debug THEN
57: hr_utility.trace('Balance values for RUN dimension');
58: hr_utility.trace('-------------------------------------');
59: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
60: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
61: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
62: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
55:
56: IF g_debug THEN
57: hr_utility.trace('Balance values for RUN dimension');
58: hr_utility.trace('-------------------------------------');
59: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
60: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
61: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
62: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
63: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
56: IF g_debug THEN
57: hr_utility.trace('Balance values for RUN dimension');
58: hr_utility.trace('-------------------------------------');
59: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
60: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
61: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
62: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
63: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
64: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
57: hr_utility.trace('Balance values for RUN dimension');
58: hr_utility.trace('-------------------------------------');
59: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
60: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
61: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
62: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
63: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
64: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
65: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
58: hr_utility.trace('-------------------------------------');
59: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
60: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
61: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
62: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
63: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
64: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
65: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
66: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
59: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
60: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
61: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
62: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
63: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
64: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
65: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
66: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
67: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
60: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
61: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
62: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
63: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
64: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
65: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
66: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
67: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
68: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
61: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
62: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
63: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
64: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
65: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
66: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
67: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
68: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
69: END IF;
62: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
63: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
64: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
65: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
66: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
67: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
68: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
69: END IF;
70:
63: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
64: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
65: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
66: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
67: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
68: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
69: END IF;
70:
71: /* Bug 3953706 - Modified calculation of Earnings and deductions as given below:
64: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
65: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
66: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
67: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
68: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
69: END IF;
70:
71: /* Bug 3953706 - Modified calculation of Earnings and deductions as given below:
72: Calculations :-
93: p_net_payment := p_taxable_earnings + p_non_taxable_earnings - p_tax - p_deductions + p_direct_payments;
94: p_employer_charges := g_result_table(10).balance_value;
95:
96: IF g_debug THEN
97: hr_utility.trace('p_taxable_earnings ===>' || p_taxable_earnings);
98: hr_utility.trace('p_non_taxable_earnings ===>' || p_non_taxable_earnings);
99: hr_utility.trace('p_deductions ===>' || p_deductions);
100: hr_utility.trace('p_tax ===>' || p_tax);
101: hr_utility.trace('p_net_payment ===>' || p_net_payment);
94: p_employer_charges := g_result_table(10).balance_value;
95:
96: IF g_debug THEN
97: hr_utility.trace('p_taxable_earnings ===>' || p_taxable_earnings);
98: hr_utility.trace('p_non_taxable_earnings ===>' || p_non_taxable_earnings);
99: hr_utility.trace('p_deductions ===>' || p_deductions);
100: hr_utility.trace('p_tax ===>' || p_tax);
101: hr_utility.trace('p_net_payment ===>' || p_net_payment);
102: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
95:
96: IF g_debug THEN
97: hr_utility.trace('p_taxable_earnings ===>' || p_taxable_earnings);
98: hr_utility.trace('p_non_taxable_earnings ===>' || p_non_taxable_earnings);
99: hr_utility.trace('p_deductions ===>' || p_deductions);
100: hr_utility.trace('p_tax ===>' || p_tax);
101: hr_utility.trace('p_net_payment ===>' || p_net_payment);
102: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
103: hr_utility.trace('p_gross_earnings ===>' || p_gross_earnings);
96: IF g_debug THEN
97: hr_utility.trace('p_taxable_earnings ===>' || p_taxable_earnings);
98: hr_utility.trace('p_non_taxable_earnings ===>' || p_non_taxable_earnings);
99: hr_utility.trace('p_deductions ===>' || p_deductions);
100: hr_utility.trace('p_tax ===>' || p_tax);
101: hr_utility.trace('p_net_payment ===>' || p_net_payment);
102: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
103: hr_utility.trace('p_gross_earnings ===>' || p_gross_earnings);
104: hr_utility.trace('p_pre_tax_deduction ===>' || p_pre_tax_deductions);
97: hr_utility.trace('p_taxable_earnings ===>' || p_taxable_earnings);
98: hr_utility.trace('p_non_taxable_earnings ===>' || p_non_taxable_earnings);
99: hr_utility.trace('p_deductions ===>' || p_deductions);
100: hr_utility.trace('p_tax ===>' || p_tax);
101: hr_utility.trace('p_net_payment ===>' || p_net_payment);
102: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
103: hr_utility.trace('p_gross_earnings ===>' || p_gross_earnings);
104: hr_utility.trace('p_pre_tax_deduction ===>' || p_pre_tax_deductions);
105: hr_utility.trace('p_direct_payments ===>' || p_direct_payments);
98: hr_utility.trace('p_non_taxable_earnings ===>' || p_non_taxable_earnings);
99: hr_utility.trace('p_deductions ===>' || p_deductions);
100: hr_utility.trace('p_tax ===>' || p_tax);
101: hr_utility.trace('p_net_payment ===>' || p_net_payment);
102: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
103: hr_utility.trace('p_gross_earnings ===>' || p_gross_earnings);
104: hr_utility.trace('p_pre_tax_deduction ===>' || p_pre_tax_deductions);
105: hr_utility.trace('p_direct_payments ===>' || p_direct_payments);
106: END IF;
99: hr_utility.trace('p_deductions ===>' || p_deductions);
100: hr_utility.trace('p_tax ===>' || p_tax);
101: hr_utility.trace('p_net_payment ===>' || p_net_payment);
102: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
103: hr_utility.trace('p_gross_earnings ===>' || p_gross_earnings);
104: hr_utility.trace('p_pre_tax_deduction ===>' || p_pre_tax_deductions);
105: hr_utility.trace('p_direct_payments ===>' || p_direct_payments);
106: END IF;
107:
100: hr_utility.trace('p_tax ===>' || p_tax);
101: hr_utility.trace('p_net_payment ===>' || p_net_payment);
102: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
103: hr_utility.trace('p_gross_earnings ===>' || p_gross_earnings);
104: hr_utility.trace('p_pre_tax_deduction ===>' || p_pre_tax_deductions);
105: hr_utility.trace('p_direct_payments ===>' || p_direct_payments);
106: END IF;
107:
108:
101: hr_utility.trace('p_net_payment ===>' || p_net_payment);
102: hr_utility.trace('p_employer_charges ===>' || p_employer_charges);
103: hr_utility.trace('p_gross_earnings ===>' || p_gross_earnings);
104: hr_utility.trace('p_pre_tax_deduction ===>' || p_pre_tax_deductions);
105: hr_utility.trace('p_direct_payments ===>' || p_direct_payments);
106: END IF;
107:
108:
109: end get_au_rec_balances;
127:
128: begin
129:
130: IF g_debug THEN
131: hr_utility.trace('Entering:' || g_package || 'get_ytd_au_rec_balances');
132: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);
133: END IF;
134:
135: /* Call to this function below implements Batch Balance Retrieval for better performance */
128: begin
129:
130: IF g_debug THEN
131: hr_utility.trace('Entering:' || g_package || 'get_ytd_au_rec_balances');
132: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);
133: END IF;
134:
135: /* Call to this function below implements Batch Balance Retrieval for better performance */
136:
147: /* pay_balance_pkg.get_value ( p_assignment_action_id => p_assignment_action_id
148: , p_defined_balance_lst => g_balance_value_tab );*/
149:
150: IF g_debug THEN
151: hr_utility.trace('Balance values for YTD dimension');
152: hr_utility.trace('-------------------------------------');
153: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
154: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
155: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
148: , p_defined_balance_lst => g_balance_value_tab );*/
149:
150: IF g_debug THEN
151: hr_utility.trace('Balance values for YTD dimension');
152: hr_utility.trace('-------------------------------------');
153: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
154: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
155: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
156: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
149:
150: IF g_debug THEN
151: hr_utility.trace('Balance values for YTD dimension');
152: hr_utility.trace('-------------------------------------');
153: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
154: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
155: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
156: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
157: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
150: IF g_debug THEN
151: hr_utility.trace('Balance values for YTD dimension');
152: hr_utility.trace('-------------------------------------');
153: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
154: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
155: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
156: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
157: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
158: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
151: hr_utility.trace('Balance values for YTD dimension');
152: hr_utility.trace('-------------------------------------');
153: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
154: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
155: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
156: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
157: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
158: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
159: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
152: hr_utility.trace('-------------------------------------');
153: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
154: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
155: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
156: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
157: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
158: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
159: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
160: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
153: hr_utility.trace('Earnings_Total ===>' || g_result_table(1).balance_value);
154: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
155: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
156: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
157: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
158: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
159: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
160: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
161: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
154: hr_utility.trace('Direct Payments ===>' || g_result_table(2).balance_value);
155: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
156: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
157: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
158: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
159: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
160: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
161: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
162: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
155: hr_utility.trace('Termination_Payments ===>' || g_result_table(3).balance_value);
156: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
157: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
158: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
159: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
160: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
161: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
162: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
163: END IF;
156: hr_utility.trace('Involuntary Deductions===>' || g_result_table(4).balance_value);
157: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
158: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
159: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
160: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
161: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
162: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
163: END IF;
164:
157: hr_utility.trace('Pre Tax Deductions ===>' || g_result_table(5).balance_value);
158: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
159: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
160: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
161: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
162: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
163: END IF;
164:
165: /* Bug 3953706 - Modified calculation of Earnings and deductions as given below:
158: hr_utility.trace('Termination Deductions===>' || g_result_table(6).balance_value);
159: hr_utility.trace('Voluntary Deductions ===>' || g_result_table(7).balance_value);
160: hr_utility.trace('Total_Tax_Deduction ===>' || g_result_table(8).balance_value);
161: hr_utility.trace('Earnings_Non_Taxable ===>' || g_result_table(9).balance_value);
162: hr_utility.trace('Employer_Charges ===>' || g_result_table(10).balance_value);
163: END IF;
164:
165: /* Bug 3953706 - Modified calculation of Earnings and deductions as given below:
166: Calculations :-
186: p_ytd_employer_charges := g_result_table(10).balance_value;
187:
188:
189: IF g_debug THEN
190: hr_utility.trace('p_ytd_taxable_earnings ===>' || p_ytd_taxable_earnings);
191: hr_utility.trace('p_ytd_non_taxable_earnings ===>' || p_ytd_non_taxable_earnings);
192: hr_utility.trace('p_ytd_deductions ===>' || p_ytd_deductions);
193: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
194: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
187:
188:
189: IF g_debug THEN
190: hr_utility.trace('p_ytd_taxable_earnings ===>' || p_ytd_taxable_earnings);
191: hr_utility.trace('p_ytd_non_taxable_earnings ===>' || p_ytd_non_taxable_earnings);
192: hr_utility.trace('p_ytd_deductions ===>' || p_ytd_deductions);
193: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
194: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
195: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
188:
189: IF g_debug THEN
190: hr_utility.trace('p_ytd_taxable_earnings ===>' || p_ytd_taxable_earnings);
191: hr_utility.trace('p_ytd_non_taxable_earnings ===>' || p_ytd_non_taxable_earnings);
192: hr_utility.trace('p_ytd_deductions ===>' || p_ytd_deductions);
193: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
194: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
195: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
196: hr_utility.trace('p_ytd_gross_earnings ===>' || p_ytd_gross_earnings);
189: IF g_debug THEN
190: hr_utility.trace('p_ytd_taxable_earnings ===>' || p_ytd_taxable_earnings);
191: hr_utility.trace('p_ytd_non_taxable_earnings ===>' || p_ytd_non_taxable_earnings);
192: hr_utility.trace('p_ytd_deductions ===>' || p_ytd_deductions);
193: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
194: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
195: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
196: hr_utility.trace('p_ytd_gross_earnings ===>' || p_ytd_gross_earnings);
197: hr_utility.trace('p_ytd_pre_tax_deduction ===>' || p_ytd_pre_tax_deductions);
190: hr_utility.trace('p_ytd_taxable_earnings ===>' || p_ytd_taxable_earnings);
191: hr_utility.trace('p_ytd_non_taxable_earnings ===>' || p_ytd_non_taxable_earnings);
192: hr_utility.trace('p_ytd_deductions ===>' || p_ytd_deductions);
193: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
194: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
195: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
196: hr_utility.trace('p_ytd_gross_earnings ===>' || p_ytd_gross_earnings);
197: hr_utility.trace('p_ytd_pre_tax_deduction ===>' || p_ytd_pre_tax_deductions);
198: hr_utility.trace('p_ytd_direct_payments ===>' || p_ytd_direct_payments);
191: hr_utility.trace('p_ytd_non_taxable_earnings ===>' || p_ytd_non_taxable_earnings);
192: hr_utility.trace('p_ytd_deductions ===>' || p_ytd_deductions);
193: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
194: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
195: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
196: hr_utility.trace('p_ytd_gross_earnings ===>' || p_ytd_gross_earnings);
197: hr_utility.trace('p_ytd_pre_tax_deduction ===>' || p_ytd_pre_tax_deductions);
198: hr_utility.trace('p_ytd_direct_payments ===>' || p_ytd_direct_payments);
199: END IF;
192: hr_utility.trace('p_ytd_deductions ===>' || p_ytd_deductions);
193: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
194: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
195: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
196: hr_utility.trace('p_ytd_gross_earnings ===>' || p_ytd_gross_earnings);
197: hr_utility.trace('p_ytd_pre_tax_deduction ===>' || p_ytd_pre_tax_deductions);
198: hr_utility.trace('p_ytd_direct_payments ===>' || p_ytd_direct_payments);
199: END IF;
200:
193: hr_utility.trace('p_ytd_tax ===>' || p_ytd_tax);
194: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
195: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
196: hr_utility.trace('p_ytd_gross_earnings ===>' || p_ytd_gross_earnings);
197: hr_utility.trace('p_ytd_pre_tax_deduction ===>' || p_ytd_pre_tax_deductions);
198: hr_utility.trace('p_ytd_direct_payments ===>' || p_ytd_direct_payments);
199: END IF;
200:
201: end get_ytd_au_rec_balances;
194: hr_utility.trace('p_ytd_net_payment ===>' || p_ytd_net_payment);
195: hr_utility.trace('p_ytd_employer_charges ===>' || p_ytd_employer_charges);
196: hr_utility.trace('p_ytd_gross_earnings ===>' || p_ytd_gross_earnings);
197: hr_utility.trace('p_ytd_pre_tax_deduction ===>' || p_ytd_pre_tax_deductions);
198: hr_utility.trace('p_ytd_direct_payments ===>' || p_ytd_direct_payments);
199: END IF;
200:
201: end get_ytd_au_rec_balances;
202:
231:
232: BEGIN
233:
234: IF g_debug THEN
235: hr_utility.trace('Entering:' || g_package || 'populate_defined_balance_ids');
236: hr_utility.trace('Parameter p_ytd_totals value ===>' || p_ytd_totals);
237: END IF;
238:
239: g_balance_value_tab.delete;
232: BEGIN
233:
234: IF g_debug THEN
235: hr_utility.trace('Entering:' || g_package || 'populate_defined_balance_ids');
236: hr_utility.trace('Parameter p_ytd_totals value ===>' || p_ytd_totals);
237: END IF;
238:
239: g_balance_value_tab.delete;
240:
271: g_balance_value_tab(csr_rec.sort_index).defined_balance_id := csr_rec.defined_balance_id;
272: END LOOP;
273:
274: IF g_debug THEN
275: hr_utility.trace('Defined Balance ids for RUN dimension');
276: hr_utility.trace('-------------------------------------');
277: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
278: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
279: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
272: END LOOP;
273:
274: IF g_debug THEN
275: hr_utility.trace('Defined Balance ids for RUN dimension');
276: hr_utility.trace('-------------------------------------');
277: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
278: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
279: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
280: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
273:
274: IF g_debug THEN
275: hr_utility.trace('Defined Balance ids for RUN dimension');
276: hr_utility.trace('-------------------------------------');
277: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
278: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
279: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
280: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
281: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
274: IF g_debug THEN
275: hr_utility.trace('Defined Balance ids for RUN dimension');
276: hr_utility.trace('-------------------------------------');
277: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
278: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
279: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
280: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
281: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
282: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
275: hr_utility.trace('Defined Balance ids for RUN dimension');
276: hr_utility.trace('-------------------------------------');
277: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
278: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
279: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
280: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
281: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
282: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
283: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
276: hr_utility.trace('-------------------------------------');
277: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
278: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
279: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
280: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
281: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
282: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
283: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
284: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
277: hr_utility.trace('Earnings_Total ===>' || g_balance_value_tab(1).defined_balance_id);
278: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
279: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
280: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
281: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
282: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
283: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
284: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
285: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
278: hr_utility.trace('Direct Payments ===>' || g_balance_value_tab(2).defined_balance_id);
279: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
280: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
281: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
282: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
283: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
284: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
285: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
286: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
279: hr_utility.trace('Termination_Payments ===>' || g_balance_value_tab(3).defined_balance_id);
280: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
281: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
282: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
283: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
284: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
285: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
286: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
287: END IF;
280: hr_utility.trace('Involuntary Deductions===>' || g_balance_value_tab(4).defined_balance_id);
281: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
282: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
283: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
284: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
285: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
286: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
287: END IF;
288:
281: hr_utility.trace('Pre Tax Deductions ===>' || g_balance_value_tab(5).defined_balance_id);
282: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
283: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
284: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
285: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
286: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
287: END IF;
288:
289: IF (p_ytd_totals = 'Y') THEN
282: hr_utility.trace('Termination Deductions===>' || g_balance_value_tab(6).defined_balance_id);
283: hr_utility.trace('Voluntary Deductions ===>' || g_balance_value_tab(7).defined_balance_id);
284: hr_utility.trace('Total_Tax_Deduction ===>' || g_balance_value_tab(8).defined_balance_id);
285: hr_utility.trace('Earnings_Non_Taxable ===>' || g_balance_value_tab(9).defined_balance_id);
286: hr_utility.trace('Employer_Charges ===>' || g_balance_value_tab(10).defined_balance_id);
287: END IF;
288:
289: IF (p_ytd_totals = 'Y') THEN
290:
293: g_ytd_balance_value_tab(csr_rec.sort_index).defined_balance_id := csr_rec.defined_balance_id; /*Bug 4040688*/
294: END LOOP;
295:
296: IF g_debug THEN
297: hr_utility.trace('Defined Balance ids for YTD dimension');
298: hr_utility.trace('-------------------------------------');
299: hr_utility.trace('Earnings_Total ===>' || g_ytd_balance_value_tab(1).defined_balance_id);
300: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
301: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
294: END LOOP;
295:
296: IF g_debug THEN
297: hr_utility.trace('Defined Balance ids for YTD dimension');
298: hr_utility.trace('-------------------------------------');
299: hr_utility.trace('Earnings_Total ===>' || g_ytd_balance_value_tab(1).defined_balance_id);
300: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
301: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
302: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
295:
296: IF g_debug THEN
297: hr_utility.trace('Defined Balance ids for YTD dimension');
298: hr_utility.trace('-------------------------------------');
299: hr_utility.trace('Earnings_Total ===>' || g_ytd_balance_value_tab(1).defined_balance_id);
300: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
301: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
302: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
303: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
296: IF g_debug THEN
297: hr_utility.trace('Defined Balance ids for YTD dimension');
298: hr_utility.trace('-------------------------------------');
299: hr_utility.trace('Earnings_Total ===>' || g_ytd_balance_value_tab(1).defined_balance_id);
300: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
301: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
302: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
303: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
304: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
297: hr_utility.trace('Defined Balance ids for YTD dimension');
298: hr_utility.trace('-------------------------------------');
299: hr_utility.trace('Earnings_Total ===>' || g_ytd_balance_value_tab(1).defined_balance_id);
300: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
301: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
302: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
303: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
304: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
305: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
298: hr_utility.trace('-------------------------------------');
299: hr_utility.trace('Earnings_Total ===>' || g_ytd_balance_value_tab(1).defined_balance_id);
300: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
301: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
302: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
303: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
304: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
305: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
306: hr_utility.trace('Total_Tax_Deduction ===>' || g_ytd_balance_value_tab(8).defined_balance_id);
299: hr_utility.trace('Earnings_Total ===>' || g_ytd_balance_value_tab(1).defined_balance_id);
300: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
301: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
302: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
303: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
304: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
305: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
306: hr_utility.trace('Total_Tax_Deduction ===>' || g_ytd_balance_value_tab(8).defined_balance_id);
307: hr_utility.trace('Earnings_Non_Taxable ===>' || g_ytd_balance_value_tab(9).defined_balance_id);
300: hr_utility.trace('Direct Payments ===>' || g_ytd_balance_value_tab(2).defined_balance_id);
301: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
302: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
303: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
304: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
305: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
306: hr_utility.trace('Total_Tax_Deduction ===>' || g_ytd_balance_value_tab(8).defined_balance_id);
307: hr_utility.trace('Earnings_Non_Taxable ===>' || g_ytd_balance_value_tab(9).defined_balance_id);
308: hr_utility.trace('Employer_Charges ===>' || g_ytd_balance_value_tab(10).defined_balance_id);
301: hr_utility.trace('Termination_Payments ===>' || g_ytd_balance_value_tab(3).defined_balance_id);
302: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
303: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
304: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
305: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
306: hr_utility.trace('Total_Tax_Deduction ===>' || g_ytd_balance_value_tab(8).defined_balance_id);
307: hr_utility.trace('Earnings_Non_Taxable ===>' || g_ytd_balance_value_tab(9).defined_balance_id);
308: hr_utility.trace('Employer_Charges ===>' || g_ytd_balance_value_tab(10).defined_balance_id);
309: END IF;
302: hr_utility.trace('Involuntary Deductions===>' || g_ytd_balance_value_tab(4).defined_balance_id);
303: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
304: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
305: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
306: hr_utility.trace('Total_Tax_Deduction ===>' || g_ytd_balance_value_tab(8).defined_balance_id);
307: hr_utility.trace('Earnings_Non_Taxable ===>' || g_ytd_balance_value_tab(9).defined_balance_id);
308: hr_utility.trace('Employer_Charges ===>' || g_ytd_balance_value_tab(10).defined_balance_id);
309: END IF;
310:
303: hr_utility.trace('Pre Tax Deductions ===>' || g_ytd_balance_value_tab(5).defined_balance_id);
304: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
305: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
306: hr_utility.trace('Total_Tax_Deduction ===>' || g_ytd_balance_value_tab(8).defined_balance_id);
307: hr_utility.trace('Earnings_Non_Taxable ===>' || g_ytd_balance_value_tab(9).defined_balance_id);
308: hr_utility.trace('Employer_Charges ===>' || g_ytd_balance_value_tab(10).defined_balance_id);
309: END IF;
310:
311: END IF;
304: hr_utility.trace('Termination Deductions===>' || g_ytd_balance_value_tab(6).defined_balance_id);
305: hr_utility.trace('Voluntary Deductionsn ===>' || g_ytd_balance_value_tab(7).defined_balance_id);
306: hr_utility.trace('Total_Tax_Deduction ===>' || g_ytd_balance_value_tab(8).defined_balance_id);
307: hr_utility.trace('Earnings_Non_Taxable ===>' || g_ytd_balance_value_tab(9).defined_balance_id);
308: hr_utility.trace('Employer_Charges ===>' || g_ytd_balance_value_tab(10).defined_balance_id);
309: END IF;
310:
311: END IF;
312:
329: l_procedure varchar2(200) ;
330:
331: begin
332:
333: g_debug :=hr_utility.debug_enabled ;
334:
335: if g_debug then
336: l_procedure := g_package||'range_code';
337: hr_utility.set_location('Entering '||l_procedure,1);
333: g_debug :=hr_utility.debug_enabled ;
334:
335: if g_debug then
336: l_procedure := g_package||'range_code';
337: hr_utility.set_location('Entering '||l_procedure,1);
338: end if ;
339:
340: -- Archive the payroll action level data and EIT defintions.
341: -- sql string to SELECT a range of assignments eligible for archival.
346: ' and p.business_group_id = pa.business_group_id' ||
347: ' order by p.person_id';
348:
349: if g_debug then
350: hr_utility.set_location('Leaving '||l_procedure,1000);
351: end if;
352:
353: end range_code;
354:
402: /*Bug 4132149 - Modification ends here */
403:
404: begin
405:
406: g_debug :=hr_utility.debug_enabled ;
407: if g_debug then
408: g_package := 'pay_au_reconciliation_pkg.' ;
409: l_procedure := g_package||'initialization_code';
410: hr_utility.set_location('Entering '||l_procedure,1);
406: g_debug :=hr_utility.debug_enabled ;
407: if g_debug then
408: g_package := 'pay_au_reconciliation_pkg.' ;
409: l_procedure := g_package||'initialization_code';
410: hr_utility.set_location('Entering '||l_procedure,1);
411: end if;
412:
413: /*Bug 4132149 - Modification begins here */
414:
424: CLOSE csr_params;
425:
426:
427: if g_debug then
428: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
429: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
430: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
431: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
432: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
425:
426:
427: if g_debug then
428: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
429: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
430: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
431: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
432: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
433: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
426:
427: if g_debug then
428: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
429: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
430: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
431: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
432: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
433: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
434: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
427: if g_debug then
428: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
429: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
430: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
431: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
432: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
433: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
434: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
435: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
428: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
429: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
430: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
431: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
432: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
433: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
434: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
435: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
436: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
429: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
430: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
431: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
432: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
433: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
434: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
435: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
436: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
437: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
430: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
431: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
432: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
433: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
434: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
435: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
436: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
437: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
438: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
431: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
432: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
433: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
434: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
435: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
436: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
437: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
438: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
439: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
432: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
433: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
434: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
435: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
436: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
437: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
438: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
439: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
440: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
433: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
434: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
435: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
436: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
437: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
438: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
439: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
440: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
441: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
434: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
435: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
436: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
437: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
438: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
439: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
440: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
441: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
442: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
435: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
436: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
437: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
438: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
439: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
440: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
441: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
442: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
443: end if;
436: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
437: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
438: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
439: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
440: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
441: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
442: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
443: end if;
444:
437: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
438: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
439: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
440: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
441: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
442: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
443: end if;
444:
445:
438: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
439: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
440: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
441: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
442: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
443: end if;
444:
445:
446: g_business_group_id := g_parameters.business_group_id ;
469: /*Bug 4132149 - Modification ends here */
470:
471: pay_au_reconciliation_pkg.populate_defined_balance_ids('Y',g_parameters.legal_employer);
472: if g_debug then
473: hr_utility.set_location('Leaving '||l_procedure,1000);
474: end if;
475:
476: exception
477: when others then
474: end if;
475:
476: exception
477: when others then
478: hr_utility.set_location('Error in '||l_procedure,999999);
479: raise;
480: end initialization_code;
481:
482: --------------------------------------------------------------------+
1053:
1054:
1055: begin
1056: i := 1;
1057: g_debug :=hr_utility.debug_enabled ;
1058: if g_debug then
1059: g_package := 'pay_au_reconciliation_pkg.' ;
1060: l_procedure := g_package||'assignment_action_code';
1061: hr_utility.set_location('Entering ' || l_procedure,1);
1057: g_debug :=hr_utility.debug_enabled ;
1058: if g_debug then
1059: g_package := 'pay_au_reconciliation_pkg.' ;
1060: l_procedure := g_package||'assignment_action_code';
1061: hr_utility.set_location('Entering ' || l_procedure,1);
1062: hr_utility.set_location('Entering assignment_Action_code',302);
1063: end if;
1064:
1065: -- initialization_code to to set the global tables for EIT
1058: if g_debug then
1059: g_package := 'pay_au_reconciliation_pkg.' ;
1060: l_procedure := g_package||'assignment_action_code';
1061: hr_utility.set_location('Entering ' || l_procedure,1);
1062: hr_utility.set_location('Entering assignment_Action_code',302);
1063: end if;
1064:
1065: -- initialization_code to to set the global tables for EIT
1066: -- that will be used by each thread in multi-threading.
1074: CLOSE csr_params;
1075:
1076:
1077: if g_debug then
1078: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1079: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1080: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1081: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1082: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1075:
1076:
1077: if g_debug then
1078: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1079: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1080: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1081: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1082: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1083: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1076:
1077: if g_debug then
1078: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1079: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1080: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1081: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1082: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1083: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1084: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1077: if g_debug then
1078: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1079: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1080: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1081: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1082: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1083: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1084: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1085: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1078: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1079: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1080: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1081: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1082: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1083: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1084: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1085: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1086: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1079: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1080: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1081: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1082: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1083: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1084: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1085: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1086: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1087: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1080: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1081: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1082: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1083: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1084: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1085: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1086: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1087: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1088: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1081: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1082: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1083: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1084: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1085: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1086: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1087: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1088: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1089: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1082: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1083: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1084: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1085: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1086: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1087: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1088: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1089: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1090: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1083: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1084: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1085: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1086: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1087: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1088: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1089: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1090: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1091: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1084: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1085: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1086: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1087: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1088: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1089: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1090: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1091: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1092: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1085: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1086: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1087: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1088: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1089: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1090: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1091: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1092: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1093: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1086: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1087: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1088: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1089: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1090: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1091: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1092: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1093: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1094: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
1087: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1088: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1089: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1090: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1091: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1092: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1093: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1094: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
1095: end if;
1088: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1089: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1090: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1091: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1092: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1093: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1094: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
1095: end if;
1096:
1089: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1090: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1091: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1092: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1093: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1094: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
1095: end if;
1096:
1097:
1090: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1091: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1092: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1093: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1094: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
1095: end if;
1096:
1097:
1098: g_business_group_id := g_parameters.business_group_id ;
1137: close csr_next_action_id;
1138:
1139: if g_debug then
1140:
1141: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1142: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1143: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1144: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1145:
1138:
1139: if g_debug then
1140:
1141: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1142: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1143: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1144: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1145:
1146: end if;
1139: if g_debug then
1140:
1141: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1142: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1143: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1144: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1145:
1146: end if;
1147:
1140:
1141: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1142: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1143: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1144: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1145:
1146: end if;
1147:
1148:
1180:
1181:
1182: END LOOP;/* Loop 1 */
1183: if g_debug then
1184: hr_utility.set_location('Leaving............Loop1 Org+Period....' || l_procedure,1000);
1185: end if;
1186:
1187: else
1188: FOR csr_rec in csr_assignment_org_run(p_payroll_action_id,
1198: fetch csr_next_action_id into l_next_assignment_action_id;
1199: close csr_next_action_id;
1200:
1201: if g_debug then
1202: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1203: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1204: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1205: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1206: end if;
1199: close csr_next_action_id;
1200:
1201: if g_debug then
1202: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1203: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1204: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1205: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1206: end if;
1207:
1200:
1201: if g_debug then
1202: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1203: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1204: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1205: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1206: end if;
1207:
1208: -- Create the archive assignment actions
1201: if g_debug then
1202: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1203: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1204: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1205: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1206: end if;
1207:
1208: -- Create the archive assignment actions
1209: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1237:
1238:
1239: END LOOP; /* Loop 2 */
1240: if g_debug then
1241: hr_utility.set_location('Leaving............Loop2 ,Org + Run....' || l_procedure,1000);
1242: end if;
1243: end if; /* End of Inner Organization */
1244: else /* Not Org,check for others */
1245:
1262: open csr_next_action_id;
1263: fetch csr_next_action_id into l_next_assignment_action_id;
1264: close csr_next_action_id;
1265: if g_debug then
1266: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1267: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1268: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1269: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1270: end if;
1263: fetch csr_next_action_id into l_next_assignment_action_id;
1264: close csr_next_action_id;
1265: if g_debug then
1266: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1267: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1268: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1269: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1270: end if;
1271:
1264: close csr_next_action_id;
1265: if g_debug then
1266: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1267: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1268: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1269: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1270: end if;
1271:
1272: -- Create the archive assignment actions
1265: if g_debug then
1266: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1267: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1268: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1269: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1270: end if;
1271:
1272: -- Create the archive assignment actions
1273: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1301:
1302: END IF;
1303: END LOOP;/* Loop 3 */
1304: if g_debug then
1305: hr_utility.set_location('Leaving............Loop3.Legal Emp + period...' || l_procedure,1000);
1306: end if;
1307:
1308: else
1309: FOR csr_rec in csr_assignment_legal_run(p_payroll_action_id,
1322: fetch csr_next_action_id into l_next_assignment_action_id;
1323: close csr_next_action_id;
1324:
1325: if g_debug then
1326: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1327: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1328: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1329: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1330: end if;
1323: close csr_next_action_id;
1324:
1325: if g_debug then
1326: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1327: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1328: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1329: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1330: end if;
1331:
1324:
1325: if g_debug then
1326: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1327: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1328: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1329: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1330: end if;
1331:
1332: -- Create the archive assignment actions
1325: if g_debug then
1326: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1327: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1328: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1329: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1330: end if;
1331:
1332: -- Create the archive assignment actions
1333: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1361:
1362: END IF;
1363: END LOOP; /* Loop 4 */
1364: if g_debug then
1365: hr_utility.set_location('Leaving............Loop4.Legal Emp + Run...' || l_procedure,1000);
1366: end if;
1367: end if; /* End of Inner Legal Employer */
1368: else /* Not Org,Legal Emp Check others */
1369:
1384: fetch csr_next_action_id into l_next_assignment_action_id;
1385: close csr_next_action_id;
1386:
1387: if g_debug then
1388: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1389: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1390: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1391: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1392: end if;
1385: close csr_next_action_id;
1386:
1387: if g_debug then
1388: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1389: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1390: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1391: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1392: end if;
1393:
1386:
1387: if g_debug then
1388: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1389: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1390: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1391: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1392: end if;
1393:
1394: -- Create the archive assignment actions
1387: if g_debug then
1388: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1389: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1390: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1391: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1392: end if;
1393:
1394: -- Create the archive assignment actions
1395: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1424:
1425: END LOOP;/* Loop 5 */
1426:
1427: if g_debug then
1428: hr_utility.set_location('Leaving............Loop5 Payroll + Period....' || l_procedure,1000);
1429: end if;
1430:
1431: else
1432: FOR csr_rec in csr_assignment_payroll_run(p_payroll_action_id,
1442: fetch csr_next_action_id into l_next_assignment_action_id;
1443: close csr_next_action_id;
1444:
1445: if g_debug then
1446: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1447: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1448: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1449: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1450: end if;
1443: close csr_next_action_id;
1444:
1445: if g_debug then
1446: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1447: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1448: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1449: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1450: end if;
1451:
1444:
1445: if g_debug then
1446: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1447: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1448: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1449: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1450: end if;
1451:
1452: -- Create the archive assignment actions
1445: if g_debug then
1446: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1447: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1448: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1449: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1450: end if;
1451:
1452: -- Create the archive assignment actions
1453: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1481:
1482:
1483: END LOOP; /* Loop 6 */
1484: if g_debug then
1485: hr_utility.set_location('Leaving............Loop6 Payroll+ Run....' || l_procedure,1000);
1486: end if;
1487: end if; /* End of Inner Payroll */
1488: else /* Not Org,Legal,Payroll check others */
1489:
1504: fetch csr_next_action_id into l_next_assignment_action_id;
1505: close csr_next_action_id;
1506:
1507: if g_debug then
1508: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1509: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1510: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1511: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1512: end if;
1505: close csr_next_action_id;
1506:
1507: if g_debug then
1508: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1509: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1510: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1511: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1512: end if;
1513:
1506:
1507: if g_debug then
1508: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1509: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1510: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1511: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1512: end if;
1513:
1514: -- Create the archive assignment actions
1507: if g_debug then
1508: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1509: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1510: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1511: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1512: end if;
1513:
1514: -- Create the archive assignment actions
1515: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1543:
1544:
1545: END LOOP;/* Loop 7 */
1546: if g_debug then
1547: hr_utility.set_location('Leaving............Loop7. Asg + Period...' || l_procedure,1000);
1548: end if;
1549:
1550: else
1551: FOR csr_rec in csr_assignment_run(p_payroll_action_id,
1561: fetch csr_next_action_id into l_next_assignment_action_id;
1562: close csr_next_action_id;
1563:
1564: if g_debug then
1565: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1566: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1567: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1568: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1569: end if;
1562: close csr_next_action_id;
1563:
1564: if g_debug then
1565: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1566: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1567: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1568: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1569: end if;
1570:
1563:
1564: if g_debug then
1565: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1566: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1567: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1568: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1569: end if;
1570:
1571: -- Create the archive assignment actions
1564: if g_debug then
1565: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1566: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1567: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1568: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1569: end if;
1570:
1571: -- Create the archive assignment actions
1572: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1600:
1601:
1602: END LOOP; /* Loop 8 */
1603: if g_debug then
1604: hr_utility.set_location('Leaving............Loop8.Asg + Run...' || l_procedure,1000);
1605: end if;
1606: end if; /* End of Inner Assignment */
1607:
1608: else
1623: fetch csr_next_action_id into l_next_assignment_action_id;
1624: close csr_next_action_id;
1625:
1626: if g_debug then
1627: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1628: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1629: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1630: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1631: end if;
1624: close csr_next_action_id;
1625:
1626: if g_debug then
1627: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1628: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1629: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1630: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1631: end if;
1632:
1625:
1626: if g_debug then
1627: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1628: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1629: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1630: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1631: end if;
1632:
1633: -- Create the archive assignment actions
1626: if g_debug then
1627: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1628: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1629: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1630: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1631: end if;
1632:
1633: -- Create the archive assignment actions
1634: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1662:
1663:
1664: END LOOP;/* Loop 9 */
1665: if g_debug then
1666: hr_utility.set_location('Leaving............Loop9..Default + Period..' || l_procedure,1000);
1667: end if;
1668:
1669: else
1670: FOR csr_rec in csr_assignment_default_run(p_payroll_action_id,
1679: fetch csr_next_action_id into l_next_assignment_action_id;
1680: close csr_next_action_id;
1681:
1682: if g_debug then
1683: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1684: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1685: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1686: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1687: end if;
1680: close csr_next_action_id;
1681:
1682: if g_debug then
1683: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1684: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1685: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1686: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1687: end if;
1688:
1681:
1682: if g_debug then
1683: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1684: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1685: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1686: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1687: end if;
1688:
1689: -- Create the archive assignment actions
1682: if g_debug then
1683: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1684: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1685: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1686: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1687: end if;
1688:
1689: -- Create the archive assignment actions
1690: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);
1718:
1719:
1720: END LOOP; /* Loop 10 */
1721: if g_debug then
1722: hr_utility.set_location('Leaving............Loop10 Default + Run....' || l_procedure,1000);
1723: end if;
1724: end if; /* End of Inner Default */
1725:
1726:
1730: end if; /* End Organization */
1731:
1732: exception
1733: when others then
1734: hr_utility.set_location('Error in '||l_procedure,999999);
1735: raise;
1736: end assignment_action_code;
1737:
1738: procedure archive_code
1882: l_payroll_name pay_payrolls_f.payroll_name%type; /*Bug 4688800*/
1883:
1884: begin
1885:
1886: g_debug :=hr_utility.debug_enabled ;
1887:
1888: l_YTD_GROSS_EARNINGS := 0;
1889: l_YTD_NON_TAXABLE_EARNINGS := 0;
1890: l_YTD_PRE_TAX_DEDUCTIONS := 0;
1897:
1898: if g_debug then
1899: g_package := 'pay_au_reconciliation_pkg.' ;
1900: l_procedure := g_package||'archive_code';
1901: hr_utility.set_location('Entering '||l_procedure,1);
1902: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1903: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1904: end if;
1905:
1898: if g_debug then
1899: g_package := 'pay_au_reconciliation_pkg.' ;
1900: l_procedure := g_package||'archive_code';
1901: hr_utility.set_location('Entering '||l_procedure,1);
1902: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1903: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1904: end if;
1905:
1906: OPEN csr_get_data(p_assignment_action_id);
1899: g_package := 'pay_au_reconciliation_pkg.' ;
1900: l_procedure := g_package||'archive_code';
1901: hr_utility.set_location('Entering '||l_procedure,1);
1902: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
1903: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
1904: end if;
1905:
1906: OPEN csr_get_data(p_assignment_action_id);
1907: FETCH csr_get_data into l_ass_act_id, l_tax_unit_id, l_assignment_id,l_action_sequence;
1907: FETCH csr_get_data into l_ass_act_id, l_tax_unit_id, l_assignment_id,l_action_sequence;
1908: CLOSE csr_get_data;
1909:
1910: if g_debug then
1911: hr_utility.set_location('l_ass_act_id......= '|| l_ass_act_id,10);
1912: hr_utility.set_location('l_tax_unit_id............= '|| l_tax_unit_id,10);
1913: hr_utility.set_location('l_assignment_id......= '|| l_assignment_id,10);
1914: end if;
1915:
1908: CLOSE csr_get_data;
1909:
1910: if g_debug then
1911: hr_utility.set_location('l_ass_act_id......= '|| l_ass_act_id,10);
1912: hr_utility.set_location('l_tax_unit_id............= '|| l_tax_unit_id,10);
1913: hr_utility.set_location('l_assignment_id......= '|| l_assignment_id,10);
1914: end if;
1915:
1916: FOR csr_rec in c_employee_details(g_business_group_id,l_assignment_id,g_end_date,g_start_date) --Bug#3662449
1909:
1910: if g_debug then
1911: hr_utility.set_location('l_ass_act_id......= '|| l_ass_act_id,10);
1912: hr_utility.set_location('l_tax_unit_id............= '|| l_tax_unit_id,10);
1913: hr_utility.set_location('l_assignment_id......= '|| l_assignment_id,10);
1914: end if;
1915:
1916: FOR csr_rec in c_employee_details(g_business_group_id,l_assignment_id,g_end_date,g_start_date) --Bug#3662449
1917: LOOP
1916: FOR csr_rec in c_employee_details(g_business_group_id,l_assignment_id,g_end_date,g_start_date) --Bug#3662449
1917: LOOP
1918:
1919: if g_debug then
1920: hr_utility.set_location('csr_rec.full_name............= '|| csr_rec.full_name,10);
1921: end if;
1922:
1923:
1924: IF (NVL(g_prev_assignment_id,0) <> csr_rec.assignment_id) THEN
2155:
2156: Begin
2157: l_count :=0;
2158: ps_request_id :=-1;
2159: g_debug :=hr_utility.debug_enabled ;
2160:
2161:
2162: if g_debug then
2163: g_package := 'pay_au_reconciliation_pkg.' ;
2161:
2162: if g_debug then
2163: g_package := 'pay_au_reconciliation_pkg.' ;
2164: l_procedure := g_package||' spawn_archive_reports';
2165: hr_utility.set_location('Entering '||l_procedure,999);
2166: end if;
2167:
2168: -- Set User Parameters for Report.
2169:
2176: ,l_parameters.end_date
2177: ,l_parameters.period_end_date);
2178:
2179: if g_debug then
2180: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
2181: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
2182: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
2183: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2184: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2177: ,l_parameters.period_end_date);
2178:
2179: if g_debug then
2180: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
2181: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
2182: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
2183: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2184: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2185: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2178:
2179: if g_debug then
2180: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
2181: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
2182: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
2183: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2184: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2185: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2186: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2179: if g_debug then
2180: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
2181: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
2182: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
2183: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2184: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2185: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2186: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2187: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2180: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
2181: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
2182: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
2183: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2184: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2185: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2186: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2187: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2188: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2181: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
2182: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
2183: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2184: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2185: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2186: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2187: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2188: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2189: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2182: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
2183: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2184: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2185: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2186: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2187: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2188: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2189: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2190: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2183: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2184: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2185: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2186: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2187: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2188: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2189: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2190: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2191: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2184: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2185: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2186: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2187: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2188: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2189: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2190: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2191: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2192: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2185: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
2186: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2187: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2188: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2189: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2190: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2191: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2192: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2193: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2186: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
2187: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2188: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2189: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2190: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2191: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2192: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2193: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2194: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2187: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
2188: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2189: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2190: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2191: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2192: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2193: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2194: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2195: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2188: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2189: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2190: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2191: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2192: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2193: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2194: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2195: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2196: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2189: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
2190: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2191: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2192: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2193: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2194: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2195: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2196: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2197: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
2190: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
2191: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2192: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2193: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2194: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2195: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2196: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2197: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
2198: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
2191: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
2192: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2193: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2194: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2195: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2196: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2197: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
2198: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
2199: hr_utility.set_location('in Output Type '||l_parameters.output_type,20); /*Bug# 5174524*/
2192: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
2193: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2194: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2195: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2196: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2197: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
2198: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
2199: hr_utility.set_location('in Output Type '||l_parameters.output_type,20); /*Bug# 5174524*/
2200: end if;
2193: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2194: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2195: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2196: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2197: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
2198: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
2199: hr_utility.set_location('in Output Type '||l_parameters.output_type,20); /*Bug# 5174524*/
2200: end if;
2201:
2194: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
2195: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2196: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2197: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
2198: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
2199: hr_utility.set_location('in Output Type '||l_parameters.output_type,20); /*Bug# 5174524*/
2200: end if;
2201:
2202: if g_debug then
2195: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
2196: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
2197: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
2198: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
2199: hr_utility.set_location('in Output Type '||l_parameters.output_type,20); /*Bug# 5174524*/
2200: end if;
2201:
2202: if g_debug then
2203: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
2199: hr_utility.set_location('in Output Type '||l_parameters.output_type,20); /*Bug# 5174524*/
2200: end if;
2201:
2202: if g_debug then
2203: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
2204:
2205: hr_utility.set_location('Before calling report',24);
2206: end if;
2207:
2201:
2202: if g_debug then
2203: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
2204:
2205: hr_utility.set_location('Before calling report',24);
2206: end if;
2207:
2208: OPEN csr_get_print_options(p_payroll_action_id);
2209: FETCH csr_get_print_options INTO rec_print_options;
2219: save_output => hr_general.char_to_bool(rec_print_options.save_output),
2220: print_together => l_print_together);
2221: -- Submit report
2222: if g_debug then
2223: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,25);
2224: end if;
2225:
2226: /* Bug 5174524 - Check for Report Output Type and choose appropriate
2227: concurrent program to submit
2276: NULL, NULL, NULL, NULL, NULL, NULL,
2277: NULL, NULL, NULL, NULL
2278: );
2279: if g_debug then
2280: hr_utility.set_location('After calling report',24);
2281: end if;
2282:
2283: end spawn_archive_reports;
2284:
2292:
2293: begin
2294:
2295: IF g_debug THEN
2296: hr_utility.trace('Entering:' || g_package || 'check_report_parameters');
2297: END IF;
2298:
2299: if p_start_date is not null and p_end_date is null then
2300: raise e_bad_end_date;
2307:
2308: exception
2309: when e_bad_end_date
2310: then
2311: hr_utility.set_message(801, 'HR_AU_REC_MISSING_END_DATE');
2312: hr_utility.raise_error;
2313: when e_bad_combination_date
2314: then
2315: hr_utility.set_message(801, 'HR_AU_REC_COMBINATION_DATES');
2308: exception
2309: when e_bad_end_date
2310: then
2311: hr_utility.set_message(801, 'HR_AU_REC_MISSING_END_DATE');
2312: hr_utility.raise_error;
2313: when e_bad_combination_date
2314: then
2315: hr_utility.set_message(801, 'HR_AU_REC_COMBINATION_DATES');
2316: hr_utility.raise_error;
2311: hr_utility.set_message(801, 'HR_AU_REC_MISSING_END_DATE');
2312: hr_utility.raise_error;
2313: when e_bad_combination_date
2314: then
2315: hr_utility.set_message(801, 'HR_AU_REC_COMBINATION_DATES');
2316: hr_utility.raise_error;
2317:
2318: end check_report_parameters;
2319:
2312: hr_utility.raise_error;
2313: when e_bad_combination_date
2314: then
2315: hr_utility.set_message(801, 'HR_AU_REC_COMBINATION_DATES');
2316: hr_utility.raise_error;
2317:
2318: end check_report_parameters;
2319:
2320: BEGIN
2318: end check_report_parameters;
2319:
2320: BEGIN
2321: /*Bug 2610141 - Code added to remove the gscc warnings */
2322: g_debug := hr_utility.debug_enabled;
2323: g_package := 'pay_au_reconciliation_pkg.';
2324:
2325: end pay_au_reconciliation_pkg;