[Home] [Help]
1: package body pyudet as
2: /* $Header: pyudet.pkb 120.49.12010000.5 2008/10/03 10:22:54 apmishra ship $ */
3: /*---------------------------------------------------------------------
4: Copyright (c) Oracle Corporation 1995. All rights reserved
5:
1: package body pyudet as
2: /* $Header: pyudet.pkb 120.49.12010000.5 2008/10/03 10:22:54 apmishra ship $ */
3: /*---------------------------------------------------------------------
4: Copyright (c) Oracle Corporation 1995. All rights reserved
5:
6: Name : pyudet
2: /* $Header: pyudet.pkb 120.49.12010000.5 2008/10/03 10:22:54 apmishra 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
300: where fcr.concurrent_program_id = fcp.concurrent_program_id
301: and fcr.request_id = c_creator_id
302: and fcr.request_id < g_current_req_id
303: and fcr.request_id >= g_request_id
304: and ( fcp.concurrent_program_name = 'PYUDET'
305: or fcp.concurrent_program_name = 'PYUDET_R'));
306:
307: ---------------------------------------------------------
308: -- This cursor returns tax ref id based on the payroll --
301: and fcr.request_id = c_creator_id
302: and fcr.request_id < g_current_req_id
303: and fcr.request_id >= g_request_id
304: and ( fcp.concurrent_program_name = 'PYUDET'
305: or fcp.concurrent_program_name = 'PYUDET_R'));
306:
307: ---------------------------------------------------------
308: -- This cursor returns tax ref id based on the payroll --
309: ---------------------------------------------------------
628: -- DESCRIPTION : --
629: -- DESCRIPTION --
630: -- Procedure inserts a record into the PAY_GB_SOY_OUTPUT table, --
631: -- which will be used to created the output files required for --
632: -- the PYUDET process --
633: ---------------------------------------------------------------------
634: PROCEDURE file_output(p_type in varchar2,
635: p_line_no in out nocopy number,
636: p_text in varchar2,
2329: END process_record;
2330:
2331: ---------------------------------------------------------------------
2332: -- NAME --
2333: -- pyudet.run_process PUBLIC PROCEDURE --
2334: -- --
2335: -- DESCRIPTION --
2336: -- The main procedure called from the SRS screen. The success or --
2337: -- or failure of the process is passed back to the SRS screen in --
2352: l_m12_rec g_typ_per_record;
2353: l_person_id per_all_people_f.person_id%type;
2354: l_process boolean;
2355: BEGIN
2356: hr_utility.trace('Start of PYUDET');
2357: --------------------------------
2358: -- Setting up GLOBAL variable --
2359: --------------------------------
2360: set_global(p_request_id,p_mode,p_effective_date,p_business_group_id,
2439: -- This section will be executed the first time that the package --
2440: -- is brought into memory for this session --
2441: ---------------------------------------------------------------------
2442: BEGIN
2443: hr_utility.set_location('pyudet',0);
2444: -------------------------------------------------------------------
2445: -- Initialize the count variable for the 'uplift_value' function --
2446: -------------------------------------------------------------------
2447: g_uplift_value(0) := -1;
2445: -- Initialize the count variable for the 'uplift_value' function --
2446: -------------------------------------------------------------------
2447: g_uplift_value(0) := -1;
2448: --
2449: hr_utility.set_location('pyudet',999);
2450: END;