1 PACKAGE PAY_NO_SUPPORT_ORDER AUTHID CURRENT_USER AS
2 /* $Header: pynosupord.pkh 120.0.12000000.1 2007/05/20 08:56:21 rlingama noship $ */
3
4
5
6 TYPE xml_rec_type IS RECORD( xmlstring VARCHAR2(32000) );
7
8 -- Table Type for XML Table
9 TYPE xml_tab_type IS TABLE OF xml_rec_type INDEX BY BINARY_INTEGER;
10
11 -- Global declaration of Pl/Sql Table for storing Xml Data
12 xml_tab xml_tab_type;
13
14
15
16 /* GET PARAMETER */
17 FUNCTION GET_PARAMETER(
18 p_parameter_string IN VARCHAR2
19 ,p_token IN VARCHAR2
20 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2 ;
21
22
23 /* GET ALL PARAMETERS */
24 PROCEDURE GET_ALL_PARAMETERS(
25 p_payroll_action_id IN NUMBER
26 ,p_business_group_id OUT NOCOPY NUMBER
27 ,p_legal_employer_id OUT NOCOPY NUMBER
28 ,p_element_type_id OUT NOCOPY NUMBER
29 ,p_effective_date OUT NOCOPY DATE
30 ,p_from_date OUT NOCOPY DATE
31 ,p_to_date OUT NOCOPY DATE
32 ,p_third_party_id OUT NOCOPY NUMBER
33 ,p_archive OUT NOCOPY VARCHAR2
34 ) ;
35
36
37 /* RANGE CODE */
38 PROCEDURE RANGE_CODE (pactid IN NUMBER
39 ,sqlstr OUT NOCOPY VARCHAR2) ;
40
41
42 /* INITIALIZATION CODE */
43 PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER) ;
44
45
46 /* ASSIGNMENT ACTION CODE */
47 PROCEDURE ASSIGNMENT_ACTION_CODE
48 (p_payroll_action_id IN NUMBER
49 ,p_start_person IN NUMBER
50 ,p_end_person IN NUMBER
51 ,p_chunk IN NUMBER) ;
52
53
54 /* ARCHIVE CODE */
55 PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
56 ,p_effective_date IN DATE) ;
57
58
59 -- PROCEDURE for writing the xml report
60
61 PROCEDURE populate_details(p_payroll_action_id in NUMBER,
62 p_template_name in VARCHAR2,
63 p_xml out nocopy CLOB) ;
64
65
66
67 -- PROCEDURE for writing the xml to clob
68
69 PROCEDURE write_to_clob (p_xml out nocopy clob) ;
70
71
72
73 END PAY_NO_SUPPORT_ORDER;