DBA Data[Home] [Help]

APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_CA_BALANCE_VIEW_PKG

Line 1045: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);

1041: ||to_char(l_person_id));
1042: end;
1043:
1044: hr_utility.trace('Setting context');
1045: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1046: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',ln_max_aa_id);
1047:
1048: ln_non_taxable_earnings :=
1049: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

Line 1046: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',ln_max_aa_id);

1042: end;
1043:
1044: hr_utility.trace('Setting context');
1045: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1046: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',ln_max_aa_id);
1047:
1048: ln_non_taxable_earnings :=
1049: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
1050: ('T4 Non Taxable Earnings',

Line 2734: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);

2730: raise_application_error(-20001,'Balance Assignment Action does not exist for : '
2731: ||to_char(l_person_id));
2732: end;
2733:
2734: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
2735: pay_ca_balance_view_pkg.set_context( 'JURISDICTION_CODE', l_jurisdiction);
2736:
2737: hr_utility.trace('Archiving the balance dbi ' || l_jurisdiction);
2738:

Line 2735: pay_ca_balance_view_pkg.set_context( 'JURISDICTION_CODE', l_jurisdiction);

2731: ||to_char(l_person_id));
2732: end;
2733:
2734: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
2735: pay_ca_balance_view_pkg.set_context( 'JURISDICTION_CODE', l_jurisdiction);
2736:
2737: hr_utility.trace('Archiving the balance dbi ' || l_jurisdiction);
2738:
2739: /* Assign values to the PL/SQL tables */

Line 2751: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);

2747: l_seq_tab(2) := 2;
2748: l_context_id_tab(2) := l_taxunit_context_id;
2749: l_context_val_tab(2) := l_tax_unit_id;
2750:
2751: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2752: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
2753: pay_ca_balance_view_pkg.set_context( 'JURISDICTION_CODE', l_jurisdiction);
2754:
2755: l_count := l_count + 1;

Line 2752: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);

2748: l_context_id_tab(2) := l_taxunit_context_id;
2749: l_context_val_tab(2) := l_tax_unit_id;
2750:
2751: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2752: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
2753: pay_ca_balance_view_pkg.set_context( 'JURISDICTION_CODE', l_jurisdiction);
2754:
2755: l_count := l_count + 1;
2756: l_user_entity_name_tab(l_count) := 'CAEOY_GROSS_EARNINGS_PER_JD_GRE_YTD';

Line 2753: pay_ca_balance_view_pkg.set_context( 'JURISDICTION_CODE', l_jurisdiction);

2749: l_context_val_tab(2) := l_tax_unit_id;
2750:
2751: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2752: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
2753: pay_ca_balance_view_pkg.set_context( 'JURISDICTION_CODE', l_jurisdiction);
2754:
2755: l_count := l_count + 1;
2756: l_user_entity_name_tab(l_count) := 'CAEOY_GROSS_EARNINGS_PER_JD_GRE_YTD';
2757: l_balance_type_tab(l_count) := 'Gross Earnings';