1 PACKAGE PAY_MX_TRR_PKG AUTHID CURRENT_USER AS
2 /* $Header: pymxtrr.pkh 120.2.12010000.1 2008/07/27 23:10:28 appldev ship $ */
3 --
4 /*
5 /*
6 ******************************************************************
7 * *
8 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
9 * Chertsey, England. *
10 * *
11 * All rights reserved. *
12 * *
13 * This material has been provided pursuant to an agreement *
14 * containing restrictions on its use. The material is also *
15 * protected by copyright law. No part of this material may *
16 * be copied or distributed, transmitted or transcribed, IN *
17 * any form or by any means, electronic, mechanical, magnetic, *
18 * manual, or otherwise, or disclosed to third parties without *
19 * the express written permission of Oracle Corporation UK Ltd, *
20 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
21 * England. *
22 * *
23 ******************************************************************
24
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ----------- ---------- ----- ------- -----------------------------------
29 01-DEC-2004 ssmukher 115.0 Created.
30 18-APR-2005 kthirmiy 115.1 Increased tag_value to 80 chars
31 06-FEB-2006 vmehta 115.2 Added parameters to
32 fetch_active_assg_act.
33 29-Mar-2006 vmehta 115.3 Removed function:
34 fetch_active_assg_act, as it is
35 used locally in pkb.
36 */
37 --
38 TYPE xml_rec IS RECORD ( tag_name VARCHAR2(50)
39 ,tag_value VARCHAR2(80)
40 ,tag_type CHAR(1));
41
42 TYPE xml_data IS TABLE OF xml_rec
43 INDEX BY BINARY_INTEGER;
44
45 l_counter NUMBER;
46
47 FUNCTION fetch_define_bal (p_bal_name IN VARCHAR2
48 ,p_data_suffix IN VARCHAR2)
49 RETURN NUMBER;
50
51 PROCEDURE populate_plsql_table
52 ( p_start_date_earned IN DATE,
53 p_end_date_earned IN DATE,
54 p_legal_employer_id IN NUMBER,
55 p_state_code IN VARCHAR2,
56 p_gre_id IN NUMBER,
57 p_show_isr IN VARCHAR2,
58 p_show_soc_security IN VARCHAR2,
59 p_show_state IN VARCHAR2,
60 p_dimension IN VARCHAR2,
61 p_business_group_id IN NUMBER,
62 p_xml_data IN OUT NOCOPY XML_DATA ) ;
63
64
65 PROCEDURE trr_report_wrapper
66 (errbuf OUT NOCOPY VARCHAR2,
67 retcode OUT NOCOPY NUMBER,
68 p_business_group_id IN NUMBER,
69 p_start_date_earned IN VARCHAR2,
70 p_end_date_earned IN VARCHAR2,
71 p_legal_employer_id IN NUMBER,
72 p_state_code IN VARCHAR2,
73 p_gre_id IN NUMBER,
74 p_show_isr IN VARCHAR2,
75 p_show_soc_security IN VARCHAR2,
76 p_show_state IN VARCHAR2,
77 p_dimension IN VARCHAR2,
78 p_template IN VARCHAR2,
79 p_template_locale IN VARCHAR2,
80 p_session_date IN VARCHAR2);
81
82 procedure populate_trr_Report
83 (errbuf OUT NOCOPY VARCHAR2,
84 retcode OUT NOCOPY NUMBER,
85 p_business_group_id IN NUMBER,
86 p_start_date_earned IN VARCHAR2,
87 p_end_date_earned IN VARCHAR2,
88 p_legal_employer_id IN NUMBER,
89 p_state_code IN VARCHAR2,
90 p_gre_id IN NUMBER,
91 p_show_isr IN VARCHAR2,
92 p_show_soc_security IN VARCHAR2,
93 p_show_state IN VARCHAR2,
94 p_dimension IN VARCHAR2,
95 p_session_date IN VARCHAR2);
96
97
98 END PAY_MX_TRR_PKG;