PACKAGE: APPS.PAY_SE_STAT_OFFICE_ARCHIVE

Source

1 PACKAGE pay_se_stat_office_archive AUTHID CURRENT_USER AS
2  /* $Header: pysestoa.pkh 120.0.12000000.1 2007/04/20 09:18:14 abhgangu 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_se_stat_office_archive;