1 PACKAGE pay_yepp_miss_assign_pkg as
2 /* $Header: pyyeppma.pkh 120.2 2007/01/19 13:59:17 ydevi noship $ */
3
4 /******************************************************************************
5
6 ******************************************************************
7 * *
8 * Copyright (C) 1996 Oracle Corporation. *
9 * All rights reserved. *
10 * *
11 * This material has been provided pursuant to an agreement *
12 * containing restrictions on its use. The material is also *
13 * protected by copyright law. No part of this material may *
14 * be copied or distributed, transmitted or transcribed, in *
15 * any form or by any means, electronic, mechanical, magnetic, *
16 * manual, or otherwise, or disclosed to third parties without *
17 * the express written permission of Oracle Corporation, *
18 * 500 Oracle Parkway, Redwood City, CA, 94065. *
19 * *
20 ******************************************************************
21
22 Name : pay_yepp_miss_assign_pkg
23
24 Description : Packge header for Year End Archive Missing Assignments Report
25
26 Change List
27 -----------
28 Date Name Vers Bug No Description
29 ----------- ---------- ------- ------- ------------------------------
30 25-Oct-2005 rdhingra 115.0 4674183 Code transferred from
31 pyusyema.pkh. Call to
32 PROCEDURE formated_element_row
33 modified
34 22-dec-2005 rdhingra 115.1 4779018 Updated Function
35 formated_header_string. Added
36 extra input parameter.
37 19-JAN-2007 ydevi 115.2 4886285 adding p_pre_or_gre in the
38 definition of
39 formated_header_string
40 ******************************************************************************/
41
42 /**********************************************************************
43 Function to display the Titles of the columns of the employee details
44 **********************************************************************/
45
46 FUNCTION formated_header_string(
47 p_legislation_code IN VARCHAR2
48 ,p_output_file_type IN VARCHAR2
49 ,p_pre_or_gre IN varchar2 default null
50 )RETURN VARCHAR2;
51
52 /***************************************************************
53 Function to display the details of the selected employee
54 ***************************************************************/
55
56 FUNCTION formated_detail_string(
57 p_output_file_type in varchar2
58 ,p_year varchar2
59 ,p_gre varchar2
60 ,p_Employee_name varchar2
61 ,p_employee_ssn varchar2
62 ,p_emplyee_number varchar2
63
64 ) RETURN varchar2;
65
66
67 /**************************************************************************
68 Procedure to display message if no employees are selected
69 *************************************************************************/
70
71 PROCEDURE formated_zero_count(output_file_type varchar2);
72
73 /**************************************************************************
74 Procedure to display the name of the assignment set to which the selected
75 assignments are added
76 ***************************************************************************/
77
78 PROCEDURE formated_assign_count(assignment_set_name in varchar2,
79 assignment_set_id in number,
80 record_count in number,
81 assign_set_created in number,
82 output_file_type in varchar2);
83
84 /**************************************************************************
85 Procedure to display the Elements having input values of type Money
86 and not feeding the YE Balances
87 ************************************************************************/
88
89 PROCEDURE formated_element_header(
90 p_output_file_type in VARCHAR2
91 ,p_static_label out nocopy VARCHAR2
92 );
93
94 /************************************************************
95 ** Procedure: formated_element_row
96 ** Returns : Formatted Element Row
97 ************************************************************/
98
99 PROCEDURE formated_element_row (
100 p_element_name in varchar2
101 ,p_classification in varchar2
102 -- ,p_input_value_name in VARCHAR2
103 ,p_output_file_type in VARCHAR2
104 ,p_static_data out nocopy VARCHAR2
105 );
106
107
108 /* ******************************************************
109 The procedure called from the concurrent program.
110 Name: select_employee
111 Description: The input parameters for the procedure are
112 Date,GRE_ID,Assignment Set and output file type from
113 the concurrent program. The procedure identifies the
114 missing assignments , adds them to the assignment
115 set entered and generates the report in the specified
116 format.
117 *****************************************************/
118
119 PROCEDURE select_employee(p_payroll_action_id IN NUMBER,
120 p_effective_date IN VARCHAR2,
121 p_tax_unit_id IN NUMBER,
122 p_session_id in NUMBER);
123
124 END pay_yepp_miss_assign_pkg;