[Home] [Help]
PACKAGE: APPS.PAY_NO_SAL_STATISTICS_ARCHIVE
Source
1 PACKAGE pay_no_sal_statistics_archive AS
2 /* $Header: pynossta.pkh 120.0.12000000.1 2007/05/20 09:29:52 rlingama noship $ */
3 --
4 -- -----------------------------------------------------------------------------
5 -- Parse out parameters from string.
6 -- -----------------------------------------------------------------------------
7 --
8 FUNCTION get_parameter
9 (p_parameter_string IN VARCHAR2
10 ,p_token IN VARCHAR) RETURN VARCHAR2;
11 --
12 -- -----------------------------------------------------------------------------
13 --
14 -- -----------------------------------------------------------------------------
15 --
16 PROCEDURE range_code
17 (p_payroll_action_id IN NUMBER
18 ,p_sql OUT NOCOPY VARCHAR2);
19 --
20 -- -----------------------------------------------------------------------------
21 --
22 -- -----------------------------------------------------------------------------
23 --
24 PROCEDURE assignment_action_code
25 (p_payroll_action_id IN NUMBER
26 ,p_start_person IN NUMBER
27 ,p_end_person IN NUMBER
28 ,p_chunk IN NUMBER);
29 --
30 -- -----------------------------------------------------------------------------
31 --
32 -- -----------------------------------------------------------------------------
33 --
34 PROCEDURE initialization_code
35 (p_payroll_action_id IN NUMBER);
36 --
37 -- -----------------------------------------------------------------------------
38 --
39 -- -----------------------------------------------------------------------------
40 --
41 PROCEDURE archive_code
42 (p_assignment_action_id IN NUMBER
43 ,p_effective_date IN DATE);
44 --
45 -- -----------------------------------------------------------------------------
46 --
47 -- -----------------------------------------------------------------------------
48 --
49
50 TYPE xml_rec_type IS RECORD
51 (
52 TagName VARCHAR2(240),
53 TagValue VARCHAR2(240)
54 );
55
56 TYPE xml_tab_type
57 IS TABLE OF xml_rec_type
58 INDEX BY BINARY_INTEGER;
59
60 xml_tab xml_tab_type;
61
62 PROCEDURE POPULATE_DATA_DETAIL
63 (p_business_group_id IN NUMBER,
64 p_payroll_action_id IN VARCHAR2,
65 p_template_name IN VARCHAR2,
66 p_xml OUT NOCOPY CLOB);
67
68 END pay_no_sal_statistics_archive;