1 PACKAGE pay_ca_yepp_add_actions_pkg AUTHID CURRENT_USER AS
2 /* $Header: pycayeaa.pkh 120.0.12010000.1 2008/07/27 22:19:08 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_ca_yepp_add_actions_pkg
21
22 Description : Package used to report the Employees which are not
23 picked up by the Year End Process and mark them for
24 retry.
25
26
27 Change List
28 -----------
29 Date Name Vers Bug No Description
30 ----------- ---------- ------ ------- --------------------------
31 18-Oct-2004 ssouresr 115.0 Created.
32
33 ********************************************************************/
34
35
36 /********************************************************************
37 Declare PL SQL Tables to store Processed/Eligible/Not Eligible
38 Assignments from the assignment set.
39 ********************************************************************/
40
41 TYPE yepp_assigments_rec IS RECORD
42 (c_assignment_id per_all_assignments_f.assignment_id%TYPE);
43
44 TYPE yepp_assigments_table IS TABLE OF yepp_assigments_rec INDEX BY BINARY_INTEGER;
45
46 l_yepp_prc_asg_table yepp_assigments_table; -- Processed Assignments
47 l_yepp_elgble_asg_table yepp_assigments_table; -- Eligible Assignments
48 l_yepp_not_elgble_asg_table yepp_assigments_table; -- Not Eligible Assignments
49
50 l_all_reported_asg_table yepp_assigments_table; -- All reported assignments
51
52
53 /********************************************************************
54 Function to display the Titles of the columns of the employee details
55 ********************************************************************/
56
57 FUNCTION formated_header_string(p_report_type in varchar2,
58 p_output_file_type in varchar2)
59 RETURN varchar2;
60
61
62 /*******************************************************************
63 Function to display the details of the selected employee
64 ********************************************************************/
65
66 FUNCTION formated_detail_string(p_output_file_type in varchar2
67 ,p_year in varchar2
68 ,p_gre_name in varchar2
69 ,p_pre_name in varchar2
70 ,p_employee_name in varchar2
71 ,p_employee_sin in varchar2
72 ,p_employee_number in varchar2
73 ,p_report_type in varchar2)
74 RETURN varchar2;
75
76
77 /********************************************************************
78 Procedure to display message if no employees are selected
79 ********************************************************************/
80
81 PROCEDURE formated_zero_count(output_file_type in varchar2,
82 p_flag in varchar2);
83
84
85 /********************************************************************
86 The procedure called from the concurrent program.
87 Name: add_actions_to_yepp
88 ********************************************************************/
89
90 PROCEDURE add_actions_to_yepp(errbuf out nocopy varchar2,
91 retcode out nocopy number,
92 p_effective_date in varchar2,
93 p_bus_grp in number,
94 p_report_type in varchar2,
95 p_dummy1 in varchar2,
96 p_gre_id in number,
97 p_dummy2 in varchar2,
98 p_pre_id in number,
99 p_assign_set in varchar2,
100 p_output_file_type in varchar2);
101
102 /*********************************************************
103 The Function returns the value of the parameter been
104 passed from the legislative parameter list.
105 ********************************************************/
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
114 END pay_ca_yepp_add_actions_pkg;