1 PACKAGE pay_us_sqwl_gre AUTHID CURRENT_USER AS
2 /* $Header: payussqwlgre.pkh 120.5.12020000.3 2013/01/22 11:24:53 schowl ship $*/
3
4 /*===========================================================================+
5 | Copyright (c) 2001 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +============================================================================+
9
10 Name
11 pay_us_mmrf_sqwl_format_record
12
13 Purpose
14 The purpose of this package is to find the eligible
15 GREs for the SQWL and submit the child SQWL Concurrent Program.
16
17 Notes
18 Referenced By: Package pay_us_sqwl_gre
19
20 History
21
22 24-Feb-2011 sjawid 115.0 10649380 Initial Version
23 11-Mar-2011 sjawid 115.1 11742500 Added new parameters to function
24 Process_sqwl
25
26 06-SEP-2012 rmugloo 115.6 9730326 Added new parameter p_fold_output
27 to function process_sqwl
28 22-Jan-2013 schowl 115.7 14456648 Added a new procedure 'process_smwl'
29
30 */
31
32 PROCEDURE process_sqwl (errbuf OUT nocopy VARCHAR2,
33 retcode OUT nocopy NUMBER,
34 p_state IN VARCHAR2,
35 p_quarter IN VARCHAR2,
36 p_effective_date IN VARCHAR2,
37 p_report_option IN VARCHAR2,
38 p_report_option_flag IN VARCHAR2,
39 p_tax_unit_id NUMBER,
40 p_format IN VARCHAR2,
41 p_business_group_id IN NUMBER,
42 p_transmitter_gre IN VARCHAR2,
43 p_Create_Audit_Report_Flag IN VARCHAR2,
44 p_Create_Audit_Report IN VARCHAR2,
45 P_Establishment_Flag IN VARCHAR2,
46 p_Establishment_Hierarchy IN VARCHAR2,
47 p_Hierarchy_Version IN VARCHAR2,
48 p_session_date IN VARCHAR2,
49 p_out_of_state_wage_check_flag IN VARCHAR2,
50 p_out_of_state_wage_check IN VARCHAR2,
51 p_action_parameter_group IN VARCHAR2 ,
52 p_fold_output IN VARCHAR2 );
53
54
55 /* Procedure added for Bug 14456648 */
56 PROCEDURE process_smwl (errbuf OUT nocopy VARCHAR2,
57 retcode OUT nocopy NUMBER,
58 p_state IN VARCHAR2,
59 p_month IN VARCHAR2,
60 p_effective_date IN VARCHAR2,
61 p_report_option IN VARCHAR2,
62 p_report_option_flag IN VARCHAR2,
63 p_tax_unit_id NUMBER,
64 p_format IN VARCHAR2,
65 p_business_group_id IN NUMBER,
66 p_transmitter_gre IN VARCHAR2,
67 p_Create_Audit_Report_Flag IN VARCHAR2,
68 p_Create_Audit_Report IN VARCHAR2,
69 P_Establishment_Flag IN VARCHAR2,
70 p_Establishment_Hierarchy IN VARCHAR2,
71 p_Hierarchy_Version IN VARCHAR2,
72 p_session_date IN VARCHAR2,
73 p_out_of_state_wage_check_flag IN VARCHAR2,
74 p_out_of_state_wage_check IN VARCHAR2,
75 p_action_parameter_group IN VARCHAR2 ,
76 p_fold_output IN VARCHAR2 );
77
78
79
80 PROCEDURE rollback_sqwl(errbuf OUT nocopy VARCHAR2,
81 retcode OUT nocopy NUMBER,
82 p_process_year IN VARCHAR2,
83 p_payroll_action_id IN NUMBER,
84 p_payroll_action_id_hidden IN VARCHAR2
85 ) ;
86
87
88 end pay_us_sqwl_gre;