1 PACKAGE PAY_MX_ANNUAL_WRI AUTHID CURRENT_USER as
2 /* $Header: paymxannualwri.pkh 120.0.12000000.1 2007/02/22 16:24:53 vmehta noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 2004, Oracle India Pvt. Ltd., Hyderabad *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19 Package Name : PAY_MX_ANNUAL_WRI
20 Package File Name : paymxannualwri.pkh
21
22 Description : Used for Annual Work Risk Incidents report.
23
24 Change List:
25 ------------
26
27 Name Date Version Bug Text
28 ------------- ----------- ------- ------- ------------------------------
29 sdahiya 18-Oct-2006 115.0 Created.
30 ***************************************************************************/
31
32 /****************************************************************************
33 Name : RANGE_CURSOR
34 Description : This procedure prepares range of persons to be processed.
35 *****************************************************************************/
36 PROCEDURE RANGE_CURSOR
37 (
38 P_PAYROLL_ACTION_ID number,
39 P_SQLSTR OUT NOCOPY varchar2
40 );
41
42 /****************************************************************************
43 Name : ACTION_CREATION
44 Description : This procedure creates assignment actions.
45 *****************************************************************************/
46 PROCEDURE ACTION_CREATION
47 (
48 P_PAYROLL_ACTION_ID number,
49 P_START_PERSON_ID number,
50 P_END_PERSON_ID number,
51 P_CHUNK number
52 );
53
54
55 /****************************************************************************
56 Name : INIT
57 Description : Initialization code.
58 *****************************************************************************/
59 PROCEDURE INIT
60 (
61 P_PAYROLL_ACTION_ID number
62 );
63
64 /****************************************************************************
65 Name : GEN_XML_HEADER
66 Description : This procedure generates XML header information to XML BLOB
67 *****************************************************************************/
68 PROCEDURE GEN_XML_HEADER;
69
70
71 /****************************************************************************
72 Name : GENERATE_XML
73 Description : This procedure fetches archived data, converts it to XML
74 format and appends to pay_mag_tape.g_blob_value.
75 *****************************************************************************/
76 PROCEDURE GENERATE_XML;
77
78
79 /****************************************************************************
80 Name : GEN_XML_FOOTER
81 Description : This procedure generates XML footer.
82 *****************************************************************************/
83 PROCEDURE GEN_XML_FOOTER;
84
85
86 level_cnt number;
87
88
89 CURSOR GET_CURR_ACT_ID IS
90 SELECT 'TRANSFER_ACT_ID=P',
91 pay_magtape_generic.get_parameter_value(
92 'TRANSFER_ACT_ID')
93 FROM DUAL;
94
95 CURSOR GET_XML_VER IS
96 SELECT 'ROOT_XML_TAG=P',
97 '<MX_ANN_WRI>',
98 'PAYROLL_ACTION_ID=P',
99 pay_magtape_generic.get_parameter_value(
100 'TRANSFER_PAYROLL_ACTION_ID')
101 FROM dual;
102
103 CURSOR GET_MAG_ASG_ACT IS
104 SELECT 'TRANSFER_ACT_ID=P',
105 assignment_action_id
106 FROM pay_assignment_actions
107 WHERE payroll_action_id = pay_magtape_generic.get_parameter_value(
108 'TRANSFER_PAYROLL_ACTION_ID');
109
110 END PAY_MX_ANNUAL_WRI;