883: ||to_char(l_person_id));
884: end;
885:
886: hr_utility.trace('Setting context');
887: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
888: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',ln_max_aa_id);
889:
890: ln_non_taxable_earnings :=
891: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
884: end;
885:
886: hr_utility.trace('Setting context');
887: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
888: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',ln_max_aa_id);
889:
890: ln_non_taxable_earnings :=
891: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
892: ('T4 Non Taxable Earnings',
2424: raise_application_error(-20001,'Balance Assignment Action does not exist for : '
2425: ||to_char(l_person_id));
2426: end;
2427:
2428: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
2429: pay_ca_balance_view_pkg.set_context( 'JURISDICTION_CODE', l_jurisdiction);
2430:
2431: hr_utility.trace('Archiving the balance dbi ' || l_jurisdiction);
2432:
2425: ||to_char(l_person_id));
2426: end;
2427:
2428: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
2429: pay_ca_balance_view_pkg.set_context( 'JURISDICTION_CODE', l_jurisdiction);
2430:
2431: hr_utility.trace('Archiving the balance dbi ' || l_jurisdiction);
2432:
2433: /* Assign values to the PL/SQL tables */
2441: l_seq_tab(2) := 2;
2442: l_context_id_tab(2) := l_taxunit_context_id;
2443: l_context_val_tab(2) := l_tax_unit_id;
2444:
2445: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2446: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
2447: pay_ca_balance_view_pkg.set_context( 'JURISDICTION_CODE', l_jurisdiction);
2448:
2449: l_count := l_count + 1;
2442: l_context_id_tab(2) := l_taxunit_context_id;
2443: l_context_val_tab(2) := l_tax_unit_id;
2444:
2445: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2446: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
2447: pay_ca_balance_view_pkg.set_context( 'JURISDICTION_CODE', l_jurisdiction);
2448:
2449: l_count := l_count + 1;
2450: l_user_entity_name_tab(l_count) := 'CAEOY_GROSS_EARNINGS_PER_JD_GRE_YTD';
2443: l_context_val_tab(2) := l_tax_unit_id;
2444:
2445: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2446: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
2447: pay_ca_balance_view_pkg.set_context( 'JURISDICTION_CODE', l_jurisdiction);
2448:
2449: l_count := l_count + 1;
2450: l_user_entity_name_tab(l_count) := 'CAEOY_GROSS_EARNINGS_PER_JD_GRE_YTD';
2451: l_balance_type_tab(l_count) := 'Gross Earnings';