11: --
12: procedure copy_template_item_context
13: (p_validate in boolean default false
14: ,p_effective_date in date
15: ,p_language_code in varchar2 default hr_api.userenv_lang
16: ,p_template_item_context_id_frm in number
17: ,p_template_item_id in number
18: ,p_template_item_context_id_to out nocopy number
19: ,p_object_version_number out nocopy number
149: -- instead of p_language_code from now on, to allow an IN OUT parameter to
150: -- be passed through.
151: --
152: l_language_code := p_language_code;
153: hr_api.validate_language_code(p_language_code => l_language_code);
154: --
155: hr_utility.set_location(l_proc, 20);
156: --
157: --
164: ,p_template_item_context_id_frm => p_template_item_context_id_frm
165: ,p_template_item_id => p_template_item_id
166: );
167: exception
168: when hr_api.cannot_find_prog_unit then
169: hr_api.cannot_find_prog_unit_error
170: (p_module_name => 'copy_template_item_context'
171: ,p_hook_type => 'BP'
172: );
165: ,p_template_item_id => p_template_item_id
166: );
167: exception
168: when hr_api.cannot_find_prog_unit then
169: hr_api.cannot_find_prog_unit_error
170: (p_module_name => 'copy_template_item_context'
171: ,p_hook_type => 'BP'
172: );
173: end;
281: ,p_item_context_id => l_item_context_id
282: ,p_concatenated_segments => l_concatenated_segments
283: );
284: exception
285: when hr_api.cannot_find_prog_unit then
286: hr_api.cannot_find_prog_unit_error
287: (p_module_name => 'copy_template_item_context'
288: ,p_hook_type => 'AP'
289: );
282: ,p_concatenated_segments => l_concatenated_segments
283: );
284: exception
285: when hr_api.cannot_find_prog_unit then
286: hr_api.cannot_find_prog_unit_error
287: (p_module_name => 'copy_template_item_context'
288: ,p_hook_type => 'AP'
289: );
290: end;
293: --
294: hr_utility.set_location('At:'|| l_proc, 50);
295:
296: if p_validate then
297: raise hr_api.validate_enabled;
298: end if;
299: --
300: -- Set all output arguments
301: --
305: p_concatenated_segments := l_concatenated_segments;
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 70);
308: exception
309: when hr_api.validate_enabled then
310: --
311: -- As the Validate_Enabled exception has been raised
312: -- we must rollback to the savepoint
313: --
342: --
343: procedure create_template_item_context
344: (p_validate in boolean default false
345: ,p_effective_date in date
346: ,p_language_code in varchar2 default hr_api.userenv_lang
347: ,p_template_item_id in number
348: ,p_context_type in varchar2
349: ,p_segment1 in varchar2 default null
350: ,p_segment2 in varchar2 default null
376: ,p_segment28 in varchar2 default null
377: ,p_segment29 in varchar2 default null
378: ,p_segment30 in varchar2 default null
379: ,p_template_tab_page_id in number default null
380: ,p_alignment in number default hr_api.g_number
381: ,p_bevel in number default hr_api.g_number
382: ,p_case_restriction in number default hr_api.g_number
383: ,p_default_value in varchar2 default hr_api.g_varchar2
384: ,p_enabled in number default hr_api.g_number
377: ,p_segment29 in varchar2 default null
378: ,p_segment30 in varchar2 default null
379: ,p_template_tab_page_id in number default null
380: ,p_alignment in number default hr_api.g_number
381: ,p_bevel in number default hr_api.g_number
382: ,p_case_restriction in number default hr_api.g_number
383: ,p_default_value in varchar2 default hr_api.g_varchar2
384: ,p_enabled in number default hr_api.g_number
385: ,p_format_mask in varchar2 default hr_api.g_varchar2
378: ,p_segment30 in varchar2 default null
379: ,p_template_tab_page_id in number default null
380: ,p_alignment in number default hr_api.g_number
381: ,p_bevel in number default hr_api.g_number
382: ,p_case_restriction in number default hr_api.g_number
383: ,p_default_value in varchar2 default hr_api.g_varchar2
384: ,p_enabled in number default hr_api.g_number
385: ,p_format_mask in varchar2 default hr_api.g_varchar2
386: ,p_height in number default hr_api.g_number
379: ,p_template_tab_page_id in number default null
380: ,p_alignment in number default hr_api.g_number
381: ,p_bevel in number default hr_api.g_number
382: ,p_case_restriction in number default hr_api.g_number
383: ,p_default_value in varchar2 default hr_api.g_varchar2
384: ,p_enabled in number default hr_api.g_number
385: ,p_format_mask in varchar2 default hr_api.g_varchar2
386: ,p_height in number default hr_api.g_number
387: ,p_information_formula_id in number default hr_api.g_number
380: ,p_alignment in number default hr_api.g_number
381: ,p_bevel in number default hr_api.g_number
382: ,p_case_restriction in number default hr_api.g_number
383: ,p_default_value in varchar2 default hr_api.g_varchar2
384: ,p_enabled in number default hr_api.g_number
385: ,p_format_mask in varchar2 default hr_api.g_varchar2
386: ,p_height in number default hr_api.g_number
387: ,p_information_formula_id in number default hr_api.g_number
388: ,p_information_param_item_id1 in number default hr_api.g_number
381: ,p_bevel in number default hr_api.g_number
382: ,p_case_restriction in number default hr_api.g_number
383: ,p_default_value in varchar2 default hr_api.g_varchar2
384: ,p_enabled in number default hr_api.g_number
385: ,p_format_mask in varchar2 default hr_api.g_varchar2
386: ,p_height in number default hr_api.g_number
387: ,p_information_formula_id in number default hr_api.g_number
388: ,p_information_param_item_id1 in number default hr_api.g_number
389: ,p_information_param_item_id2 in number default hr_api.g_number
382: ,p_case_restriction in number default hr_api.g_number
383: ,p_default_value in varchar2 default hr_api.g_varchar2
384: ,p_enabled in number default hr_api.g_number
385: ,p_format_mask in varchar2 default hr_api.g_varchar2
386: ,p_height in number default hr_api.g_number
387: ,p_information_formula_id in number default hr_api.g_number
388: ,p_information_param_item_id1 in number default hr_api.g_number
389: ,p_information_param_item_id2 in number default hr_api.g_number
390: ,p_information_param_item_id3 in number default hr_api.g_number
383: ,p_default_value in varchar2 default hr_api.g_varchar2
384: ,p_enabled in number default hr_api.g_number
385: ,p_format_mask in varchar2 default hr_api.g_varchar2
386: ,p_height in number default hr_api.g_number
387: ,p_information_formula_id in number default hr_api.g_number
388: ,p_information_param_item_id1 in number default hr_api.g_number
389: ,p_information_param_item_id2 in number default hr_api.g_number
390: ,p_information_param_item_id3 in number default hr_api.g_number
391: ,p_information_param_item_id4 in number default hr_api.g_number
384: ,p_enabled in number default hr_api.g_number
385: ,p_format_mask in varchar2 default hr_api.g_varchar2
386: ,p_height in number default hr_api.g_number
387: ,p_information_formula_id in number default hr_api.g_number
388: ,p_information_param_item_id1 in number default hr_api.g_number
389: ,p_information_param_item_id2 in number default hr_api.g_number
390: ,p_information_param_item_id3 in number default hr_api.g_number
391: ,p_information_param_item_id4 in number default hr_api.g_number
392: ,p_information_param_item_id5 in number default hr_api.g_number
385: ,p_format_mask in varchar2 default hr_api.g_varchar2
386: ,p_height in number default hr_api.g_number
387: ,p_information_formula_id in number default hr_api.g_number
388: ,p_information_param_item_id1 in number default hr_api.g_number
389: ,p_information_param_item_id2 in number default hr_api.g_number
390: ,p_information_param_item_id3 in number default hr_api.g_number
391: ,p_information_param_item_id4 in number default hr_api.g_number
392: ,p_information_param_item_id5 in number default hr_api.g_number
393: ,p_information_prompt in varchar2 default hr_api.g_varchar2
386: ,p_height in number default hr_api.g_number
387: ,p_information_formula_id in number default hr_api.g_number
388: ,p_information_param_item_id1 in number default hr_api.g_number
389: ,p_information_param_item_id2 in number default hr_api.g_number
390: ,p_information_param_item_id3 in number default hr_api.g_number
391: ,p_information_param_item_id4 in number default hr_api.g_number
392: ,p_information_param_item_id5 in number default hr_api.g_number
393: ,p_information_prompt in varchar2 default hr_api.g_varchar2
394: ,p_insert_allowed in number default hr_api.g_number
387: ,p_information_formula_id in number default hr_api.g_number
388: ,p_information_param_item_id1 in number default hr_api.g_number
389: ,p_information_param_item_id2 in number default hr_api.g_number
390: ,p_information_param_item_id3 in number default hr_api.g_number
391: ,p_information_param_item_id4 in number default hr_api.g_number
392: ,p_information_param_item_id5 in number default hr_api.g_number
393: ,p_information_prompt in varchar2 default hr_api.g_varchar2
394: ,p_insert_allowed in number default hr_api.g_number
395: ,p_label in varchar2 default hr_api.g_varchar2
388: ,p_information_param_item_id1 in number default hr_api.g_number
389: ,p_information_param_item_id2 in number default hr_api.g_number
390: ,p_information_param_item_id3 in number default hr_api.g_number
391: ,p_information_param_item_id4 in number default hr_api.g_number
392: ,p_information_param_item_id5 in number default hr_api.g_number
393: ,p_information_prompt in varchar2 default hr_api.g_varchar2
394: ,p_insert_allowed in number default hr_api.g_number
395: ,p_label in varchar2 default hr_api.g_varchar2
396: ,p_prompt_text in varchar2 default hr_api.g_varchar2
389: ,p_information_param_item_id2 in number default hr_api.g_number
390: ,p_information_param_item_id3 in number default hr_api.g_number
391: ,p_information_param_item_id4 in number default hr_api.g_number
392: ,p_information_param_item_id5 in number default hr_api.g_number
393: ,p_information_prompt in varchar2 default hr_api.g_varchar2
394: ,p_insert_allowed in number default hr_api.g_number
395: ,p_label in varchar2 default hr_api.g_varchar2
396: ,p_prompt_text in varchar2 default hr_api.g_varchar2
397: ,p_prompt_alignment_offset in number default hr_api.g_number
390: ,p_information_param_item_id3 in number default hr_api.g_number
391: ,p_information_param_item_id4 in number default hr_api.g_number
392: ,p_information_param_item_id5 in number default hr_api.g_number
393: ,p_information_prompt in varchar2 default hr_api.g_varchar2
394: ,p_insert_allowed in number default hr_api.g_number
395: ,p_label in varchar2 default hr_api.g_varchar2
396: ,p_prompt_text in varchar2 default hr_api.g_varchar2
397: ,p_prompt_alignment_offset in number default hr_api.g_number
398: ,p_prompt_display_style in number default hr_api.g_number
391: ,p_information_param_item_id4 in number default hr_api.g_number
392: ,p_information_param_item_id5 in number default hr_api.g_number
393: ,p_information_prompt in varchar2 default hr_api.g_varchar2
394: ,p_insert_allowed in number default hr_api.g_number
395: ,p_label in varchar2 default hr_api.g_varchar2
396: ,p_prompt_text in varchar2 default hr_api.g_varchar2
397: ,p_prompt_alignment_offset in number default hr_api.g_number
398: ,p_prompt_display_style in number default hr_api.g_number
399: ,p_prompt_edge in number default hr_api.g_number
392: ,p_information_param_item_id5 in number default hr_api.g_number
393: ,p_information_prompt in varchar2 default hr_api.g_varchar2
394: ,p_insert_allowed in number default hr_api.g_number
395: ,p_label in varchar2 default hr_api.g_varchar2
396: ,p_prompt_text in varchar2 default hr_api.g_varchar2
397: ,p_prompt_alignment_offset in number default hr_api.g_number
398: ,p_prompt_display_style in number default hr_api.g_number
399: ,p_prompt_edge in number default hr_api.g_number
400: ,p_prompt_edge_alignment in number default hr_api.g_number
393: ,p_information_prompt in varchar2 default hr_api.g_varchar2
394: ,p_insert_allowed in number default hr_api.g_number
395: ,p_label in varchar2 default hr_api.g_varchar2
396: ,p_prompt_text in varchar2 default hr_api.g_varchar2
397: ,p_prompt_alignment_offset in number default hr_api.g_number
398: ,p_prompt_display_style in number default hr_api.g_number
399: ,p_prompt_edge in number default hr_api.g_number
400: ,p_prompt_edge_alignment in number default hr_api.g_number
401: ,p_prompt_edge_offset in number default hr_api.g_number
394: ,p_insert_allowed in number default hr_api.g_number
395: ,p_label in varchar2 default hr_api.g_varchar2
396: ,p_prompt_text in varchar2 default hr_api.g_varchar2
397: ,p_prompt_alignment_offset in number default hr_api.g_number
398: ,p_prompt_display_style in number default hr_api.g_number
399: ,p_prompt_edge in number default hr_api.g_number
400: ,p_prompt_edge_alignment in number default hr_api.g_number
401: ,p_prompt_edge_offset in number default hr_api.g_number
402: ,p_prompt_text_alignment in number default hr_api.g_number
395: ,p_label in varchar2 default hr_api.g_varchar2
396: ,p_prompt_text in varchar2 default hr_api.g_varchar2
397: ,p_prompt_alignment_offset in number default hr_api.g_number
398: ,p_prompt_display_style in number default hr_api.g_number
399: ,p_prompt_edge in number default hr_api.g_number
400: ,p_prompt_edge_alignment in number default hr_api.g_number
401: ,p_prompt_edge_offset in number default hr_api.g_number
402: ,p_prompt_text_alignment in number default hr_api.g_number
403: ,p_query_allowed in number default hr_api.g_number
396: ,p_prompt_text in varchar2 default hr_api.g_varchar2
397: ,p_prompt_alignment_offset in number default hr_api.g_number
398: ,p_prompt_display_style in number default hr_api.g_number
399: ,p_prompt_edge in number default hr_api.g_number
400: ,p_prompt_edge_alignment in number default hr_api.g_number
401: ,p_prompt_edge_offset in number default hr_api.g_number
402: ,p_prompt_text_alignment in number default hr_api.g_number
403: ,p_query_allowed in number default hr_api.g_number
404: ,p_required in number default hr_api.g_number
397: ,p_prompt_alignment_offset in number default hr_api.g_number
398: ,p_prompt_display_style in number default hr_api.g_number
399: ,p_prompt_edge in number default hr_api.g_number
400: ,p_prompt_edge_alignment in number default hr_api.g_number
401: ,p_prompt_edge_offset in number default hr_api.g_number
402: ,p_prompt_text_alignment in number default hr_api.g_number
403: ,p_query_allowed in number default hr_api.g_number
404: ,p_required in number default hr_api.g_number
405: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
398: ,p_prompt_display_style in number default hr_api.g_number
399: ,p_prompt_edge in number default hr_api.g_number
400: ,p_prompt_edge_alignment in number default hr_api.g_number
401: ,p_prompt_edge_offset in number default hr_api.g_number
402: ,p_prompt_text_alignment in number default hr_api.g_number
403: ,p_query_allowed in number default hr_api.g_number
404: ,p_required in number default hr_api.g_number
405: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
406: ,p_update_allowed in number default hr_api.g_number
399: ,p_prompt_edge in number default hr_api.g_number
400: ,p_prompt_edge_alignment in number default hr_api.g_number
401: ,p_prompt_edge_offset in number default hr_api.g_number
402: ,p_prompt_text_alignment in number default hr_api.g_number
403: ,p_query_allowed in number default hr_api.g_number
404: ,p_required in number default hr_api.g_number
405: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
406: ,p_update_allowed in number default hr_api.g_number
407: ,p_validation_formula_id in number default hr_api.g_number
400: ,p_prompt_edge_alignment in number default hr_api.g_number
401: ,p_prompt_edge_offset in number default hr_api.g_number
402: ,p_prompt_text_alignment in number default hr_api.g_number
403: ,p_query_allowed in number default hr_api.g_number
404: ,p_required in number default hr_api.g_number
405: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
406: ,p_update_allowed in number default hr_api.g_number
407: ,p_validation_formula_id in number default hr_api.g_number
408: ,p_validation_param_item_id1 in number default hr_api.g_number
401: ,p_prompt_edge_offset in number default hr_api.g_number
402: ,p_prompt_text_alignment in number default hr_api.g_number
403: ,p_query_allowed in number default hr_api.g_number
404: ,p_required in number default hr_api.g_number
405: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
406: ,p_update_allowed in number default hr_api.g_number
407: ,p_validation_formula_id in number default hr_api.g_number
408: ,p_validation_param_item_id1 in number default hr_api.g_number
409: ,p_validation_param_item_id2 in number default hr_api.g_number
402: ,p_prompt_text_alignment in number default hr_api.g_number
403: ,p_query_allowed in number default hr_api.g_number
404: ,p_required in number default hr_api.g_number
405: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
406: ,p_update_allowed in number default hr_api.g_number
407: ,p_validation_formula_id in number default hr_api.g_number
408: ,p_validation_param_item_id1 in number default hr_api.g_number
409: ,p_validation_param_item_id2 in number default hr_api.g_number
410: ,p_validation_param_item_id3 in number default hr_api.g_number
403: ,p_query_allowed in number default hr_api.g_number
404: ,p_required in number default hr_api.g_number
405: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
406: ,p_update_allowed in number default hr_api.g_number
407: ,p_validation_formula_id in number default hr_api.g_number
408: ,p_validation_param_item_id1 in number default hr_api.g_number
409: ,p_validation_param_item_id2 in number default hr_api.g_number
410: ,p_validation_param_item_id3 in number default hr_api.g_number
411: ,p_validation_param_item_id4 in number default hr_api.g_number
404: ,p_required in number default hr_api.g_number
405: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
406: ,p_update_allowed in number default hr_api.g_number
407: ,p_validation_formula_id in number default hr_api.g_number
408: ,p_validation_param_item_id1 in number default hr_api.g_number
409: ,p_validation_param_item_id2 in number default hr_api.g_number
410: ,p_validation_param_item_id3 in number default hr_api.g_number
411: ,p_validation_param_item_id4 in number default hr_api.g_number
412: ,p_validation_param_item_id5 in number default hr_api.g_number
405: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
406: ,p_update_allowed in number default hr_api.g_number
407: ,p_validation_formula_id in number default hr_api.g_number
408: ,p_validation_param_item_id1 in number default hr_api.g_number
409: ,p_validation_param_item_id2 in number default hr_api.g_number
410: ,p_validation_param_item_id3 in number default hr_api.g_number
411: ,p_validation_param_item_id4 in number default hr_api.g_number
412: ,p_validation_param_item_id5 in number default hr_api.g_number
413: ,p_visible in number default hr_api.g_number
406: ,p_update_allowed in number default hr_api.g_number
407: ,p_validation_formula_id in number default hr_api.g_number
408: ,p_validation_param_item_id1 in number default hr_api.g_number
409: ,p_validation_param_item_id2 in number default hr_api.g_number
410: ,p_validation_param_item_id3 in number default hr_api.g_number
411: ,p_validation_param_item_id4 in number default hr_api.g_number
412: ,p_validation_param_item_id5 in number default hr_api.g_number
413: ,p_visible in number default hr_api.g_number
414: ,p_width in number default hr_api.g_number
407: ,p_validation_formula_id in number default hr_api.g_number
408: ,p_validation_param_item_id1 in number default hr_api.g_number
409: ,p_validation_param_item_id2 in number default hr_api.g_number
410: ,p_validation_param_item_id3 in number default hr_api.g_number
411: ,p_validation_param_item_id4 in number default hr_api.g_number
412: ,p_validation_param_item_id5 in number default hr_api.g_number
413: ,p_visible in number default hr_api.g_number
414: ,p_width in number default hr_api.g_number
415: ,p_x_position in number default hr_api.g_number
408: ,p_validation_param_item_id1 in number default hr_api.g_number
409: ,p_validation_param_item_id2 in number default hr_api.g_number
410: ,p_validation_param_item_id3 in number default hr_api.g_number
411: ,p_validation_param_item_id4 in number default hr_api.g_number
412: ,p_validation_param_item_id5 in number default hr_api.g_number
413: ,p_visible in number default hr_api.g_number
414: ,p_width in number default hr_api.g_number
415: ,p_x_position in number default hr_api.g_number
416: ,p_y_position in number default hr_api.g_number
409: ,p_validation_param_item_id2 in number default hr_api.g_number
410: ,p_validation_param_item_id3 in number default hr_api.g_number
411: ,p_validation_param_item_id4 in number default hr_api.g_number
412: ,p_validation_param_item_id5 in number default hr_api.g_number
413: ,p_visible in number default hr_api.g_number
414: ,p_width in number default hr_api.g_number
415: ,p_x_position in number default hr_api.g_number
416: ,p_y_position in number default hr_api.g_number
417: ,p_information_category in varchar2 default hr_api.g_varchar2
410: ,p_validation_param_item_id3 in number default hr_api.g_number
411: ,p_validation_param_item_id4 in number default hr_api.g_number
412: ,p_validation_param_item_id5 in number default hr_api.g_number
413: ,p_visible in number default hr_api.g_number
414: ,p_width in number default hr_api.g_number
415: ,p_x_position in number default hr_api.g_number
416: ,p_y_position in number default hr_api.g_number
417: ,p_information_category in varchar2 default hr_api.g_varchar2
418: ,p_information1 in varchar2 default hr_api.g_varchar2
411: ,p_validation_param_item_id4 in number default hr_api.g_number
412: ,p_validation_param_item_id5 in number default hr_api.g_number
413: ,p_visible in number default hr_api.g_number
414: ,p_width in number default hr_api.g_number
415: ,p_x_position in number default hr_api.g_number
416: ,p_y_position in number default hr_api.g_number
417: ,p_information_category in varchar2 default hr_api.g_varchar2
418: ,p_information1 in varchar2 default hr_api.g_varchar2
419: ,p_information2 in varchar2 default hr_api.g_varchar2
412: ,p_validation_param_item_id5 in number default hr_api.g_number
413: ,p_visible in number default hr_api.g_number
414: ,p_width in number default hr_api.g_number
415: ,p_x_position in number default hr_api.g_number
416: ,p_y_position in number default hr_api.g_number
417: ,p_information_category in varchar2 default hr_api.g_varchar2
418: ,p_information1 in varchar2 default hr_api.g_varchar2
419: ,p_information2 in varchar2 default hr_api.g_varchar2
420: ,p_information3 in varchar2 default hr_api.g_varchar2
413: ,p_visible in number default hr_api.g_number
414: ,p_width in number default hr_api.g_number
415: ,p_x_position in number default hr_api.g_number
416: ,p_y_position in number default hr_api.g_number
417: ,p_information_category in varchar2 default hr_api.g_varchar2
418: ,p_information1 in varchar2 default hr_api.g_varchar2
419: ,p_information2 in varchar2 default hr_api.g_varchar2
420: ,p_information3 in varchar2 default hr_api.g_varchar2
421: ,p_information4 in varchar2 default hr_api.g_varchar2
414: ,p_width in number default hr_api.g_number
415: ,p_x_position in number default hr_api.g_number
416: ,p_y_position in number default hr_api.g_number
417: ,p_information_category in varchar2 default hr_api.g_varchar2
418: ,p_information1 in varchar2 default hr_api.g_varchar2
419: ,p_information2 in varchar2 default hr_api.g_varchar2
420: ,p_information3 in varchar2 default hr_api.g_varchar2
421: ,p_information4 in varchar2 default hr_api.g_varchar2
422: ,p_information5 in varchar2 default hr_api.g_varchar2
415: ,p_x_position in number default hr_api.g_number
416: ,p_y_position in number default hr_api.g_number
417: ,p_information_category in varchar2 default hr_api.g_varchar2
418: ,p_information1 in varchar2 default hr_api.g_varchar2
419: ,p_information2 in varchar2 default hr_api.g_varchar2
420: ,p_information3 in varchar2 default hr_api.g_varchar2
421: ,p_information4 in varchar2 default hr_api.g_varchar2
422: ,p_information5 in varchar2 default hr_api.g_varchar2
423: ,p_information6 in varchar2 default hr_api.g_varchar2
416: ,p_y_position in number default hr_api.g_number
417: ,p_information_category in varchar2 default hr_api.g_varchar2
418: ,p_information1 in varchar2 default hr_api.g_varchar2
419: ,p_information2 in varchar2 default hr_api.g_varchar2
420: ,p_information3 in varchar2 default hr_api.g_varchar2
421: ,p_information4 in varchar2 default hr_api.g_varchar2
422: ,p_information5 in varchar2 default hr_api.g_varchar2
423: ,p_information6 in varchar2 default hr_api.g_varchar2
424: ,p_information7 in varchar2 default hr_api.g_varchar2
417: ,p_information_category in varchar2 default hr_api.g_varchar2
418: ,p_information1 in varchar2 default hr_api.g_varchar2
419: ,p_information2 in varchar2 default hr_api.g_varchar2
420: ,p_information3 in varchar2 default hr_api.g_varchar2
421: ,p_information4 in varchar2 default hr_api.g_varchar2
422: ,p_information5 in varchar2 default hr_api.g_varchar2
423: ,p_information6 in varchar2 default hr_api.g_varchar2
424: ,p_information7 in varchar2 default hr_api.g_varchar2
425: ,p_information8 in varchar2 default hr_api.g_varchar2
418: ,p_information1 in varchar2 default hr_api.g_varchar2
419: ,p_information2 in varchar2 default hr_api.g_varchar2
420: ,p_information3 in varchar2 default hr_api.g_varchar2
421: ,p_information4 in varchar2 default hr_api.g_varchar2
422: ,p_information5 in varchar2 default hr_api.g_varchar2
423: ,p_information6 in varchar2 default hr_api.g_varchar2
424: ,p_information7 in varchar2 default hr_api.g_varchar2
425: ,p_information8 in varchar2 default hr_api.g_varchar2
426: ,p_information9 in varchar2 default hr_api.g_varchar2
419: ,p_information2 in varchar2 default hr_api.g_varchar2
420: ,p_information3 in varchar2 default hr_api.g_varchar2
421: ,p_information4 in varchar2 default hr_api.g_varchar2
422: ,p_information5 in varchar2 default hr_api.g_varchar2
423: ,p_information6 in varchar2 default hr_api.g_varchar2
424: ,p_information7 in varchar2 default hr_api.g_varchar2
425: ,p_information8 in varchar2 default hr_api.g_varchar2
426: ,p_information9 in varchar2 default hr_api.g_varchar2
427: ,p_information10 in varchar2 default hr_api.g_varchar2
420: ,p_information3 in varchar2 default hr_api.g_varchar2
421: ,p_information4 in varchar2 default hr_api.g_varchar2
422: ,p_information5 in varchar2 default hr_api.g_varchar2
423: ,p_information6 in varchar2 default hr_api.g_varchar2
424: ,p_information7 in varchar2 default hr_api.g_varchar2
425: ,p_information8 in varchar2 default hr_api.g_varchar2
426: ,p_information9 in varchar2 default hr_api.g_varchar2
427: ,p_information10 in varchar2 default hr_api.g_varchar2
428: ,p_information11 in varchar2 default hr_api.g_varchar2
421: ,p_information4 in varchar2 default hr_api.g_varchar2
422: ,p_information5 in varchar2 default hr_api.g_varchar2
423: ,p_information6 in varchar2 default hr_api.g_varchar2
424: ,p_information7 in varchar2 default hr_api.g_varchar2
425: ,p_information8 in varchar2 default hr_api.g_varchar2
426: ,p_information9 in varchar2 default hr_api.g_varchar2
427: ,p_information10 in varchar2 default hr_api.g_varchar2
428: ,p_information11 in varchar2 default hr_api.g_varchar2
429: ,p_information12 in varchar2 default hr_api.g_varchar2
422: ,p_information5 in varchar2 default hr_api.g_varchar2
423: ,p_information6 in varchar2 default hr_api.g_varchar2
424: ,p_information7 in varchar2 default hr_api.g_varchar2
425: ,p_information8 in varchar2 default hr_api.g_varchar2
426: ,p_information9 in varchar2 default hr_api.g_varchar2
427: ,p_information10 in varchar2 default hr_api.g_varchar2
428: ,p_information11 in varchar2 default hr_api.g_varchar2
429: ,p_information12 in varchar2 default hr_api.g_varchar2
430: ,p_information13 in varchar2 default hr_api.g_varchar2
423: ,p_information6 in varchar2 default hr_api.g_varchar2
424: ,p_information7 in varchar2 default hr_api.g_varchar2
425: ,p_information8 in varchar2 default hr_api.g_varchar2
426: ,p_information9 in varchar2 default hr_api.g_varchar2
427: ,p_information10 in varchar2 default hr_api.g_varchar2
428: ,p_information11 in varchar2 default hr_api.g_varchar2
429: ,p_information12 in varchar2 default hr_api.g_varchar2
430: ,p_information13 in varchar2 default hr_api.g_varchar2
431: ,p_information14 in varchar2 default hr_api.g_varchar2
424: ,p_information7 in varchar2 default hr_api.g_varchar2
425: ,p_information8 in varchar2 default hr_api.g_varchar2
426: ,p_information9 in varchar2 default hr_api.g_varchar2
427: ,p_information10 in varchar2 default hr_api.g_varchar2
428: ,p_information11 in varchar2 default hr_api.g_varchar2
429: ,p_information12 in varchar2 default hr_api.g_varchar2
430: ,p_information13 in varchar2 default hr_api.g_varchar2
431: ,p_information14 in varchar2 default hr_api.g_varchar2
432: ,p_information15 in varchar2 default hr_api.g_varchar2
425: ,p_information8 in varchar2 default hr_api.g_varchar2
426: ,p_information9 in varchar2 default hr_api.g_varchar2
427: ,p_information10 in varchar2 default hr_api.g_varchar2
428: ,p_information11 in varchar2 default hr_api.g_varchar2
429: ,p_information12 in varchar2 default hr_api.g_varchar2
430: ,p_information13 in varchar2 default hr_api.g_varchar2
431: ,p_information14 in varchar2 default hr_api.g_varchar2
432: ,p_information15 in varchar2 default hr_api.g_varchar2
433: ,p_information16 in varchar2 default hr_api.g_varchar2
426: ,p_information9 in varchar2 default hr_api.g_varchar2
427: ,p_information10 in varchar2 default hr_api.g_varchar2
428: ,p_information11 in varchar2 default hr_api.g_varchar2
429: ,p_information12 in varchar2 default hr_api.g_varchar2
430: ,p_information13 in varchar2 default hr_api.g_varchar2
431: ,p_information14 in varchar2 default hr_api.g_varchar2
432: ,p_information15 in varchar2 default hr_api.g_varchar2
433: ,p_information16 in varchar2 default hr_api.g_varchar2
434: ,p_information17 in varchar2 default hr_api.g_varchar2
427: ,p_information10 in varchar2 default hr_api.g_varchar2
428: ,p_information11 in varchar2 default hr_api.g_varchar2
429: ,p_information12 in varchar2 default hr_api.g_varchar2
430: ,p_information13 in varchar2 default hr_api.g_varchar2
431: ,p_information14 in varchar2 default hr_api.g_varchar2
432: ,p_information15 in varchar2 default hr_api.g_varchar2
433: ,p_information16 in varchar2 default hr_api.g_varchar2
434: ,p_information17 in varchar2 default hr_api.g_varchar2
435: ,p_information18 in varchar2 default hr_api.g_varchar2
428: ,p_information11 in varchar2 default hr_api.g_varchar2
429: ,p_information12 in varchar2 default hr_api.g_varchar2
430: ,p_information13 in varchar2 default hr_api.g_varchar2
431: ,p_information14 in varchar2 default hr_api.g_varchar2
432: ,p_information15 in varchar2 default hr_api.g_varchar2
433: ,p_information16 in varchar2 default hr_api.g_varchar2
434: ,p_information17 in varchar2 default hr_api.g_varchar2
435: ,p_information18 in varchar2 default hr_api.g_varchar2
436: ,p_information19 in varchar2 default hr_api.g_varchar2
429: ,p_information12 in varchar2 default hr_api.g_varchar2
430: ,p_information13 in varchar2 default hr_api.g_varchar2
431: ,p_information14 in varchar2 default hr_api.g_varchar2
432: ,p_information15 in varchar2 default hr_api.g_varchar2
433: ,p_information16 in varchar2 default hr_api.g_varchar2
434: ,p_information17 in varchar2 default hr_api.g_varchar2
435: ,p_information18 in varchar2 default hr_api.g_varchar2
436: ,p_information19 in varchar2 default hr_api.g_varchar2
437: ,p_information20 in varchar2 default hr_api.g_varchar2
430: ,p_information13 in varchar2 default hr_api.g_varchar2
431: ,p_information14 in varchar2 default hr_api.g_varchar2
432: ,p_information15 in varchar2 default hr_api.g_varchar2
433: ,p_information16 in varchar2 default hr_api.g_varchar2
434: ,p_information17 in varchar2 default hr_api.g_varchar2
435: ,p_information18 in varchar2 default hr_api.g_varchar2
436: ,p_information19 in varchar2 default hr_api.g_varchar2
437: ,p_information20 in varchar2 default hr_api.g_varchar2
438: ,p_information21 in varchar2 default hr_api.g_varchar2
431: ,p_information14 in varchar2 default hr_api.g_varchar2
432: ,p_information15 in varchar2 default hr_api.g_varchar2
433: ,p_information16 in varchar2 default hr_api.g_varchar2
434: ,p_information17 in varchar2 default hr_api.g_varchar2
435: ,p_information18 in varchar2 default hr_api.g_varchar2
436: ,p_information19 in varchar2 default hr_api.g_varchar2
437: ,p_information20 in varchar2 default hr_api.g_varchar2
438: ,p_information21 in varchar2 default hr_api.g_varchar2
439: ,p_information22 in varchar2 default hr_api.g_varchar2
432: ,p_information15 in varchar2 default hr_api.g_varchar2
433: ,p_information16 in varchar2 default hr_api.g_varchar2
434: ,p_information17 in varchar2 default hr_api.g_varchar2
435: ,p_information18 in varchar2 default hr_api.g_varchar2
436: ,p_information19 in varchar2 default hr_api.g_varchar2
437: ,p_information20 in varchar2 default hr_api.g_varchar2
438: ,p_information21 in varchar2 default hr_api.g_varchar2
439: ,p_information22 in varchar2 default hr_api.g_varchar2
440: ,p_information23 in varchar2 default hr_api.g_varchar2
433: ,p_information16 in varchar2 default hr_api.g_varchar2
434: ,p_information17 in varchar2 default hr_api.g_varchar2
435: ,p_information18 in varchar2 default hr_api.g_varchar2
436: ,p_information19 in varchar2 default hr_api.g_varchar2
437: ,p_information20 in varchar2 default hr_api.g_varchar2
438: ,p_information21 in varchar2 default hr_api.g_varchar2
439: ,p_information22 in varchar2 default hr_api.g_varchar2
440: ,p_information23 in varchar2 default hr_api.g_varchar2
441: ,p_information24 in varchar2 default hr_api.g_varchar2
434: ,p_information17 in varchar2 default hr_api.g_varchar2
435: ,p_information18 in varchar2 default hr_api.g_varchar2
436: ,p_information19 in varchar2 default hr_api.g_varchar2
437: ,p_information20 in varchar2 default hr_api.g_varchar2
438: ,p_information21 in varchar2 default hr_api.g_varchar2
439: ,p_information22 in varchar2 default hr_api.g_varchar2
440: ,p_information23 in varchar2 default hr_api.g_varchar2
441: ,p_information24 in varchar2 default hr_api.g_varchar2
442: ,p_information25 in varchar2 default hr_api.g_varchar2
435: ,p_information18 in varchar2 default hr_api.g_varchar2
436: ,p_information19 in varchar2 default hr_api.g_varchar2
437: ,p_information20 in varchar2 default hr_api.g_varchar2
438: ,p_information21 in varchar2 default hr_api.g_varchar2
439: ,p_information22 in varchar2 default hr_api.g_varchar2
440: ,p_information23 in varchar2 default hr_api.g_varchar2
441: ,p_information24 in varchar2 default hr_api.g_varchar2
442: ,p_information25 in varchar2 default hr_api.g_varchar2
443: ,p_information26 in varchar2 default hr_api.g_varchar2
436: ,p_information19 in varchar2 default hr_api.g_varchar2
437: ,p_information20 in varchar2 default hr_api.g_varchar2
438: ,p_information21 in varchar2 default hr_api.g_varchar2
439: ,p_information22 in varchar2 default hr_api.g_varchar2
440: ,p_information23 in varchar2 default hr_api.g_varchar2
441: ,p_information24 in varchar2 default hr_api.g_varchar2
442: ,p_information25 in varchar2 default hr_api.g_varchar2
443: ,p_information26 in varchar2 default hr_api.g_varchar2
444: ,p_information27 in varchar2 default hr_api.g_varchar2
437: ,p_information20 in varchar2 default hr_api.g_varchar2
438: ,p_information21 in varchar2 default hr_api.g_varchar2
439: ,p_information22 in varchar2 default hr_api.g_varchar2
440: ,p_information23 in varchar2 default hr_api.g_varchar2
441: ,p_information24 in varchar2 default hr_api.g_varchar2
442: ,p_information25 in varchar2 default hr_api.g_varchar2
443: ,p_information26 in varchar2 default hr_api.g_varchar2
444: ,p_information27 in varchar2 default hr_api.g_varchar2
445: ,p_information28 in varchar2 default hr_api.g_varchar2
438: ,p_information21 in varchar2 default hr_api.g_varchar2
439: ,p_information22 in varchar2 default hr_api.g_varchar2
440: ,p_information23 in varchar2 default hr_api.g_varchar2
441: ,p_information24 in varchar2 default hr_api.g_varchar2
442: ,p_information25 in varchar2 default hr_api.g_varchar2
443: ,p_information26 in varchar2 default hr_api.g_varchar2
444: ,p_information27 in varchar2 default hr_api.g_varchar2
445: ,p_information28 in varchar2 default hr_api.g_varchar2
446: ,p_information29 in varchar2 default hr_api.g_varchar2
439: ,p_information22 in varchar2 default hr_api.g_varchar2
440: ,p_information23 in varchar2 default hr_api.g_varchar2
441: ,p_information24 in varchar2 default hr_api.g_varchar2
442: ,p_information25 in varchar2 default hr_api.g_varchar2
443: ,p_information26 in varchar2 default hr_api.g_varchar2
444: ,p_information27 in varchar2 default hr_api.g_varchar2
445: ,p_information28 in varchar2 default hr_api.g_varchar2
446: ,p_information29 in varchar2 default hr_api.g_varchar2
447: ,p_information30 in varchar2 default hr_api.g_varchar2
440: ,p_information23 in varchar2 default hr_api.g_varchar2
441: ,p_information24 in varchar2 default hr_api.g_varchar2
442: ,p_information25 in varchar2 default hr_api.g_varchar2
443: ,p_information26 in varchar2 default hr_api.g_varchar2
444: ,p_information27 in varchar2 default hr_api.g_varchar2
445: ,p_information28 in varchar2 default hr_api.g_varchar2
446: ,p_information29 in varchar2 default hr_api.g_varchar2
447: ,p_information30 in varchar2 default hr_api.g_varchar2
448: ,p_next_navigation_item_id in number default hr_api.g_number
441: ,p_information24 in varchar2 default hr_api.g_varchar2
442: ,p_information25 in varchar2 default hr_api.g_varchar2
443: ,p_information26 in varchar2 default hr_api.g_varchar2
444: ,p_information27 in varchar2 default hr_api.g_varchar2
445: ,p_information28 in varchar2 default hr_api.g_varchar2
446: ,p_information29 in varchar2 default hr_api.g_varchar2
447: ,p_information30 in varchar2 default hr_api.g_varchar2
448: ,p_next_navigation_item_id in number default hr_api.g_number
449: ,p_previous_navigation_item_id in number default hr_api.g_number
442: ,p_information25 in varchar2 default hr_api.g_varchar2
443: ,p_information26 in varchar2 default hr_api.g_varchar2
444: ,p_information27 in varchar2 default hr_api.g_varchar2
445: ,p_information28 in varchar2 default hr_api.g_varchar2
446: ,p_information29 in varchar2 default hr_api.g_varchar2
447: ,p_information30 in varchar2 default hr_api.g_varchar2
448: ,p_next_navigation_item_id in number default hr_api.g_number
449: ,p_previous_navigation_item_id in number default hr_api.g_number
450: ,p_template_item_context_id out nocopy number
443: ,p_information26 in varchar2 default hr_api.g_varchar2
444: ,p_information27 in varchar2 default hr_api.g_varchar2
445: ,p_information28 in varchar2 default hr_api.g_varchar2
446: ,p_information29 in varchar2 default hr_api.g_varchar2
447: ,p_information30 in varchar2 default hr_api.g_varchar2
448: ,p_next_navigation_item_id in number default hr_api.g_number
449: ,p_previous_navigation_item_id in number default hr_api.g_number
450: ,p_template_item_context_id out nocopy number
451: ,p_object_version_number out nocopy number
444: ,p_information27 in varchar2 default hr_api.g_varchar2
445: ,p_information28 in varchar2 default hr_api.g_varchar2
446: ,p_information29 in varchar2 default hr_api.g_varchar2
447: ,p_information30 in varchar2 default hr_api.g_varchar2
448: ,p_next_navigation_item_id in number default hr_api.g_number
449: ,p_previous_navigation_item_id in number default hr_api.g_number
450: ,p_template_item_context_id out nocopy number
451: ,p_object_version_number out nocopy number
452: ,p_item_context_id out nocopy number
445: ,p_information28 in varchar2 default hr_api.g_varchar2
446: ,p_information29 in varchar2 default hr_api.g_varchar2
447: ,p_information30 in varchar2 default hr_api.g_varchar2
448: ,p_next_navigation_item_id in number default hr_api.g_number
449: ,p_previous_navigation_item_id in number default hr_api.g_number
450: ,p_template_item_context_id out nocopy number
451: ,p_object_version_number out nocopy number
452: ,p_item_context_id out nocopy number
453: ,p_concatenated_segments out nocopy varchar2
506: -- instead of p_language_code from now on, to allow an IN OUT parameter to
507: -- be passed through.
508: --
509: l_language_code := p_language_code;
510: hr_api.validate_language_code(p_language_code => l_language_code);
511: --
512: hr_utility.set_location(l_proc, 20);
513: --
514: --
621: ,p_information30 => p_information30
622: ,p_next_navigation_item_id => p_next_navigation_item_id
623: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
624: exception
625: when hr_api.cannot_find_prog_unit then
626: hr_api.cannot_find_prog_unit_error
627: (p_module_name => 'create_template_item_context'
628: ,p_hook_type => 'BP'
629: );
622: ,p_next_navigation_item_id => p_next_navigation_item_id
623: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
624: exception
625: when hr_api.cannot_find_prog_unit then
626: hr_api.cannot_find_prog_unit_error
627: (p_module_name => 'create_template_item_context'
628: ,p_hook_type => 'BP'
629: );
630: end;
638: CLOSE cur_override;
639:
640: hr_utility.set_location('At:'|| l_proc, 20);
641:
642: IF p_required <> hr_api.g_number AND
643: ( l_required_override is not null AND p_required is not null ) THEN
644: l_override_value_warning := TRUE;
645: END IF;
646:
645: END IF;
646:
647: hr_utility.set_location('At:'|| l_proc, 25);
648:
649: IF p_visible <> hr_api.g_number AND
650: ( l_visible_override is not null AND p_visible is not null ) THEN
651: l_override_value_warning := TRUE;
652: END IF;
653:
926: ,p_concatenated_segments => l_concatenated_segments
927: ,p_override_value_warning => l_override_value_warning
928: );
929: exception
930: when hr_api.cannot_find_prog_unit then
931: hr_api.cannot_find_prog_unit_error
932: (p_module_name => 'create_template_item_context'
933: ,p_hook_type => 'AP'
934: );
927: ,p_override_value_warning => l_override_value_warning
928: );
929: exception
930: when hr_api.cannot_find_prog_unit then
931: hr_api.cannot_find_prog_unit_error
932: (p_module_name => 'create_template_item_context'
933: ,p_hook_type => 'AP'
934: );
935: end;
936: --
937: -- When in validation only mode raise the Validate_Enabled exception
938: --
939: if p_validate then
940: raise hr_api.validate_enabled;
941: end if;
942: --
943: -- Set all output arguments
944: --
949: p_override_value_warning := l_override_value_warning;
950: --
951: hr_utility.set_location(' Leaving:'||l_proc, 70);
952: exception
953: when hr_api.validate_enabled then
954: --
955: -- As the Validate_Enabled exception has been raised
956: -- we must rollback to the savepoint
957: --
1031: ,p_object_version_number => p_object_version_number
1032: --,p_delete_children_flag => p_delete_children_flag
1033: );
1034: exception
1035: when hr_api.cannot_find_prog_unit then
1036: hr_api.cannot_find_prog_unit_error
1037: (p_module_name => 'delete_template_item_context'
1038: ,p_hook_type => 'BP'
1039: );
1032: --,p_delete_children_flag => p_delete_children_flag
1033: );
1034: exception
1035: when hr_api.cannot_find_prog_unit then
1036: hr_api.cannot_find_prog_unit_error
1037: (p_module_name => 'delete_template_item_context'
1038: ,p_hook_type => 'BP'
1039: );
1040: end;
1092: ,p_object_version_number => p_object_version_number
1093: --,p_delete_children_flag => p_delete_children_flag
1094: );
1095: exception
1096: when hr_api.cannot_find_prog_unit then
1097: hr_api.cannot_find_prog_unit_error
1098: (p_module_name => 'delete_template_item_context'
1099: ,p_hook_type => 'AP'
1100: );
1093: --,p_delete_children_flag => p_delete_children_flag
1094: );
1095: exception
1096: when hr_api.cannot_find_prog_unit then
1097: hr_api.cannot_find_prog_unit_error
1098: (p_module_name => 'delete_template_item_context'
1099: ,p_hook_type => 'AP'
1100: );
1101: end;
1104: --
1105: hr_utility.set_location('At:'|| l_proc, 45);
1106:
1107: if p_validate then
1108: raise hr_api.validate_enabled;
1109: end if;
1110: --
1111: hr_utility.set_location(' Leaving:'||l_proc, 70);
1112: exception
1109: end if;
1110: --
1111: hr_utility.set_location(' Leaving:'||l_proc, 70);
1112: exception
1113: when hr_api.validate_enabled then
1114: --
1115: -- As the Validate_Enabled exception has been raised
1116: -- we must rollback to the savepoint
1117: --
1137: --
1138: procedure update_template_item_context
1139: (p_validate in boolean default false
1140: ,p_effective_date in date
1141: ,p_language_code in varchar2 default hr_api.userenv_lang
1142: --,p_context_type in varchar2 default hr_api.g_varchar2
1143: ,p_template_item_context_id in number
1144: ,p_object_version_number in out nocopy number
1145: --,p_segment1 in varchar2 default hr_api.g_varchar2
1138: procedure update_template_item_context
1139: (p_validate in boolean default false
1140: ,p_effective_date in date
1141: ,p_language_code in varchar2 default hr_api.userenv_lang
1142: --,p_context_type in varchar2 default hr_api.g_varchar2
1143: ,p_template_item_context_id in number
1144: ,p_object_version_number in out nocopy number
1145: --,p_segment1 in varchar2 default hr_api.g_varchar2
1146: --,p_segment2 in varchar2 default hr_api.g_varchar2
1141: ,p_language_code in varchar2 default hr_api.userenv_lang
1142: --,p_context_type in varchar2 default hr_api.g_varchar2
1143: ,p_template_item_context_id in number
1144: ,p_object_version_number in out nocopy number
1145: --,p_segment1 in varchar2 default hr_api.g_varchar2
1146: --,p_segment2 in varchar2 default hr_api.g_varchar2
1147: --,p_segment3 in varchar2 default hr_api.g_varchar2
1148: --,p_segment4 in varchar2 default hr_api.g_varchar2
1149: --,p_segment5 in varchar2 default hr_api.g_varchar2
1142: --,p_context_type in varchar2 default hr_api.g_varchar2
1143: ,p_template_item_context_id in number
1144: ,p_object_version_number in out nocopy number
1145: --,p_segment1 in varchar2 default hr_api.g_varchar2
1146: --,p_segment2 in varchar2 default hr_api.g_varchar2
1147: --,p_segment3 in varchar2 default hr_api.g_varchar2
1148: --,p_segment4 in varchar2 default hr_api.g_varchar2
1149: --,p_segment5 in varchar2 default hr_api.g_varchar2
1150: --,p_segment6 in varchar2 default hr_api.g_varchar2
1143: ,p_template_item_context_id in number
1144: ,p_object_version_number in out nocopy number
1145: --,p_segment1 in varchar2 default hr_api.g_varchar2
1146: --,p_segment2 in varchar2 default hr_api.g_varchar2
1147: --,p_segment3 in varchar2 default hr_api.g_varchar2
1148: --,p_segment4 in varchar2 default hr_api.g_varchar2
1149: --,p_segment5 in varchar2 default hr_api.g_varchar2
1150: --,p_segment6 in varchar2 default hr_api.g_varchar2
1151: --,p_segment7 in varchar2 default hr_api.g_varchar2
1144: ,p_object_version_number in out nocopy number
1145: --,p_segment1 in varchar2 default hr_api.g_varchar2
1146: --,p_segment2 in varchar2 default hr_api.g_varchar2
1147: --,p_segment3 in varchar2 default hr_api.g_varchar2
1148: --,p_segment4 in varchar2 default hr_api.g_varchar2
1149: --,p_segment5 in varchar2 default hr_api.g_varchar2
1150: --,p_segment6 in varchar2 default hr_api.g_varchar2
1151: --,p_segment7 in varchar2 default hr_api.g_varchar2
1152: --,p_segment8 in varchar2 default hr_api.g_varchar2
1145: --,p_segment1 in varchar2 default hr_api.g_varchar2
1146: --,p_segment2 in varchar2 default hr_api.g_varchar2
1147: --,p_segment3 in varchar2 default hr_api.g_varchar2
1148: --,p_segment4 in varchar2 default hr_api.g_varchar2
1149: --,p_segment5 in varchar2 default hr_api.g_varchar2
1150: --,p_segment6 in varchar2 default hr_api.g_varchar2
1151: --,p_segment7 in varchar2 default hr_api.g_varchar2
1152: --,p_segment8 in varchar2 default hr_api.g_varchar2
1153: --,p_segment9 in varchar2 default hr_api.g_varchar2
1146: --,p_segment2 in varchar2 default hr_api.g_varchar2
1147: --,p_segment3 in varchar2 default hr_api.g_varchar2
1148: --,p_segment4 in varchar2 default hr_api.g_varchar2
1149: --,p_segment5 in varchar2 default hr_api.g_varchar2
1150: --,p_segment6 in varchar2 default hr_api.g_varchar2
1151: --,p_segment7 in varchar2 default hr_api.g_varchar2
1152: --,p_segment8 in varchar2 default hr_api.g_varchar2
1153: --,p_segment9 in varchar2 default hr_api.g_varchar2
1154: --,p_segment10 in varchar2 default hr_api.g_varchar2
1147: --,p_segment3 in varchar2 default hr_api.g_varchar2
1148: --,p_segment4 in varchar2 default hr_api.g_varchar2
1149: --,p_segment5 in varchar2 default hr_api.g_varchar2
1150: --,p_segment6 in varchar2 default hr_api.g_varchar2
1151: --,p_segment7 in varchar2 default hr_api.g_varchar2
1152: --,p_segment8 in varchar2 default hr_api.g_varchar2
1153: --,p_segment9 in varchar2 default hr_api.g_varchar2
1154: --,p_segment10 in varchar2 default hr_api.g_varchar2
1155: --,p_segment11 in varchar2 default hr_api.g_varchar2
1148: --,p_segment4 in varchar2 default hr_api.g_varchar2
1149: --,p_segment5 in varchar2 default hr_api.g_varchar2
1150: --,p_segment6 in varchar2 default hr_api.g_varchar2
1151: --,p_segment7 in varchar2 default hr_api.g_varchar2
1152: --,p_segment8 in varchar2 default hr_api.g_varchar2
1153: --,p_segment9 in varchar2 default hr_api.g_varchar2
1154: --,p_segment10 in varchar2 default hr_api.g_varchar2
1155: --,p_segment11 in varchar2 default hr_api.g_varchar2
1156: --,p_segment12 in varchar2 default hr_api.g_varchar2
1149: --,p_segment5 in varchar2 default hr_api.g_varchar2
1150: --,p_segment6 in varchar2 default hr_api.g_varchar2
1151: --,p_segment7 in varchar2 default hr_api.g_varchar2
1152: --,p_segment8 in varchar2 default hr_api.g_varchar2
1153: --,p_segment9 in varchar2 default hr_api.g_varchar2
1154: --,p_segment10 in varchar2 default hr_api.g_varchar2
1155: --,p_segment11 in varchar2 default hr_api.g_varchar2
1156: --,p_segment12 in varchar2 default hr_api.g_varchar2
1157: --,p_segment13 in varchar2 default hr_api.g_varchar2
1150: --,p_segment6 in varchar2 default hr_api.g_varchar2
1151: --,p_segment7 in varchar2 default hr_api.g_varchar2
1152: --,p_segment8 in varchar2 default hr_api.g_varchar2
1153: --,p_segment9 in varchar2 default hr_api.g_varchar2
1154: --,p_segment10 in varchar2 default hr_api.g_varchar2
1155: --,p_segment11 in varchar2 default hr_api.g_varchar2
1156: --,p_segment12 in varchar2 default hr_api.g_varchar2
1157: --,p_segment13 in varchar2 default hr_api.g_varchar2
1158: --,p_segment14 in varchar2 default hr_api.g_varchar2
1151: --,p_segment7 in varchar2 default hr_api.g_varchar2
1152: --,p_segment8 in varchar2 default hr_api.g_varchar2
1153: --,p_segment9 in varchar2 default hr_api.g_varchar2
1154: --,p_segment10 in varchar2 default hr_api.g_varchar2
1155: --,p_segment11 in varchar2 default hr_api.g_varchar2
1156: --,p_segment12 in varchar2 default hr_api.g_varchar2
1157: --,p_segment13 in varchar2 default hr_api.g_varchar2
1158: --,p_segment14 in varchar2 default hr_api.g_varchar2
1159: --,p_segment15 in varchar2 default hr_api.g_varchar2
1152: --,p_segment8 in varchar2 default hr_api.g_varchar2
1153: --,p_segment9 in varchar2 default hr_api.g_varchar2
1154: --,p_segment10 in varchar2 default hr_api.g_varchar2
1155: --,p_segment11 in varchar2 default hr_api.g_varchar2
1156: --,p_segment12 in varchar2 default hr_api.g_varchar2
1157: --,p_segment13 in varchar2 default hr_api.g_varchar2
1158: --,p_segment14 in varchar2 default hr_api.g_varchar2
1159: --,p_segment15 in varchar2 default hr_api.g_varchar2
1160: --,p_segment16 in varchar2 default hr_api.g_varchar2
1153: --,p_segment9 in varchar2 default hr_api.g_varchar2
1154: --,p_segment10 in varchar2 default hr_api.g_varchar2
1155: --,p_segment11 in varchar2 default hr_api.g_varchar2
1156: --,p_segment12 in varchar2 default hr_api.g_varchar2
1157: --,p_segment13 in varchar2 default hr_api.g_varchar2
1158: --,p_segment14 in varchar2 default hr_api.g_varchar2
1159: --,p_segment15 in varchar2 default hr_api.g_varchar2
1160: --,p_segment16 in varchar2 default hr_api.g_varchar2
1161: --,p_segment17 in varchar2 default hr_api.g_varchar2
1154: --,p_segment10 in varchar2 default hr_api.g_varchar2
1155: --,p_segment11 in varchar2 default hr_api.g_varchar2
1156: --,p_segment12 in varchar2 default hr_api.g_varchar2
1157: --,p_segment13 in varchar2 default hr_api.g_varchar2
1158: --,p_segment14 in varchar2 default hr_api.g_varchar2
1159: --,p_segment15 in varchar2 default hr_api.g_varchar2
1160: --,p_segment16 in varchar2 default hr_api.g_varchar2
1161: --,p_segment17 in varchar2 default hr_api.g_varchar2
1162: --,p_segment18 in varchar2 default hr_api.g_varchar2
1155: --,p_segment11 in varchar2 default hr_api.g_varchar2
1156: --,p_segment12 in varchar2 default hr_api.g_varchar2
1157: --,p_segment13 in varchar2 default hr_api.g_varchar2
1158: --,p_segment14 in varchar2 default hr_api.g_varchar2
1159: --,p_segment15 in varchar2 default hr_api.g_varchar2
1160: --,p_segment16 in varchar2 default hr_api.g_varchar2
1161: --,p_segment17 in varchar2 default hr_api.g_varchar2
1162: --,p_segment18 in varchar2 default hr_api.g_varchar2
1163: --,p_segment19 in varchar2 default hr_api.g_varchar2
1156: --,p_segment12 in varchar2 default hr_api.g_varchar2
1157: --,p_segment13 in varchar2 default hr_api.g_varchar2
1158: --,p_segment14 in varchar2 default hr_api.g_varchar2
1159: --,p_segment15 in varchar2 default hr_api.g_varchar2
1160: --,p_segment16 in varchar2 default hr_api.g_varchar2
1161: --,p_segment17 in varchar2 default hr_api.g_varchar2
1162: --,p_segment18 in varchar2 default hr_api.g_varchar2
1163: --,p_segment19 in varchar2 default hr_api.g_varchar2
1164: --,p_segment20 in varchar2 default hr_api.g_varchar2
1157: --,p_segment13 in varchar2 default hr_api.g_varchar2
1158: --,p_segment14 in varchar2 default hr_api.g_varchar2
1159: --,p_segment15 in varchar2 default hr_api.g_varchar2
1160: --,p_segment16 in varchar2 default hr_api.g_varchar2
1161: --,p_segment17 in varchar2 default hr_api.g_varchar2
1162: --,p_segment18 in varchar2 default hr_api.g_varchar2
1163: --,p_segment19 in varchar2 default hr_api.g_varchar2
1164: --,p_segment20 in varchar2 default hr_api.g_varchar2
1165: --,p_segment21 in varchar2 default hr_api.g_varchar2
1158: --,p_segment14 in varchar2 default hr_api.g_varchar2
1159: --,p_segment15 in varchar2 default hr_api.g_varchar2
1160: --,p_segment16 in varchar2 default hr_api.g_varchar2
1161: --,p_segment17 in varchar2 default hr_api.g_varchar2
1162: --,p_segment18 in varchar2 default hr_api.g_varchar2
1163: --,p_segment19 in varchar2 default hr_api.g_varchar2
1164: --,p_segment20 in varchar2 default hr_api.g_varchar2
1165: --,p_segment21 in varchar2 default hr_api.g_varchar2
1166: --,p_segment22 in varchar2 default hr_api.g_varchar2
1159: --,p_segment15 in varchar2 default hr_api.g_varchar2
1160: --,p_segment16 in varchar2 default hr_api.g_varchar2
1161: --,p_segment17 in varchar2 default hr_api.g_varchar2
1162: --,p_segment18 in varchar2 default hr_api.g_varchar2
1163: --,p_segment19 in varchar2 default hr_api.g_varchar2
1164: --,p_segment20 in varchar2 default hr_api.g_varchar2
1165: --,p_segment21 in varchar2 default hr_api.g_varchar2
1166: --,p_segment22 in varchar2 default hr_api.g_varchar2
1167: --,p_segment23 in varchar2 default hr_api.g_varchar2
1160: --,p_segment16 in varchar2 default hr_api.g_varchar2
1161: --,p_segment17 in varchar2 default hr_api.g_varchar2
1162: --,p_segment18 in varchar2 default hr_api.g_varchar2
1163: --,p_segment19 in varchar2 default hr_api.g_varchar2
1164: --,p_segment20 in varchar2 default hr_api.g_varchar2
1165: --,p_segment21 in varchar2 default hr_api.g_varchar2
1166: --,p_segment22 in varchar2 default hr_api.g_varchar2
1167: --,p_segment23 in varchar2 default hr_api.g_varchar2
1168: --,p_segment24 in varchar2 default hr_api.g_varchar2
1161: --,p_segment17 in varchar2 default hr_api.g_varchar2
1162: --,p_segment18 in varchar2 default hr_api.g_varchar2
1163: --,p_segment19 in varchar2 default hr_api.g_varchar2
1164: --,p_segment20 in varchar2 default hr_api.g_varchar2
1165: --,p_segment21 in varchar2 default hr_api.g_varchar2
1166: --,p_segment22 in varchar2 default hr_api.g_varchar2
1167: --,p_segment23 in varchar2 default hr_api.g_varchar2
1168: --,p_segment24 in varchar2 default hr_api.g_varchar2
1169: --,p_segment25 in varchar2 default hr_api.g_varchar2
1162: --,p_segment18 in varchar2 default hr_api.g_varchar2
1163: --,p_segment19 in varchar2 default hr_api.g_varchar2
1164: --,p_segment20 in varchar2 default hr_api.g_varchar2
1165: --,p_segment21 in varchar2 default hr_api.g_varchar2
1166: --,p_segment22 in varchar2 default hr_api.g_varchar2
1167: --,p_segment23 in varchar2 default hr_api.g_varchar2
1168: --,p_segment24 in varchar2 default hr_api.g_varchar2
1169: --,p_segment25 in varchar2 default hr_api.g_varchar2
1170: --,p_segment26 in varchar2 default hr_api.g_varchar2
1163: --,p_segment19 in varchar2 default hr_api.g_varchar2
1164: --,p_segment20 in varchar2 default hr_api.g_varchar2
1165: --,p_segment21 in varchar2 default hr_api.g_varchar2
1166: --,p_segment22 in varchar2 default hr_api.g_varchar2
1167: --,p_segment23 in varchar2 default hr_api.g_varchar2
1168: --,p_segment24 in varchar2 default hr_api.g_varchar2
1169: --,p_segment25 in varchar2 default hr_api.g_varchar2
1170: --,p_segment26 in varchar2 default hr_api.g_varchar2
1171: --,p_segment27 in varchar2 default hr_api.g_varchar2
1164: --,p_segment20 in varchar2 default hr_api.g_varchar2
1165: --,p_segment21 in varchar2 default hr_api.g_varchar2
1166: --,p_segment22 in varchar2 default hr_api.g_varchar2
1167: --,p_segment23 in varchar2 default hr_api.g_varchar2
1168: --,p_segment24 in varchar2 default hr_api.g_varchar2
1169: --,p_segment25 in varchar2 default hr_api.g_varchar2
1170: --,p_segment26 in varchar2 default hr_api.g_varchar2
1171: --,p_segment27 in varchar2 default hr_api.g_varchar2
1172: --,p_segment28 in varchar2 default hr_api.g_varchar2
1165: --,p_segment21 in varchar2 default hr_api.g_varchar2
1166: --,p_segment22 in varchar2 default hr_api.g_varchar2
1167: --,p_segment23 in varchar2 default hr_api.g_varchar2
1168: --,p_segment24 in varchar2 default hr_api.g_varchar2
1169: --,p_segment25 in varchar2 default hr_api.g_varchar2
1170: --,p_segment26 in varchar2 default hr_api.g_varchar2
1171: --,p_segment27 in varchar2 default hr_api.g_varchar2
1172: --,p_segment28 in varchar2 default hr_api.g_varchar2
1173: --,p_segment29 in varchar2 default hr_api.g_varchar2
1166: --,p_segment22 in varchar2 default hr_api.g_varchar2
1167: --,p_segment23 in varchar2 default hr_api.g_varchar2
1168: --,p_segment24 in varchar2 default hr_api.g_varchar2
1169: --,p_segment25 in varchar2 default hr_api.g_varchar2
1170: --,p_segment26 in varchar2 default hr_api.g_varchar2
1171: --,p_segment27 in varchar2 default hr_api.g_varchar2
1172: --,p_segment28 in varchar2 default hr_api.g_varchar2
1173: --,p_segment29 in varchar2 default hr_api.g_varchar2
1174: --,p_segment30 in varchar2 default hr_api.g_varchar2
1167: --,p_segment23 in varchar2 default hr_api.g_varchar2
1168: --,p_segment24 in varchar2 default hr_api.g_varchar2
1169: --,p_segment25 in varchar2 default hr_api.g_varchar2
1170: --,p_segment26 in varchar2 default hr_api.g_varchar2
1171: --,p_segment27 in varchar2 default hr_api.g_varchar2
1172: --,p_segment28 in varchar2 default hr_api.g_varchar2
1173: --,p_segment29 in varchar2 default hr_api.g_varchar2
1174: --,p_segment30 in varchar2 default hr_api.g_varchar2
1175: ,p_template_tab_page_id in number default hr_api.g_number
1168: --,p_segment24 in varchar2 default hr_api.g_varchar2
1169: --,p_segment25 in varchar2 default hr_api.g_varchar2
1170: --,p_segment26 in varchar2 default hr_api.g_varchar2
1171: --,p_segment27 in varchar2 default hr_api.g_varchar2
1172: --,p_segment28 in varchar2 default hr_api.g_varchar2
1173: --,p_segment29 in varchar2 default hr_api.g_varchar2
1174: --,p_segment30 in varchar2 default hr_api.g_varchar2
1175: ,p_template_tab_page_id in number default hr_api.g_number
1176: ,p_alignment in number default hr_api.g_number
1169: --,p_segment25 in varchar2 default hr_api.g_varchar2
1170: --,p_segment26 in varchar2 default hr_api.g_varchar2
1171: --,p_segment27 in varchar2 default hr_api.g_varchar2
1172: --,p_segment28 in varchar2 default hr_api.g_varchar2
1173: --,p_segment29 in varchar2 default hr_api.g_varchar2
1174: --,p_segment30 in varchar2 default hr_api.g_varchar2
1175: ,p_template_tab_page_id in number default hr_api.g_number
1176: ,p_alignment in number default hr_api.g_number
1177: ,p_bevel in number default hr_api.g_number
1170: --,p_segment26 in varchar2 default hr_api.g_varchar2
1171: --,p_segment27 in varchar2 default hr_api.g_varchar2
1172: --,p_segment28 in varchar2 default hr_api.g_varchar2
1173: --,p_segment29 in varchar2 default hr_api.g_varchar2
1174: --,p_segment30 in varchar2 default hr_api.g_varchar2
1175: ,p_template_tab_page_id in number default hr_api.g_number
1176: ,p_alignment in number default hr_api.g_number
1177: ,p_bevel in number default hr_api.g_number
1178: ,p_case_restriction in number default hr_api.g_number
1171: --,p_segment27 in varchar2 default hr_api.g_varchar2
1172: --,p_segment28 in varchar2 default hr_api.g_varchar2
1173: --,p_segment29 in varchar2 default hr_api.g_varchar2
1174: --,p_segment30 in varchar2 default hr_api.g_varchar2
1175: ,p_template_tab_page_id in number default hr_api.g_number
1176: ,p_alignment in number default hr_api.g_number
1177: ,p_bevel in number default hr_api.g_number
1178: ,p_case_restriction in number default hr_api.g_number
1179: ,p_default_value in varchar2 default hr_api.g_varchar2
1172: --,p_segment28 in varchar2 default hr_api.g_varchar2
1173: --,p_segment29 in varchar2 default hr_api.g_varchar2
1174: --,p_segment30 in varchar2 default hr_api.g_varchar2
1175: ,p_template_tab_page_id in number default hr_api.g_number
1176: ,p_alignment in number default hr_api.g_number
1177: ,p_bevel in number default hr_api.g_number
1178: ,p_case_restriction in number default hr_api.g_number
1179: ,p_default_value in varchar2 default hr_api.g_varchar2
1180: ,p_enabled in number default hr_api.g_number
1173: --,p_segment29 in varchar2 default hr_api.g_varchar2
1174: --,p_segment30 in varchar2 default hr_api.g_varchar2
1175: ,p_template_tab_page_id in number default hr_api.g_number
1176: ,p_alignment in number default hr_api.g_number
1177: ,p_bevel in number default hr_api.g_number
1178: ,p_case_restriction in number default hr_api.g_number
1179: ,p_default_value in varchar2 default hr_api.g_varchar2
1180: ,p_enabled in number default hr_api.g_number
1181: ,p_format_mask in varchar2 default hr_api.g_varchar2
1174: --,p_segment30 in varchar2 default hr_api.g_varchar2
1175: ,p_template_tab_page_id in number default hr_api.g_number
1176: ,p_alignment in number default hr_api.g_number
1177: ,p_bevel in number default hr_api.g_number
1178: ,p_case_restriction in number default hr_api.g_number
1179: ,p_default_value in varchar2 default hr_api.g_varchar2
1180: ,p_enabled in number default hr_api.g_number
1181: ,p_format_mask in varchar2 default hr_api.g_varchar2
1182: ,p_height in number default hr_api.g_number
1175: ,p_template_tab_page_id in number default hr_api.g_number
1176: ,p_alignment in number default hr_api.g_number
1177: ,p_bevel in number default hr_api.g_number
1178: ,p_case_restriction in number default hr_api.g_number
1179: ,p_default_value in varchar2 default hr_api.g_varchar2
1180: ,p_enabled in number default hr_api.g_number
1181: ,p_format_mask in varchar2 default hr_api.g_varchar2
1182: ,p_height in number default hr_api.g_number
1183: ,p_information_formula_id in number default hr_api.g_number
1176: ,p_alignment in number default hr_api.g_number
1177: ,p_bevel in number default hr_api.g_number
1178: ,p_case_restriction in number default hr_api.g_number
1179: ,p_default_value in varchar2 default hr_api.g_varchar2
1180: ,p_enabled in number default hr_api.g_number
1181: ,p_format_mask in varchar2 default hr_api.g_varchar2
1182: ,p_height in number default hr_api.g_number
1183: ,p_information_formula_id in number default hr_api.g_number
1184: ,p_information_param_item_id1 in number default hr_api.g_number
1177: ,p_bevel in number default hr_api.g_number
1178: ,p_case_restriction in number default hr_api.g_number
1179: ,p_default_value in varchar2 default hr_api.g_varchar2
1180: ,p_enabled in number default hr_api.g_number
1181: ,p_format_mask in varchar2 default hr_api.g_varchar2
1182: ,p_height in number default hr_api.g_number
1183: ,p_information_formula_id in number default hr_api.g_number
1184: ,p_information_param_item_id1 in number default hr_api.g_number
1185: ,p_information_param_item_id2 in number default hr_api.g_number
1178: ,p_case_restriction in number default hr_api.g_number
1179: ,p_default_value in varchar2 default hr_api.g_varchar2
1180: ,p_enabled in number default hr_api.g_number
1181: ,p_format_mask in varchar2 default hr_api.g_varchar2
1182: ,p_height in number default hr_api.g_number
1183: ,p_information_formula_id in number default hr_api.g_number
1184: ,p_information_param_item_id1 in number default hr_api.g_number
1185: ,p_information_param_item_id2 in number default hr_api.g_number
1186: ,p_information_param_item_id3 in number default hr_api.g_number
1179: ,p_default_value in varchar2 default hr_api.g_varchar2
1180: ,p_enabled in number default hr_api.g_number
1181: ,p_format_mask in varchar2 default hr_api.g_varchar2
1182: ,p_height in number default hr_api.g_number
1183: ,p_information_formula_id in number default hr_api.g_number
1184: ,p_information_param_item_id1 in number default hr_api.g_number
1185: ,p_information_param_item_id2 in number default hr_api.g_number
1186: ,p_information_param_item_id3 in number default hr_api.g_number
1187: ,p_information_param_item_id4 in number default hr_api.g_number
1180: ,p_enabled in number default hr_api.g_number
1181: ,p_format_mask in varchar2 default hr_api.g_varchar2
1182: ,p_height in number default hr_api.g_number
1183: ,p_information_formula_id in number default hr_api.g_number
1184: ,p_information_param_item_id1 in number default hr_api.g_number
1185: ,p_information_param_item_id2 in number default hr_api.g_number
1186: ,p_information_param_item_id3 in number default hr_api.g_number
1187: ,p_information_param_item_id4 in number default hr_api.g_number
1188: ,p_information_param_item_id5 in number default hr_api.g_number
1181: ,p_format_mask in varchar2 default hr_api.g_varchar2
1182: ,p_height in number default hr_api.g_number
1183: ,p_information_formula_id in number default hr_api.g_number
1184: ,p_information_param_item_id1 in number default hr_api.g_number
1185: ,p_information_param_item_id2 in number default hr_api.g_number
1186: ,p_information_param_item_id3 in number default hr_api.g_number
1187: ,p_information_param_item_id4 in number default hr_api.g_number
1188: ,p_information_param_item_id5 in number default hr_api.g_number
1189: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1182: ,p_height in number default hr_api.g_number
1183: ,p_information_formula_id in number default hr_api.g_number
1184: ,p_information_param_item_id1 in number default hr_api.g_number
1185: ,p_information_param_item_id2 in number default hr_api.g_number
1186: ,p_information_param_item_id3 in number default hr_api.g_number
1187: ,p_information_param_item_id4 in number default hr_api.g_number
1188: ,p_information_param_item_id5 in number default hr_api.g_number
1189: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1190: ,p_insert_allowed in number default hr_api.g_number
1183: ,p_information_formula_id in number default hr_api.g_number
1184: ,p_information_param_item_id1 in number default hr_api.g_number
1185: ,p_information_param_item_id2 in number default hr_api.g_number
1186: ,p_information_param_item_id3 in number default hr_api.g_number
1187: ,p_information_param_item_id4 in number default hr_api.g_number
1188: ,p_information_param_item_id5 in number default hr_api.g_number
1189: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1190: ,p_insert_allowed in number default hr_api.g_number
1191: ,p_label in varchar2 default hr_api.g_varchar2
1184: ,p_information_param_item_id1 in number default hr_api.g_number
1185: ,p_information_param_item_id2 in number default hr_api.g_number
1186: ,p_information_param_item_id3 in number default hr_api.g_number
1187: ,p_information_param_item_id4 in number default hr_api.g_number
1188: ,p_information_param_item_id5 in number default hr_api.g_number
1189: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1190: ,p_insert_allowed in number default hr_api.g_number
1191: ,p_label in varchar2 default hr_api.g_varchar2
1192: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1185: ,p_information_param_item_id2 in number default hr_api.g_number
1186: ,p_information_param_item_id3 in number default hr_api.g_number
1187: ,p_information_param_item_id4 in number default hr_api.g_number
1188: ,p_information_param_item_id5 in number default hr_api.g_number
1189: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1190: ,p_insert_allowed in number default hr_api.g_number
1191: ,p_label in varchar2 default hr_api.g_varchar2
1192: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1193: ,p_prompt_alignment_offset in number default hr_api.g_number
1186: ,p_information_param_item_id3 in number default hr_api.g_number
1187: ,p_information_param_item_id4 in number default hr_api.g_number
1188: ,p_information_param_item_id5 in number default hr_api.g_number
1189: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1190: ,p_insert_allowed in number default hr_api.g_number
1191: ,p_label in varchar2 default hr_api.g_varchar2
1192: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1193: ,p_prompt_alignment_offset in number default hr_api.g_number
1194: ,p_prompt_display_style in number default hr_api.g_number
1187: ,p_information_param_item_id4 in number default hr_api.g_number
1188: ,p_information_param_item_id5 in number default hr_api.g_number
1189: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1190: ,p_insert_allowed in number default hr_api.g_number
1191: ,p_label in varchar2 default hr_api.g_varchar2
1192: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1193: ,p_prompt_alignment_offset in number default hr_api.g_number
1194: ,p_prompt_display_style in number default hr_api.g_number
1195: ,p_prompt_edge in number default hr_api.g_number
1188: ,p_information_param_item_id5 in number default hr_api.g_number
1189: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1190: ,p_insert_allowed in number default hr_api.g_number
1191: ,p_label in varchar2 default hr_api.g_varchar2
1192: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1193: ,p_prompt_alignment_offset in number default hr_api.g_number
1194: ,p_prompt_display_style in number default hr_api.g_number
1195: ,p_prompt_edge in number default hr_api.g_number
1196: ,p_prompt_edge_alignment in number default hr_api.g_number
1189: ,p_information_prompt in varchar2 default hr_api.g_varchar2
1190: ,p_insert_allowed in number default hr_api.g_number
1191: ,p_label in varchar2 default hr_api.g_varchar2
1192: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1193: ,p_prompt_alignment_offset in number default hr_api.g_number
1194: ,p_prompt_display_style in number default hr_api.g_number
1195: ,p_prompt_edge in number default hr_api.g_number
1196: ,p_prompt_edge_alignment in number default hr_api.g_number
1197: ,p_prompt_edge_offset in number default hr_api.g_number
1190: ,p_insert_allowed in number default hr_api.g_number
1191: ,p_label in varchar2 default hr_api.g_varchar2
1192: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1193: ,p_prompt_alignment_offset in number default hr_api.g_number
1194: ,p_prompt_display_style in number default hr_api.g_number
1195: ,p_prompt_edge in number default hr_api.g_number
1196: ,p_prompt_edge_alignment in number default hr_api.g_number
1197: ,p_prompt_edge_offset in number default hr_api.g_number
1198: ,p_prompt_text_alignment in number default hr_api.g_number
1191: ,p_label in varchar2 default hr_api.g_varchar2
1192: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1193: ,p_prompt_alignment_offset in number default hr_api.g_number
1194: ,p_prompt_display_style in number default hr_api.g_number
1195: ,p_prompt_edge in number default hr_api.g_number
1196: ,p_prompt_edge_alignment in number default hr_api.g_number
1197: ,p_prompt_edge_offset in number default hr_api.g_number
1198: ,p_prompt_text_alignment in number default hr_api.g_number
1199: ,p_query_allowed in number default hr_api.g_number
1192: ,p_prompt_text in varchar2 default hr_api.g_varchar2
1193: ,p_prompt_alignment_offset in number default hr_api.g_number
1194: ,p_prompt_display_style in number default hr_api.g_number
1195: ,p_prompt_edge in number default hr_api.g_number
1196: ,p_prompt_edge_alignment in number default hr_api.g_number
1197: ,p_prompt_edge_offset in number default hr_api.g_number
1198: ,p_prompt_text_alignment in number default hr_api.g_number
1199: ,p_query_allowed in number default hr_api.g_number
1200: ,p_required in number default hr_api.g_number
1193: ,p_prompt_alignment_offset in number default hr_api.g_number
1194: ,p_prompt_display_style in number default hr_api.g_number
1195: ,p_prompt_edge in number default hr_api.g_number
1196: ,p_prompt_edge_alignment in number default hr_api.g_number
1197: ,p_prompt_edge_offset in number default hr_api.g_number
1198: ,p_prompt_text_alignment in number default hr_api.g_number
1199: ,p_query_allowed in number default hr_api.g_number
1200: ,p_required in number default hr_api.g_number
1201: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1194: ,p_prompt_display_style in number default hr_api.g_number
1195: ,p_prompt_edge in number default hr_api.g_number
1196: ,p_prompt_edge_alignment in number default hr_api.g_number
1197: ,p_prompt_edge_offset in number default hr_api.g_number
1198: ,p_prompt_text_alignment in number default hr_api.g_number
1199: ,p_query_allowed in number default hr_api.g_number
1200: ,p_required in number default hr_api.g_number
1201: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1202: ,p_update_allowed in number default hr_api.g_number
1195: ,p_prompt_edge in number default hr_api.g_number
1196: ,p_prompt_edge_alignment in number default hr_api.g_number
1197: ,p_prompt_edge_offset in number default hr_api.g_number
1198: ,p_prompt_text_alignment in number default hr_api.g_number
1199: ,p_query_allowed in number default hr_api.g_number
1200: ,p_required in number default hr_api.g_number
1201: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1202: ,p_update_allowed in number default hr_api.g_number
1203: ,p_validation_formula_id in number default hr_api.g_number
1196: ,p_prompt_edge_alignment in number default hr_api.g_number
1197: ,p_prompt_edge_offset in number default hr_api.g_number
1198: ,p_prompt_text_alignment in number default hr_api.g_number
1199: ,p_query_allowed in number default hr_api.g_number
1200: ,p_required in number default hr_api.g_number
1201: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1202: ,p_update_allowed in number default hr_api.g_number
1203: ,p_validation_formula_id in number default hr_api.g_number
1204: ,p_validation_param_item_id1 in number default hr_api.g_number
1197: ,p_prompt_edge_offset in number default hr_api.g_number
1198: ,p_prompt_text_alignment in number default hr_api.g_number
1199: ,p_query_allowed in number default hr_api.g_number
1200: ,p_required in number default hr_api.g_number
1201: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1202: ,p_update_allowed in number default hr_api.g_number
1203: ,p_validation_formula_id in number default hr_api.g_number
1204: ,p_validation_param_item_id1 in number default hr_api.g_number
1205: ,p_validation_param_item_id2 in number default hr_api.g_number
1198: ,p_prompt_text_alignment in number default hr_api.g_number
1199: ,p_query_allowed in number default hr_api.g_number
1200: ,p_required in number default hr_api.g_number
1201: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1202: ,p_update_allowed in number default hr_api.g_number
1203: ,p_validation_formula_id in number default hr_api.g_number
1204: ,p_validation_param_item_id1 in number default hr_api.g_number
1205: ,p_validation_param_item_id2 in number default hr_api.g_number
1206: ,p_validation_param_item_id3 in number default hr_api.g_number
1199: ,p_query_allowed in number default hr_api.g_number
1200: ,p_required in number default hr_api.g_number
1201: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1202: ,p_update_allowed in number default hr_api.g_number
1203: ,p_validation_formula_id in number default hr_api.g_number
1204: ,p_validation_param_item_id1 in number default hr_api.g_number
1205: ,p_validation_param_item_id2 in number default hr_api.g_number
1206: ,p_validation_param_item_id3 in number default hr_api.g_number
1207: ,p_validation_param_item_id4 in number default hr_api.g_number
1200: ,p_required in number default hr_api.g_number
1201: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1202: ,p_update_allowed in number default hr_api.g_number
1203: ,p_validation_formula_id in number default hr_api.g_number
1204: ,p_validation_param_item_id1 in number default hr_api.g_number
1205: ,p_validation_param_item_id2 in number default hr_api.g_number
1206: ,p_validation_param_item_id3 in number default hr_api.g_number
1207: ,p_validation_param_item_id4 in number default hr_api.g_number
1208: ,p_validation_param_item_id5 in number default hr_api.g_number
1201: ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1202: ,p_update_allowed in number default hr_api.g_number
1203: ,p_validation_formula_id in number default hr_api.g_number
1204: ,p_validation_param_item_id1 in number default hr_api.g_number
1205: ,p_validation_param_item_id2 in number default hr_api.g_number
1206: ,p_validation_param_item_id3 in number default hr_api.g_number
1207: ,p_validation_param_item_id4 in number default hr_api.g_number
1208: ,p_validation_param_item_id5 in number default hr_api.g_number
1209: ,p_visible in number default hr_api.g_number
1202: ,p_update_allowed in number default hr_api.g_number
1203: ,p_validation_formula_id in number default hr_api.g_number
1204: ,p_validation_param_item_id1 in number default hr_api.g_number
1205: ,p_validation_param_item_id2 in number default hr_api.g_number
1206: ,p_validation_param_item_id3 in number default hr_api.g_number
1207: ,p_validation_param_item_id4 in number default hr_api.g_number
1208: ,p_validation_param_item_id5 in number default hr_api.g_number
1209: ,p_visible in number default hr_api.g_number
1210: ,p_width in number default hr_api.g_number
1203: ,p_validation_formula_id in number default hr_api.g_number
1204: ,p_validation_param_item_id1 in number default hr_api.g_number
1205: ,p_validation_param_item_id2 in number default hr_api.g_number
1206: ,p_validation_param_item_id3 in number default hr_api.g_number
1207: ,p_validation_param_item_id4 in number default hr_api.g_number
1208: ,p_validation_param_item_id5 in number default hr_api.g_number
1209: ,p_visible in number default hr_api.g_number
1210: ,p_width in number default hr_api.g_number
1211: ,p_x_position in number default hr_api.g_number
1204: ,p_validation_param_item_id1 in number default hr_api.g_number
1205: ,p_validation_param_item_id2 in number default hr_api.g_number
1206: ,p_validation_param_item_id3 in number default hr_api.g_number
1207: ,p_validation_param_item_id4 in number default hr_api.g_number
1208: ,p_validation_param_item_id5 in number default hr_api.g_number
1209: ,p_visible in number default hr_api.g_number
1210: ,p_width in number default hr_api.g_number
1211: ,p_x_position in number default hr_api.g_number
1212: ,p_y_position in number default hr_api.g_number
1205: ,p_validation_param_item_id2 in number default hr_api.g_number
1206: ,p_validation_param_item_id3 in number default hr_api.g_number
1207: ,p_validation_param_item_id4 in number default hr_api.g_number
1208: ,p_validation_param_item_id5 in number default hr_api.g_number
1209: ,p_visible in number default hr_api.g_number
1210: ,p_width in number default hr_api.g_number
1211: ,p_x_position in number default hr_api.g_number
1212: ,p_y_position in number default hr_api.g_number
1213: ,p_information_category in varchar2 default hr_api.g_varchar2
1206: ,p_validation_param_item_id3 in number default hr_api.g_number
1207: ,p_validation_param_item_id4 in number default hr_api.g_number
1208: ,p_validation_param_item_id5 in number default hr_api.g_number
1209: ,p_visible in number default hr_api.g_number
1210: ,p_width in number default hr_api.g_number
1211: ,p_x_position in number default hr_api.g_number
1212: ,p_y_position in number default hr_api.g_number
1213: ,p_information_category in varchar2 default hr_api.g_varchar2
1214: ,p_information1 in varchar2 default hr_api.g_varchar2
1207: ,p_validation_param_item_id4 in number default hr_api.g_number
1208: ,p_validation_param_item_id5 in number default hr_api.g_number
1209: ,p_visible in number default hr_api.g_number
1210: ,p_width in number default hr_api.g_number
1211: ,p_x_position in number default hr_api.g_number
1212: ,p_y_position in number default hr_api.g_number
1213: ,p_information_category in varchar2 default hr_api.g_varchar2
1214: ,p_information1 in varchar2 default hr_api.g_varchar2
1215: ,p_information2 in varchar2 default hr_api.g_varchar2
1208: ,p_validation_param_item_id5 in number default hr_api.g_number
1209: ,p_visible in number default hr_api.g_number
1210: ,p_width in number default hr_api.g_number
1211: ,p_x_position in number default hr_api.g_number
1212: ,p_y_position in number default hr_api.g_number
1213: ,p_information_category in varchar2 default hr_api.g_varchar2
1214: ,p_information1 in varchar2 default hr_api.g_varchar2
1215: ,p_information2 in varchar2 default hr_api.g_varchar2
1216: ,p_information3 in varchar2 default hr_api.g_varchar2
1209: ,p_visible in number default hr_api.g_number
1210: ,p_width in number default hr_api.g_number
1211: ,p_x_position in number default hr_api.g_number
1212: ,p_y_position in number default hr_api.g_number
1213: ,p_information_category in varchar2 default hr_api.g_varchar2
1214: ,p_information1 in varchar2 default hr_api.g_varchar2
1215: ,p_information2 in varchar2 default hr_api.g_varchar2
1216: ,p_information3 in varchar2 default hr_api.g_varchar2
1217: ,p_information4 in varchar2 default hr_api.g_varchar2
1210: ,p_width in number default hr_api.g_number
1211: ,p_x_position in number default hr_api.g_number
1212: ,p_y_position in number default hr_api.g_number
1213: ,p_information_category in varchar2 default hr_api.g_varchar2
1214: ,p_information1 in varchar2 default hr_api.g_varchar2
1215: ,p_information2 in varchar2 default hr_api.g_varchar2
1216: ,p_information3 in varchar2 default hr_api.g_varchar2
1217: ,p_information4 in varchar2 default hr_api.g_varchar2
1218: ,p_information5 in varchar2 default hr_api.g_varchar2
1211: ,p_x_position in number default hr_api.g_number
1212: ,p_y_position in number default hr_api.g_number
1213: ,p_information_category in varchar2 default hr_api.g_varchar2
1214: ,p_information1 in varchar2 default hr_api.g_varchar2
1215: ,p_information2 in varchar2 default hr_api.g_varchar2
1216: ,p_information3 in varchar2 default hr_api.g_varchar2
1217: ,p_information4 in varchar2 default hr_api.g_varchar2
1218: ,p_information5 in varchar2 default hr_api.g_varchar2
1219: ,p_information6 in varchar2 default hr_api.g_varchar2
1212: ,p_y_position in number default hr_api.g_number
1213: ,p_information_category in varchar2 default hr_api.g_varchar2
1214: ,p_information1 in varchar2 default hr_api.g_varchar2
1215: ,p_information2 in varchar2 default hr_api.g_varchar2
1216: ,p_information3 in varchar2 default hr_api.g_varchar2
1217: ,p_information4 in varchar2 default hr_api.g_varchar2
1218: ,p_information5 in varchar2 default hr_api.g_varchar2
1219: ,p_information6 in varchar2 default hr_api.g_varchar2
1220: ,p_information7 in varchar2 default hr_api.g_varchar2
1213: ,p_information_category in varchar2 default hr_api.g_varchar2
1214: ,p_information1 in varchar2 default hr_api.g_varchar2
1215: ,p_information2 in varchar2 default hr_api.g_varchar2
1216: ,p_information3 in varchar2 default hr_api.g_varchar2
1217: ,p_information4 in varchar2 default hr_api.g_varchar2
1218: ,p_information5 in varchar2 default hr_api.g_varchar2
1219: ,p_information6 in varchar2 default hr_api.g_varchar2
1220: ,p_information7 in varchar2 default hr_api.g_varchar2
1221: ,p_information8 in varchar2 default hr_api.g_varchar2
1214: ,p_information1 in varchar2 default hr_api.g_varchar2
1215: ,p_information2 in varchar2 default hr_api.g_varchar2
1216: ,p_information3 in varchar2 default hr_api.g_varchar2
1217: ,p_information4 in varchar2 default hr_api.g_varchar2
1218: ,p_information5 in varchar2 default hr_api.g_varchar2
1219: ,p_information6 in varchar2 default hr_api.g_varchar2
1220: ,p_information7 in varchar2 default hr_api.g_varchar2
1221: ,p_information8 in varchar2 default hr_api.g_varchar2
1222: ,p_information9 in varchar2 default hr_api.g_varchar2
1215: ,p_information2 in varchar2 default hr_api.g_varchar2
1216: ,p_information3 in varchar2 default hr_api.g_varchar2
1217: ,p_information4 in varchar2 default hr_api.g_varchar2
1218: ,p_information5 in varchar2 default hr_api.g_varchar2
1219: ,p_information6 in varchar2 default hr_api.g_varchar2
1220: ,p_information7 in varchar2 default hr_api.g_varchar2
1221: ,p_information8 in varchar2 default hr_api.g_varchar2
1222: ,p_information9 in varchar2 default hr_api.g_varchar2
1223: ,p_information10 in varchar2 default hr_api.g_varchar2
1216: ,p_information3 in varchar2 default hr_api.g_varchar2
1217: ,p_information4 in varchar2 default hr_api.g_varchar2
1218: ,p_information5 in varchar2 default hr_api.g_varchar2
1219: ,p_information6 in varchar2 default hr_api.g_varchar2
1220: ,p_information7 in varchar2 default hr_api.g_varchar2
1221: ,p_information8 in varchar2 default hr_api.g_varchar2
1222: ,p_information9 in varchar2 default hr_api.g_varchar2
1223: ,p_information10 in varchar2 default hr_api.g_varchar2
1224: ,p_information11 in varchar2 default hr_api.g_varchar2
1217: ,p_information4 in varchar2 default hr_api.g_varchar2
1218: ,p_information5 in varchar2 default hr_api.g_varchar2
1219: ,p_information6 in varchar2 default hr_api.g_varchar2
1220: ,p_information7 in varchar2 default hr_api.g_varchar2
1221: ,p_information8 in varchar2 default hr_api.g_varchar2
1222: ,p_information9 in varchar2 default hr_api.g_varchar2
1223: ,p_information10 in varchar2 default hr_api.g_varchar2
1224: ,p_information11 in varchar2 default hr_api.g_varchar2
1225: ,p_information12 in varchar2 default hr_api.g_varchar2
1218: ,p_information5 in varchar2 default hr_api.g_varchar2
1219: ,p_information6 in varchar2 default hr_api.g_varchar2
1220: ,p_information7 in varchar2 default hr_api.g_varchar2
1221: ,p_information8 in varchar2 default hr_api.g_varchar2
1222: ,p_information9 in varchar2 default hr_api.g_varchar2
1223: ,p_information10 in varchar2 default hr_api.g_varchar2
1224: ,p_information11 in varchar2 default hr_api.g_varchar2
1225: ,p_information12 in varchar2 default hr_api.g_varchar2
1226: ,p_information13 in varchar2 default hr_api.g_varchar2
1219: ,p_information6 in varchar2 default hr_api.g_varchar2
1220: ,p_information7 in varchar2 default hr_api.g_varchar2
1221: ,p_information8 in varchar2 default hr_api.g_varchar2
1222: ,p_information9 in varchar2 default hr_api.g_varchar2
1223: ,p_information10 in varchar2 default hr_api.g_varchar2
1224: ,p_information11 in varchar2 default hr_api.g_varchar2
1225: ,p_information12 in varchar2 default hr_api.g_varchar2
1226: ,p_information13 in varchar2 default hr_api.g_varchar2
1227: ,p_information14 in varchar2 default hr_api.g_varchar2
1220: ,p_information7 in varchar2 default hr_api.g_varchar2
1221: ,p_information8 in varchar2 default hr_api.g_varchar2
1222: ,p_information9 in varchar2 default hr_api.g_varchar2
1223: ,p_information10 in varchar2 default hr_api.g_varchar2
1224: ,p_information11 in varchar2 default hr_api.g_varchar2
1225: ,p_information12 in varchar2 default hr_api.g_varchar2
1226: ,p_information13 in varchar2 default hr_api.g_varchar2
1227: ,p_information14 in varchar2 default hr_api.g_varchar2
1228: ,p_information15 in varchar2 default hr_api.g_varchar2
1221: ,p_information8 in varchar2 default hr_api.g_varchar2
1222: ,p_information9 in varchar2 default hr_api.g_varchar2
1223: ,p_information10 in varchar2 default hr_api.g_varchar2
1224: ,p_information11 in varchar2 default hr_api.g_varchar2
1225: ,p_information12 in varchar2 default hr_api.g_varchar2
1226: ,p_information13 in varchar2 default hr_api.g_varchar2
1227: ,p_information14 in varchar2 default hr_api.g_varchar2
1228: ,p_information15 in varchar2 default hr_api.g_varchar2
1229: ,p_information16 in varchar2 default hr_api.g_varchar2
1222: ,p_information9 in varchar2 default hr_api.g_varchar2
1223: ,p_information10 in varchar2 default hr_api.g_varchar2
1224: ,p_information11 in varchar2 default hr_api.g_varchar2
1225: ,p_information12 in varchar2 default hr_api.g_varchar2
1226: ,p_information13 in varchar2 default hr_api.g_varchar2
1227: ,p_information14 in varchar2 default hr_api.g_varchar2
1228: ,p_information15 in varchar2 default hr_api.g_varchar2
1229: ,p_information16 in varchar2 default hr_api.g_varchar2
1230: ,p_information17 in varchar2 default hr_api.g_varchar2
1223: ,p_information10 in varchar2 default hr_api.g_varchar2
1224: ,p_information11 in varchar2 default hr_api.g_varchar2
1225: ,p_information12 in varchar2 default hr_api.g_varchar2
1226: ,p_information13 in varchar2 default hr_api.g_varchar2
1227: ,p_information14 in varchar2 default hr_api.g_varchar2
1228: ,p_information15 in varchar2 default hr_api.g_varchar2
1229: ,p_information16 in varchar2 default hr_api.g_varchar2
1230: ,p_information17 in varchar2 default hr_api.g_varchar2
1231: ,p_information18 in varchar2 default hr_api.g_varchar2
1224: ,p_information11 in varchar2 default hr_api.g_varchar2
1225: ,p_information12 in varchar2 default hr_api.g_varchar2
1226: ,p_information13 in varchar2 default hr_api.g_varchar2
1227: ,p_information14 in varchar2 default hr_api.g_varchar2
1228: ,p_information15 in varchar2 default hr_api.g_varchar2
1229: ,p_information16 in varchar2 default hr_api.g_varchar2
1230: ,p_information17 in varchar2 default hr_api.g_varchar2
1231: ,p_information18 in varchar2 default hr_api.g_varchar2
1232: ,p_information19 in varchar2 default hr_api.g_varchar2
1225: ,p_information12 in varchar2 default hr_api.g_varchar2
1226: ,p_information13 in varchar2 default hr_api.g_varchar2
1227: ,p_information14 in varchar2 default hr_api.g_varchar2
1228: ,p_information15 in varchar2 default hr_api.g_varchar2
1229: ,p_information16 in varchar2 default hr_api.g_varchar2
1230: ,p_information17 in varchar2 default hr_api.g_varchar2
1231: ,p_information18 in varchar2 default hr_api.g_varchar2
1232: ,p_information19 in varchar2 default hr_api.g_varchar2
1233: ,p_information20 in varchar2 default hr_api.g_varchar2
1226: ,p_information13 in varchar2 default hr_api.g_varchar2
1227: ,p_information14 in varchar2 default hr_api.g_varchar2
1228: ,p_information15 in varchar2 default hr_api.g_varchar2
1229: ,p_information16 in varchar2 default hr_api.g_varchar2
1230: ,p_information17 in varchar2 default hr_api.g_varchar2
1231: ,p_information18 in varchar2 default hr_api.g_varchar2
1232: ,p_information19 in varchar2 default hr_api.g_varchar2
1233: ,p_information20 in varchar2 default hr_api.g_varchar2
1234: ,p_information21 in varchar2 default hr_api.g_varchar2
1227: ,p_information14 in varchar2 default hr_api.g_varchar2
1228: ,p_information15 in varchar2 default hr_api.g_varchar2
1229: ,p_information16 in varchar2 default hr_api.g_varchar2
1230: ,p_information17 in varchar2 default hr_api.g_varchar2
1231: ,p_information18 in varchar2 default hr_api.g_varchar2
1232: ,p_information19 in varchar2 default hr_api.g_varchar2
1233: ,p_information20 in varchar2 default hr_api.g_varchar2
1234: ,p_information21 in varchar2 default hr_api.g_varchar2
1235: ,p_information22 in varchar2 default hr_api.g_varchar2
1228: ,p_information15 in varchar2 default hr_api.g_varchar2
1229: ,p_information16 in varchar2 default hr_api.g_varchar2
1230: ,p_information17 in varchar2 default hr_api.g_varchar2
1231: ,p_information18 in varchar2 default hr_api.g_varchar2
1232: ,p_information19 in varchar2 default hr_api.g_varchar2
1233: ,p_information20 in varchar2 default hr_api.g_varchar2
1234: ,p_information21 in varchar2 default hr_api.g_varchar2
1235: ,p_information22 in varchar2 default hr_api.g_varchar2
1236: ,p_information23 in varchar2 default hr_api.g_varchar2
1229: ,p_information16 in varchar2 default hr_api.g_varchar2
1230: ,p_information17 in varchar2 default hr_api.g_varchar2
1231: ,p_information18 in varchar2 default hr_api.g_varchar2
1232: ,p_information19 in varchar2 default hr_api.g_varchar2
1233: ,p_information20 in varchar2 default hr_api.g_varchar2
1234: ,p_information21 in varchar2 default hr_api.g_varchar2
1235: ,p_information22 in varchar2 default hr_api.g_varchar2
1236: ,p_information23 in varchar2 default hr_api.g_varchar2
1237: ,p_information24 in varchar2 default hr_api.g_varchar2
1230: ,p_information17 in varchar2 default hr_api.g_varchar2
1231: ,p_information18 in varchar2 default hr_api.g_varchar2
1232: ,p_information19 in varchar2 default hr_api.g_varchar2
1233: ,p_information20 in varchar2 default hr_api.g_varchar2
1234: ,p_information21 in varchar2 default hr_api.g_varchar2
1235: ,p_information22 in varchar2 default hr_api.g_varchar2
1236: ,p_information23 in varchar2 default hr_api.g_varchar2
1237: ,p_information24 in varchar2 default hr_api.g_varchar2
1238: ,p_information25 in varchar2 default hr_api.g_varchar2
1231: ,p_information18 in varchar2 default hr_api.g_varchar2
1232: ,p_information19 in varchar2 default hr_api.g_varchar2
1233: ,p_information20 in varchar2 default hr_api.g_varchar2
1234: ,p_information21 in varchar2 default hr_api.g_varchar2
1235: ,p_information22 in varchar2 default hr_api.g_varchar2
1236: ,p_information23 in varchar2 default hr_api.g_varchar2
1237: ,p_information24 in varchar2 default hr_api.g_varchar2
1238: ,p_information25 in varchar2 default hr_api.g_varchar2
1239: ,p_information26 in varchar2 default hr_api.g_varchar2
1232: ,p_information19 in varchar2 default hr_api.g_varchar2
1233: ,p_information20 in varchar2 default hr_api.g_varchar2
1234: ,p_information21 in varchar2 default hr_api.g_varchar2
1235: ,p_information22 in varchar2 default hr_api.g_varchar2
1236: ,p_information23 in varchar2 default hr_api.g_varchar2
1237: ,p_information24 in varchar2 default hr_api.g_varchar2
1238: ,p_information25 in varchar2 default hr_api.g_varchar2
1239: ,p_information26 in varchar2 default hr_api.g_varchar2
1240: ,p_information27 in varchar2 default hr_api.g_varchar2
1233: ,p_information20 in varchar2 default hr_api.g_varchar2
1234: ,p_information21 in varchar2 default hr_api.g_varchar2
1235: ,p_information22 in varchar2 default hr_api.g_varchar2
1236: ,p_information23 in varchar2 default hr_api.g_varchar2
1237: ,p_information24 in varchar2 default hr_api.g_varchar2
1238: ,p_information25 in varchar2 default hr_api.g_varchar2
1239: ,p_information26 in varchar2 default hr_api.g_varchar2
1240: ,p_information27 in varchar2 default hr_api.g_varchar2
1241: ,p_information28 in varchar2 default hr_api.g_varchar2
1234: ,p_information21 in varchar2 default hr_api.g_varchar2
1235: ,p_information22 in varchar2 default hr_api.g_varchar2
1236: ,p_information23 in varchar2 default hr_api.g_varchar2
1237: ,p_information24 in varchar2 default hr_api.g_varchar2
1238: ,p_information25 in varchar2 default hr_api.g_varchar2
1239: ,p_information26 in varchar2 default hr_api.g_varchar2
1240: ,p_information27 in varchar2 default hr_api.g_varchar2
1241: ,p_information28 in varchar2 default hr_api.g_varchar2
1242: ,p_information29 in varchar2 default hr_api.g_varchar2
1235: ,p_information22 in varchar2 default hr_api.g_varchar2
1236: ,p_information23 in varchar2 default hr_api.g_varchar2
1237: ,p_information24 in varchar2 default hr_api.g_varchar2
1238: ,p_information25 in varchar2 default hr_api.g_varchar2
1239: ,p_information26 in varchar2 default hr_api.g_varchar2
1240: ,p_information27 in varchar2 default hr_api.g_varchar2
1241: ,p_information28 in varchar2 default hr_api.g_varchar2
1242: ,p_information29 in varchar2 default hr_api.g_varchar2
1243: ,p_information30 in varchar2 default hr_api.g_varchar2
1236: ,p_information23 in varchar2 default hr_api.g_varchar2
1237: ,p_information24 in varchar2 default hr_api.g_varchar2
1238: ,p_information25 in varchar2 default hr_api.g_varchar2
1239: ,p_information26 in varchar2 default hr_api.g_varchar2
1240: ,p_information27 in varchar2 default hr_api.g_varchar2
1241: ,p_information28 in varchar2 default hr_api.g_varchar2
1242: ,p_information29 in varchar2 default hr_api.g_varchar2
1243: ,p_information30 in varchar2 default hr_api.g_varchar2
1244: ,p_next_navigation_item_id in number default hr_api.g_number
1237: ,p_information24 in varchar2 default hr_api.g_varchar2
1238: ,p_information25 in varchar2 default hr_api.g_varchar2
1239: ,p_information26 in varchar2 default hr_api.g_varchar2
1240: ,p_information27 in varchar2 default hr_api.g_varchar2
1241: ,p_information28 in varchar2 default hr_api.g_varchar2
1242: ,p_information29 in varchar2 default hr_api.g_varchar2
1243: ,p_information30 in varchar2 default hr_api.g_varchar2
1244: ,p_next_navigation_item_id in number default hr_api.g_number
1245: ,p_previous_navigation_item_id in number default hr_api.g_number
1238: ,p_information25 in varchar2 default hr_api.g_varchar2
1239: ,p_information26 in varchar2 default hr_api.g_varchar2
1240: ,p_information27 in varchar2 default hr_api.g_varchar2
1241: ,p_information28 in varchar2 default hr_api.g_varchar2
1242: ,p_information29 in varchar2 default hr_api.g_varchar2
1243: ,p_information30 in varchar2 default hr_api.g_varchar2
1244: ,p_next_navigation_item_id in number default hr_api.g_number
1245: ,p_previous_navigation_item_id in number default hr_api.g_number
1246: --,p_item_context_id out number
1239: ,p_information26 in varchar2 default hr_api.g_varchar2
1240: ,p_information27 in varchar2 default hr_api.g_varchar2
1241: ,p_information28 in varchar2 default hr_api.g_varchar2
1242: ,p_information29 in varchar2 default hr_api.g_varchar2
1243: ,p_information30 in varchar2 default hr_api.g_varchar2
1244: ,p_next_navigation_item_id in number default hr_api.g_number
1245: ,p_previous_navigation_item_id in number default hr_api.g_number
1246: --,p_item_context_id out number
1247: --,p_concatenated_segments out varchar2
1240: ,p_information27 in varchar2 default hr_api.g_varchar2
1241: ,p_information28 in varchar2 default hr_api.g_varchar2
1242: ,p_information29 in varchar2 default hr_api.g_varchar2
1243: ,p_information30 in varchar2 default hr_api.g_varchar2
1244: ,p_next_navigation_item_id in number default hr_api.g_number
1245: ,p_previous_navigation_item_id in number default hr_api.g_number
1246: --,p_item_context_id out number
1247: --,p_concatenated_segments out varchar2
1248: ,p_override_value_warning out nocopy boolean
1241: ,p_information28 in varchar2 default hr_api.g_varchar2
1242: ,p_information29 in varchar2 default hr_api.g_varchar2
1243: ,p_information30 in varchar2 default hr_api.g_varchar2
1244: ,p_next_navigation_item_id in number default hr_api.g_number
1245: ,p_previous_navigation_item_id in number default hr_api.g_number
1246: --,p_item_context_id out number
1247: --,p_concatenated_segments out varchar2
1248: ,p_override_value_warning out nocopy boolean
1249: ) is
1280: AND tic.template_item_context_id = p_template_item_context_id;
1281:
1282: --CURSOR cur_context
1283: --IS
1284: --SELECT DECODE(context_type,hr_api.g_varchar2,context_type,p_context_type)
1285: --FROM hr_template_item_contexts_b
1286: --WHERE template_item_context_id = p_template_item_context_id;
1287:
1288: --l_context_type varchar2(30);
1310: -- instead of p_language_code from now on, to allow an IN OUT parameter to
1311: -- be passed through.
1312: --
1313: l_language_code := p_language_code;
1314: hr_api.validate_language_code(p_language_code => l_language_code);
1315: --
1316: hr_utility.set_location(l_proc, 20);
1317: --
1318: --
1426: ,p_information30 => p_information30
1427: ,p_next_navigation_item_id => p_next_navigation_item_id
1428: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
1429: exception
1430: when hr_api.cannot_find_prog_unit then
1431: hr_api.cannot_find_prog_unit_error
1432: (p_module_name => 'update_template_item_context'
1433: ,p_hook_type => 'BP'
1434: );
1427: ,p_next_navigation_item_id => p_next_navigation_item_id
1428: ,p_previous_navigation_item_id => p_previous_navigation_item_id);
1429: exception
1430: when hr_api.cannot_find_prog_unit then
1431: hr_api.cannot_find_prog_unit_error
1432: (p_module_name => 'update_template_item_context'
1433: ,p_hook_type => 'BP'
1434: );
1435: end;
1443: CLOSE cur_override;
1444:
1445: hr_utility.set_location('At:'|| l_proc, 20);
1446:
1447: IF p_required <> hr_api.g_number AND
1448: ( l_required_override is not null AND p_required is not null ) THEN
1449: l_override_value_warning := TRUE;
1450: END IF;
1451:
1450: END IF;
1451:
1452: hr_utility.set_location('At:'|| l_proc, 25);
1453:
1454: IF p_visible <> hr_api.g_number AND
1455: ( l_visible_override is not null AND p_visible is not null ) THEN
1456: l_override_value_warning := TRUE;
1457: END IF;
1458:
1721: --,p_item_context_id => l_item_context_id
1722: --,p_concatenated_segments => l_concatenated_segments
1723: ,p_override_value_warning => l_override_value_warning);
1724: exception
1725: when hr_api.cannot_find_prog_unit then
1726: hr_api.cannot_find_prog_unit_error
1727: (p_module_name => 'update_template_item_context'
1728: ,p_hook_type => 'AP'
1729: );
1722: --,p_concatenated_segments => l_concatenated_segments
1723: ,p_override_value_warning => l_override_value_warning);
1724: exception
1725: when hr_api.cannot_find_prog_unit then
1726: hr_api.cannot_find_prog_unit_error
1727: (p_module_name => 'update_template_item_context'
1728: ,p_hook_type => 'AP'
1729: );
1730: end;
1733: --
1734: hr_utility.set_location('At:'|| l_proc, 55);
1735:
1736: if p_validate then
1737: raise hr_api.validate_enabled;
1738: end if;
1739: --
1740: -- Set all output arguments
1741: --
1745: p_object_version_number := l_object_version_number;
1746: --
1747: hr_utility.set_location(' Leaving:'||l_proc, 70);
1748: exception
1749: when hr_api.validate_enabled then
1750: --
1751: -- As the Validate_Enabled exception has been raised
1752: -- we must rollback to the savepoint
1753: --