1 PACKAGE pay_us_yepp_miss_assign_pkg as
2 /* $Header: pyusyema.pkh 120.1 2005/08/26 11:45:34 rsethupa noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1996 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_yepp_miss_assign_pkg
21
22 Description : Packge header for Year End Archive Missing Assignments Report
23
24 Change List
25 -----------
26 Date Name Vers Bug No Description
27 ---- ---- ------ ------- -----------
28 25-AUG-2003 rsethupa 115.0 2527077 Created.
29 28-AUG-2003 rsethupa 115.1 2527077 Modified declaration of
30 procedure formated_assign_count
31 to enable check of existing
32 assignment set
33 29-AUG-2003 rsethupa 115.2 2527077 Moved functions formated_header_string
34 and formated_data_string to
35 file pyusutil.pkh.
36 29-AUG-2003 rsethupa 115.3 2527077 Added Comments.
37 25-AUG-2005 rsethupa 115.4 4160436 Rewrite of package for
38 Multithreading of Report
39 */
40
41 /**********************************************************************
42 Function to display the Titles of the columns of the employee details
43 **********************************************************************/
44
45 FUNCTION formated_header_string(
46 p_output_file_type in varchar2
47 )RETURN VARCHAR2;
48
49 /***************************************************************
50 Function to display the details of the selected employee
51 ***************************************************************/
52
53 FUNCTION formated_detail_string(
54 p_output_file_type in varchar2
55 ,p_year varchar2
56 ,p_gre varchar2
57 ,p_Employee_name varchar2
58 ,p_employee_ssn varchar2
59 ,p_emplyee_number varchar2
60
61 ) RETURN varchar2;
62
63
64 /**************************************************************************
65 Procedure to display message if no employees are selected
66 *************************************************************************/
67
68 PROCEDURE formated_zero_count(output_file_type varchar2);
69
70 /**************************************************************************
71 Procedure to display the name of the assignment set to which the selected
72 assignments are added
73 ***************************************************************************/
74
75 PROCEDURE formated_assign_count(assignment_set_name in varchar2,
76 assignment_set_id in number,
77 record_count in number,
78 assign_set_created in number,
79 output_file_type in varchar2);
80
81 /**************************************************************************
82 Procedure to display the Elements having input values of type Money
83 and not feeding the YE Balances
84 ************************************************************************/
85
86 PROCEDURE formated_element_header(
87 p_output_file_type in VARCHAR2
88 ,p_static_label out nocopy VARCHAR2
89 );
90
91 /************************************************************
92 ** Procedure: formated_element_row
93 ** Returns : Formatted Element Row
94 ************************************************************/
95
96 PROCEDURE formated_element_row (
97 p_element_name in varchar2
98 ,p_classification in varchar2
99 ,p_input_value_name in VARCHAR2
100 ,p_output_file_type in VARCHAR2
101 ,p_static_data out nocopy VARCHAR2
102 );
103
104
105 /* ******************************************************
106 The procedure called from the concurrent program.
107 Name: select_employee
108 Description: The input parameters for the procedure are
109 Date,GRE_ID,Assignment Set and output file type from
110 the concurrent program. The procedure identifies the
111 missing assignments , adds them to the assignment
112 set entered and generates the report in the specified
113 format.
114 *****************************************************/
115
116 PROCEDURE select_employee(p_payroll_action_id IN NUMBER,
117 p_effective_date IN VARCHAR2,
118 p_tax_unit_id IN NUMBER,
119 p_session_id in NUMBER);
120
121 END pay_us_yepp_miss_assign_pkg;