PACKAGE: APPS.PAY_NL_REM_REPORT

Source

1 PACKAGE PAY_NL_REM_REPORT AUTHID CURRENT_USER as
2 /* $Header: paynlremrep.pkh 120.0.12020000.2 2013/03/19 14:33:52 sgmaram noship $ */
3 
4   /******************************************
5     Record for storing XML tag and its value
6    ******************************************/
7   TYPE XMLRec IS RECORD  (TagName  VARCHAR2(1000)
8                          ,TagValue VARCHAR2(4000));
9 
10   TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
11 
12   xXMLTable        tXMLTable;
13 
14   /******************************************
15    Record Type to hold payroll values
16    *******************************************/
17   TYPE emp_payroll_details_rec IS RECORD (
18       values_present  VARCHAR2(20),
19 	    column1 VARCHAR2(70),
20       column3 NUMBER := 0.00,
21       column4 NUMBER := 0.00,
22       column5 NUMBER := 0.00,
23       column6 NUMBER := 0.00,
24       column7 NUMBER := 0.00,
25       column8 NUMBER := 0.00,
26       column12  NUMBER := 0.00,
27       column14 NUMBER := 0.00,
28       column15 NUMBER := 0.00,
29       column16 NUMBER := 0.00,
30       column17 NUMBER := 0.00,
31       column18 NUMBER := 0.00,
32       column19 NUMBER := 0.00
33    );
34 
35    /**************************************************
36          Number Format to Display
37     **************************************************/
38    g_number_format VARCHAR2(20) := 'FM9G999G999G990D00';
39 
40   PROCEDURE generate( p_business_group_id         NUMBER
41                    ,p_pay_period                VARCHAR2 DEFAULT NULL
42    				         ,p_dummy                     VARCHAR2 DEFAULT NULL
43                    ,p_end_of_year               VARCHAR2
44                    ,p_org_struct_id             VARCHAR2
45                    ,p_org_struct_name           VARCHAR2
46                    ,p_top_org_id                NUMBER DEFAULT NULL
47                    ,p_dummy_emp                 VARCHAR2 DEFAULT NULL
48                    ,p_sub_emp                   VARCHAR2
49                    ,p_top_org_name              VARCHAR2 DEFAULT NULL
50                    ,p_person_id                 NUMBER    DEFAULT NULL
51                    ,p_employee_name             VARCHAR2 DEFAULT NULL
52                    ,p_effective_date            VARCHAR2
53                    ,p_template_name              VARCHAR2
54                    ,p_xml                       OUT NOCOPY CLOB);
55 
56   PROCEDURE get_employee_high_wages(errbuf OUT NOCOPY      VARCHAR2
57                                    ,retcode   OUT NOCOPY   NUMBER
58                                    ,p_business_group_id    NUMBER
59                                    ,p_end_of_year          VARCHAR2
60                                    ,p_org_id               NUMBER
61                                    ,p_employer_name        VARCHAR2
62 			           ,p_threshold_limit      NUMBER
63 				   ,p_percentage           NUMBER
64                                  );
65 
66 END PAY_NL_REM_REPORT;
67