1 PACKAGE pay_us_yepp_add_actions_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyusyeaa.pkh 120.0.12000000.1 2007/01/18 03:14:51 appldev noship $ */
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_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. It is used by the concurrent request -
25 'Add Assignment Actions To The Year End Pre-Process'
26
27
28 Change List
29 -----------
30 Date Name Vers Bug No Description
31 ----------- ---------- ------ ------- --------------------------
32 01-Sep-2003 kaverma 115.0 2222748 Created.
33 03-Sep-2003 kaverma 115.1 2222748 Removed extra lines from the
34 package
35
36
37 ********************************************************************/
38
39
40 /********************************************************************
41 Declare PL SQL Tables to strore Processed/Eligible/Not Eligible
42 Assignments from the assignment set.
43 ********************************************************************/
44
45 TYPE yepp_assigments_rec IS RECORD
46 (c_assignment_id per_all_assignments_f.assignment_id%TYPE);
47
48 TYPE yepp_assigments_table IS TABLE OF yepp_assigments_rec INDEX BY BINARY_INTEGER;
49
50 l_yepp_prc_asg_table yepp_assigments_table; -- Processed Assignments
51 l_yepp_elgble_asg_table yepp_assigments_table; -- Eligible Assignments
52 l_yepp_not_elgble_asg_table yepp_assigments_table; -- Not Eligible Assignments
53
54 l_gre_reported_asg_table yepp_assigments_table; -- All reported assignments
55 -- in the GRE
56
57
58
59 /********************************************************************
60 Function to display the Titles of the columns of the employee details
61 ********************************************************************/
62
63 FUNCTION formated_header_string(p_output_file_type in varchar2)
64 RETURN varchar2;
65
66
67 /*******************************************************************
68 Function to display the details of the selected employee
69 ********************************************************************/
70
71 FUNCTION formated_detail_string(p_output_file_type in varchar2
72 ,p_year in varchar2
73 ,p_gre in varchar2
74 ,p_Employee_name in varchar2
75 ,p_employee_ssn in varchar2
76 ,p_emplyee_number in varchar2)
77 RETURN varchar2;
78
79
80 /********************************************************************
81 Procedure to display message if no employees are selected
82 ********************************************************************/
83
84 PROCEDURE formated_zero_count(output_file_type in varchar2,
85 p_flag in varchar2);
86
87
88
89 /********************************************************************
90 The procedure called from the concurrent program.
91 Name: add_actions_to_yepp
92
93 Description: The input parameters for the procedure are Date,GRE_ID,
94 Assignment Set and output file type fromthe concurrent
95 program. The procedure identifies the eligible/processed
96 /not eligible and secondary assignments from the
97 Assignment set and report them as the output in the
98 specified format.
99
100 ********************************************************************/
101
102 PROCEDURE add_actions_to_yepp(errbuf out nocopy varchar2,
103 retcode out nocopy number,
104 p_effective_date in varchar2,
105 p_gre_id in number,
106 p_assign_set in number,
107 p_output_file_type in varchar2);
108
109 END pay_us_yepp_add_actions_pkg ;