eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on PAY_CA_T4AEOY_ARCHIVE

Line 1: package body pay_ca_t4aeoy_archive as

1: package body pay_ca_t4aeoy_archive as
2: /*$Header: pycayt4a.pkb 120.8.12000000.2 2007/08/23 08:36:29 ssmukher noship $ */
3: /*
4: **
5: ** Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved

Line 445: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;

441: l_tax_unit_id number;
442: l_eoy_tax_unit_id number;
443: l_effective_end_date date;
444: l_archive_item_id number;
445: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
446:
447: /* Variables used to hold the values used as bind variables within the
448: SQL statement. */
449:

Line 1139: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;

1135: l_sit_uid number;
1136: l_sui_uid number;
1137: l_fips_uid number;
1138: l_counter number;
1139: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1140: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1141: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1142: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1143: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;

Line 1140: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;

1136: l_sui_uid number;
1137: l_fips_uid number;
1138: l_counter number;
1139: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1140: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1141: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1142: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1143: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1144: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;

Line 1141: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1137: l_fips_uid number;
1138: l_counter number;
1139: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1140: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1141: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1142: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1143: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1144: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1145: l_arch_gre_step number := 0;

Line 1142: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1138: l_counter number;
1139: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1140: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1141: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1142: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1143: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1144: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1145: l_arch_gre_step number := 0;
1146: l_name varchar2(240);

Line 1143: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1139: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1140: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1141: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1142: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1143: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1144: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1145: l_arch_gre_step number := 0;
1146: l_name varchar2(240);
1147: l_business_group_id number;

Line 1144: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1140: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1141: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1142: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1143: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1144: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1145: l_arch_gre_step number := 0;
1146: l_name varchar2(240);
1147: l_business_group_id number;
1148: l_seq number;

Line 1712: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1708: l_aaid pay_assignment_actions.assignment_action_id%type;
1709: l_aaseq pay_assignment_actions.action_sequence%type;
1710: l_asgid pay_assignment_actions.assignment_id%type;
1711: l_date_earned date;
1712: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1713: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1714: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1715: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1716: l_business_group_id pay_assignment_actions.tax_unit_id%type;

Line 1713: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1709: l_aaseq pay_assignment_actions.action_sequence%type;
1710: l_asgid pay_assignment_actions.assignment_id%type;
1711: l_date_earned date;
1712: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1713: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1714: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1715: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1716: l_business_group_id pay_assignment_actions.tax_unit_id%type;
1717: l_year_start date;

Line 1714: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1710: l_asgid pay_assignment_actions.assignment_id%type;
1711: l_date_earned date;
1712: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1713: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1714: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1715: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1716: l_business_group_id pay_assignment_actions.tax_unit_id%type;
1717: l_year_start date;
1718: l_year_end date;

Line 1737: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;

1733: l_county_code varchar2(3);
1734: l_city_code varchar2(4);
1735: l_jursd_context_id ff_contexts.context_id%type;
1736: l_taxunit_context_id ff_contexts.context_id%type;
1737: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1738: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1739: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1740: l_chunk number;
1741: l_payroll_action_id number;

Line 1738: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;

1734: l_city_code varchar2(4);
1735: l_jursd_context_id ff_contexts.context_id%type;
1736: l_taxunit_context_id ff_contexts.context_id%type;
1737: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1738: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1739: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1740: l_chunk number;
1741: l_payroll_action_id number;
1742: l_defined_balance_id number;

Line 1739: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1735: l_jursd_context_id ff_contexts.context_id%type;
1736: l_taxunit_context_id ff_contexts.context_id%type;
1737: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1738: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1739: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1740: l_chunk number;
1741: l_payroll_action_id number;
1742: l_defined_balance_id number;
1743: l_result number;

Line 3837: end pay_ca_t4aeoy_archive;

3833: end if;
3834:
3835: end eoy_range_cursor;
3836:
3837: end pay_ca_t4aeoy_archive;