1 PACKAGE PAYRPENP AUTHID CURRENT_USER AS
2 /* $Header: payrpenp.pkh 115.1 2004/01/21 03:30:12 saurgupt noship $ */
3 --
4 --
5 /*===========================================================================+
6 | Copyright (c) 1993 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +============================================================================
10 Name
11 PAYRPENP
12 Purpose
13 Supports the report PAYRPENP.rdf, Employee Assignments Not Processed.
14 Notes
15
16 History
17 Date Name Vers Bug Description
18 ----------- ---------- ------ -------- -------------------------
19 04-SEP-2000 H.Maclean 40.2 Created Package
20 21-JAN-2004 saurgupt 115.1 3372714 Modify to make the package
21 gscc compliant.
22 ============================================================================*/
23
24 -----------------------------------------------------------------------------
25 -- Name --
26 -- get_gre_name --
27 -- Purpose --
28 -- This function returns the name of the government reporting entity --
29 -- associated with the soft_coding_keyflex_id. If this is null, the --
30 -- function returns ' ', avoiding the need for an outer join to handle --
31 -- non-US business groups. --
32 -----------------------------------------------------------------------------
33 --
34 FUNCTION get_gre_name( p_soft_coding_keyflex_id IN NUMBER )
35 RETURN VARCHAR2;
36
37 -----------------------------------------------------------------------------
38 -- Name --
39 -- get_gre_id --
40 -- Purpose --
41 -- This function returns the id of the government reporting entity --
42 -- associated with the soft_coding_keyflex_id. If this is null, the --
43 -- function returns NULL, avoiding the need for an outer join to handle --
44 -- non-US business groups. --
45 -- --
46 -----------------------------------------------------------------------------
47
48 FUNCTION get_gre_id( p_soft_coding_keyflex_id IN NUMBER )
49 RETURN NUMBER;
50
51 -----------------------------------------------------------------------------
52 -- Name --
53 -- get_location_code --
54 -- Purpose --
55 -- This function returns the location code associated with the --
56 -- location_id. If this is null, the function returns ' ', avoiding --
57 -- the need for an outer join to handle non-US business groups in which --
58 -- the location is not a mandatory field. --
59 -- --
60 -----------------------------------------------------------------------------
61
62
63 FUNCTION get_location_code( p_location_id IN NUMBER )
64 RETURN VARCHAR2;
65
66 -----------------------------------------------------------------------------
67 -- Name --
68 -- missing_assignment_action --
69 -- Purpose --
70 -- This function identifies those assignments which do not have --
71 -- completed assignment actions in a given payroll period. --
72 -- --
73 -----------------------------------------------------------------------------
74
75 FUNCTION missing_assignment_action( p_assignment_id IN NUMBER,
76 p_time_period_id IN NUMBER )
77 RETURN VARCHAR2;
78
79 END PAYRPENP;