DBA Data[Home] [Help]

APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_CA_EOY_ARCHIVE

Line 1: package body pay_ca_eoy_archive as

1: package body pay_ca_eoy_archive as
2: /* $Header: pycayear.pkb 120.37.12020000.10 2013/02/28 06:15:34 rgottipa ship $ */
3:
4: /*
5: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved

Line 568: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;

564: l_tax_unit_id number;
565: l_eoy_tax_unit_id number;
566: l_effective_end_date date;
567: l_archive_item_id number;
568: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
569:
570: /* Variables used to hold the values used as bind variables within the
571: SQL statement. */
572:

Line 1461: l_seq_tab pay_ca_eoy_archive.number_data_type_table;

1457: l_sit_uid number;
1458: l_sui_uid number;
1459: l_fips_uid number;
1460: l_counter number;
1461: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1462: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1463: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1464: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1465: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;

Line 1462: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;

1458: l_sui_uid number;
1459: l_fips_uid number;
1460: l_counter number;
1461: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1462: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1463: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1464: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1465: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
1466: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;

Line 1463: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;

1459: l_fips_uid number;
1460: l_counter number;
1461: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1462: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1463: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1464: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1465: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
1466: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;
1467: l_arch_gre_step number := 0;

Line 1464: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;

1460: l_counter number;
1461: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1462: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1463: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1464: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1465: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
1466: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;
1467: l_arch_gre_step number := 0;
1468: l_name varchar2(240);

Line 1465: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;

1461: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1462: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1463: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1464: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1465: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
1466: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;
1467: l_arch_gre_step number := 0;
1468: l_name varchar2(240);
1469: l_business_group_id number;

Line 1466: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;

1462: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1463: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1464: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1465: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
1466: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;
1467: l_arch_gre_step number := 0;
1468: l_name varchar2(240);
1469: l_business_group_id number;
1470: l_seq number;

Line 2119: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;

2115: l_aaid pay_assignment_actions.assignment_action_id%type;
2116: l_aaseq pay_assignment_actions.action_sequence%type;
2117: l_asgid pay_assignment_actions.assignment_id%type;
2118: l_date_earned date;
2119: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
2120: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
2121: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;
2122: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2123: l_business_group_id pay_assignment_actions.tax_unit_id%type;

Line 2120: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;

2116: l_aaseq pay_assignment_actions.action_sequence%type;
2117: l_asgid pay_assignment_actions.assignment_id%type;
2118: l_date_earned date;
2119: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
2120: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
2121: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;
2122: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2123: l_business_group_id pay_assignment_actions.tax_unit_id%type;
2124: l_year_start date;

Line 2121: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;

2117: l_asgid pay_assignment_actions.assignment_id%type;
2118: l_date_earned date;
2119: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
2120: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
2121: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;
2122: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
2123: l_business_group_id pay_assignment_actions.tax_unit_id%type;
2124: l_year_start date;
2125: l_year_end date;

Line 2144: l_seq_tab pay_ca_eoy_archive.number_data_type_table;

2140: l_county_code varchar2(3);
2141: l_city_code varchar2(4);
2142: l_jursd_context_id ff_contexts.context_id%type;
2143: l_taxunit_context_id ff_contexts.context_id%type;
2144: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
2145: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
2146: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
2147: l_chunk number;
2148: l_payroll_action_id number;

Line 2145: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;

2141: l_city_code varchar2(4);
2142: l_jursd_context_id ff_contexts.context_id%type;
2143: l_taxunit_context_id ff_contexts.context_id%type;
2144: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
2145: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
2146: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
2147: l_chunk number;
2148: l_payroll_action_id number;
2149: l_defined_balance_id number;

Line 2146: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;

2142: l_jursd_context_id ff_contexts.context_id%type;
2143: l_taxunit_context_id ff_contexts.context_id%type;
2144: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
2145: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
2146: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
2147: l_chunk number;
2148: l_payroll_action_id number;
2149: l_defined_balance_id number;
2150: l_result number;

Line 4467: end pay_ca_eoy_archive;

4463: end if;
4464:
4465: end eoy_range_cursor;
4466:
4467: end pay_ca_eoy_archive;