1 PACKAGE per_za_utility_pkg AS
2 /* $Header: pezautly.pkh 120.1 2005/08/05 19:22:58 nragavar noship $ */
3 /* Copyright (c) Oracle Corporation 2002. All rights reserved. */
4 /*
5 PRODUCT
6 Oracle Human Resources - ZA Utility Package
7 NAME
8 pezautly.pkh
9
10 DESCRIPTION
11 .
12
13 PUBLIC FUNCTIONS
14 per_za_table_meaning
15 This function returns the value from a specific user_table
16 References
17 PER_ZA_LEARNERSHIP_AGREEMENT_V
18
19 PUBLIC PROCEDURES
20 maintain_ipv_links
21 This procedure checks for any seeded input value that has been
22 linked on element level, but for which no input value link exists
23 It will then create the link based on the element link's values and
24 also create a dummy element entry value if an element entry is found
25 The procedure is called from perlegza.sql during the legislative
26 install process
27
28
29 PRIVATE FUNCTIONS
30 <none>
31 NOTES
32 .
33
34 MODIFICATION HISTORY
35 Person Date Version Bug Comments
36 ------------- ----------- ------- ------- -------------------------------
37 Nageswara 24/06/2005 115.4 4346970 Modified procedure insert_ee_value
38 to public for migration scripts
39 Added new procedure insert_rr_value
40 J.N. Louw 06/11/2002 115.3 2224332 Added maintain_ipv_links
41 L.Kloppers 16/10/2002 115.2 Added za_term_cat_update
42 L.Kloppers 02/05/2002 115.1 2266156 Added overloaded version of
43 FUNCTION get_table_value
44 J.N. Louw 25/04/2002 115.0 2266156 New version of the package
45 For previous history see
46 pezatbme.pkh
47 */
48 -------------------------------------------------------------------------------
49 -- ZA_TERM_CAT_UPDATE
50 -------------------------------------------------------------------------------
51 PROCEDURE za_term_cat_update (
52 p_existing_leaving_reason IN hr_lookups.lookup_code%TYPE
53 , p_seeded_leaving_reason IN hr_lookups.lookup_code%TYPE
54 );
55
56 ----------------------------------------------------------------------------
57 -- PER_ZA_TABLE_MEANING
58 ----------------------------------------------------------------------------
59 FUNCTION per_za_table_meaning (
60 p_table_name in varchar2
61 , p_column in varchar2
62 , p_value in varchar2
63 , p_business_group_id in number
64 , p_effective_date in date default null
65 ) RETURN varchar2;
66
67 ----------------------------------------------------------------------------
68 -- CHK_ENTRY_IN_LOOKUP
69 ----------------------------------------------------------------------------
70 FUNCTION chk_entry_in_lookup (
71 p_lookup_type IN hr_leg_lookups.lookup_type%TYPE
72 , p_entry_val IN hr_leg_lookups.meaning%TYPE
73 , p_effective_date IN hr_leg_lookups.start_date_active%TYPE
74 , p_message OUT NOCOPY VARCHAR2
75 ) RETURN VARCHAR2;
76
77 ----------------------------------------------------------------------------
78 -- GET_TABLE_VALUE
79 ----------------------------------------------------------------------------
80 FUNCTION get_table_value (
81 p_table_name IN VARCHAR2
82 , p_col_name IN VARCHAR2
83 , p_row_value IN VARCHAR2
84 , p_effective_date IN DATE DEFAULT NULL
85 ) RETURN VARCHAR2;
86
87 ----------------------------------------------------------------------------
88 -- GET_TABLE_VALUE Overloaded version to select for a Business Group
89 ----------------------------------------------------------------------------
90 FUNCTION get_table_value (
91 p_table_name IN VARCHAR2
92 , p_col_name IN VARCHAR2
93 , p_row_value IN VARCHAR2
94 , p_effective_date IN DATE DEFAULT NULL
95 , p_business_group_id IN VARCHAR2
96 ) RETURN VARCHAR2;
97
98 ----------------------------------------------------------------------------
99 -- MAINTAIN_IPV_LINKS
100 ----------------------------------------------------------------------------
101 PROCEDURE maintain_ipv_links;
102
103 ----------------------------------------------------------------------------
104 -- INSERT_EE_VALUE
105 -- Update the procedure to public as a part of migration scripts for
106 -- Context Balances functionality
107 ----------------------------------------------------------------------------
108 PROCEDURE insert_ee_value (
109 p_effective_start_date IN pay_element_entry_values_f.effective_start_date%TYPE
110 , p_effective_end_date IN pay_element_entry_values_f.effective_end_date%TYPE
111 , p_input_value_id IN pay_element_entry_values_f.input_value_id%TYPE
112 , p_element_entry_id IN pay_element_entry_values_f.element_entry_id%TYPE
113 , p_screen_entry_value IN pay_element_entry_values_f.screen_entry_value%TYPE
114 );
115
116 ----------------------------------------------------------------------------
117 -- Procedure inserts input value for a perticular run result and input value
118 ----------------------------------------------------------------------------
119
120 PROCEDURE insert_rr_value (
121 p_input_value_id IN pay_input_values_f.input_value_id%TYPE
122 ,p_run_result_id IN pay_run_results.run_result_id%TYPE
123 ,p_result_value IN pay_run_result_values.result_value%TYPE
124 );
125
126 PRAGMA RESTRICT_REFERENCES (per_za_table_meaning, WNDS);
127 ----------------------------------------------------------------------------
128 END per_za_utility_pkg;
129 ----------------------------------------------------------------------------