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.41.12020000.6 2012/12/28 12:06:59 sbachu ship $ */
3:
4: /*
5: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved

Line 1033: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

1029: l_effective_end_date date;
1030: l_object_version_number number;
1031: l_some_warning boolean;
1032: l_counter number;
1033: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1034: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1035: l_user_entity_name varchar2(240);
1036:
1037: /* Variables used to hold the values used as bind variables within the

Line 1034: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

1030: l_object_version_number number;
1031: l_some_warning boolean;
1032: l_counter number;
1033: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1034: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1035: l_user_entity_name varchar2(240);
1036:
1037: /* Variables used to hold the values used as bind variables within the
1038: SQL statement. */

Line 1638: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;

1634: l_value varchar2(240);
1635: l_sit_uid number;
1636: l_sui_uid number;
1637: l_fips_uid number;
1638: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1639: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1640: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1641: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1642: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

Line 1639: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;

1635: l_sit_uid number;
1636: l_sui_uid number;
1637: l_fips_uid number;
1638: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1639: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1640: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1641: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1642: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1643: l_arch_gre_step number := 0;

Line 1640: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

1636: l_sui_uid number;
1637: l_fips_uid number;
1638: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1639: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1640: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1641: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1642: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1643: l_arch_gre_step number := 0;
1644: l_archive_item_id number;

Line 1641: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

1637: l_fips_uid number;
1638: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1639: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1640: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1641: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1642: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1643: l_arch_gre_step number := 0;
1644: l_archive_item_id number;
1645: l_town_or_city varchar2(240);

Line 1642: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

1638: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1639: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
1640: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1641: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1642: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
1643: l_arch_gre_step number := 0;
1644: l_archive_item_id number;
1645: l_town_or_city varchar2(240);
1646: l_province_code varchar2(240);

Line 2240: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 10');

2236: l_warning boolean;
2237: l_archive_item_id number;
2238:
2239: begin
2240: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 10');
2241:
2242: if (called_from = 'XMLPROC') then
2243: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 20');
2244:

Line 2243: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 20');

2239: begin
2240: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 10');
2241:
2242: if (called_from = 'XMLPROC') then
2243: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 20');
2244:
2245: open c_get_arch_seq_num(p_aaid, p_jurisdiction);
2246: fetch c_get_arch_seq_num into l_final_seq_num,l_archive_item_id,l_obj_ver;
2247: close c_get_arch_seq_num;

Line 2262: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 30');

2258: close c_get_seq_num_range;
2259:
2260: if (l_start_seq_num is not null) then
2261:
2262: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 30');
2263: hr_utility.trace('l_start_seq_num = '||l_start_seq_num);
2264: hr_utility.trace('l_end_seq_num = '||l_end_seq_num);
2265:
2266: select PAY_CA_RL1_PDF_SEQ_COUNT_S.nextval into l_seq_offset

Line 2280: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 40');

2276: end if;
2277:
2278: if (called_from ='XMLPROC') then
2279: if(l_archive_item_id is null) then --If DBI is not archived when PDF is run
2280: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 40');
2281:
2282: ff_archive_api.create_archive_item(
2283: p_archive_item_id => l_archive_item_id
2284: ,p_user_entity_id => get_user_entity_id('CAEOY_RL1_PDF_SEQ_NUMBER')

Line 2295: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 50');

2291: ,p_context1 => 'QC'
2292: ,p_some_warning => l_warning
2293: );
2294: else -- If DBI is archived but with null value then update it with new value
2295: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 50');
2296:
2297: /* Commented for bug 8732218
2298: ff_archive_api.update_archive_item( p_archive_item_id => l_archive_item_id
2299: ,p_effective_date => fnd_date.string_to_date('31/12/'||p_reporting_year,'DD/MM/YYYY')

Line 2459: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

2455: l_some_warning boolean;
2456: l_negative_balance_exists varchar2(5);
2457: l_archive_item_id number;
2458: l_object_version_number number;
2459: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2460: l_balance_type_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2461:
2462: CURSOR c_get_max_asgactid_jd(cp_person_id number,
2463: cp_tax_unit_id number,

Line 2460: l_balance_type_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

2456: l_negative_balance_exists varchar2(5);
2457: l_archive_item_id number;
2458: l_object_version_number number;
2459: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2460: l_balance_type_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2461:
2462: CURSOR c_get_max_asgactid_jd(cp_person_id number,
2463: cp_tax_unit_id number,
2464: cp_period_start date,

Line 2823: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;

2819: l_county_code varchar2(3);
2820: l_city_code varchar2(4);
2821: l_jursd_context_id ff_contexts.context_id%type;
2822: l_taxunit_context_id ff_contexts.context_id%type;
2823: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2824: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2825: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2826: l_chunk number;
2827: l_payroll_action_id number;

Line 2824: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;

2820: l_city_code varchar2(4);
2821: l_jursd_context_id ff_contexts.context_id%type;
2822: l_taxunit_context_id ff_contexts.context_id%type;
2823: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2824: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2825: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2826: l_chunk number;
2827: l_payroll_action_id number;
2828: l_person_id number;

Line 2825: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

2821: l_jursd_context_id ff_contexts.context_id%type;
2822: l_taxunit_context_id ff_contexts.context_id%type;
2823: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2824: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2825: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2826: l_chunk number;
2827: l_payroll_action_id number;
2828: l_person_id number;
2829: l_defined_balance_id number;

Line 2865: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

2861: l_some_warning boolean;
2862: result number;
2863: l_no_of_payroll_run number := 0;
2864: l_has_been_paid varchar2(3) := 'N';
2865: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2866: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2867: l_balance_type_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2868: l_footnote_balance_type_tab varchar2(80);
2869: l_footnote_code varchar2(30);

Line 2866: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

2862: result number;
2863: l_no_of_payroll_run number := 0;
2864: l_has_been_paid varchar2(3) := 'N';
2865: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2866: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2867: l_balance_type_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2868: l_footnote_balance_type_tab varchar2(80);
2869: l_footnote_code varchar2(30);
2870: l_footnote_balance varchar2(80);

Line 2867: l_balance_type_tab pay_ca_eoy_rl1_archive.char240_data_type_table;

2863: l_no_of_payroll_run number := 0;
2864: l_has_been_paid varchar2(3) := 'N';
2865: l_user_entity_name_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2866: l_user_entity_value_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2867: l_balance_type_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2868: l_footnote_balance_type_tab varchar2(80);
2869: l_footnote_code varchar2(30);
2870: l_footnote_balance varchar2(80);
2871: l_footnote_amount number := 0;

Line 5170: end pay_ca_eoy_rl1_archive;

5166: end if;
5167:
5168: end eoy_range_cursor;
5169:
5170: end pay_ca_eoy_rl1_archive;