1 PACKAGE pay_us_mark_w2c_paper AS
2 /* $Header: payusmarkw2cpapr.pkh 120.0.12010000.1 2008/07/27 21:55:59 appldev ship $*/
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
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
20 Name : pay_us_mark_w2c_paper
21 File Name : payusmarkw2cpapr.pkh
22
23 Description : Mark all assignment action included in W-2c Report process
24 confirming W-2c paper submitted to Govt. Once a corrected
25 assignment is marked as submitted, this assignment will not
26 be picked up by "Federeal W-2c Magnetic Media" process.
27
28 Uses :
29
30 Change List
31 -----------
32 Date Name Vers Bug No Description
33 ---- ---- ------ ------- -----------
34 10-Oct-2003 ppanda 115.0 Created.
35 02-DEC-2003 ppanda 115.1 3275044 A fatal error will be raised
36 when no W-2c paper assignment action
37 picked up by the process
38 10-NOV-2004 asasthan 115.2 3264740 Detail Report provided.
39 *******************************************************************/
40
41 /*******************************************************************
42 ** Function gets the W-2c Mag Report Action Parameters
43 ******************************************************************/
44
45 PROCEDURE get_payroll_action_info
46 (
47 p_payroll_action_id in number,
48 p_start_date in out nocopy date,
49 p_end_date in out nocopy date,
50 p_report_type in out nocopy varchar2,
51 p_report_qualifier in out nocopy varchar2,
52 p_business_group_id in out nocopy number,
53 p_seq_num in out nocopy number
54 );
55
56 FUNCTION preprocess_check (p_payroll_action_id IN NUMBER,
57 p_start_date IN DATE,
58 p_end_date IN DATE,
59 p_business_group_id IN NUMBER
60 ) RETURN BOOLEAN;
61
62
63 /*******************************************************************
64 ** Range Code to pick all the distinct assignment_ids
65 ** that need to be marked as submitted to governement.
66 *******************************************************************/
67 PROCEDURE mark_w2c_range_cursor( p_payroll_action_id in number
68 ,p_sqlstr out nocopy varchar2);
69
70 /*******************************************************************
71 ** Action Creation Code to create assignment actions for all the
72 ** the assignment_ids that need to be marked as submitted to governement
73 *******************************************************************/
74 PROCEDURE mark_w2c_action_creation( p_payroll_action_id in number
75 ,p_start_person_id in number
76 ,p_end_person_id in number
77 ,p_chunk in number);
78
79 PROCEDURE select_ee_details(errbuf OUT nocopy VARCHAR2,
80 retcode OUT nocopy NUMBER,
81 p_seq_num IN VARCHAR2,
82 p_output_file_type IN VARCHAR2);
83
84 END pay_us_mark_w2c_paper;