DBA Data[Home] [Help]

PACKAGE: APPS.PAY_IN_PF_REPORTS

Source


1 PACKAGE  pay_in_pf_reports AUTHID CURRENT_USER AS
2 /* $Header: pyinmpfr.pkh 120.0 2007/12/18 14:47:56 sivanara noship $ */
3 
4   ----------------------------------------------------------------------+
5   -- This is a global variable used to store Archive assignment action id
6   ----------------------------------------------------------------------+
7 
8 --------------------------------------------------------------------------
9 --                                                                      --
10 -- Name           : INIT_CODE                                           --
11 -- Type           : PROCEDURE                                           --
12 -- Access         : Public                                              --
13 -- Description    : This procedure calls procedure for PF Monthly       --
14 --                  Reorts and EFile depending on the report type       --
15 --                  parameter                                           --
16 -- Parameters     :                                                     --
17 --             IN :   p_pf_business_no            VARCHAR2		--
18 --                    p_pf_arc_ref_no             VARCHAR2		--
19 --                    p_template_name             VARCHAR2		--
20 --                    p_return_type               VARCHAR2		--
21 --                    p_year                      VARCHAR2		--
22 --                    p_month                     VARCHAR2		--
23 --                    p_filer_license_no          VARCHAR2		--
24 --                    p_nssn                      VARCHAR2		--
25 --                    p_sort_by                   VARCHAR2		--
26 --            OUT :   p_xml                       CLOB                  --
27 --                                                                      --
28 -- Change History :                                                     --
29 --------------------------------------------------------------------------
30 -- Rev#  Date           Userid    Description                           --
31 --------------------------------------------------------------------------
32 -- 115.0 01-AUG-2007    rsaharay   Initial Version                      --
33 --------------------------------------------------------------------------
34 PROCEDURE init_code  (p_pf_business_no       IN VARCHAR2  DEFAULT NULL
35 		     ,p_pf_arc_ref_no        IN VARCHAR2  DEFAULT NULL
36 	             ,p_template_name        IN VARCHAR2
37 		     ,p_xml                  OUT NOCOPY CLOB
38 		     ,p_return_type          IN VARCHAR2  DEFAULT NULL
39 		     ,p_year                 IN VARCHAR2  DEFAULT NULL
40 		     ,p_month                IN VARCHAR2  DEFAULT NULL
41 		     ,p_filer_license_no     IN VARCHAR2  DEFAULT NULL
42 		     ,p_nssn                 IN VARCHAR2  DEFAULT NULL
43 		     ,p_sort_by              IN VARCHAR2  DEFAULT NULL) ;
44 
45 
46 END ;