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.29 2011/09/06 06:46:11 abellur ship $ */
3: /*
4: **
5: ** Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved

Line 523: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;

519: l_tax_unit_id number;
520: l_eoy_tax_unit_id number;
521: l_effective_end_date date;
522: l_archive_item_id number;
523: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
524:
525: /* Variables used to hold the values used as bind variables within the
526: SQL statement. */
527:

Line 1316: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;

1312: l_sit_uid number;
1313: l_sui_uid number;
1314: l_fips_uid number;
1315: l_counter number;
1316: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1317: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1318: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1319: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1320: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;

Line 1317: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;

1313: l_sui_uid number;
1314: l_fips_uid number;
1315: l_counter number;
1316: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1317: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1318: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1319: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1320: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1321: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;

Line 1318: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1314: l_fips_uid number;
1315: l_counter number;
1316: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1317: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1318: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1319: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1320: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1321: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1322: l_arch_gre_step number := 0;

Line 1319: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1315: l_counter number;
1316: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1317: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1318: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1319: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1320: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1321: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1322: l_arch_gre_step number := 0;
1323: l_name varchar2(240);

Line 1320: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1316: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
1317: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1318: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1319: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1320: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1321: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1322: l_arch_gre_step number := 0;
1323: l_name varchar2(240);
1324: l_business_group_id number;

Line 1321: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1317: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
1318: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1319: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1320: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1321: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1322: l_arch_gre_step number := 0;
1323: l_name varchar2(240);
1324: l_business_group_id number;
1325: l_seq number;

Line 1912: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1908: l_aaid pay_assignment_actions.assignment_action_id%type;
1909: l_aaseq pay_assignment_actions.action_sequence%type;
1910: l_asgid pay_assignment_actions.assignment_id%type;
1911: l_date_earned date;
1912: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1913: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1914: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1915: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1916: l_business_group_id pay_assignment_actions.tax_unit_id%type;

Line 1913: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1909: l_aaseq pay_assignment_actions.action_sequence%type;
1910: l_asgid pay_assignment_actions.assignment_id%type;
1911: l_date_earned date;
1912: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1913: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1914: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1915: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1916: l_business_group_id pay_assignment_actions.tax_unit_id%type;
1917: l_year_start date;

Line 1914: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;

1910: l_asgid pay_assignment_actions.assignment_id%type;
1911: l_date_earned date;
1912: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1913: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1914: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
1915: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1916: l_business_group_id pay_assignment_actions.tax_unit_id%type;
1917: l_year_start date;
1918: l_year_end date;

Line 3252: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;

3248: l_aaid pay_assignment_actions.assignment_action_id%type;
3249: l_aaseq pay_assignment_actions.action_sequence%type;
3250: l_asgid pay_assignment_actions.assignment_id%type;
3251: l_date_earned date;
3252: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3253: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3254: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3255: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
3256: l_business_group_id pay_assignment_actions.tax_unit_id%type;

Line 3253: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;

3249: l_aaseq pay_assignment_actions.action_sequence%type;
3250: l_asgid pay_assignment_actions.assignment_id%type;
3251: l_date_earned date;
3252: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3253: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3254: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3255: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
3256: l_business_group_id pay_assignment_actions.tax_unit_id%type;
3257: l_year_start date;

Line 3254: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;

3250: l_asgid pay_assignment_actions.assignment_id%type;
3251: l_date_earned date;
3252: l_user_entity_name_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3253: l_balance_type_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3254: l_user_entity_value_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3255: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
3256: l_business_group_id pay_assignment_actions.tax_unit_id%type;
3257: l_year_start date;
3258: l_year_end date;

Line 3277: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;

3273: l_county_code varchar2(3);
3274: l_city_code varchar2(4);
3275: l_jursd_context_id ff_contexts.context_id%type;
3276: l_taxunit_context_id ff_contexts.context_id%type;
3277: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
3278: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
3279: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3280: l_chunk number;
3281: l_payroll_action_id number;

Line 3278: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;

3274: l_city_code varchar2(4);
3275: l_jursd_context_id ff_contexts.context_id%type;
3276: l_taxunit_context_id ff_contexts.context_id%type;
3277: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
3278: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
3279: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3280: l_chunk number;
3281: l_payroll_action_id number;
3282: l_defined_balance_id number;

Line 3279: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;

3275: l_jursd_context_id ff_contexts.context_id%type;
3276: l_taxunit_context_id ff_contexts.context_id%type;
3277: l_seq_tab pay_ca_t4aeoy_archive.number_data_type_table;
3278: l_context_id_tab pay_ca_t4aeoy_archive.number_data_type_table;
3279: l_context_val_tab pay_ca_t4aeoy_archive.char240_data_type_table;
3280: l_chunk number;
3281: l_payroll_action_id number;
3282: l_defined_balance_id number;
3283: l_result number;

Line 5536: end pay_ca_t4aeoy_archive;

5532: end if;
5533:
5534: end eoy_range_cursor;
5535:
5536: end pay_ca_t4aeoy_archive;