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_EOY_RL1_ARCHIVE dependencies on PAY_CA_EOY_RL1_ARCHIVE

Line 1: package body pay_ca_eoy_rl1_archive as

1: package body pay_ca_eoy_rl1_archive as
2: /* $Header: pycarlar.pkb 120.17 2008/01/10 16:41:30 sapalani noship $ */
3:
4: /*
5: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved

Line 945: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

941: l_effective_end_date date;
942: l_object_version_number number;
943: l_some_warning boolean;
944: l_counter number;
945: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
946: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
947: l_user_entity_name varchar2(240);
948:
949: /* Variables used to hold the values used as bind variables within the

Line 946: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

942: l_object_version_number number;
943: l_some_warning boolean;
944: l_counter number;
945: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
946: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
947: l_user_entity_name varchar2(240);
948:
949: /* Variables used to hold the values used as bind variables within the
950: SQL statement. */

Line 1441: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;

1437: l_value varchar2(240);
1438: l_sit_uid number;
1439: l_sui_uid number;
1440: l_fips_uid number;
1441: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1442: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1443: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1444: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1445: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

Line 1442: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;

1438: l_sit_uid number;
1439: l_sui_uid number;
1440: l_fips_uid number;
1441: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1442: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1443: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1444: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1445: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1446: l_arch_gre_step number := 0;

Line 1443: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

1439: l_sui_uid number;
1440: l_fips_uid number;
1441: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1442: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1443: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1444: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1445: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1446: l_arch_gre_step number := 0;
1447: l_archive_item_id number;

Line 1444: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

1440: l_fips_uid number;
1441: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1442: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1443: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1444: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1445: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1446: l_arch_gre_step number := 0;
1447: l_archive_item_id number;
1448: l_town_or_city varchar2(240);

Line 1445: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

1441: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1442: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1443: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1444: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1445: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1446: l_arch_gre_step number := 0;
1447: l_archive_item_id number;
1448: l_town_or_city varchar2(240);
1449: l_province_code varchar2(240);

Line 2014: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;

2010: l_county_code varchar2(3);
2011: l_city_code varchar2(4);
2012: l_jursd_context_id ff_contexts.context_id%type;
2013: l_taxunit_context_id ff_contexts.context_id%type;
2014: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2015: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2016: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2017: l_chunk number;
2018: l_payroll_action_id number;

Line 2015: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;

2011: l_city_code varchar2(4);
2012: l_jursd_context_id ff_contexts.context_id%type;
2013: l_taxunit_context_id ff_contexts.context_id%type;
2014: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2015: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2016: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2017: l_chunk number;
2018: l_payroll_action_id number;
2019: l_person_id number;

Line 2016: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

2012: l_jursd_context_id ff_contexts.context_id%type;
2013: l_taxunit_context_id ff_contexts.context_id%type;
2014: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2015: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2016: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2017: l_chunk number;
2018: l_payroll_action_id number;
2019: l_person_id number;
2020: l_defined_balance_id number;

Line 2056: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

2052: l_some_warning boolean;
2053: result number;
2054: l_no_of_payroll_run number := 0;
2055: l_has_been_paid varchar2(3) := 'N';
2056: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2057: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2058: l_balance_type_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2059: l_footnote_balance_type_tab varchar2(80);
2060: l_footnote_code varchar2(30);

Line 2057: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

2053: result number;
2054: l_no_of_payroll_run number := 0;
2055: l_has_been_paid varchar2(3) := 'N';
2056: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2057: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2058: l_balance_type_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2059: l_footnote_balance_type_tab varchar2(80);
2060: l_footnote_code varchar2(30);
2061: l_footnote_balance varchar2(80);

Line 2058: l_balance_type_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

2054: l_no_of_payroll_run number := 0;
2055: l_has_been_paid varchar2(3) := 'N';
2056: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2057: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2058: l_balance_type_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2059: l_footnote_balance_type_tab varchar2(80);
2060: l_footnote_code varchar2(30);
2061: l_footnote_balance varchar2(80);
2062: l_footnote_amount number := 0;

Line 4145: end pay_ca_eoy_rl1_archive;

4141: end if;
4142:
4143: end eoy_range_cursor;
4144:
4145: end pay_ca_eoy_rl1_archive;