113: ) is
114: --
115: begin
116: --
117: hr_utility.set_location('hr_entry_display.count_input_values', 1);
118: --
119: -- Need to determine how many input values have been defined for the element.
120: -- This value is used to control a loop which is used to select each input
121: -- value definition in the correct order a row at a time.
179: v_lookup_type varchar2(30);
180: --
181: begin
182: --
183: hr_utility.set_location('hr_entry_display.get_input_value_details', 1);
184: --
185: -- Select the input_value_id of the required input value as specified
186: -- by the ordering criteria.
187: -- The inner sub-query works by selecting the minimum order sequence of
248: NVL(p_input_value_id5,0),
249: NVL(p_input_value_id6,0))));
250: exception
251: when NO_DATA_FOUND then
252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE',
254: 'hr_entry_display.get_input_value_details');
255: hr_utility.set_message_token('STEP','2');
256: hr_utility.raise_error;
249: NVL(p_input_value_id6,0))));
250: exception
251: when NO_DATA_FOUND then
252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE',
254: 'hr_entry_display.get_input_value_details');
255: hr_utility.set_message_token('STEP','2');
256: hr_utility.raise_error;
257: end;
251: when NO_DATA_FOUND then
252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE',
254: 'hr_entry_display.get_input_value_details');
255: hr_utility.set_message_token('STEP','2');
256: hr_utility.raise_error;
257: end;
258: --
259: p_input_value_id := v_select_input_value_id;
252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE',
254: 'hr_entry_display.get_input_value_details');
255: hr_utility.set_message_token('STEP','2');
256: hr_utility.raise_error;
257: end;
258: --
259: p_input_value_id := v_select_input_value_id;
260: p_hot_default_flag := v_hot_default_flag;
265: -- details the entry value can now be selected provided the element entry id
266: -- exists.
267: if p_element_entry_id is not null then
268: --
269: hr_utility.set_location('hr_entry_display.get_input_value_details', 3);
270: begin
271: SELECT HEEV1.SCREEN_ENTRY_VALUE
272: INTO v_database_format_value
273: FROM PAY_ELEMENT_ENTRY_VALUES_F HEEV1
276: AND p_session_date
277: BETWEEN HEEV1.EFFECTIVE_START_DATE AND HEEV1.EFFECTIVE_END_DATE;
278: exception
279: when NO_DATA_FOUND then
280: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE',
282: 'hr_entry_display.get_input_value_details');
283: hr_utility.set_message_token('STEP','3');
284: hr_utility.raise_error;
277: BETWEEN HEEV1.EFFECTIVE_START_DATE AND HEEV1.EFFECTIVE_END_DATE;
278: exception
279: when NO_DATA_FOUND then
280: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE',
282: 'hr_entry_display.get_input_value_details');
283: hr_utility.set_message_token('STEP','3');
284: hr_utility.raise_error;
285: end;
279: when NO_DATA_FOUND then
280: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE',
282: 'hr_entry_display.get_input_value_details');
283: hr_utility.set_message_token('STEP','3');
284: hr_utility.raise_error;
285: end;
286: end if;
287: --
280: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE',
282: 'hr_entry_display.get_input_value_details');
283: hr_utility.set_message_token('STEP','3');
284: hr_utility.raise_error;
285: end;
286: end if;
287: --
288: -- derive default value.
310: elsif v_database_format_value is not null then
311: --
312: if v_lookup_type is not null then
313: --
314: hr_utility.set_location('hr_entry_display.get_input_value_details', 4);
315: begin
316: select h.meaning
317: into v_screen_format_value
318: from hr_lookups h
319: where h.lookup_type = v_lookup_type
320: and h.lookup_code = v_database_format_value;
321: exception
322: when NO_DATA_FOUND then
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE',
325: 'hr_entry_display.get_input_value_details');
326: hr_utility.set_message_token('STEP','4');
327: hr_utility.raise_error;
320: and h.lookup_code = v_database_format_value;
321: exception
322: when NO_DATA_FOUND then
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE',
325: 'hr_entry_display.get_input_value_details');
326: hr_utility.set_message_token('STEP','4');
327: hr_utility.raise_error;
328: end;
322: when NO_DATA_FOUND then
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE',
325: 'hr_entry_display.get_input_value_details');
326: hr_utility.set_message_token('STEP','4');
327: hr_utility.raise_error;
328: end;
329: --
330: else
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE',
325: 'hr_entry_display.get_input_value_details');
326: hr_utility.set_message_token('STEP','4');
327: hr_utility.raise_error;
328: end;
329: --
330: else
331: --