DBA Data[Home] [Help]

APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_CA_BALANCE_VIEW_PKG

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

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

Line 888: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',ln_max_aa_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
892: ('T4 Non Taxable Earnings',

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

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:

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

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 */

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

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;

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

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';

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

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';