[Home] [Help]
PACKAGE: APPS.PAY_IN_EOY_REPORTS
Source
1 PACKAGE pay_in_eoy_reports AS
2 /* $Header: pyineoyr.pkh 120.0.12010000.1 2008/07/27 22:53:03 appldev ship $ */
3
4 --------------------------------------------------------------------------
5 -- --
6 -- Name : GET_TEMPLATE --
7 -- Type : PROCEDURE --
8 -- Access : Public --
9 -- Description : This procedure gets the payslip template code --
10 -- --
11 -- Parameters : --
12 -- IN : p_business_group_id NUMBER --
13 -- OUT : p_template VARCHAR2 --
14 --------------------------------------------------------------------------
15 --
16
17 PROCEDURE get_template (p_business_group_id IN NUMBER
18 ,p_template OUT NOCOPY VARCHAR2
19 );
20
21 --------------------------------------------------------------------------
22 -- --
23 -- Name : FETCH_XML --
24 -- Type : PROCEDURE --
25 -- Access : Public --
26 -- Description : This procedure returns the next CLOB available in --
27 -- global CLOB array --
28 -- --
29 -- Parameters : --
30 -- IN : N/A --
31 -- OUT : p_clob CLOB --
32 --------------------------------------------------------------------------
33 --
34 PROCEDURE fetch_xml (p_clob OUT NOCOPY CLOB);
35
36 --------------------------------------------------------------------------
37 -- --
38 -- Name : LOAD_XML --
39 -- Type : PROCEDURE --
40 -- Access : Public --
41 -- Description : This procedure makes a list of XMLs in a global --
42 -- CLOB array --
43 -- --
44 -- Parameters : --
45 -- IN : p_business_group_id NUMBER --
46 -- p_assessment_year VARCHAR2 --
47 -- p_gre_organization VARCHAR2 --
48 -- p_employee_type VARCHAR2 --
49 -- p_employee_number VARCHAR2 --
50 -- OUT : p_clob_cnt NUMBER --
51 --------------------------------------------------------------------------
52 --
53 PROCEDURE load_xml (p_business_group_id IN NUMBER
54 ,p_assessment_year IN VARCHAR2
55 ,p_gre_organization IN VARCHAR2 DEFAULT NULL
56 ,p_employee_type IN VARCHAR2
57 ,p_employee_number IN VARCHAR2 DEFAULT NULL
58 ,p_clob_cnt OUT NOCOPY NUMBER
59 );
60
61 --------------------------------------------------------------------------
62 -- --
63 -- Name : GET_LOCATION_DETAILS --
64 -- Type : FUNCTION --
65 -- Access : Public --
66 -- Description : This function returns either the complete gre --
67 -- location details or of a specified field based on --
68 -- the parameters passed --
69 -- Parameters : --
70 -- IN : p_location_id NUMBER --
71 -- p_concatenate VARCHAR2 --
72 -- p_field VARCHAR2 --
73 -- RETURN : VARCHAR2
74 --------------------------------------------------------------------------
75 FUNCTION get_location_details ( p_location_id IN hr_locations.location_id%TYPE
76 , p_concatenate IN VARCHAR2 DEFAULT 'N'
77 , p_field IN VARCHAR2 DEFAULT NULL
78 )
79 RETURN VARCHAR2;
80
81 --------------------------------------------------------------------------
82 -- --
83 -- Name : GET_ADDRESS_DETAILS --
84 -- Type : FUNCTION --
85 -- Access : Public --
86 -- Description : This function returns either the complete person --
87 -- address details or of a specified field based on --
88 -- the parameters passed --
89 -- Parameters : --
90 -- IN : p_address_id NUMBER --
91 -- p_concatenate VARCHAR2 --
92 -- p_field VARCHAR2 --
93 -- RETURN : VARCHAR2
94 --------------------------------------------------------------------------
95 FUNCTION get_address_details ( p_address_id IN per_addresses.address_id%TYPE
96 , p_concatenate IN VARCHAR2 DEFAULT 'N'
97 , p_field IN VARCHAR2 DEFAULT NULL
98 )
99 RETURN VARCHAR2;
100
101 END pay_in_eoy_reports;