[Home] [Help]
PACKAGE: APPS.PAY_JP_UITE_REPORT_PKG
Source
1 PACKAGE PAY_JP_UITE_REPORT_PKG AUTHID CURRENT_USER AS
2 -- $Header: pyjpuirp.pkh 120.1 2010/05/21 13:46:57 pmatamsr noship $
3 -- *******************************************************************************************************
4 -- * Copyright (c) Oracle Corporation Japan,2009 Product Development. *
5 -- * All rights reserved *
6 -- *******************************************************************************************************
7 -- * *
8 -- * PROGRAM NAME *
9 -- * PAY_JP_UITE_REPORT_PKG.pks *
10 -- * *
11 -- * DESCRIPTION *
12 -- * This script creates the package specification of PAY_JP_UITE_REPORT_PKG. *
13 -- * *
14 -- * USAGE *
15 -- * To Install sqlplus <apps_user>/<apps_pwd> @PAYJPUITEREPORTPKG.PKH *
16 -- * To Execute sqlplus <apps_user>/<apps_pwd> EXEC PAY_JP_UITE_REPORT_PKG.<procedure name> *
17 -- * *
18 -- * PROGRAM LIST *
19 -- * ========== *
20 -- * NAME DESCRIPTION *
21 -- * ----------------- -------------------------------------------------- *
22 -- * RANGE_CURSOR *
23 -- * ACTION_CREATION *
24 -- * GEN_XML_HEADER *
25 -- * GENERATE_XML *
26 -- * PRINT_CLOB *
27 -- * GEN_XML_FOOTER *
28 -- * INIT_CODE *
29 -- * ARCHIVE_CODE *
30 -- * ASSACT_XML *
31 -- * GET_CP_XML *
32 -- * WRITETOCLOB *
33 -- * CALLED BY *
34 -- * Concurrent Program Japan, Terminated Employee Report *
35 -- * *
36 -- * LAST UPDATE DATE *
37 -- * Date the program has been modified for the last time *
38 -- * *
39 -- * HISTORY *
40 -- * ======= *
41 -- * *
42 -- * VERSION DATE AUTHOR(S) DESCRIPTION *
43 -- * ------- ----------- ---------------- ---------------------------- *
44 -- * 120.0.12010000.1 12/02/2010 RDARASI intial *
45 -- * 120.0.12010000.2 13/04/2010 RDARASI Modified as per internal review comments *
46 -- * 120.0.12010000.3 20/04/2010 RDARASI Modified as per internal review comments *
47 -- *******************************************************************************************************
48 TYPE parameters IS RECORD (payroll_action_id NUMBER
49 ,ass_setid NUMBER
50 ,rep_group VARCHAR2(50)
51 ,rep_cat VARCHAR2(50)
52 ,business_group_id NUMBER
53 ,subject_year NUMBER
54 ,effective_date DATE
55 ,payroll_arch NUMBER
56 ,sort_order VARCHAR2(50)
57 );
58 --
59 gr_parameters parameters;
60 --
61 g_msg_circle fnd_new_messages.message_text%TYPE;
62 --
63 g_mag_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
64 --
65 TYPE XMLRec IS RECORD (xmlstring CLOB);
66 --
67 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
68 --
69 vXMLTable tXMLTable;
70 --
71 level_cnt NUMBER;
72 -- *********************
73 -- Cursors Declaration *
74 -- *********************
75 --
76 CURSOR c_header
77 IS
78 SELECT 1
79 FROM dual ;
80 --
81 CURSOR c_footer
82 IS
83 SELECT 1
84 FROM dual ;
85 --
86 CURSOR eof
87 IS
88 SELECT 1
89 FROM dual ;
90 --
91 CURSOR c_body
92 IS
93 SELECT 'TRANSFER_ACT_ID=P'
94 , assignment_action_id
95 FROM pay_assignment_actions
96 WHERE payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
97 ORDER BY action_sequence;
98
99 -- ************************
100 -- Procedures Declaration *
101 -- ************************
102 --
103
104 PROCEDURE gen_xml_header;
105 --
106 PROCEDURE gen_xml_footer;
107 --
108 PROCEDURE generate_xml;
109 --
110 PROCEDURE range_cursor ( P_PAYROLL_ACTION_ID IN NUMBER
111 , P_SQLSTR OUT NOCOPY VARCHAR2
112 );
113 --
114 PROCEDURE get_numbers ( p_input IN NUMBER
115 , p_input1 IN VARCHAR2
116 , p_output OUT NOCOPY VARCHAR2
117 );
118 --
119 PROCEDURE action_creation ( P_PAYROLL_ACTION_ID NUMBER
120 , P_START_PERSON_ID NUMBER
121 , P_END_PERSON_ID NUMBER
122 , P_CHUNK NUMBER
123 );
124 --
125 PROCEDURE init_code ( P_PAYROLL_ACTION_ID IN NUMBER) ;
126 --
127 PROCEDURE archive_code ( P_ASSIGNMENT_ACTION_ID IN NUMBER
128 , P_EFFECTIVE_DATE IN DATE );
129 --
130 PROCEDURE assact_xml ( p_assignment_action_id IN NUMBER );
131
132 --
133 PROCEDURE deinitialise ( p_payroll_action_id IN NUMBER);
134 --
135 PROCEDURE get_cp_xml ( p_assignment_action_id IN NUMBER
136 , p_xml OUT NOCOPY CLOB
137 );
138 --
139 PROCEDURE writetoclob ( p_write_xml OUT NOCOPY CLOB );
140 --
141 PROCEDURE print_clob ( p_clob IN CLOB );
142 --
143 --
144 PROCEDURE sort_action ( p_payroll_action_id IN NUMBER
145 , sqlstr IN OUT NOCOPY VARCHAR2
146 , len OUT NOCOPY NUMBER);
147
148 --
149 END PAY_JP_UITE_REPORT_PKG;