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.27.12020000.11 2013/02/25 09:05:52 nvelaga ship $ */
3:
4: /*
5: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved

Line 322: p_sequence in pay_us_sqwl_archive.number_data_type_table,

318: function chk_gre_archive (p_payroll_action_id number) return boolean;
319: procedure create_archive (p_user_entity_id in number,
320: p_context1 in number,
321: p_value in varchar2,
322: p_sequence in pay_us_sqwl_archive.number_data_type_table,
323: p_context in pay_us_sqwl_archive.char240_data_type_table,
324: p_context_id in pay_us_sqwl_archive.number_data_type_table);
325:
326: sqwl_range varchar2(4000);

Line 323: p_context in pay_us_sqwl_archive.char240_data_type_table,

319: procedure create_archive (p_user_entity_id in number,
320: p_context1 in number,
321: p_value in varchar2,
322: p_sequence in pay_us_sqwl_archive.number_data_type_table,
323: p_context in pay_us_sqwl_archive.char240_data_type_table,
324: p_context_id in pay_us_sqwl_archive.number_data_type_table);
325:
326: sqwl_range varchar2(4000);
327:

Line 324: p_context_id in pay_us_sqwl_archive.number_data_type_table);

320: p_context1 in number,
321: p_value in varchar2,
322: p_sequence in pay_us_sqwl_archive.number_data_type_table,
323: p_context in pay_us_sqwl_archive.char240_data_type_table,
324: p_context_id in pay_us_sqwl_archive.number_data_type_table);
325:
326: sqwl_range varchar2(4000);
327:
328:

Line 1708: p_sequence in pay_us_sqwl_archive.number_data_type_table,

1704:
1705: procedure create_archive (p_user_entity_id in number,
1706: p_context1 in number,
1707: p_value in varchar2,
1708: p_sequence in pay_us_sqwl_archive.number_data_type_table,
1709: p_context in pay_us_sqwl_archive.char240_data_type_table,
1710: p_context_id in pay_us_sqwl_archive.number_data_type_table) is
1711: l_step number := 0;
1712:

Line 1709: p_context in pay_us_sqwl_archive.char240_data_type_table,

1705: procedure create_archive (p_user_entity_id in number,
1706: p_context1 in number,
1707: p_value in varchar2,
1708: p_sequence in pay_us_sqwl_archive.number_data_type_table,
1709: p_context in pay_us_sqwl_archive.char240_data_type_table,
1710: p_context_id in pay_us_sqwl_archive.number_data_type_table) is
1711: l_step number := 0;
1712:
1713: begin

Line 1710: p_context_id in pay_us_sqwl_archive.number_data_type_table) is

1706: p_context1 in number,
1707: p_value in varchar2,
1708: p_sequence in pay_us_sqwl_archive.number_data_type_table,
1709: p_context in pay_us_sqwl_archive.char240_data_type_table,
1710: p_context_id in pay_us_sqwl_archive.number_data_type_table) is
1711: l_step number := 0;
1712:
1713: begin
1714:

Line 1778: l_seq_tab pay_us_sqwl_archive.number_data_type_table;

1774: l_user_entity_id number;
1775: l_tax_context_id number;
1776: l_jursd_context_id number;
1777: l_value varchar2(240);
1778: l_seq_tab pay_us_sqwl_archive.number_data_type_table;
1779: l_context_id_tab pay_us_sqwl_archive.number_data_type_table;
1780: l_context_val_tab pay_us_sqwl_archive.char240_data_type_table;
1781: l_arch_gre_step number := 0;
1782:

Line 1779: l_context_id_tab pay_us_sqwl_archive.number_data_type_table;

1775: l_tax_context_id number;
1776: l_jursd_context_id number;
1777: l_value varchar2(240);
1778: l_seq_tab pay_us_sqwl_archive.number_data_type_table;
1779: l_context_id_tab pay_us_sqwl_archive.number_data_type_table;
1780: l_context_val_tab pay_us_sqwl_archive.char240_data_type_table;
1781: l_arch_gre_step number := 0;
1782:
1783: l_state_code pay_us_states.state_code%type;

Line 1780: l_context_val_tab pay_us_sqwl_archive.char240_data_type_table;

1776: l_jursd_context_id number;
1777: l_value varchar2(240);
1778: l_seq_tab pay_us_sqwl_archive.number_data_type_table;
1779: l_context_id_tab pay_us_sqwl_archive.number_data_type_table;
1780: l_context_val_tab pay_us_sqwl_archive.char240_data_type_table;
1781: l_arch_gre_step number := 0;
1782:
1783: l_state_code pay_us_states.state_code%type;
1784:

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

3448: l_distinct_wage_plan_code NUMBER := 0 ;
3449:
3450:
3451: BEGIN
3452: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 10);
3453:
3454: IF (l_report_cat = 'RTM') THEN
3455:
3456: l_counter := 0;

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

3462:
3463: END LOOP;
3464:
3465: IF (l_counter > 0) THEN
3466: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 30);
3467: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3468: hr_utility.set_message_token('FORMAT', '> 1 row in hoi for wg plcd');
3469: hr_utility.raise_error;
3470: END IF;

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

3481:
3482: END LOOP;
3483:
3484: IF l_counter > 0 THEN
3485: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 40);
3486: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3487: hr_utility.set_message_token('FORMAT',' Default Wage Plan not marked');
3488: hr_utility.raise_error;
3489: END IF;

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

3497:
3498: END LOOP;
3499:
3500: IF l_counter > 0 THEN
3501: hr_utility.set_location('pay_us_sqwl_archive.preprocess_check', 50);
3502: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
3503: hr_utility.set_message_token('FORMAT',' wage plan not defined at GRE');
3504: hr_utility.raise_error;
3505: END IF;

Line 4041: end pay_us_sqwl_archive;

4037: --begin
4038:
4039: --hr_utility.trace_on(null,'sqwl');
4040:
4041: end pay_us_sqwl_archive;