1 PACKAGE pay_ca_yepp_miss_assign_pkg AUTHID CURRENT_USER AS
2 /* $Header: pycayema.pkh 120.0 2005/05/29 03:56 appldev 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 Name : pay_ca_yepp_miss_assign_pkg
20
21 Description : Package header for Year End Archive Missing
22 Assignments Report
23 Change List
24 -----------
25 Date Name Vers Bug No Description
26 ---- ---- ------ ------- -----------
27 08-OCT-2004 ssouresr 115.0 3562508 Created.
28 */
29
30 /**********************************************************************
31 Function to display the Titles of the columns of the employee details
32 **********************************************************************/
33 FUNCTION formated_header_string(p_output_file_type in varchar2)
34 RETURN varchar2;
35
36 /**********************************************************************
37 Function to display the Titles of the columns of the employee details
38 **********************************************************************/
39 FUNCTION formated_header_string_rl(p_output_file_type in varchar2)
40 RETURN varchar2;
41
42 /***************************************************************
43 Function to display the details of the selected employee
44 ***************************************************************/
45 FUNCTION formated_detail_string(p_output_file_type in varchar2
46 ,p_year varchar2
47 ,p_gre varchar2
48 ,p_employee_name varchar2
49 ,p_employee_sin varchar2
50 ,p_employee_number varchar2)
51 RETURN varchar2;
52
53 /***************************************************************
54 Function to display the details of the selected employee
55 ***************************************************************/
56 FUNCTION formated_detail_string_rl(p_output_file_type in varchar2
57 ,p_year varchar2
58 ,p_pre varchar2
59 ,p_employee_name varchar2
60 ,p_employee_sin varchar2
61 ,p_employee_number varchar2)
62 RETURN varchar2;
63
64
65 /**************************************************************************
66 Procedure to display message if no employees are selected
67 *************************************************************************/
68
69 PROCEDURE formated_zero_count(output_file_type varchar2);
70
71 /**************************************************************************
72 Procedure to display the name of the assignment set to which the selected
73 assignments are added
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 The procedure called from the concurrent program.
83 Name: select_employee
84 Description: The input parameters for the procedure are
85 Date,GRE/PRE,Assignment Set and output file type from
86 the concurrent program. The procedure identifies the
87 missing assignments , adds them to the assignment
88 set entered and generates the report in the specified
89 format.
90 *****************************************************/
91 PROCEDURE select_employee(errbuf out nocopy varchar2,
92 retcode out nocopy number,
93 p_effective_date in varchar2,
94 p_bus_grp in number,
95 p_report_type in varchar2,
96 p_dummy1 in varchar2,
97 p_gre_id in number,
98 p_dummy2 in varchar2,
99 p_pre_id in number,
100 p_assign_set in varchar2,
101 p_output_file_type in varchar2);
102
103 /*********************************************************
104 The Function returns the value of the parameter been
105 passed from the Legislative parameter list.
106 ********************************************************/
107 FUNCTION get_parameter(name in varchar2,
108 parameter_list varchar2)
109 return varchar2;
110
111 pragma restrict_references(get_parameter, WNDS, WNPS);
112
113 END pay_ca_yepp_miss_assign_pkg;
[Home] [Help]