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.20.12010000.8 2008/09/26 14:12:00 sneelapa ship $ */
3:
4: /*
5: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved

Line 501: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;

497: l_tax_unit_id number;
498: l_eoy_tax_unit_id number;
499: l_effective_end_date date;
500: l_archive_item_id number;
501: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
502:
503: /* Variables used to hold the values used as bind variables within the
504: SQL statement. */
505:

Line 1294: l_seq_tab pay_ca_eoy_archive.number_data_type_table;

1290: l_sit_uid number;
1291: l_sui_uid number;
1292: l_fips_uid number;
1293: l_counter number;
1294: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1295: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1296: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1297: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1298: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;

Line 1295: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;

1291: l_sui_uid number;
1292: l_fips_uid number;
1293: l_counter number;
1294: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1295: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1296: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1297: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1298: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
1299: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;

Line 1296: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;

1292: l_fips_uid number;
1293: l_counter number;
1294: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1295: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1296: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1297: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1298: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
1299: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;
1300: l_arch_gre_step number := 0;

Line 1297: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;

1293: l_counter number;
1294: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1295: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1296: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1297: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1298: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
1299: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;
1300: l_arch_gre_step number := 0;
1301: l_name varchar2(240);

Line 1298: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;

1294: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1295: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1296: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1297: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1298: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
1299: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;
1300: l_arch_gre_step number := 0;
1301: l_name varchar2(240);
1302: l_business_group_id number;

Line 1299: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;

1295: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1296: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1297: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1298: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
1299: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;
1300: l_arch_gre_step number := 0;
1301: l_name varchar2(240);
1302: l_business_group_id number;
1303: l_seq number;

Line 1901: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;

1897: l_aaid pay_assignment_actions.assignment_action_id%type;
1898: l_aaseq pay_assignment_actions.action_sequence%type;
1899: l_asgid pay_assignment_actions.assignment_id%type;
1900: l_date_earned date;
1901: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1902: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
1903: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;
1904: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1905: l_business_group_id pay_assignment_actions.tax_unit_id%type;

Line 1902: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;

1898: l_aaseq pay_assignment_actions.action_sequence%type;
1899: l_asgid pay_assignment_actions.assignment_id%type;
1900: l_date_earned date;
1901: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1902: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
1903: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;
1904: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1905: l_business_group_id pay_assignment_actions.tax_unit_id%type;
1906: l_year_start date;

Line 1903: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;

1899: l_asgid pay_assignment_actions.assignment_id%type;
1900: l_date_earned date;
1901: l_user_entity_name_tab pay_ca_eoy_archive.char240_data_type_table;
1902: l_balance_type_tab pay_ca_eoy_archive.char240_data_type_table;
1903: l_user_entity_value_tab pay_ca_eoy_archive.char240_data_type_table;
1904: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
1905: l_business_group_id pay_assignment_actions.tax_unit_id%type;
1906: l_year_start date;
1907: l_year_end date;

Line 1926: l_seq_tab pay_ca_eoy_archive.number_data_type_table;

1922: l_county_code varchar2(3);
1923: l_city_code varchar2(4);
1924: l_jursd_context_id ff_contexts.context_id%type;
1925: l_taxunit_context_id ff_contexts.context_id%type;
1926: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1927: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1928: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1929: l_chunk number;
1930: l_payroll_action_id number;

Line 1927: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;

1923: l_city_code varchar2(4);
1924: l_jursd_context_id ff_contexts.context_id%type;
1925: l_taxunit_context_id ff_contexts.context_id%type;
1926: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1927: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1928: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1929: l_chunk number;
1930: l_payroll_action_id number;
1931: l_defined_balance_id number;

Line 1928: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;

1924: l_jursd_context_id ff_contexts.context_id%type;
1925: l_taxunit_context_id ff_contexts.context_id%type;
1926: l_seq_tab pay_ca_eoy_archive.number_data_type_table;
1927: l_context_id_tab pay_ca_eoy_archive.number_data_type_table;
1928: l_context_val_tab pay_ca_eoy_archive.char240_data_type_table;
1929: l_chunk number;
1930: l_payroll_action_id number;
1931: l_defined_balance_id number;
1932: l_result number;

Line 3840: end pay_ca_eoy_archive;

3836: end if;
3837:
3838: end eoy_range_cursor;
3839:
3840: end pay_ca_eoy_archive;
3841: