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_US_SQWL_ARCHIVE dependencies on PAY_US_SQWL_ARCHIVE

Line 1: package body pay_us_sqwl_archive as

1: package body pay_us_sqwl_archive as
2: /* $Header: pyussqwl.pkb 120.12.12010000.2 2008/08/06 08:36:01 ubhat ship $ */
3:
4: /*
5: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved

Line 267: p_sequence in pay_us_sqwl_archive.number_data_type_table,

263: function chk_gre_archive (p_payroll_action_id number) return boolean;
264: procedure create_archive (p_user_entity_id in number,
265: p_context1 in number,
266: p_value in varchar2,
267: p_sequence in pay_us_sqwl_archive.number_data_type_table,
268: p_context in pay_us_sqwl_archive.char240_data_type_table,
269: p_context_id in pay_us_sqwl_archive.number_data_type_table);
270:
271: sqwl_range varchar2(4000);

Line 268: p_context in pay_us_sqwl_archive.char240_data_type_table,

264: procedure create_archive (p_user_entity_id in number,
265: p_context1 in number,
266: p_value in varchar2,
267: p_sequence in pay_us_sqwl_archive.number_data_type_table,
268: p_context in pay_us_sqwl_archive.char240_data_type_table,
269: p_context_id in pay_us_sqwl_archive.number_data_type_table);
270:
271: sqwl_range varchar2(4000);
272:

Line 269: p_context_id in pay_us_sqwl_archive.number_data_type_table);

265: p_context1 in number,
266: p_value in varchar2,
267: p_sequence in pay_us_sqwl_archive.number_data_type_table,
268: p_context in pay_us_sqwl_archive.char240_data_type_table,
269: p_context_id in pay_us_sqwl_archive.number_data_type_table);
270:
271: sqwl_range varchar2(4000);
272:
273:

Line 1609: p_sequence in pay_us_sqwl_archive.number_data_type_table,

1605:
1606: procedure create_archive (p_user_entity_id in number,
1607: p_context1 in number,
1608: p_value in varchar2,
1609: p_sequence in pay_us_sqwl_archive.number_data_type_table,
1610: p_context in pay_us_sqwl_archive.char240_data_type_table,
1611: p_context_id in pay_us_sqwl_archive.number_data_type_table) is
1612: l_step number := 0;
1613:

Line 1610: p_context in pay_us_sqwl_archive.char240_data_type_table,

1606: procedure create_archive (p_user_entity_id in number,
1607: p_context1 in number,
1608: p_value in varchar2,
1609: p_sequence in pay_us_sqwl_archive.number_data_type_table,
1610: p_context in pay_us_sqwl_archive.char240_data_type_table,
1611: p_context_id in pay_us_sqwl_archive.number_data_type_table) is
1612: l_step number := 0;
1613:
1614: begin

Line 1611: p_context_id in pay_us_sqwl_archive.number_data_type_table) is

1607: p_context1 in number,
1608: p_value in varchar2,
1609: p_sequence in pay_us_sqwl_archive.number_data_type_table,
1610: p_context in pay_us_sqwl_archive.char240_data_type_table,
1611: p_context_id in pay_us_sqwl_archive.number_data_type_table) is
1612: l_step number := 0;
1613:
1614: begin
1615:

Line 1679: l_seq_tab pay_us_sqwl_archive.number_data_type_table;

1675: l_user_entity_id number;
1676: l_tax_context_id number;
1677: l_jursd_context_id number;
1678: l_value varchar2(240);
1679: l_seq_tab pay_us_sqwl_archive.number_data_type_table;
1680: l_context_id_tab pay_us_sqwl_archive.number_data_type_table;
1681: l_context_val_tab pay_us_sqwl_archive.char240_data_type_table;
1682: l_arch_gre_step number := 0;
1683:

Line 1680: l_context_id_tab pay_us_sqwl_archive.number_data_type_table;

1676: l_tax_context_id number;
1677: l_jursd_context_id number;
1678: l_value varchar2(240);
1679: l_seq_tab pay_us_sqwl_archive.number_data_type_table;
1680: l_context_id_tab pay_us_sqwl_archive.number_data_type_table;
1681: l_context_val_tab pay_us_sqwl_archive.char240_data_type_table;
1682: l_arch_gre_step number := 0;
1683:
1684: l_state_code pay_us_states.state_code%type;

Line 1681: l_context_val_tab pay_us_sqwl_archive.char240_data_type_table;

1677: l_jursd_context_id number;
1678: l_value varchar2(240);
1679: l_seq_tab pay_us_sqwl_archive.number_data_type_table;
1680: l_context_id_tab pay_us_sqwl_archive.number_data_type_table;
1681: l_context_val_tab pay_us_sqwl_archive.char240_data_type_table;
1682: l_arch_gre_step number := 0;
1683:
1684: l_state_code pay_us_states.state_code%type;
1685:

Line 2515: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 10);

2511: l_distinct_wage_plan_code NUMBER := 0 ;
2512:
2513:
2514: BEGIN
2515: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 10);
2516:
2517: IF (l_report_cat = 'RTM') THEN
2518:
2519: l_counter := 0;

Line 2529: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 30);

2525:
2526: END LOOP;
2527:
2528: IF (l_counter > 0) THEN
2529: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 30);
2530: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2531: hr_utility.set_message_token('FORMAT', '> 1 row in hoi for wg plcd');
2532: hr_utility.raise_error;
2533: END IF;

Line 2548: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 40);

2544:
2545: END LOOP;
2546:
2547: IF l_counter > 0 THEN
2548: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 40);
2549: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2550: hr_utility.set_message_token('FORMAT',' Default Wage Plan not marked');
2551: hr_utility.raise_error;
2552: END IF;

Line 2564: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 50);

2560:
2561: END LOOP;
2562:
2563: IF l_counter > 0 THEN
2564: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 50);
2565: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
2566: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
2567: hr_utility.raise_error;
2568: END IF;

Line 3045: end pay_us_sqwl_archive;

3041: --begin
3042:
3043: --hr_utility.trace_on(null,'sqwl');
3044:
3045: end pay_us_sqwl_archive;