[Home] [Help]
PACKAGE: APPS.PAY_JP_IWHT_REPORT_ARCH_PKG
Source
1 PACKAGE PAY_JP_IWHT_REPORT_ARCH_PKG AUTHID CURRENT_USER AS
2 -- $Header: pyjpiwra.pkh 120.3 2010/06/08 12:10:48 mpothala noship $
3 -- *************************************************************************
4 -- * Copyright (c) Oracle Corporation Japan,2009 Product Development.
5 -- * All rights reserved
6 -- *************************************************************************
7 -- *
8 -- * PROGRAM NAME
9 -- * PAYJLWL.pkb
10 -- *
11 -- * DESCRIPTION
12 -- * This script creates the package body of PAY_JP_IWHT_REPORT_ARCH_PKG
13 -- *
14 -- * USAGE
15 -- * To install sqlplus <apps_user>/<apps_pwd> @PAY_JP_IWHT_REPORT_ARCH_PKG .pkh
16 -- * To Execute sqlplus <apps_user>/<apps_pwd> EXEC PAY_JP_IWHT_REPORT_ARCHIVE.<procedure name>
17 -- *
18 -- * PROGRAM LIST
19 -- * ==========
20 -- * NAME DESCRIPTION
21 -- * ----------------- --------------------------------------------------
22 -- * SUBMIT_REQUEST
23 -- *
24 -- * DEPENDENCIES
25 -- * None
26 -- *
27 -- * CALLED BY
28 -- * Concurrent Program
29 -- *
30 -- * LAST UPDATE DATE 10-Feb-2010
31 -- * Date the program has been modified for the last time
32 -- *
33 -- * HISTORY
34 -- * =======
35 -- *
36 -- * VERSION DATE AUTHOR(S) DESCRIPTION
37 -- * ------- ----------- ----------------- -----------------------------
38 -- * 120.0.12010000.1 09-Aug-2009 MPOTHALA Creation
39 -- * 120.0.12010000.2 08-Jun-2010 MPOTHALA Added commit
40 -- *************************************************************************
41 --
42 PROCEDURE submit_request
43 (errbuf OUT NOCOPY VARCHAR2
44 ,retcode OUT NOCOPY NUMBER
45 ,p_run_pre_tax_archive IN VARCHAR2
46 --
47 ,p_effective_date IN VARCHAR2
48 ,p_business_group_id IN VARCHAR2
49 ,p_rearchive_flag IN VARCHAR2 DEFAULT NULL
50 ,p_itax_organization_id IN VARCHAR2 DEFAULT NULL
51 ,p_payroll_id IN VARCHAR2 DEFAULT NULL
52 ,p_termination_date_from IN VARCHAR2 DEFAULT NULL
53 ,p_termination_date_to IN VARCHAR2 DEFAULT NULL
54 ,p_assignment_set_id IN VARCHAR2 DEFAULT NULL
55 --
56 ,p_enable_flag IN VARCHAR2 DEFAULT NULL
57 ,p_start_date IN VARCHAR2 DEFAULT NULL
58 ,p_end_date IN VARCHAR2 DEFAULT NULL
59 ,p_consolidation_set_id IN VARCHAR2 DEFAULT NULL
60 );
61
62 --
63 END PAY_JP_IWHT_REPORT_ARCH_PKG;