[Home] [Help]
1: package body pyudet as
2: /* $Header: pyudet.pkb 120.69.12020000.2 2013/01/22 13:16:48 ssarap ship $ */
3: /*---------------------------------------------------------------------
4: Copyright (c) Oracle Corporation 1995. All rights reserved
5:
1: package body pyudet as
2: /* $Header: pyudet.pkb 120.69.12020000.2 2013/01/22 13:16:48 ssarap ship $ */
3: /*---------------------------------------------------------------------
4: Copyright (c) Oracle Corporation 1995. All rights reserved
5:
6: Name : pyudet
2: /* $Header: pyudet.pkb 120.69.12020000.2 2013/01/22 13:16:48 ssarap ship $ */
3: /*---------------------------------------------------------------------
4: Copyright (c) Oracle Corporation 1995. All rights reserved
5:
6: Name : pyudet
7: Description : Start Of Year Process, used to change Tax Basis to
8: Cumulative, clear Previous Tax Paid and Taxable Pay,
9: uplift Tax Codes or read new Tax Codes from tape.
10: Author : Barry Goodsell
379: where fcr.concurrent_program_id = fcp.concurrent_program_id
380: and fcr.request_id = c_creator_id
381: and fcr.request_id < g_current_req_id
382: and fcr.request_id >= g_request_id
383: and ( fcp.concurrent_program_name = 'PYUDET'
384: or fcp.concurrent_program_name = 'PYUDET_R'));
385:
386: ---------------------------------------------------------
387: -- This cursor returns tax ref id based on the payroll --
380: and fcr.request_id = c_creator_id
381: and fcr.request_id < g_current_req_id
382: and fcr.request_id >= g_request_id
383: and ( fcp.concurrent_program_name = 'PYUDET'
384: or fcp.concurrent_program_name = 'PYUDET_R'));
385:
386: ---------------------------------------------------------
387: -- This cursor returns tax ref id based on the payroll --
388: ---------------------------------------------------------
714: -- DESCRIPTION : --
715: -- DESCRIPTION --
716: -- Procedure inserts a record into the PAY_GB_SOY_OUTPUT table, --
717: -- which will be used to created the output files required for --
718: -- the PYUDET process --
719: ---------------------------------------------------------------------
720: PROCEDURE file_output(p_type in varchar2,
721: p_line_no in out nocopy number,
722: p_text in varchar2,
2965: END process_record;
2966:
2967: ---------------------------------------------------------------------
2968: -- NAME --
2969: -- pyudet.run_process PUBLIC PROCEDURE --
2970: -- --
2971: -- DESCRIPTION --
2972: -- The main procedure called from the SRS screen. The success or --
2973: -- or failure of the process is passed back to the SRS screen in --
2989: l_person_id per_all_people_f.person_id%type;
2990: l_process boolean;
2991: BEGIN
2992: --hr_utility.trace_on(null,'hello');
2993: hr_utility.trace('Start of PYUDET');
2994: --------------------------------
2995: -- Setting up GLOBAL variable --
2996: --------------------------------
2997: set_global(p_request_id,p_mode,p_effective_date,p_business_group_id,
3079: -- This section will be executed the first time that the package --
3080: -- is brought into memory for this session --
3081: ---------------------------------------------------------------------
3082: BEGIN
3083: hr_utility.set_location('pyudet',0);
3084: -------------------------------------------------------------------
3085: -- Initialize the count variable for the 'uplift_value' function --
3086: -------------------------------------------------------------------
3087: g_uplift_value(0) := -1;
3085: -- Initialize the count variable for the 'uplift_value' function --
3086: -------------------------------------------------------------------
3087: g_uplift_value(0) := -1;
3088: --
3089: hr_utility.set_location('pyudet',999);
3090: END;