[Home] [Help]
PACKAGE: APPS.PAY_INPUT_VALUES_PKG
Source
1 package PAY_INPUT_VALUES_PKG AUTHID CURRENT_USER as
2 /* $Header: pyipv.pkh 120.0.12010000.1 2008/07/27 22:56:18 appldev ship $ */
3
4 --------------------------------------------------------------------------------
5 procedure validate_translation (input_value_id IN number,
6 language IN varchar2,
7 input_name IN varchar2);
8 --------------------------------------------------------------------------------
9 PROCEDURE set_translation_globals(p_element_type_id IN number);
10 --------------------------------------------------------------------------------
11 function NO_DEFAULT_AT_LINK (
12 --
13 p_input_value_id number,
14 p_effective_start_date date,
15 p_effective_end_date date,
16 p_error_if_true boolean := FALSE) return boolean;
17 --------------------------------------------------------------------------------
18 function ELEMENT_ENTRY_NEEDS_DEFAULT (
19 --
20 p_input_value_id number,
21 p_effective_start_date date,
22 p_effective_end_date date,
23 p_error_if_true boolean := FALSE ) return boolean ;
24 --------------------------------------------------------------------------------
25 procedure RECREATE_DB_ITEMS (
26 --
27 p_element_type_id number);
28 --------------------------------------------------------------------------------
29 procedure PARENT_DELETED (
30 --
31 p_element_type_id number,
32 p_session_date date default trunc(sysdate),
33 p_validation_start_date date,
34 p_validation_end_date date,
35 p_delete_mode varchar2 default 'DELETE');
36 -------------------------------------------------------------------------------
37 function CANT_DELETE_ALL_INPUT_VALUES (
38 --
39 p_element_type_id number,
40 p_delete_mode varchar2,
41 p_validation_start_date date,
42 p_validation_end_date date,
43 p_error_if_true boolean default FALSE) return boolean ;
44 --------------------------------------------------------------------------------
45 function DELETION_ALLOWED (
46 --
47 p_input_value_id number,
48 p_delete_mode varchar2,
49 p_validation_start_date date,
50 p_validation_end_date date,
51 p_error_if_true boolean default FALSE) return boolean ;
52 -----------------------------------------------------------------------------
53 function NO_OF_INPUT_VALUES (p_element_type_id number) return number;
54 --------------------------------------------------------------------------------
55 function DATE_EFFECTIVELY_UPDATED (
56 --
57 p_input_value_id number,
58 p_rowid varchar2) return boolean;
59 --------------------------------------------------------------------------------
60 function NAME_NOT_UNIQUE (
61 --
62 p_element_type_id number,
63 p_rowid varchar2 default null,
64 p_name varchar2,
65 p_error_if_true boolean default FALSE) return boolean;
66 --------------------------------------------------------------------------------
67 function MANDATORY_IN_FUTURE (
68 --
69 p_input_value_id number,
70 p_session_date date default trunc(sysdate),
71 p_error_if_true boolean default FALSE ) return boolean;
72 --------------------------------------------------------------------------------
73 procedure INSERT_ROW (
74 --
75 p_effective_start_date date default trunc (sysdate),
76 p_effective_end_date date default to_date ('31/12/4712',
77 'DD/MM/YYYY'),
78 p_element_type_id number,
79 p_lookup_type varchar2 default null,
80 p_business_group_id number default null,
81 p_legislation_code varchar2 default null,
82 p_formula_id number default null,
83 p_display_sequence number default 1,
84 p_generate_db_items_flag varchar2 default 'Y',
85 p_hot_default_flag varchar2 default 'N',
86 p_mandatory_flag varchar2 default 'N',
87
88 -- change 115.7 - make p_name default to null
89 --p_name varchar2 default 'Pay Value',
90 p_name varchar2 default null,
91 -- change 115.7 - make p_base_name a mandatory parameter
92 --p_base_name varchar2 default 'Pay Value',
93 p_base_name varchar2,
94
95 p_uom varchar2 default 'M',
96 p_default_value varchar2 default null,
97 p_legislation_subgroup varchar2 default null,
98 p_max_value varchar2 default null,
99 p_min_value varchar2 default null,
100 p_warning_or_error varchar2 default null,
101 p_classification_id number default null,
102 -- Enhancement 2793978
103 p_value_set_id number default null,
104 --
105 p_input_value_id in out nocopy number,
106 p_rowid in out nocopy varchar2);
107 ---------------------------------------------------------------------------
108 procedure UPDATE_ROW(
109 --
110 p_ROWID VARCHAR2,
111 p_INPUT_VALUE_ID NUMBER,
112 p_EFFECTIVE_START_DATE DATE,
113 p_EFFECTIVE_END_DATE DATE,
114 p_ELEMENT_TYPE_ID NUMBER,
115 p_LOOKUP_TYPE VARCHAR2,
116 p_BUSINESS_GROUP_ID NUMBER,
117 p_LEGISLATION_CODE VARCHAR2,
118 p_FORMULA_ID NUMBER,
119 p_DISPLAY_SEQUENCE NUMBER,
120 p_GENERATE_DB_ITEMS_FLAG VARCHAR2,
121 p_HOT_DEFAULT_FLAG VARCHAR2,
122 p_MANDATORY_FLAG VARCHAR2,
123 p_NAME VARCHAR2,
124 p_UOM VARCHAR2,
125 p_DEFAULT_VALUE VARCHAR2,
126 p_LEGISLATION_SUBGROUP VARCHAR2,
127 p_MAX_VALUE VARCHAR2,
128 p_MIN_VALUE VARCHAR2,
129 p_WARNING_OR_ERROR VARCHAR2,
130 -- Enhancement 2793978
131 p_value_set_id number default null,
132 --
133 p_recreate_db_items varchar2,
134 p_base_name varchar2);
135 ---------------------------------------------------------------------------
136 procedure DELETE_ROW (
137 --
138 p_rowid varchar2,
139 p_input_value_id number,
140 p_delete_mode varchar2,
141 p_session_date date,
142 p_validation_start_date date default
143 to_date ('01/01/0001','DD/MM/YYYY'),
144 p_validation_end_date date default
145 to_date ('31/12/4712','DD/MM/YYYY'));
146 ---------------------------------------------------------------------------
147 procedure LOCK_ROW (
148 p_rowid VARCHAR2,
149 p_INPUT_VALUE_ID NUMBER,
150 p_EFFECTIVE_START_DATE DATE,
151 p_EFFECTIVE_END_DATE DATE,
152 p_ELEMENT_TYPE_ID NUMBER,
153 p_LOOKUP_TYPE VARCHAR2,
154 p_BUSINESS_GROUP_ID NUMBER,
155 p_LEGISLATION_CODE VARCHAR2,
156 p_FORMULA_ID NUMBER,
157 p_DISPLAY_SEQUENCE NUMBER,
158 p_GENERATE_DB_ITEMS_FLAG VARCHAR2,
159 p_HOT_DEFAULT_FLAG VARCHAR2,
160 p_MANDATORY_FLAG VARCHAR2,
161 --p_NAME VARCHAR2,
162 -- --
163 p_BASE_NAME VARCHAR2,
164 -- --
165 p_UOM VARCHAR2,
166 p_DEFAULT_VALUE VARCHAR2,
167 p_LEGISLATION_SUBGROUP VARCHAR2,
168 p_MAX_VALUE VARCHAR2,
169 p_MIN_VALUE VARCHAR2,
170 p_WARNING_OR_ERROR VARCHAR2,
171 -- Enhancement 2793978
172 p_value_set_id NUMBER default null
173 --
174 );
175 -----------------------------------------------------------
176 procedure ADD_LANGUAGE;
177 -----------------------------------------------------------
178 procedure TRANSLATE_ROW (
179 X_I_NAME in varchar2,
180 X_I_LEGISLATION_CODE in varchar2,
181 X_I_EFFECTIVE_START_DATE in date,
182 X_I_EFFECTIVE_END_DATE in date,
183 X_I_E_ELEMENT_NAME in varchar2,
184 X_I_E_LEGISLATION_CODE in varchar2,
185 X_I_E_EFFECTIVE_START_DATE in date,
186 X_I_E_EFFECTIVE_END_DATE in date,
187 X_NAME in varchar2,
188 X_OWNER in varchar2
189 );
190 -----------------------------------------------------------
191 -- Enhancement 2793978
192 function decode_vset_value (
193 p_value_set_id in number,
194 p_value_set_value in varchar2
195 ) return varchar2;
196 -----------------------------------------------------------
197 -- Enhancement 2793978
198 function decode_vset_meaning (
199 p_value_set_id in number,
200 p_value_set_meaning in varchar2
201 ) return varchar2;
202 -----------------------------------------------------------
203 end PAY_INPUT_VALUES_PKG;