[Home] [Help]
1: Package Body hr_item_properties_bsi as
2: /* $Header: hritpbsi.pkb 120.0 2005/05/31 00:59:30 appldev noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: hritpbsi.pkb 120.0 2005/05/31 00:59:30 appldev noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_item_properties_bsi.';
7: --
8: -- ----------------------------------------------------------------------------
9: PROCEDURE update_radio_button_property
10: (p_effective_date IN DATE
39: (p_form_item_id IN NUMBER
40: )
41: IS
42: SELECT itp.item_property_id
43: FROM hr_item_properties_b itp
44: ,hr_form_items_b fi2
45: ,hr_form_items_b fi1
46: WHERE itp.form_item_id = fi2.form_item_id
47: AND fi2.application_id = fi1.application_id
54: (p_template_item_id IN NUMBER
55: )
56: IS
57: SELECT itp.item_property_id
58: FROM hr_item_properties_b itp
59: ,hr_template_items_b ti2
60: ,hr_form_items_b fi2
61: ,hr_form_items_b fi1
62: ,hr_template_items_b ti1
74: (p_template_item_context_id IN NUMBER
75: )
76: IS
77: SELECT itp.item_property_id
78: FROM hr_item_properties_b itp
79: ,hr_template_item_contexts_b tc2
80: ,hr_template_items_b ti2
81: ,hr_form_items_b fi2
82: ,hr_form_items_b fi1
513:
514: CURSOR cur_item_prop_1
515: IS
516: SELECT item_property_id
517: FROM hr_item_properties_b
518: WHERE form_item_id = p_form_item_id;
519:
520: CURSOR cur_item_prop_2
521: IS
519:
520: CURSOR cur_item_prop_2
521: IS
522: SELECT item_property_id
523: FROM hr_item_properties_b
524: WHERE template_item_id = p_template_item_id;
525:
526: CURSOR cur_item_prop_3
527: IS
525:
526: CURSOR cur_item_prop_3
527: IS
528: SELECT item_property_id
529: FROM hr_item_properties_b
530: WHERE template_item_context_id = p_template_item_context_id;
531:
532: l_item_property_id number;
533: l_proc varchar2(72) := g_package||'update_item_property';
785:
786: CURSOR cur_item_prop_1
787: IS
788: SELECT item_property_id
789: FROM hr_item_properties_b
790: WHERE form_item_id = p_form_item_id;
791:
792: CURSOR cur_item_prop_2
793: IS
791:
792: CURSOR cur_item_prop_2
793: IS
794: SELECT item_property_id
795: FROM hr_item_properties_b
796: WHERE template_item_id = p_template_item_id;
797:
798: CURSOR cur_item_prop_3
799: IS
797:
798: CURSOR cur_item_prop_3
799: IS
800: SELECT item_property_id
801: FROM hr_item_properties_b
802: WHERE template_item_context_id = p_template_item_context_id;
803:
804: l_item_property_id number;
805: l_proc varchar2(72) := g_package||'delete_item_property';
1017: -- Declare cursors and local variables
1018: --
1019:
1020: Type l_rec_type Is Record
1021: (alignment hr_item_properties_b.alignment%TYPE
1022: ,bevel hr_item_properties_b.bevel%TYPE
1023: ,case_restriction hr_item_properties_b.case_restriction%TYPE
1024: ,enabled hr_item_properties_b.enabled%TYPE
1025: ,format_mask hr_item_properties_b.format_mask%TYPE
1018: --
1019:
1020: Type l_rec_type Is Record
1021: (alignment hr_item_properties_b.alignment%TYPE
1022: ,bevel hr_item_properties_b.bevel%TYPE
1023: ,case_restriction hr_item_properties_b.case_restriction%TYPE
1024: ,enabled hr_item_properties_b.enabled%TYPE
1025: ,format_mask hr_item_properties_b.format_mask%TYPE
1026: ,height hr_item_properties_b.height%TYPE
1019:
1020: Type l_rec_type Is Record
1021: (alignment hr_item_properties_b.alignment%TYPE
1022: ,bevel hr_item_properties_b.bevel%TYPE
1023: ,case_restriction hr_item_properties_b.case_restriction%TYPE
1024: ,enabled hr_item_properties_b.enabled%TYPE
1025: ,format_mask hr_item_properties_b.format_mask%TYPE
1026: ,height hr_item_properties_b.height%TYPE
1027: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1020: Type l_rec_type Is Record
1021: (alignment hr_item_properties_b.alignment%TYPE
1022: ,bevel hr_item_properties_b.bevel%TYPE
1023: ,case_restriction hr_item_properties_b.case_restriction%TYPE
1024: ,enabled hr_item_properties_b.enabled%TYPE
1025: ,format_mask hr_item_properties_b.format_mask%TYPE
1026: ,height hr_item_properties_b.height%TYPE
1027: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1028: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1021: (alignment hr_item_properties_b.alignment%TYPE
1022: ,bevel hr_item_properties_b.bevel%TYPE
1023: ,case_restriction hr_item_properties_b.case_restriction%TYPE
1024: ,enabled hr_item_properties_b.enabled%TYPE
1025: ,format_mask hr_item_properties_b.format_mask%TYPE
1026: ,height hr_item_properties_b.height%TYPE
1027: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1028: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1029: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1022: ,bevel hr_item_properties_b.bevel%TYPE
1023: ,case_restriction hr_item_properties_b.case_restriction%TYPE
1024: ,enabled hr_item_properties_b.enabled%TYPE
1025: ,format_mask hr_item_properties_b.format_mask%TYPE
1026: ,height hr_item_properties_b.height%TYPE
1027: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1028: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1029: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1030: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1023: ,case_restriction hr_item_properties_b.case_restriction%TYPE
1024: ,enabled hr_item_properties_b.enabled%TYPE
1025: ,format_mask hr_item_properties_b.format_mask%TYPE
1026: ,height hr_item_properties_b.height%TYPE
1027: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1028: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1029: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1030: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1031: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1024: ,enabled hr_item_properties_b.enabled%TYPE
1025: ,format_mask hr_item_properties_b.format_mask%TYPE
1026: ,height hr_item_properties_b.height%TYPE
1027: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1028: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1029: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1030: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1031: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1032: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1025: ,format_mask hr_item_properties_b.format_mask%TYPE
1026: ,height hr_item_properties_b.height%TYPE
1027: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1028: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1029: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1030: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1031: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1032: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1033: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1026: ,height hr_item_properties_b.height%TYPE
1027: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1028: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1029: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1030: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1031: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1032: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1033: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1034: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1027: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1028: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1029: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1030: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1031: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1032: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1033: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1034: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1035: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1028: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1029: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1030: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1031: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1032: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1033: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1034: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1035: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1036: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1029: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1030: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1031: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1032: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1033: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1034: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1035: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1036: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1037: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1030: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1031: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1032: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1033: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1034: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1035: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1036: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1037: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1038: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1031: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1032: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1033: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1034: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1035: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1036: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1037: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1038: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1039: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1032: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1033: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1034: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1035: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1036: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1037: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1038: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1039: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1040: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1033: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1034: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1035: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1036: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1037: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1038: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1039: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1040: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1041: ,required hr_item_properties_b.required%TYPE
1034: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1035: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1036: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1037: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1038: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1039: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1040: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1041: ,required hr_item_properties_b.required%TYPE
1042: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1035: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1036: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1037: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1038: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1039: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1040: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1041: ,required hr_item_properties_b.required%TYPE
1042: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1043: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1036: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1037: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1038: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1039: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1040: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1041: ,required hr_item_properties_b.required%TYPE
1042: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1043: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1044: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1037: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1038: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1039: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1040: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1041: ,required hr_item_properties_b.required%TYPE
1042: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1043: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1044: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1045: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1038: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1039: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1040: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1041: ,required hr_item_properties_b.required%TYPE
1042: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1043: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1044: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1045: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1046: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1039: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1040: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1041: ,required hr_item_properties_b.required%TYPE
1042: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1043: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1044: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1045: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1046: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1047: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1040: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1041: ,required hr_item_properties_b.required%TYPE
1042: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1043: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1044: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1045: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1046: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1047: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1048: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1041: ,required hr_item_properties_b.required%TYPE
1042: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1043: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1044: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1045: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1046: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1047: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1048: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1049: ,visible hr_item_properties_b.visible%TYPE
1042: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1043: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1044: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1045: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1046: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1047: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1048: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1049: ,visible hr_item_properties_b.visible%TYPE
1050: ,width hr_item_properties_b.width%TYPE
1043: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1044: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1045: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1046: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1047: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1048: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1049: ,visible hr_item_properties_b.visible%TYPE
1050: ,width hr_item_properties_b.width%TYPE
1051: ,x_position hr_item_properties_b.x_position%TYPE
1044: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1045: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1046: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1047: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1048: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1049: ,visible hr_item_properties_b.visible%TYPE
1050: ,width hr_item_properties_b.width%TYPE
1051: ,x_position hr_item_properties_b.x_position%TYPE
1052: ,y_position hr_item_properties_b.y_position%TYPE
1045: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1046: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1047: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1048: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1049: ,visible hr_item_properties_b.visible%TYPE
1050: ,width hr_item_properties_b.width%TYPE
1051: ,x_position hr_item_properties_b.x_position%TYPE
1052: ,y_position hr_item_properties_b.y_position%TYPE
1053: ,information_category hr_item_properties_b.information_category%TYPE
1046: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1047: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1048: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1049: ,visible hr_item_properties_b.visible%TYPE
1050: ,width hr_item_properties_b.width%TYPE
1051: ,x_position hr_item_properties_b.x_position%TYPE
1052: ,y_position hr_item_properties_b.y_position%TYPE
1053: ,information_category hr_item_properties_b.information_category%TYPE
1054: ,information1 hr_item_properties_b.information1%TYPE
1047: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1048: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1049: ,visible hr_item_properties_b.visible%TYPE
1050: ,width hr_item_properties_b.width%TYPE
1051: ,x_position hr_item_properties_b.x_position%TYPE
1052: ,y_position hr_item_properties_b.y_position%TYPE
1053: ,information_category hr_item_properties_b.information_category%TYPE
1054: ,information1 hr_item_properties_b.information1%TYPE
1055: ,information2 hr_item_properties_b.information2%TYPE
1048: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1049: ,visible hr_item_properties_b.visible%TYPE
1050: ,width hr_item_properties_b.width%TYPE
1051: ,x_position hr_item_properties_b.x_position%TYPE
1052: ,y_position hr_item_properties_b.y_position%TYPE
1053: ,information_category hr_item_properties_b.information_category%TYPE
1054: ,information1 hr_item_properties_b.information1%TYPE
1055: ,information2 hr_item_properties_b.information2%TYPE
1056: ,information3 hr_item_properties_b.information3%TYPE
1049: ,visible hr_item_properties_b.visible%TYPE
1050: ,width hr_item_properties_b.width%TYPE
1051: ,x_position hr_item_properties_b.x_position%TYPE
1052: ,y_position hr_item_properties_b.y_position%TYPE
1053: ,information_category hr_item_properties_b.information_category%TYPE
1054: ,information1 hr_item_properties_b.information1%TYPE
1055: ,information2 hr_item_properties_b.information2%TYPE
1056: ,information3 hr_item_properties_b.information3%TYPE
1057: ,information4 hr_item_properties_b.information4%TYPE
1050: ,width hr_item_properties_b.width%TYPE
1051: ,x_position hr_item_properties_b.x_position%TYPE
1052: ,y_position hr_item_properties_b.y_position%TYPE
1053: ,information_category hr_item_properties_b.information_category%TYPE
1054: ,information1 hr_item_properties_b.information1%TYPE
1055: ,information2 hr_item_properties_b.information2%TYPE
1056: ,information3 hr_item_properties_b.information3%TYPE
1057: ,information4 hr_item_properties_b.information4%TYPE
1058: ,information5 hr_item_properties_b.information5%TYPE
1051: ,x_position hr_item_properties_b.x_position%TYPE
1052: ,y_position hr_item_properties_b.y_position%TYPE
1053: ,information_category hr_item_properties_b.information_category%TYPE
1054: ,information1 hr_item_properties_b.information1%TYPE
1055: ,information2 hr_item_properties_b.information2%TYPE
1056: ,information3 hr_item_properties_b.information3%TYPE
1057: ,information4 hr_item_properties_b.information4%TYPE
1058: ,information5 hr_item_properties_b.information5%TYPE
1059: ,information6 hr_item_properties_b.information6%TYPE
1052: ,y_position hr_item_properties_b.y_position%TYPE
1053: ,information_category hr_item_properties_b.information_category%TYPE
1054: ,information1 hr_item_properties_b.information1%TYPE
1055: ,information2 hr_item_properties_b.information2%TYPE
1056: ,information3 hr_item_properties_b.information3%TYPE
1057: ,information4 hr_item_properties_b.information4%TYPE
1058: ,information5 hr_item_properties_b.information5%TYPE
1059: ,information6 hr_item_properties_b.information6%TYPE
1060: ,information7 hr_item_properties_b.information7%TYPE
1053: ,information_category hr_item_properties_b.information_category%TYPE
1054: ,information1 hr_item_properties_b.information1%TYPE
1055: ,information2 hr_item_properties_b.information2%TYPE
1056: ,information3 hr_item_properties_b.information3%TYPE
1057: ,information4 hr_item_properties_b.information4%TYPE
1058: ,information5 hr_item_properties_b.information5%TYPE
1059: ,information6 hr_item_properties_b.information6%TYPE
1060: ,information7 hr_item_properties_b.information7%TYPE
1061: ,information8 hr_item_properties_b.information8%TYPE
1054: ,information1 hr_item_properties_b.information1%TYPE
1055: ,information2 hr_item_properties_b.information2%TYPE
1056: ,information3 hr_item_properties_b.information3%TYPE
1057: ,information4 hr_item_properties_b.information4%TYPE
1058: ,information5 hr_item_properties_b.information5%TYPE
1059: ,information6 hr_item_properties_b.information6%TYPE
1060: ,information7 hr_item_properties_b.information7%TYPE
1061: ,information8 hr_item_properties_b.information8%TYPE
1062: ,information9 hr_item_properties_b.information9%TYPE
1055: ,information2 hr_item_properties_b.information2%TYPE
1056: ,information3 hr_item_properties_b.information3%TYPE
1057: ,information4 hr_item_properties_b.information4%TYPE
1058: ,information5 hr_item_properties_b.information5%TYPE
1059: ,information6 hr_item_properties_b.information6%TYPE
1060: ,information7 hr_item_properties_b.information7%TYPE
1061: ,information8 hr_item_properties_b.information8%TYPE
1062: ,information9 hr_item_properties_b.information9%TYPE
1063: ,information10 hr_item_properties_b.information10%TYPE
1056: ,information3 hr_item_properties_b.information3%TYPE
1057: ,information4 hr_item_properties_b.information4%TYPE
1058: ,information5 hr_item_properties_b.information5%TYPE
1059: ,information6 hr_item_properties_b.information6%TYPE
1060: ,information7 hr_item_properties_b.information7%TYPE
1061: ,information8 hr_item_properties_b.information8%TYPE
1062: ,information9 hr_item_properties_b.information9%TYPE
1063: ,information10 hr_item_properties_b.information10%TYPE
1064: ,information11 hr_item_properties_b.information11%TYPE
1057: ,information4 hr_item_properties_b.information4%TYPE
1058: ,information5 hr_item_properties_b.information5%TYPE
1059: ,information6 hr_item_properties_b.information6%TYPE
1060: ,information7 hr_item_properties_b.information7%TYPE
1061: ,information8 hr_item_properties_b.information8%TYPE
1062: ,information9 hr_item_properties_b.information9%TYPE
1063: ,information10 hr_item_properties_b.information10%TYPE
1064: ,information11 hr_item_properties_b.information11%TYPE
1065: ,information12 hr_item_properties_b.information12%TYPE
1058: ,information5 hr_item_properties_b.information5%TYPE
1059: ,information6 hr_item_properties_b.information6%TYPE
1060: ,information7 hr_item_properties_b.information7%TYPE
1061: ,information8 hr_item_properties_b.information8%TYPE
1062: ,information9 hr_item_properties_b.information9%TYPE
1063: ,information10 hr_item_properties_b.information10%TYPE
1064: ,information11 hr_item_properties_b.information11%TYPE
1065: ,information12 hr_item_properties_b.information12%TYPE
1066: ,information13 hr_item_properties_b.information13%TYPE
1059: ,information6 hr_item_properties_b.information6%TYPE
1060: ,information7 hr_item_properties_b.information7%TYPE
1061: ,information8 hr_item_properties_b.information8%TYPE
1062: ,information9 hr_item_properties_b.information9%TYPE
1063: ,information10 hr_item_properties_b.information10%TYPE
1064: ,information11 hr_item_properties_b.information11%TYPE
1065: ,information12 hr_item_properties_b.information12%TYPE
1066: ,information13 hr_item_properties_b.information13%TYPE
1067: ,information14 hr_item_properties_b.information14%TYPE
1060: ,information7 hr_item_properties_b.information7%TYPE
1061: ,information8 hr_item_properties_b.information8%TYPE
1062: ,information9 hr_item_properties_b.information9%TYPE
1063: ,information10 hr_item_properties_b.information10%TYPE
1064: ,information11 hr_item_properties_b.information11%TYPE
1065: ,information12 hr_item_properties_b.information12%TYPE
1066: ,information13 hr_item_properties_b.information13%TYPE
1067: ,information14 hr_item_properties_b.information14%TYPE
1068: ,information15 hr_item_properties_b.information15%TYPE
1061: ,information8 hr_item_properties_b.information8%TYPE
1062: ,information9 hr_item_properties_b.information9%TYPE
1063: ,information10 hr_item_properties_b.information10%TYPE
1064: ,information11 hr_item_properties_b.information11%TYPE
1065: ,information12 hr_item_properties_b.information12%TYPE
1066: ,information13 hr_item_properties_b.information13%TYPE
1067: ,information14 hr_item_properties_b.information14%TYPE
1068: ,information15 hr_item_properties_b.information15%TYPE
1069: ,information16 hr_item_properties_b.information16%TYPE
1062: ,information9 hr_item_properties_b.information9%TYPE
1063: ,information10 hr_item_properties_b.information10%TYPE
1064: ,information11 hr_item_properties_b.information11%TYPE
1065: ,information12 hr_item_properties_b.information12%TYPE
1066: ,information13 hr_item_properties_b.information13%TYPE
1067: ,information14 hr_item_properties_b.information14%TYPE
1068: ,information15 hr_item_properties_b.information15%TYPE
1069: ,information16 hr_item_properties_b.information16%TYPE
1070: ,information17 hr_item_properties_b.information17%TYPE
1063: ,information10 hr_item_properties_b.information10%TYPE
1064: ,information11 hr_item_properties_b.information11%TYPE
1065: ,information12 hr_item_properties_b.information12%TYPE
1066: ,information13 hr_item_properties_b.information13%TYPE
1067: ,information14 hr_item_properties_b.information14%TYPE
1068: ,information15 hr_item_properties_b.information15%TYPE
1069: ,information16 hr_item_properties_b.information16%TYPE
1070: ,information17 hr_item_properties_b.information17%TYPE
1071: ,information18 hr_item_properties_b.information18%TYPE
1064: ,information11 hr_item_properties_b.information11%TYPE
1065: ,information12 hr_item_properties_b.information12%TYPE
1066: ,information13 hr_item_properties_b.information13%TYPE
1067: ,information14 hr_item_properties_b.information14%TYPE
1068: ,information15 hr_item_properties_b.information15%TYPE
1069: ,information16 hr_item_properties_b.information16%TYPE
1070: ,information17 hr_item_properties_b.information17%TYPE
1071: ,information18 hr_item_properties_b.information18%TYPE
1072: ,information19 hr_item_properties_b.information19%TYPE
1065: ,information12 hr_item_properties_b.information12%TYPE
1066: ,information13 hr_item_properties_b.information13%TYPE
1067: ,information14 hr_item_properties_b.information14%TYPE
1068: ,information15 hr_item_properties_b.information15%TYPE
1069: ,information16 hr_item_properties_b.information16%TYPE
1070: ,information17 hr_item_properties_b.information17%TYPE
1071: ,information18 hr_item_properties_b.information18%TYPE
1072: ,information19 hr_item_properties_b.information19%TYPE
1073: ,information20 hr_item_properties_b.information20%TYPE
1066: ,information13 hr_item_properties_b.information13%TYPE
1067: ,information14 hr_item_properties_b.information14%TYPE
1068: ,information15 hr_item_properties_b.information15%TYPE
1069: ,information16 hr_item_properties_b.information16%TYPE
1070: ,information17 hr_item_properties_b.information17%TYPE
1071: ,information18 hr_item_properties_b.information18%TYPE
1072: ,information19 hr_item_properties_b.information19%TYPE
1073: ,information20 hr_item_properties_b.information20%TYPE
1074: ,information21 hr_item_properties_b.information21%TYPE
1067: ,information14 hr_item_properties_b.information14%TYPE
1068: ,information15 hr_item_properties_b.information15%TYPE
1069: ,information16 hr_item_properties_b.information16%TYPE
1070: ,information17 hr_item_properties_b.information17%TYPE
1071: ,information18 hr_item_properties_b.information18%TYPE
1072: ,information19 hr_item_properties_b.information19%TYPE
1073: ,information20 hr_item_properties_b.information20%TYPE
1074: ,information21 hr_item_properties_b.information21%TYPE
1075: ,information22 hr_item_properties_b.information22%TYPE
1068: ,information15 hr_item_properties_b.information15%TYPE
1069: ,information16 hr_item_properties_b.information16%TYPE
1070: ,information17 hr_item_properties_b.information17%TYPE
1071: ,information18 hr_item_properties_b.information18%TYPE
1072: ,information19 hr_item_properties_b.information19%TYPE
1073: ,information20 hr_item_properties_b.information20%TYPE
1074: ,information21 hr_item_properties_b.information21%TYPE
1075: ,information22 hr_item_properties_b.information22%TYPE
1076: ,information23 hr_item_properties_b.information23%TYPE
1069: ,information16 hr_item_properties_b.information16%TYPE
1070: ,information17 hr_item_properties_b.information17%TYPE
1071: ,information18 hr_item_properties_b.information18%TYPE
1072: ,information19 hr_item_properties_b.information19%TYPE
1073: ,information20 hr_item_properties_b.information20%TYPE
1074: ,information21 hr_item_properties_b.information21%TYPE
1075: ,information22 hr_item_properties_b.information22%TYPE
1076: ,information23 hr_item_properties_b.information23%TYPE
1077: ,information24 hr_item_properties_b.information24%TYPE
1070: ,information17 hr_item_properties_b.information17%TYPE
1071: ,information18 hr_item_properties_b.information18%TYPE
1072: ,information19 hr_item_properties_b.information19%TYPE
1073: ,information20 hr_item_properties_b.information20%TYPE
1074: ,information21 hr_item_properties_b.information21%TYPE
1075: ,information22 hr_item_properties_b.information22%TYPE
1076: ,information23 hr_item_properties_b.information23%TYPE
1077: ,information24 hr_item_properties_b.information24%TYPE
1078: ,information25 hr_item_properties_b.information25%TYPE
1071: ,information18 hr_item_properties_b.information18%TYPE
1072: ,information19 hr_item_properties_b.information19%TYPE
1073: ,information20 hr_item_properties_b.information20%TYPE
1074: ,information21 hr_item_properties_b.information21%TYPE
1075: ,information22 hr_item_properties_b.information22%TYPE
1076: ,information23 hr_item_properties_b.information23%TYPE
1077: ,information24 hr_item_properties_b.information24%TYPE
1078: ,information25 hr_item_properties_b.information25%TYPE
1079: ,information26 hr_item_properties_b.information26%TYPE
1072: ,information19 hr_item_properties_b.information19%TYPE
1073: ,information20 hr_item_properties_b.information20%TYPE
1074: ,information21 hr_item_properties_b.information21%TYPE
1075: ,information22 hr_item_properties_b.information22%TYPE
1076: ,information23 hr_item_properties_b.information23%TYPE
1077: ,information24 hr_item_properties_b.information24%TYPE
1078: ,information25 hr_item_properties_b.information25%TYPE
1079: ,information26 hr_item_properties_b.information26%TYPE
1080: ,information27 hr_item_properties_b.information27%TYPE
1073: ,information20 hr_item_properties_b.information20%TYPE
1074: ,information21 hr_item_properties_b.information21%TYPE
1075: ,information22 hr_item_properties_b.information22%TYPE
1076: ,information23 hr_item_properties_b.information23%TYPE
1077: ,information24 hr_item_properties_b.information24%TYPE
1078: ,information25 hr_item_properties_b.information25%TYPE
1079: ,information26 hr_item_properties_b.information26%TYPE
1080: ,information27 hr_item_properties_b.information27%TYPE
1081: ,information28 hr_item_properties_b.information28%TYPE
1074: ,information21 hr_item_properties_b.information21%TYPE
1075: ,information22 hr_item_properties_b.information22%TYPE
1076: ,information23 hr_item_properties_b.information23%TYPE
1077: ,information24 hr_item_properties_b.information24%TYPE
1078: ,information25 hr_item_properties_b.information25%TYPE
1079: ,information26 hr_item_properties_b.information26%TYPE
1080: ,information27 hr_item_properties_b.information27%TYPE
1081: ,information28 hr_item_properties_b.information28%TYPE
1082: ,information29 hr_item_properties_b.information29%TYPE
1075: ,information22 hr_item_properties_b.information22%TYPE
1076: ,information23 hr_item_properties_b.information23%TYPE
1077: ,information24 hr_item_properties_b.information24%TYPE
1078: ,information25 hr_item_properties_b.information25%TYPE
1079: ,information26 hr_item_properties_b.information26%TYPE
1080: ,information27 hr_item_properties_b.information27%TYPE
1081: ,information28 hr_item_properties_b.information28%TYPE
1082: ,information29 hr_item_properties_b.information29%TYPE
1083: ,information30 hr_item_properties_b.information30%TYPE
1076: ,information23 hr_item_properties_b.information23%TYPE
1077: ,information24 hr_item_properties_b.information24%TYPE
1078: ,information25 hr_item_properties_b.information25%TYPE
1079: ,information26 hr_item_properties_b.information26%TYPE
1080: ,information27 hr_item_properties_b.information27%TYPE
1081: ,information28 hr_item_properties_b.information28%TYPE
1082: ,information29 hr_item_properties_b.information29%TYPE
1083: ,information30 hr_item_properties_b.information30%TYPE
1084: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
1077: ,information24 hr_item_properties_b.information24%TYPE
1078: ,information25 hr_item_properties_b.information25%TYPE
1079: ,information26 hr_item_properties_b.information26%TYPE
1080: ,information27 hr_item_properties_b.information27%TYPE
1081: ,information28 hr_item_properties_b.information28%TYPE
1082: ,information29 hr_item_properties_b.information29%TYPE
1083: ,information30 hr_item_properties_b.information30%TYPE
1084: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
1085: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
1078: ,information25 hr_item_properties_b.information25%TYPE
1079: ,information26 hr_item_properties_b.information26%TYPE
1080: ,information27 hr_item_properties_b.information27%TYPE
1081: ,information28 hr_item_properties_b.information28%TYPE
1082: ,information29 hr_item_properties_b.information29%TYPE
1083: ,information30 hr_item_properties_b.information30%TYPE
1084: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
1085: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
1086: );
1079: ,information26 hr_item_properties_b.information26%TYPE
1080: ,information27 hr_item_properties_b.information27%TYPE
1081: ,information28 hr_item_properties_b.information28%TYPE
1082: ,information29 hr_item_properties_b.information29%TYPE
1083: ,information30 hr_item_properties_b.information30%TYPE
1084: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
1085: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
1086: );
1087:
1080: ,information27 hr_item_properties_b.information27%TYPE
1081: ,information28 hr_item_properties_b.information28%TYPE
1082: ,information29 hr_item_properties_b.information29%TYPE
1083: ,information30 hr_item_properties_b.information30%TYPE
1084: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
1085: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
1086: );
1087:
1088: l_rec l_rec_type;
1081: ,information28 hr_item_properties_b.information28%TYPE
1082: ,information29 hr_item_properties_b.information29%TYPE
1083: ,information30 hr_item_properties_b.information30%TYPE
1084: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
1085: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
1086: );
1087:
1088: l_rec l_rec_type;
1089:
1162: ,DECODE(p_information29,hr_api.g_varchar2,itp.information29,p_information29)
1163: ,DECODE(p_information30,hr_api.g_varchar2,itp.information30,p_information30)
1164: ,DECODE(p_next_navigation_item_id,hr_api.g_number,itp.next_navigation_item_id,p_next_navigation_item_id)
1165: ,DECODE(p_previous_navigation_item_id,hr_api.g_number,itp.previous_navigation_item_id,p_previous_navigation_item_id)
1166: FROM hr_item_properties_b itp
1167: , hr_form_items_b hfi
1168: WHERE itp.form_item_id (+) = hfi.form_item_id
1169: AND hfi.form_item_id = p_form_item_id;
1170:
1177: ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label) label
1178: ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text) prompt_text
1179: ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text) tooltip_text
1180: FROM hr_item_properties_tl itptl
1181: ,hr_item_properties_b itp
1182: WHERE itptl.item_property_id = itp.item_property_id
1183: AND itp.form_item_id = p_form_item_id
1184: GROUP BY itptl.source_lang
1185: ,DECODE(p_default_value,hr_api.g_varchar2,itptl.default_value,p_default_value)
1519: -- Declare cursors and local variables
1520: --
1521:
1522: Type l_rec_type Is Record
1523: (alignment hr_item_properties_b.alignment%TYPE
1524: ,bevel hr_item_properties_b.bevel%TYPE
1525: ,case_restriction hr_item_properties_b.case_restriction%TYPE
1526: ,enabled hr_item_properties_b.enabled%TYPE
1527: ,format_mask hr_item_properties_b.format_mask%TYPE
1520: --
1521:
1522: Type l_rec_type Is Record
1523: (alignment hr_item_properties_b.alignment%TYPE
1524: ,bevel hr_item_properties_b.bevel%TYPE
1525: ,case_restriction hr_item_properties_b.case_restriction%TYPE
1526: ,enabled hr_item_properties_b.enabled%TYPE
1527: ,format_mask hr_item_properties_b.format_mask%TYPE
1528: ,height hr_item_properties_b.height%TYPE
1521:
1522: Type l_rec_type Is Record
1523: (alignment hr_item_properties_b.alignment%TYPE
1524: ,bevel hr_item_properties_b.bevel%TYPE
1525: ,case_restriction hr_item_properties_b.case_restriction%TYPE
1526: ,enabled hr_item_properties_b.enabled%TYPE
1527: ,format_mask hr_item_properties_b.format_mask%TYPE
1528: ,height hr_item_properties_b.height%TYPE
1529: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1522: Type l_rec_type Is Record
1523: (alignment hr_item_properties_b.alignment%TYPE
1524: ,bevel hr_item_properties_b.bevel%TYPE
1525: ,case_restriction hr_item_properties_b.case_restriction%TYPE
1526: ,enabled hr_item_properties_b.enabled%TYPE
1527: ,format_mask hr_item_properties_b.format_mask%TYPE
1528: ,height hr_item_properties_b.height%TYPE
1529: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1530: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1523: (alignment hr_item_properties_b.alignment%TYPE
1524: ,bevel hr_item_properties_b.bevel%TYPE
1525: ,case_restriction hr_item_properties_b.case_restriction%TYPE
1526: ,enabled hr_item_properties_b.enabled%TYPE
1527: ,format_mask hr_item_properties_b.format_mask%TYPE
1528: ,height hr_item_properties_b.height%TYPE
1529: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1530: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1531: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1524: ,bevel hr_item_properties_b.bevel%TYPE
1525: ,case_restriction hr_item_properties_b.case_restriction%TYPE
1526: ,enabled hr_item_properties_b.enabled%TYPE
1527: ,format_mask hr_item_properties_b.format_mask%TYPE
1528: ,height hr_item_properties_b.height%TYPE
1529: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1530: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1531: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1532: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1525: ,case_restriction hr_item_properties_b.case_restriction%TYPE
1526: ,enabled hr_item_properties_b.enabled%TYPE
1527: ,format_mask hr_item_properties_b.format_mask%TYPE
1528: ,height hr_item_properties_b.height%TYPE
1529: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1530: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1531: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1532: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1533: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1526: ,enabled hr_item_properties_b.enabled%TYPE
1527: ,format_mask hr_item_properties_b.format_mask%TYPE
1528: ,height hr_item_properties_b.height%TYPE
1529: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1530: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1531: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1532: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1533: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1534: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1527: ,format_mask hr_item_properties_b.format_mask%TYPE
1528: ,height hr_item_properties_b.height%TYPE
1529: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1530: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1531: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1532: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1533: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1534: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1535: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1528: ,height hr_item_properties_b.height%TYPE
1529: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1530: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1531: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1532: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1533: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1534: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1535: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1536: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1529: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1530: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1531: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1532: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1533: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1534: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1535: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1536: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1537: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1530: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1531: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1532: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1533: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1534: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1535: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1536: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1537: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1538: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1531: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1532: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1533: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1534: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1535: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1536: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1537: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1538: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1539: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1532: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1533: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1534: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1535: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1536: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1537: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1538: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1539: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1540: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1533: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1534: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1535: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1536: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1537: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1538: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1539: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1540: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1541: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1534: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1535: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1536: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1537: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1538: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1539: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1540: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1541: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1542: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1535: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1536: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1537: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1538: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1539: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1540: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1541: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1542: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1543: ,required hr_item_properties_b.required%TYPE
1536: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1537: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1538: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1539: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1540: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1541: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1542: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1543: ,required hr_item_properties_b.required%TYPE
1544: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1537: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1538: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1539: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1540: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1541: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1542: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1543: ,required hr_item_properties_b.required%TYPE
1544: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1545: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1538: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1539: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1540: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1541: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1542: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1543: ,required hr_item_properties_b.required%TYPE
1544: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1545: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1546: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1539: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1540: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1541: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1542: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1543: ,required hr_item_properties_b.required%TYPE
1544: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1545: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1546: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1547: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1540: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1541: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1542: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1543: ,required hr_item_properties_b.required%TYPE
1544: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1545: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1546: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1547: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1548: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1541: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1542: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1543: ,required hr_item_properties_b.required%TYPE
1544: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1545: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1546: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1547: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1548: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1549: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1542: ,query_allowed hr_item_properties_b.query_allowed%TYPE
1543: ,required hr_item_properties_b.required%TYPE
1544: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1545: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1546: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1547: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1548: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1549: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1550: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1543: ,required hr_item_properties_b.required%TYPE
1544: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1545: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1546: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1547: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1548: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1549: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1550: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1551: ,visible hr_item_properties_b.visible%TYPE
1544: ,update_allowed hr_item_properties_b.update_allowed%TYPE
1545: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1546: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1547: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1548: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1549: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1550: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1551: ,visible hr_item_properties_b.visible%TYPE
1552: ,width hr_item_properties_b.width%TYPE
1545: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1546: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1547: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1548: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1549: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1550: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1551: ,visible hr_item_properties_b.visible%TYPE
1552: ,width hr_item_properties_b.width%TYPE
1553: ,x_position hr_item_properties_b.x_position%TYPE
1546: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1547: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1548: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1549: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1550: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1551: ,visible hr_item_properties_b.visible%TYPE
1552: ,width hr_item_properties_b.width%TYPE
1553: ,x_position hr_item_properties_b.x_position%TYPE
1554: ,y_position hr_item_properties_b.y_position%TYPE
1547: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1548: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1549: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1550: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1551: ,visible hr_item_properties_b.visible%TYPE
1552: ,width hr_item_properties_b.width%TYPE
1553: ,x_position hr_item_properties_b.x_position%TYPE
1554: ,y_position hr_item_properties_b.y_position%TYPE
1555: ,information_category hr_item_properties_b.information_category%TYPE
1548: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1549: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1550: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1551: ,visible hr_item_properties_b.visible%TYPE
1552: ,width hr_item_properties_b.width%TYPE
1553: ,x_position hr_item_properties_b.x_position%TYPE
1554: ,y_position hr_item_properties_b.y_position%TYPE
1555: ,information_category hr_item_properties_b.information_category%TYPE
1556: ,information1 hr_item_properties_b.information1%TYPE
1549: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1550: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1551: ,visible hr_item_properties_b.visible%TYPE
1552: ,width hr_item_properties_b.width%TYPE
1553: ,x_position hr_item_properties_b.x_position%TYPE
1554: ,y_position hr_item_properties_b.y_position%TYPE
1555: ,information_category hr_item_properties_b.information_category%TYPE
1556: ,information1 hr_item_properties_b.information1%TYPE
1557: ,information2 hr_item_properties_b.information2%TYPE
1550: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1551: ,visible hr_item_properties_b.visible%TYPE
1552: ,width hr_item_properties_b.width%TYPE
1553: ,x_position hr_item_properties_b.x_position%TYPE
1554: ,y_position hr_item_properties_b.y_position%TYPE
1555: ,information_category hr_item_properties_b.information_category%TYPE
1556: ,information1 hr_item_properties_b.information1%TYPE
1557: ,information2 hr_item_properties_b.information2%TYPE
1558: ,information3 hr_item_properties_b.information3%TYPE
1551: ,visible hr_item_properties_b.visible%TYPE
1552: ,width hr_item_properties_b.width%TYPE
1553: ,x_position hr_item_properties_b.x_position%TYPE
1554: ,y_position hr_item_properties_b.y_position%TYPE
1555: ,information_category hr_item_properties_b.information_category%TYPE
1556: ,information1 hr_item_properties_b.information1%TYPE
1557: ,information2 hr_item_properties_b.information2%TYPE
1558: ,information3 hr_item_properties_b.information3%TYPE
1559: ,information4 hr_item_properties_b.information4%TYPE
1552: ,width hr_item_properties_b.width%TYPE
1553: ,x_position hr_item_properties_b.x_position%TYPE
1554: ,y_position hr_item_properties_b.y_position%TYPE
1555: ,information_category hr_item_properties_b.information_category%TYPE
1556: ,information1 hr_item_properties_b.information1%TYPE
1557: ,information2 hr_item_properties_b.information2%TYPE
1558: ,information3 hr_item_properties_b.information3%TYPE
1559: ,information4 hr_item_properties_b.information4%TYPE
1560: ,information5 hr_item_properties_b.information5%TYPE
1553: ,x_position hr_item_properties_b.x_position%TYPE
1554: ,y_position hr_item_properties_b.y_position%TYPE
1555: ,information_category hr_item_properties_b.information_category%TYPE
1556: ,information1 hr_item_properties_b.information1%TYPE
1557: ,information2 hr_item_properties_b.information2%TYPE
1558: ,information3 hr_item_properties_b.information3%TYPE
1559: ,information4 hr_item_properties_b.information4%TYPE
1560: ,information5 hr_item_properties_b.information5%TYPE
1561: ,information6 hr_item_properties_b.information6%TYPE
1554: ,y_position hr_item_properties_b.y_position%TYPE
1555: ,information_category hr_item_properties_b.information_category%TYPE
1556: ,information1 hr_item_properties_b.information1%TYPE
1557: ,information2 hr_item_properties_b.information2%TYPE
1558: ,information3 hr_item_properties_b.information3%TYPE
1559: ,information4 hr_item_properties_b.information4%TYPE
1560: ,information5 hr_item_properties_b.information5%TYPE
1561: ,information6 hr_item_properties_b.information6%TYPE
1562: ,information7 hr_item_properties_b.information7%TYPE
1555: ,information_category hr_item_properties_b.information_category%TYPE
1556: ,information1 hr_item_properties_b.information1%TYPE
1557: ,information2 hr_item_properties_b.information2%TYPE
1558: ,information3 hr_item_properties_b.information3%TYPE
1559: ,information4 hr_item_properties_b.information4%TYPE
1560: ,information5 hr_item_properties_b.information5%TYPE
1561: ,information6 hr_item_properties_b.information6%TYPE
1562: ,information7 hr_item_properties_b.information7%TYPE
1563: ,information8 hr_item_properties_b.information8%TYPE
1556: ,information1 hr_item_properties_b.information1%TYPE
1557: ,information2 hr_item_properties_b.information2%TYPE
1558: ,information3 hr_item_properties_b.information3%TYPE
1559: ,information4 hr_item_properties_b.information4%TYPE
1560: ,information5 hr_item_properties_b.information5%TYPE
1561: ,information6 hr_item_properties_b.information6%TYPE
1562: ,information7 hr_item_properties_b.information7%TYPE
1563: ,information8 hr_item_properties_b.information8%TYPE
1564: ,information9 hr_item_properties_b.information9%TYPE
1557: ,information2 hr_item_properties_b.information2%TYPE
1558: ,information3 hr_item_properties_b.information3%TYPE
1559: ,information4 hr_item_properties_b.information4%TYPE
1560: ,information5 hr_item_properties_b.information5%TYPE
1561: ,information6 hr_item_properties_b.information6%TYPE
1562: ,information7 hr_item_properties_b.information7%TYPE
1563: ,information8 hr_item_properties_b.information8%TYPE
1564: ,information9 hr_item_properties_b.information9%TYPE
1565: ,information10 hr_item_properties_b.information10%TYPE
1558: ,information3 hr_item_properties_b.information3%TYPE
1559: ,information4 hr_item_properties_b.information4%TYPE
1560: ,information5 hr_item_properties_b.information5%TYPE
1561: ,information6 hr_item_properties_b.information6%TYPE
1562: ,information7 hr_item_properties_b.information7%TYPE
1563: ,information8 hr_item_properties_b.information8%TYPE
1564: ,information9 hr_item_properties_b.information9%TYPE
1565: ,information10 hr_item_properties_b.information10%TYPE
1566: ,information11 hr_item_properties_b.information11%TYPE
1559: ,information4 hr_item_properties_b.information4%TYPE
1560: ,information5 hr_item_properties_b.information5%TYPE
1561: ,information6 hr_item_properties_b.information6%TYPE
1562: ,information7 hr_item_properties_b.information7%TYPE
1563: ,information8 hr_item_properties_b.information8%TYPE
1564: ,information9 hr_item_properties_b.information9%TYPE
1565: ,information10 hr_item_properties_b.information10%TYPE
1566: ,information11 hr_item_properties_b.information11%TYPE
1567: ,information12 hr_item_properties_b.information12%TYPE
1560: ,information5 hr_item_properties_b.information5%TYPE
1561: ,information6 hr_item_properties_b.information6%TYPE
1562: ,information7 hr_item_properties_b.information7%TYPE
1563: ,information8 hr_item_properties_b.information8%TYPE
1564: ,information9 hr_item_properties_b.information9%TYPE
1565: ,information10 hr_item_properties_b.information10%TYPE
1566: ,information11 hr_item_properties_b.information11%TYPE
1567: ,information12 hr_item_properties_b.information12%TYPE
1568: ,information13 hr_item_properties_b.information13%TYPE
1561: ,information6 hr_item_properties_b.information6%TYPE
1562: ,information7 hr_item_properties_b.information7%TYPE
1563: ,information8 hr_item_properties_b.information8%TYPE
1564: ,information9 hr_item_properties_b.information9%TYPE
1565: ,information10 hr_item_properties_b.information10%TYPE
1566: ,information11 hr_item_properties_b.information11%TYPE
1567: ,information12 hr_item_properties_b.information12%TYPE
1568: ,information13 hr_item_properties_b.information13%TYPE
1569: ,information14 hr_item_properties_b.information14%TYPE
1562: ,information7 hr_item_properties_b.information7%TYPE
1563: ,information8 hr_item_properties_b.information8%TYPE
1564: ,information9 hr_item_properties_b.information9%TYPE
1565: ,information10 hr_item_properties_b.information10%TYPE
1566: ,information11 hr_item_properties_b.information11%TYPE
1567: ,information12 hr_item_properties_b.information12%TYPE
1568: ,information13 hr_item_properties_b.information13%TYPE
1569: ,information14 hr_item_properties_b.information14%TYPE
1570: ,information15 hr_item_properties_b.information15%TYPE
1563: ,information8 hr_item_properties_b.information8%TYPE
1564: ,information9 hr_item_properties_b.information9%TYPE
1565: ,information10 hr_item_properties_b.information10%TYPE
1566: ,information11 hr_item_properties_b.information11%TYPE
1567: ,information12 hr_item_properties_b.information12%TYPE
1568: ,information13 hr_item_properties_b.information13%TYPE
1569: ,information14 hr_item_properties_b.information14%TYPE
1570: ,information15 hr_item_properties_b.information15%TYPE
1571: ,information16 hr_item_properties_b.information16%TYPE
1564: ,information9 hr_item_properties_b.information9%TYPE
1565: ,information10 hr_item_properties_b.information10%TYPE
1566: ,information11 hr_item_properties_b.information11%TYPE
1567: ,information12 hr_item_properties_b.information12%TYPE
1568: ,information13 hr_item_properties_b.information13%TYPE
1569: ,information14 hr_item_properties_b.information14%TYPE
1570: ,information15 hr_item_properties_b.information15%TYPE
1571: ,information16 hr_item_properties_b.information16%TYPE
1572: ,information17 hr_item_properties_b.information17%TYPE
1565: ,information10 hr_item_properties_b.information10%TYPE
1566: ,information11 hr_item_properties_b.information11%TYPE
1567: ,information12 hr_item_properties_b.information12%TYPE
1568: ,information13 hr_item_properties_b.information13%TYPE
1569: ,information14 hr_item_properties_b.information14%TYPE
1570: ,information15 hr_item_properties_b.information15%TYPE
1571: ,information16 hr_item_properties_b.information16%TYPE
1572: ,information17 hr_item_properties_b.information17%TYPE
1573: ,information18 hr_item_properties_b.information18%TYPE
1566: ,information11 hr_item_properties_b.information11%TYPE
1567: ,information12 hr_item_properties_b.information12%TYPE
1568: ,information13 hr_item_properties_b.information13%TYPE
1569: ,information14 hr_item_properties_b.information14%TYPE
1570: ,information15 hr_item_properties_b.information15%TYPE
1571: ,information16 hr_item_properties_b.information16%TYPE
1572: ,information17 hr_item_properties_b.information17%TYPE
1573: ,information18 hr_item_properties_b.information18%TYPE
1574: ,information19 hr_item_properties_b.information19%TYPE
1567: ,information12 hr_item_properties_b.information12%TYPE
1568: ,information13 hr_item_properties_b.information13%TYPE
1569: ,information14 hr_item_properties_b.information14%TYPE
1570: ,information15 hr_item_properties_b.information15%TYPE
1571: ,information16 hr_item_properties_b.information16%TYPE
1572: ,information17 hr_item_properties_b.information17%TYPE
1573: ,information18 hr_item_properties_b.information18%TYPE
1574: ,information19 hr_item_properties_b.information19%TYPE
1575: ,information20 hr_item_properties_b.information20%TYPE
1568: ,information13 hr_item_properties_b.information13%TYPE
1569: ,information14 hr_item_properties_b.information14%TYPE
1570: ,information15 hr_item_properties_b.information15%TYPE
1571: ,information16 hr_item_properties_b.information16%TYPE
1572: ,information17 hr_item_properties_b.information17%TYPE
1573: ,information18 hr_item_properties_b.information18%TYPE
1574: ,information19 hr_item_properties_b.information19%TYPE
1575: ,information20 hr_item_properties_b.information20%TYPE
1576: ,information21 hr_item_properties_b.information21%TYPE
1569: ,information14 hr_item_properties_b.information14%TYPE
1570: ,information15 hr_item_properties_b.information15%TYPE
1571: ,information16 hr_item_properties_b.information16%TYPE
1572: ,information17 hr_item_properties_b.information17%TYPE
1573: ,information18 hr_item_properties_b.information18%TYPE
1574: ,information19 hr_item_properties_b.information19%TYPE
1575: ,information20 hr_item_properties_b.information20%TYPE
1576: ,information21 hr_item_properties_b.information21%TYPE
1577: ,information22 hr_item_properties_b.information22%TYPE
1570: ,information15 hr_item_properties_b.information15%TYPE
1571: ,information16 hr_item_properties_b.information16%TYPE
1572: ,information17 hr_item_properties_b.information17%TYPE
1573: ,information18 hr_item_properties_b.information18%TYPE
1574: ,information19 hr_item_properties_b.information19%TYPE
1575: ,information20 hr_item_properties_b.information20%TYPE
1576: ,information21 hr_item_properties_b.information21%TYPE
1577: ,information22 hr_item_properties_b.information22%TYPE
1578: ,information23 hr_item_properties_b.information23%TYPE
1571: ,information16 hr_item_properties_b.information16%TYPE
1572: ,information17 hr_item_properties_b.information17%TYPE
1573: ,information18 hr_item_properties_b.information18%TYPE
1574: ,information19 hr_item_properties_b.information19%TYPE
1575: ,information20 hr_item_properties_b.information20%TYPE
1576: ,information21 hr_item_properties_b.information21%TYPE
1577: ,information22 hr_item_properties_b.information22%TYPE
1578: ,information23 hr_item_properties_b.information23%TYPE
1579: ,information24 hr_item_properties_b.information24%TYPE
1572: ,information17 hr_item_properties_b.information17%TYPE
1573: ,information18 hr_item_properties_b.information18%TYPE
1574: ,information19 hr_item_properties_b.information19%TYPE
1575: ,information20 hr_item_properties_b.information20%TYPE
1576: ,information21 hr_item_properties_b.information21%TYPE
1577: ,information22 hr_item_properties_b.information22%TYPE
1578: ,information23 hr_item_properties_b.information23%TYPE
1579: ,information24 hr_item_properties_b.information24%TYPE
1580: ,information25 hr_item_properties_b.information25%TYPE
1573: ,information18 hr_item_properties_b.information18%TYPE
1574: ,information19 hr_item_properties_b.information19%TYPE
1575: ,information20 hr_item_properties_b.information20%TYPE
1576: ,information21 hr_item_properties_b.information21%TYPE
1577: ,information22 hr_item_properties_b.information22%TYPE
1578: ,information23 hr_item_properties_b.information23%TYPE
1579: ,information24 hr_item_properties_b.information24%TYPE
1580: ,information25 hr_item_properties_b.information25%TYPE
1581: ,information26 hr_item_properties_b.information26%TYPE
1574: ,information19 hr_item_properties_b.information19%TYPE
1575: ,information20 hr_item_properties_b.information20%TYPE
1576: ,information21 hr_item_properties_b.information21%TYPE
1577: ,information22 hr_item_properties_b.information22%TYPE
1578: ,information23 hr_item_properties_b.information23%TYPE
1579: ,information24 hr_item_properties_b.information24%TYPE
1580: ,information25 hr_item_properties_b.information25%TYPE
1581: ,information26 hr_item_properties_b.information26%TYPE
1582: ,information27 hr_item_properties_b.information27%TYPE
1575: ,information20 hr_item_properties_b.information20%TYPE
1576: ,information21 hr_item_properties_b.information21%TYPE
1577: ,information22 hr_item_properties_b.information22%TYPE
1578: ,information23 hr_item_properties_b.information23%TYPE
1579: ,information24 hr_item_properties_b.information24%TYPE
1580: ,information25 hr_item_properties_b.information25%TYPE
1581: ,information26 hr_item_properties_b.information26%TYPE
1582: ,information27 hr_item_properties_b.information27%TYPE
1583: ,information28 hr_item_properties_b.information28%TYPE
1576: ,information21 hr_item_properties_b.information21%TYPE
1577: ,information22 hr_item_properties_b.information22%TYPE
1578: ,information23 hr_item_properties_b.information23%TYPE
1579: ,information24 hr_item_properties_b.information24%TYPE
1580: ,information25 hr_item_properties_b.information25%TYPE
1581: ,information26 hr_item_properties_b.information26%TYPE
1582: ,information27 hr_item_properties_b.information27%TYPE
1583: ,information28 hr_item_properties_b.information28%TYPE
1584: ,information29 hr_item_properties_b.information29%TYPE
1577: ,information22 hr_item_properties_b.information22%TYPE
1578: ,information23 hr_item_properties_b.information23%TYPE
1579: ,information24 hr_item_properties_b.information24%TYPE
1580: ,information25 hr_item_properties_b.information25%TYPE
1581: ,information26 hr_item_properties_b.information26%TYPE
1582: ,information27 hr_item_properties_b.information27%TYPE
1583: ,information28 hr_item_properties_b.information28%TYPE
1584: ,information29 hr_item_properties_b.information29%TYPE
1585: ,information30 hr_item_properties_b.information30%TYPE
1578: ,information23 hr_item_properties_b.information23%TYPE
1579: ,information24 hr_item_properties_b.information24%TYPE
1580: ,information25 hr_item_properties_b.information25%TYPE
1581: ,information26 hr_item_properties_b.information26%TYPE
1582: ,information27 hr_item_properties_b.information27%TYPE
1583: ,information28 hr_item_properties_b.information28%TYPE
1584: ,information29 hr_item_properties_b.information29%TYPE
1585: ,information30 hr_item_properties_b.information30%TYPE
1586: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
1579: ,information24 hr_item_properties_b.information24%TYPE
1580: ,information25 hr_item_properties_b.information25%TYPE
1581: ,information26 hr_item_properties_b.information26%TYPE
1582: ,information27 hr_item_properties_b.information27%TYPE
1583: ,information28 hr_item_properties_b.information28%TYPE
1584: ,information29 hr_item_properties_b.information29%TYPE
1585: ,information30 hr_item_properties_b.information30%TYPE
1586: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
1587: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
1580: ,information25 hr_item_properties_b.information25%TYPE
1581: ,information26 hr_item_properties_b.information26%TYPE
1582: ,information27 hr_item_properties_b.information27%TYPE
1583: ,information28 hr_item_properties_b.information28%TYPE
1584: ,information29 hr_item_properties_b.information29%TYPE
1585: ,information30 hr_item_properties_b.information30%TYPE
1586: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
1587: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
1588: );
1581: ,information26 hr_item_properties_b.information26%TYPE
1582: ,information27 hr_item_properties_b.information27%TYPE
1583: ,information28 hr_item_properties_b.information28%TYPE
1584: ,information29 hr_item_properties_b.information29%TYPE
1585: ,information30 hr_item_properties_b.information30%TYPE
1586: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
1587: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
1588: );
1589:
1582: ,information27 hr_item_properties_b.information27%TYPE
1583: ,information28 hr_item_properties_b.information28%TYPE
1584: ,information29 hr_item_properties_b.information29%TYPE
1585: ,information30 hr_item_properties_b.information30%TYPE
1586: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
1587: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
1588: );
1589:
1590: l_rec l_rec_type;
1583: ,information28 hr_item_properties_b.information28%TYPE
1584: ,information29 hr_item_properties_b.information29%TYPE
1585: ,information30 hr_item_properties_b.information30%TYPE
1586: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
1587: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
1588: );
1589:
1590: l_rec l_rec_type;
1591:
1664: ,DECODE(p_information29,hr_api.g_varchar2,itp.information29,p_information29)
1665: ,DECODE(p_information30,hr_api.g_varchar2,itp.information30,p_information30)
1666: ,DECODE(p_next_navigation_item_id,hr_api.g_number,itp.next_navigation_item_id,p_next_navigation_item_id)
1667: ,DECODE(p_previous_navigation_item_id,hr_api.g_number,itp.previous_navigation_item_id,p_previous_navigation_item_id)
1668: FROM hr_item_properties_b itp
1669: , hr_template_items_b hti
1670: WHERE itp.template_item_id (+) = hti.template_item_id
1671: AND hti.template_item_id = p_template_item_id;
1672:
1679: ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label) label
1680: ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text) prompt_text
1681: ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text) tooltip_text
1682: FROM hr_item_properties_tl itptl
1683: ,hr_item_properties_b itp
1684: WHERE itptl.item_property_id = itp.item_property_id
1685: AND itp.template_item_id = p_template_item_id
1686: GROUP BY itptl.source_lang
1687: ,DECODE(p_default_value,hr_api.g_varchar2,itptl.default_value,p_default_value)
2021: -- Declare cursors and local variables
2022: --
2023:
2024: Type l_rec_type Is Record
2025: (alignment hr_item_properties_b.alignment%TYPE
2026: ,bevel hr_item_properties_b.bevel%TYPE
2027: ,case_restriction hr_item_properties_b.case_restriction%TYPE
2028: ,enabled hr_item_properties_b.enabled%TYPE
2029: ,format_mask hr_item_properties_b.format_mask%TYPE
2022: --
2023:
2024: Type l_rec_type Is Record
2025: (alignment hr_item_properties_b.alignment%TYPE
2026: ,bevel hr_item_properties_b.bevel%TYPE
2027: ,case_restriction hr_item_properties_b.case_restriction%TYPE
2028: ,enabled hr_item_properties_b.enabled%TYPE
2029: ,format_mask hr_item_properties_b.format_mask%TYPE
2030: ,height hr_item_properties_b.height%TYPE
2023:
2024: Type l_rec_type Is Record
2025: (alignment hr_item_properties_b.alignment%TYPE
2026: ,bevel hr_item_properties_b.bevel%TYPE
2027: ,case_restriction hr_item_properties_b.case_restriction%TYPE
2028: ,enabled hr_item_properties_b.enabled%TYPE
2029: ,format_mask hr_item_properties_b.format_mask%TYPE
2030: ,height hr_item_properties_b.height%TYPE
2031: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2024: Type l_rec_type Is Record
2025: (alignment hr_item_properties_b.alignment%TYPE
2026: ,bevel hr_item_properties_b.bevel%TYPE
2027: ,case_restriction hr_item_properties_b.case_restriction%TYPE
2028: ,enabled hr_item_properties_b.enabled%TYPE
2029: ,format_mask hr_item_properties_b.format_mask%TYPE
2030: ,height hr_item_properties_b.height%TYPE
2031: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2032: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2025: (alignment hr_item_properties_b.alignment%TYPE
2026: ,bevel hr_item_properties_b.bevel%TYPE
2027: ,case_restriction hr_item_properties_b.case_restriction%TYPE
2028: ,enabled hr_item_properties_b.enabled%TYPE
2029: ,format_mask hr_item_properties_b.format_mask%TYPE
2030: ,height hr_item_properties_b.height%TYPE
2031: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2032: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2033: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2026: ,bevel hr_item_properties_b.bevel%TYPE
2027: ,case_restriction hr_item_properties_b.case_restriction%TYPE
2028: ,enabled hr_item_properties_b.enabled%TYPE
2029: ,format_mask hr_item_properties_b.format_mask%TYPE
2030: ,height hr_item_properties_b.height%TYPE
2031: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2032: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2033: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2034: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2027: ,case_restriction hr_item_properties_b.case_restriction%TYPE
2028: ,enabled hr_item_properties_b.enabled%TYPE
2029: ,format_mask hr_item_properties_b.format_mask%TYPE
2030: ,height hr_item_properties_b.height%TYPE
2031: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2032: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2033: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2034: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2035: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2028: ,enabled hr_item_properties_b.enabled%TYPE
2029: ,format_mask hr_item_properties_b.format_mask%TYPE
2030: ,height hr_item_properties_b.height%TYPE
2031: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2032: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2033: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2034: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2035: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2036: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2029: ,format_mask hr_item_properties_b.format_mask%TYPE
2030: ,height hr_item_properties_b.height%TYPE
2031: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2032: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2033: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2034: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2035: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2036: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2037: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2030: ,height hr_item_properties_b.height%TYPE
2031: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2032: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2033: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2034: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2035: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2036: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2037: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2038: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2031: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2032: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2033: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2034: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2035: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2036: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2037: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2038: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2039: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2032: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2033: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2034: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2035: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2036: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2037: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2038: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2039: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2040: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2033: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2034: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2035: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2036: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2037: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2038: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2039: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2040: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2041: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2034: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2035: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2036: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2037: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2038: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2039: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2040: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2041: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2042: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2035: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2036: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2037: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2038: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2039: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2040: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2041: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2042: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2043: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2036: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2037: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2038: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2039: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2040: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2041: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2042: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2043: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2044: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2037: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2038: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2039: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2040: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2041: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2042: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2043: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2044: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2045: ,required hr_item_properties_b.required%TYPE
2038: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2039: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2040: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2041: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2042: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2043: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2044: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2045: ,required hr_item_properties_b.required%TYPE
2046: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2039: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2040: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2041: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2042: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2043: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2044: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2045: ,required hr_item_properties_b.required%TYPE
2046: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2047: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2040: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2041: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2042: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2043: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2044: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2045: ,required hr_item_properties_b.required%TYPE
2046: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2047: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2048: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2041: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2042: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2043: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2044: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2045: ,required hr_item_properties_b.required%TYPE
2046: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2047: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2048: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2049: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2042: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2043: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2044: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2045: ,required hr_item_properties_b.required%TYPE
2046: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2047: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2048: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2049: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2050: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2043: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2044: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2045: ,required hr_item_properties_b.required%TYPE
2046: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2047: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2048: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2049: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2050: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2051: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2044: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2045: ,required hr_item_properties_b.required%TYPE
2046: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2047: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2048: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2049: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2050: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2051: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2052: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2045: ,required hr_item_properties_b.required%TYPE
2046: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2047: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2048: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2049: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2050: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2051: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2052: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2053: ,visible hr_item_properties_b.visible%TYPE
2046: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2047: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2048: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2049: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2050: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2051: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2052: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2053: ,visible hr_item_properties_b.visible%TYPE
2054: ,width hr_item_properties_b.width%TYPE
2047: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2048: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2049: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2050: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2051: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2052: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2053: ,visible hr_item_properties_b.visible%TYPE
2054: ,width hr_item_properties_b.width%TYPE
2055: ,x_position hr_item_properties_b.x_position%TYPE
2048: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2049: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2050: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2051: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2052: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2053: ,visible hr_item_properties_b.visible%TYPE
2054: ,width hr_item_properties_b.width%TYPE
2055: ,x_position hr_item_properties_b.x_position%TYPE
2056: ,y_position hr_item_properties_b.y_position%TYPE
2049: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2050: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2051: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2052: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2053: ,visible hr_item_properties_b.visible%TYPE
2054: ,width hr_item_properties_b.width%TYPE
2055: ,x_position hr_item_properties_b.x_position%TYPE
2056: ,y_position hr_item_properties_b.y_position%TYPE
2057: ,information_category hr_item_properties_b.information_category%TYPE
2050: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2051: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2052: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2053: ,visible hr_item_properties_b.visible%TYPE
2054: ,width hr_item_properties_b.width%TYPE
2055: ,x_position hr_item_properties_b.x_position%TYPE
2056: ,y_position hr_item_properties_b.y_position%TYPE
2057: ,information_category hr_item_properties_b.information_category%TYPE
2058: ,information1 hr_item_properties_b.information1%TYPE
2051: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2052: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2053: ,visible hr_item_properties_b.visible%TYPE
2054: ,width hr_item_properties_b.width%TYPE
2055: ,x_position hr_item_properties_b.x_position%TYPE
2056: ,y_position hr_item_properties_b.y_position%TYPE
2057: ,information_category hr_item_properties_b.information_category%TYPE
2058: ,information1 hr_item_properties_b.information1%TYPE
2059: ,information2 hr_item_properties_b.information2%TYPE
2052: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2053: ,visible hr_item_properties_b.visible%TYPE
2054: ,width hr_item_properties_b.width%TYPE
2055: ,x_position hr_item_properties_b.x_position%TYPE
2056: ,y_position hr_item_properties_b.y_position%TYPE
2057: ,information_category hr_item_properties_b.information_category%TYPE
2058: ,information1 hr_item_properties_b.information1%TYPE
2059: ,information2 hr_item_properties_b.information2%TYPE
2060: ,information3 hr_item_properties_b.information3%TYPE
2053: ,visible hr_item_properties_b.visible%TYPE
2054: ,width hr_item_properties_b.width%TYPE
2055: ,x_position hr_item_properties_b.x_position%TYPE
2056: ,y_position hr_item_properties_b.y_position%TYPE
2057: ,information_category hr_item_properties_b.information_category%TYPE
2058: ,information1 hr_item_properties_b.information1%TYPE
2059: ,information2 hr_item_properties_b.information2%TYPE
2060: ,information3 hr_item_properties_b.information3%TYPE
2061: ,information4 hr_item_properties_b.information4%TYPE
2054: ,width hr_item_properties_b.width%TYPE
2055: ,x_position hr_item_properties_b.x_position%TYPE
2056: ,y_position hr_item_properties_b.y_position%TYPE
2057: ,information_category hr_item_properties_b.information_category%TYPE
2058: ,information1 hr_item_properties_b.information1%TYPE
2059: ,information2 hr_item_properties_b.information2%TYPE
2060: ,information3 hr_item_properties_b.information3%TYPE
2061: ,information4 hr_item_properties_b.information4%TYPE
2062: ,information5 hr_item_properties_b.information5%TYPE
2055: ,x_position hr_item_properties_b.x_position%TYPE
2056: ,y_position hr_item_properties_b.y_position%TYPE
2057: ,information_category hr_item_properties_b.information_category%TYPE
2058: ,information1 hr_item_properties_b.information1%TYPE
2059: ,information2 hr_item_properties_b.information2%TYPE
2060: ,information3 hr_item_properties_b.information3%TYPE
2061: ,information4 hr_item_properties_b.information4%TYPE
2062: ,information5 hr_item_properties_b.information5%TYPE
2063: ,information6 hr_item_properties_b.information6%TYPE
2056: ,y_position hr_item_properties_b.y_position%TYPE
2057: ,information_category hr_item_properties_b.information_category%TYPE
2058: ,information1 hr_item_properties_b.information1%TYPE
2059: ,information2 hr_item_properties_b.information2%TYPE
2060: ,information3 hr_item_properties_b.information3%TYPE
2061: ,information4 hr_item_properties_b.information4%TYPE
2062: ,information5 hr_item_properties_b.information5%TYPE
2063: ,information6 hr_item_properties_b.information6%TYPE
2064: ,information7 hr_item_properties_b.information7%TYPE
2057: ,information_category hr_item_properties_b.information_category%TYPE
2058: ,information1 hr_item_properties_b.information1%TYPE
2059: ,information2 hr_item_properties_b.information2%TYPE
2060: ,information3 hr_item_properties_b.information3%TYPE
2061: ,information4 hr_item_properties_b.information4%TYPE
2062: ,information5 hr_item_properties_b.information5%TYPE
2063: ,information6 hr_item_properties_b.information6%TYPE
2064: ,information7 hr_item_properties_b.information7%TYPE
2065: ,information8 hr_item_properties_b.information8%TYPE
2058: ,information1 hr_item_properties_b.information1%TYPE
2059: ,information2 hr_item_properties_b.information2%TYPE
2060: ,information3 hr_item_properties_b.information3%TYPE
2061: ,information4 hr_item_properties_b.information4%TYPE
2062: ,information5 hr_item_properties_b.information5%TYPE
2063: ,information6 hr_item_properties_b.information6%TYPE
2064: ,information7 hr_item_properties_b.information7%TYPE
2065: ,information8 hr_item_properties_b.information8%TYPE
2066: ,information9 hr_item_properties_b.information9%TYPE
2059: ,information2 hr_item_properties_b.information2%TYPE
2060: ,information3 hr_item_properties_b.information3%TYPE
2061: ,information4 hr_item_properties_b.information4%TYPE
2062: ,information5 hr_item_properties_b.information5%TYPE
2063: ,information6 hr_item_properties_b.information6%TYPE
2064: ,information7 hr_item_properties_b.information7%TYPE
2065: ,information8 hr_item_properties_b.information8%TYPE
2066: ,information9 hr_item_properties_b.information9%TYPE
2067: ,information10 hr_item_properties_b.information10%TYPE
2060: ,information3 hr_item_properties_b.information3%TYPE
2061: ,information4 hr_item_properties_b.information4%TYPE
2062: ,information5 hr_item_properties_b.information5%TYPE
2063: ,information6 hr_item_properties_b.information6%TYPE
2064: ,information7 hr_item_properties_b.information7%TYPE
2065: ,information8 hr_item_properties_b.information8%TYPE
2066: ,information9 hr_item_properties_b.information9%TYPE
2067: ,information10 hr_item_properties_b.information10%TYPE
2068: ,information11 hr_item_properties_b.information11%TYPE
2061: ,information4 hr_item_properties_b.information4%TYPE
2062: ,information5 hr_item_properties_b.information5%TYPE
2063: ,information6 hr_item_properties_b.information6%TYPE
2064: ,information7 hr_item_properties_b.information7%TYPE
2065: ,information8 hr_item_properties_b.information8%TYPE
2066: ,information9 hr_item_properties_b.information9%TYPE
2067: ,information10 hr_item_properties_b.information10%TYPE
2068: ,information11 hr_item_properties_b.information11%TYPE
2069: ,information12 hr_item_properties_b.information12%TYPE
2062: ,information5 hr_item_properties_b.information5%TYPE
2063: ,information6 hr_item_properties_b.information6%TYPE
2064: ,information7 hr_item_properties_b.information7%TYPE
2065: ,information8 hr_item_properties_b.information8%TYPE
2066: ,information9 hr_item_properties_b.information9%TYPE
2067: ,information10 hr_item_properties_b.information10%TYPE
2068: ,information11 hr_item_properties_b.information11%TYPE
2069: ,information12 hr_item_properties_b.information12%TYPE
2070: ,information13 hr_item_properties_b.information13%TYPE
2063: ,information6 hr_item_properties_b.information6%TYPE
2064: ,information7 hr_item_properties_b.information7%TYPE
2065: ,information8 hr_item_properties_b.information8%TYPE
2066: ,information9 hr_item_properties_b.information9%TYPE
2067: ,information10 hr_item_properties_b.information10%TYPE
2068: ,information11 hr_item_properties_b.information11%TYPE
2069: ,information12 hr_item_properties_b.information12%TYPE
2070: ,information13 hr_item_properties_b.information13%TYPE
2071: ,information14 hr_item_properties_b.information14%TYPE
2064: ,information7 hr_item_properties_b.information7%TYPE
2065: ,information8 hr_item_properties_b.information8%TYPE
2066: ,information9 hr_item_properties_b.information9%TYPE
2067: ,information10 hr_item_properties_b.information10%TYPE
2068: ,information11 hr_item_properties_b.information11%TYPE
2069: ,information12 hr_item_properties_b.information12%TYPE
2070: ,information13 hr_item_properties_b.information13%TYPE
2071: ,information14 hr_item_properties_b.information14%TYPE
2072: ,information15 hr_item_properties_b.information15%TYPE
2065: ,information8 hr_item_properties_b.information8%TYPE
2066: ,information9 hr_item_properties_b.information9%TYPE
2067: ,information10 hr_item_properties_b.information10%TYPE
2068: ,information11 hr_item_properties_b.information11%TYPE
2069: ,information12 hr_item_properties_b.information12%TYPE
2070: ,information13 hr_item_properties_b.information13%TYPE
2071: ,information14 hr_item_properties_b.information14%TYPE
2072: ,information15 hr_item_properties_b.information15%TYPE
2073: ,information16 hr_item_properties_b.information16%TYPE
2066: ,information9 hr_item_properties_b.information9%TYPE
2067: ,information10 hr_item_properties_b.information10%TYPE
2068: ,information11 hr_item_properties_b.information11%TYPE
2069: ,information12 hr_item_properties_b.information12%TYPE
2070: ,information13 hr_item_properties_b.information13%TYPE
2071: ,information14 hr_item_properties_b.information14%TYPE
2072: ,information15 hr_item_properties_b.information15%TYPE
2073: ,information16 hr_item_properties_b.information16%TYPE
2074: ,information17 hr_item_properties_b.information17%TYPE
2067: ,information10 hr_item_properties_b.information10%TYPE
2068: ,information11 hr_item_properties_b.information11%TYPE
2069: ,information12 hr_item_properties_b.information12%TYPE
2070: ,information13 hr_item_properties_b.information13%TYPE
2071: ,information14 hr_item_properties_b.information14%TYPE
2072: ,information15 hr_item_properties_b.information15%TYPE
2073: ,information16 hr_item_properties_b.information16%TYPE
2074: ,information17 hr_item_properties_b.information17%TYPE
2075: ,information18 hr_item_properties_b.information18%TYPE
2068: ,information11 hr_item_properties_b.information11%TYPE
2069: ,information12 hr_item_properties_b.information12%TYPE
2070: ,information13 hr_item_properties_b.information13%TYPE
2071: ,information14 hr_item_properties_b.information14%TYPE
2072: ,information15 hr_item_properties_b.information15%TYPE
2073: ,information16 hr_item_properties_b.information16%TYPE
2074: ,information17 hr_item_properties_b.information17%TYPE
2075: ,information18 hr_item_properties_b.information18%TYPE
2076: ,information19 hr_item_properties_b.information19%TYPE
2069: ,information12 hr_item_properties_b.information12%TYPE
2070: ,information13 hr_item_properties_b.information13%TYPE
2071: ,information14 hr_item_properties_b.information14%TYPE
2072: ,information15 hr_item_properties_b.information15%TYPE
2073: ,information16 hr_item_properties_b.information16%TYPE
2074: ,information17 hr_item_properties_b.information17%TYPE
2075: ,information18 hr_item_properties_b.information18%TYPE
2076: ,information19 hr_item_properties_b.information19%TYPE
2077: ,information20 hr_item_properties_b.information20%TYPE
2070: ,information13 hr_item_properties_b.information13%TYPE
2071: ,information14 hr_item_properties_b.information14%TYPE
2072: ,information15 hr_item_properties_b.information15%TYPE
2073: ,information16 hr_item_properties_b.information16%TYPE
2074: ,information17 hr_item_properties_b.information17%TYPE
2075: ,information18 hr_item_properties_b.information18%TYPE
2076: ,information19 hr_item_properties_b.information19%TYPE
2077: ,information20 hr_item_properties_b.information20%TYPE
2078: ,information21 hr_item_properties_b.information21%TYPE
2071: ,information14 hr_item_properties_b.information14%TYPE
2072: ,information15 hr_item_properties_b.information15%TYPE
2073: ,information16 hr_item_properties_b.information16%TYPE
2074: ,information17 hr_item_properties_b.information17%TYPE
2075: ,information18 hr_item_properties_b.information18%TYPE
2076: ,information19 hr_item_properties_b.information19%TYPE
2077: ,information20 hr_item_properties_b.information20%TYPE
2078: ,information21 hr_item_properties_b.information21%TYPE
2079: ,information22 hr_item_properties_b.information22%TYPE
2072: ,information15 hr_item_properties_b.information15%TYPE
2073: ,information16 hr_item_properties_b.information16%TYPE
2074: ,information17 hr_item_properties_b.information17%TYPE
2075: ,information18 hr_item_properties_b.information18%TYPE
2076: ,information19 hr_item_properties_b.information19%TYPE
2077: ,information20 hr_item_properties_b.information20%TYPE
2078: ,information21 hr_item_properties_b.information21%TYPE
2079: ,information22 hr_item_properties_b.information22%TYPE
2080: ,information23 hr_item_properties_b.information23%TYPE
2073: ,information16 hr_item_properties_b.information16%TYPE
2074: ,information17 hr_item_properties_b.information17%TYPE
2075: ,information18 hr_item_properties_b.information18%TYPE
2076: ,information19 hr_item_properties_b.information19%TYPE
2077: ,information20 hr_item_properties_b.information20%TYPE
2078: ,information21 hr_item_properties_b.information21%TYPE
2079: ,information22 hr_item_properties_b.information22%TYPE
2080: ,information23 hr_item_properties_b.information23%TYPE
2081: ,information24 hr_item_properties_b.information24%TYPE
2074: ,information17 hr_item_properties_b.information17%TYPE
2075: ,information18 hr_item_properties_b.information18%TYPE
2076: ,information19 hr_item_properties_b.information19%TYPE
2077: ,information20 hr_item_properties_b.information20%TYPE
2078: ,information21 hr_item_properties_b.information21%TYPE
2079: ,information22 hr_item_properties_b.information22%TYPE
2080: ,information23 hr_item_properties_b.information23%TYPE
2081: ,information24 hr_item_properties_b.information24%TYPE
2082: ,information25 hr_item_properties_b.information25%TYPE
2075: ,information18 hr_item_properties_b.information18%TYPE
2076: ,information19 hr_item_properties_b.information19%TYPE
2077: ,information20 hr_item_properties_b.information20%TYPE
2078: ,information21 hr_item_properties_b.information21%TYPE
2079: ,information22 hr_item_properties_b.information22%TYPE
2080: ,information23 hr_item_properties_b.information23%TYPE
2081: ,information24 hr_item_properties_b.information24%TYPE
2082: ,information25 hr_item_properties_b.information25%TYPE
2083: ,information26 hr_item_properties_b.information26%TYPE
2076: ,information19 hr_item_properties_b.information19%TYPE
2077: ,information20 hr_item_properties_b.information20%TYPE
2078: ,information21 hr_item_properties_b.information21%TYPE
2079: ,information22 hr_item_properties_b.information22%TYPE
2080: ,information23 hr_item_properties_b.information23%TYPE
2081: ,information24 hr_item_properties_b.information24%TYPE
2082: ,information25 hr_item_properties_b.information25%TYPE
2083: ,information26 hr_item_properties_b.information26%TYPE
2084: ,information27 hr_item_properties_b.information27%TYPE
2077: ,information20 hr_item_properties_b.information20%TYPE
2078: ,information21 hr_item_properties_b.information21%TYPE
2079: ,information22 hr_item_properties_b.information22%TYPE
2080: ,information23 hr_item_properties_b.information23%TYPE
2081: ,information24 hr_item_properties_b.information24%TYPE
2082: ,information25 hr_item_properties_b.information25%TYPE
2083: ,information26 hr_item_properties_b.information26%TYPE
2084: ,information27 hr_item_properties_b.information27%TYPE
2085: ,information28 hr_item_properties_b.information28%TYPE
2078: ,information21 hr_item_properties_b.information21%TYPE
2079: ,information22 hr_item_properties_b.information22%TYPE
2080: ,information23 hr_item_properties_b.information23%TYPE
2081: ,information24 hr_item_properties_b.information24%TYPE
2082: ,information25 hr_item_properties_b.information25%TYPE
2083: ,information26 hr_item_properties_b.information26%TYPE
2084: ,information27 hr_item_properties_b.information27%TYPE
2085: ,information28 hr_item_properties_b.information28%TYPE
2086: ,information29 hr_item_properties_b.information29%TYPE
2079: ,information22 hr_item_properties_b.information22%TYPE
2080: ,information23 hr_item_properties_b.information23%TYPE
2081: ,information24 hr_item_properties_b.information24%TYPE
2082: ,information25 hr_item_properties_b.information25%TYPE
2083: ,information26 hr_item_properties_b.information26%TYPE
2084: ,information27 hr_item_properties_b.information27%TYPE
2085: ,information28 hr_item_properties_b.information28%TYPE
2086: ,information29 hr_item_properties_b.information29%TYPE
2087: ,information30 hr_item_properties_b.information30%TYPE
2080: ,information23 hr_item_properties_b.information23%TYPE
2081: ,information24 hr_item_properties_b.information24%TYPE
2082: ,information25 hr_item_properties_b.information25%TYPE
2083: ,information26 hr_item_properties_b.information26%TYPE
2084: ,information27 hr_item_properties_b.information27%TYPE
2085: ,information28 hr_item_properties_b.information28%TYPE
2086: ,information29 hr_item_properties_b.information29%TYPE
2087: ,information30 hr_item_properties_b.information30%TYPE
2088: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
2081: ,information24 hr_item_properties_b.information24%TYPE
2082: ,information25 hr_item_properties_b.information25%TYPE
2083: ,information26 hr_item_properties_b.information26%TYPE
2084: ,information27 hr_item_properties_b.information27%TYPE
2085: ,information28 hr_item_properties_b.information28%TYPE
2086: ,information29 hr_item_properties_b.information29%TYPE
2087: ,information30 hr_item_properties_b.information30%TYPE
2088: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
2089: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
2082: ,information25 hr_item_properties_b.information25%TYPE
2083: ,information26 hr_item_properties_b.information26%TYPE
2084: ,information27 hr_item_properties_b.information27%TYPE
2085: ,information28 hr_item_properties_b.information28%TYPE
2086: ,information29 hr_item_properties_b.information29%TYPE
2087: ,information30 hr_item_properties_b.information30%TYPE
2088: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
2089: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
2090: );
2083: ,information26 hr_item_properties_b.information26%TYPE
2084: ,information27 hr_item_properties_b.information27%TYPE
2085: ,information28 hr_item_properties_b.information28%TYPE
2086: ,information29 hr_item_properties_b.information29%TYPE
2087: ,information30 hr_item_properties_b.information30%TYPE
2088: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
2089: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
2090: );
2091:
2084: ,information27 hr_item_properties_b.information27%TYPE
2085: ,information28 hr_item_properties_b.information28%TYPE
2086: ,information29 hr_item_properties_b.information29%TYPE
2087: ,information30 hr_item_properties_b.information30%TYPE
2088: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
2089: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
2090: );
2091:
2092: l_rec l_rec_type;
2085: ,information28 hr_item_properties_b.information28%TYPE
2086: ,information29 hr_item_properties_b.information29%TYPE
2087: ,information30 hr_item_properties_b.information30%TYPE
2088: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
2089: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
2090: );
2091:
2092: l_rec l_rec_type;
2093:
2167: ,DECODE(p_information29,hr_api.g_varchar2,itp.information29,p_information29)
2168: ,DECODE(p_information30,hr_api.g_varchar2,itp.information30,p_information30)
2169: ,DECODE(p_next_navigation_item_id,hr_api.g_number,itp.next_navigation_item_id,p_next_navigation_item_id)
2170: ,DECODE(p_previous_navigation_item_id,hr_api.g_number,itp.previous_navigation_item_id,p_previous_navigation_item_id)
2171: FROM hr_item_properties_b itp
2172: ,hr_template_items_b hti
2173: WHERE itp.template_item_id (+) = hti.template_item_id
2174: AND hti.template_item_id = p_template_item_id_from;
2175:
2182: ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label) label
2183: ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text) prompt_text
2184: ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text) tooltip_text
2185: FROM hr_item_properties_tl itptl
2186: ,hr_item_properties_b itp
2187: WHERE itptl.item_property_id = itp.item_property_id
2188: AND itp.template_item_id = p_template_item_id_from
2189: GROUP BY itptl.source_lang
2190: ,DECODE(p_default_value,hr_api.g_varchar2,itptl.default_value,p_default_value)
2525: -- Declare cursors and local variables
2526: --
2527:
2528: Type l_rec_type Is Record
2529: (alignment hr_item_properties_b.alignment%TYPE
2530: ,bevel hr_item_properties_b.bevel%TYPE
2531: ,case_restriction hr_item_properties_b.case_restriction%TYPE
2532: ,enabled hr_item_properties_b.enabled%TYPE
2533: ,format_mask hr_item_properties_b.format_mask%TYPE
2526: --
2527:
2528: Type l_rec_type Is Record
2529: (alignment hr_item_properties_b.alignment%TYPE
2530: ,bevel hr_item_properties_b.bevel%TYPE
2531: ,case_restriction hr_item_properties_b.case_restriction%TYPE
2532: ,enabled hr_item_properties_b.enabled%TYPE
2533: ,format_mask hr_item_properties_b.format_mask%TYPE
2534: ,height hr_item_properties_b.height%TYPE
2527:
2528: Type l_rec_type Is Record
2529: (alignment hr_item_properties_b.alignment%TYPE
2530: ,bevel hr_item_properties_b.bevel%TYPE
2531: ,case_restriction hr_item_properties_b.case_restriction%TYPE
2532: ,enabled hr_item_properties_b.enabled%TYPE
2533: ,format_mask hr_item_properties_b.format_mask%TYPE
2534: ,height hr_item_properties_b.height%TYPE
2535: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2528: Type l_rec_type Is Record
2529: (alignment hr_item_properties_b.alignment%TYPE
2530: ,bevel hr_item_properties_b.bevel%TYPE
2531: ,case_restriction hr_item_properties_b.case_restriction%TYPE
2532: ,enabled hr_item_properties_b.enabled%TYPE
2533: ,format_mask hr_item_properties_b.format_mask%TYPE
2534: ,height hr_item_properties_b.height%TYPE
2535: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2536: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2529: (alignment hr_item_properties_b.alignment%TYPE
2530: ,bevel hr_item_properties_b.bevel%TYPE
2531: ,case_restriction hr_item_properties_b.case_restriction%TYPE
2532: ,enabled hr_item_properties_b.enabled%TYPE
2533: ,format_mask hr_item_properties_b.format_mask%TYPE
2534: ,height hr_item_properties_b.height%TYPE
2535: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2536: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2537: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2530: ,bevel hr_item_properties_b.bevel%TYPE
2531: ,case_restriction hr_item_properties_b.case_restriction%TYPE
2532: ,enabled hr_item_properties_b.enabled%TYPE
2533: ,format_mask hr_item_properties_b.format_mask%TYPE
2534: ,height hr_item_properties_b.height%TYPE
2535: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2536: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2537: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2538: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2531: ,case_restriction hr_item_properties_b.case_restriction%TYPE
2532: ,enabled hr_item_properties_b.enabled%TYPE
2533: ,format_mask hr_item_properties_b.format_mask%TYPE
2534: ,height hr_item_properties_b.height%TYPE
2535: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2536: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2537: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2538: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2539: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2532: ,enabled hr_item_properties_b.enabled%TYPE
2533: ,format_mask hr_item_properties_b.format_mask%TYPE
2534: ,height hr_item_properties_b.height%TYPE
2535: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2536: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2537: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2538: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2539: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2540: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2533: ,format_mask hr_item_properties_b.format_mask%TYPE
2534: ,height hr_item_properties_b.height%TYPE
2535: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2536: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2537: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2538: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2539: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2540: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2541: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2534: ,height hr_item_properties_b.height%TYPE
2535: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2536: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2537: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2538: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2539: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2540: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2541: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2542: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2535: ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2536: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2537: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2538: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2539: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2540: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2541: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2542: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2543: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2536: ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2537: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2538: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2539: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2540: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2541: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2542: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2543: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2544: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2537: ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2538: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2539: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2540: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2541: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2542: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2543: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2544: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2545: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2538: ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2539: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2540: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2541: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2542: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2543: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2544: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2545: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2546: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2539: ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2540: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2541: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2542: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2543: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2544: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2545: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2546: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2547: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2540: ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2541: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2542: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2543: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2544: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2545: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2546: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2547: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2548: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2541: ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2542: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2543: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2544: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2545: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2546: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2547: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2548: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2549: ,required hr_item_properties_b.required%TYPE
2542: ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2543: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2544: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2545: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2546: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2547: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2548: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2549: ,required hr_item_properties_b.required%TYPE
2550: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2543: ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2544: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2545: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2546: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2547: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2548: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2549: ,required hr_item_properties_b.required%TYPE
2550: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2551: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2544: ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2545: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2546: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2547: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2548: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2549: ,required hr_item_properties_b.required%TYPE
2550: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2551: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2552: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2545: ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2546: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2547: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2548: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2549: ,required hr_item_properties_b.required%TYPE
2550: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2551: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2552: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2553: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2546: ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2547: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2548: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2549: ,required hr_item_properties_b.required%TYPE
2550: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2551: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2552: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2553: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2554: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2547: ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2548: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2549: ,required hr_item_properties_b.required%TYPE
2550: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2551: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2552: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2553: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2554: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2555: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2548: ,query_allowed hr_item_properties_b.query_allowed%TYPE
2549: ,required hr_item_properties_b.required%TYPE
2550: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2551: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2552: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2553: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2554: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2555: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2556: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2549: ,required hr_item_properties_b.required%TYPE
2550: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2551: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2552: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2553: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2554: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2555: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2556: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2557: ,visible hr_item_properties_b.visible%TYPE
2550: ,update_allowed hr_item_properties_b.update_allowed%TYPE
2551: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2552: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2553: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2554: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2555: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2556: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2557: ,visible hr_item_properties_b.visible%TYPE
2558: ,width hr_item_properties_b.width%TYPE
2551: ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2552: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2553: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2554: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2555: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2556: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2557: ,visible hr_item_properties_b.visible%TYPE
2558: ,width hr_item_properties_b.width%TYPE
2559: ,x_position hr_item_properties_b.x_position%TYPE
2552: ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2553: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2554: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2555: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2556: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2557: ,visible hr_item_properties_b.visible%TYPE
2558: ,width hr_item_properties_b.width%TYPE
2559: ,x_position hr_item_properties_b.x_position%TYPE
2560: ,y_position hr_item_properties_b.y_position%TYPE
2553: ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2554: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2555: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2556: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2557: ,visible hr_item_properties_b.visible%TYPE
2558: ,width hr_item_properties_b.width%TYPE
2559: ,x_position hr_item_properties_b.x_position%TYPE
2560: ,y_position hr_item_properties_b.y_position%TYPE
2561: ,information_category hr_item_properties_b.information_category%TYPE
2554: ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2555: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2556: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2557: ,visible hr_item_properties_b.visible%TYPE
2558: ,width hr_item_properties_b.width%TYPE
2559: ,x_position hr_item_properties_b.x_position%TYPE
2560: ,y_position hr_item_properties_b.y_position%TYPE
2561: ,information_category hr_item_properties_b.information_category%TYPE
2562: ,information1 hr_item_properties_b.information1%TYPE
2555: ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2556: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2557: ,visible hr_item_properties_b.visible%TYPE
2558: ,width hr_item_properties_b.width%TYPE
2559: ,x_position hr_item_properties_b.x_position%TYPE
2560: ,y_position hr_item_properties_b.y_position%TYPE
2561: ,information_category hr_item_properties_b.information_category%TYPE
2562: ,information1 hr_item_properties_b.information1%TYPE
2563: ,information2 hr_item_properties_b.information2%TYPE
2556: ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2557: ,visible hr_item_properties_b.visible%TYPE
2558: ,width hr_item_properties_b.width%TYPE
2559: ,x_position hr_item_properties_b.x_position%TYPE
2560: ,y_position hr_item_properties_b.y_position%TYPE
2561: ,information_category hr_item_properties_b.information_category%TYPE
2562: ,information1 hr_item_properties_b.information1%TYPE
2563: ,information2 hr_item_properties_b.information2%TYPE
2564: ,information3 hr_item_properties_b.information3%TYPE
2557: ,visible hr_item_properties_b.visible%TYPE
2558: ,width hr_item_properties_b.width%TYPE
2559: ,x_position hr_item_properties_b.x_position%TYPE
2560: ,y_position hr_item_properties_b.y_position%TYPE
2561: ,information_category hr_item_properties_b.information_category%TYPE
2562: ,information1 hr_item_properties_b.information1%TYPE
2563: ,information2 hr_item_properties_b.information2%TYPE
2564: ,information3 hr_item_properties_b.information3%TYPE
2565: ,information4 hr_item_properties_b.information4%TYPE
2558: ,width hr_item_properties_b.width%TYPE
2559: ,x_position hr_item_properties_b.x_position%TYPE
2560: ,y_position hr_item_properties_b.y_position%TYPE
2561: ,information_category hr_item_properties_b.information_category%TYPE
2562: ,information1 hr_item_properties_b.information1%TYPE
2563: ,information2 hr_item_properties_b.information2%TYPE
2564: ,information3 hr_item_properties_b.information3%TYPE
2565: ,information4 hr_item_properties_b.information4%TYPE
2566: ,information5 hr_item_properties_b.information5%TYPE
2559: ,x_position hr_item_properties_b.x_position%TYPE
2560: ,y_position hr_item_properties_b.y_position%TYPE
2561: ,information_category hr_item_properties_b.information_category%TYPE
2562: ,information1 hr_item_properties_b.information1%TYPE
2563: ,information2 hr_item_properties_b.information2%TYPE
2564: ,information3 hr_item_properties_b.information3%TYPE
2565: ,information4 hr_item_properties_b.information4%TYPE
2566: ,information5 hr_item_properties_b.information5%TYPE
2567: ,information6 hr_item_properties_b.information6%TYPE
2560: ,y_position hr_item_properties_b.y_position%TYPE
2561: ,information_category hr_item_properties_b.information_category%TYPE
2562: ,information1 hr_item_properties_b.information1%TYPE
2563: ,information2 hr_item_properties_b.information2%TYPE
2564: ,information3 hr_item_properties_b.information3%TYPE
2565: ,information4 hr_item_properties_b.information4%TYPE
2566: ,information5 hr_item_properties_b.information5%TYPE
2567: ,information6 hr_item_properties_b.information6%TYPE
2568: ,information7 hr_item_properties_b.information7%TYPE
2561: ,information_category hr_item_properties_b.information_category%TYPE
2562: ,information1 hr_item_properties_b.information1%TYPE
2563: ,information2 hr_item_properties_b.information2%TYPE
2564: ,information3 hr_item_properties_b.information3%TYPE
2565: ,information4 hr_item_properties_b.information4%TYPE
2566: ,information5 hr_item_properties_b.information5%TYPE
2567: ,information6 hr_item_properties_b.information6%TYPE
2568: ,information7 hr_item_properties_b.information7%TYPE
2569: ,information8 hr_item_properties_b.information8%TYPE
2562: ,information1 hr_item_properties_b.information1%TYPE
2563: ,information2 hr_item_properties_b.information2%TYPE
2564: ,information3 hr_item_properties_b.information3%TYPE
2565: ,information4 hr_item_properties_b.information4%TYPE
2566: ,information5 hr_item_properties_b.information5%TYPE
2567: ,information6 hr_item_properties_b.information6%TYPE
2568: ,information7 hr_item_properties_b.information7%TYPE
2569: ,information8 hr_item_properties_b.information8%TYPE
2570: ,information9 hr_item_properties_b.information9%TYPE
2563: ,information2 hr_item_properties_b.information2%TYPE
2564: ,information3 hr_item_properties_b.information3%TYPE
2565: ,information4 hr_item_properties_b.information4%TYPE
2566: ,information5 hr_item_properties_b.information5%TYPE
2567: ,information6 hr_item_properties_b.information6%TYPE
2568: ,information7 hr_item_properties_b.information7%TYPE
2569: ,information8 hr_item_properties_b.information8%TYPE
2570: ,information9 hr_item_properties_b.information9%TYPE
2571: ,information10 hr_item_properties_b.information10%TYPE
2564: ,information3 hr_item_properties_b.information3%TYPE
2565: ,information4 hr_item_properties_b.information4%TYPE
2566: ,information5 hr_item_properties_b.information5%TYPE
2567: ,information6 hr_item_properties_b.information6%TYPE
2568: ,information7 hr_item_properties_b.information7%TYPE
2569: ,information8 hr_item_properties_b.information8%TYPE
2570: ,information9 hr_item_properties_b.information9%TYPE
2571: ,information10 hr_item_properties_b.information10%TYPE
2572: ,information11 hr_item_properties_b.information11%TYPE
2565: ,information4 hr_item_properties_b.information4%TYPE
2566: ,information5 hr_item_properties_b.information5%TYPE
2567: ,information6 hr_item_properties_b.information6%TYPE
2568: ,information7 hr_item_properties_b.information7%TYPE
2569: ,information8 hr_item_properties_b.information8%TYPE
2570: ,information9 hr_item_properties_b.information9%TYPE
2571: ,information10 hr_item_properties_b.information10%TYPE
2572: ,information11 hr_item_properties_b.information11%TYPE
2573: ,information12 hr_item_properties_b.information12%TYPE
2566: ,information5 hr_item_properties_b.information5%TYPE
2567: ,information6 hr_item_properties_b.information6%TYPE
2568: ,information7 hr_item_properties_b.information7%TYPE
2569: ,information8 hr_item_properties_b.information8%TYPE
2570: ,information9 hr_item_properties_b.information9%TYPE
2571: ,information10 hr_item_properties_b.information10%TYPE
2572: ,information11 hr_item_properties_b.information11%TYPE
2573: ,information12 hr_item_properties_b.information12%TYPE
2574: ,information13 hr_item_properties_b.information13%TYPE
2567: ,information6 hr_item_properties_b.information6%TYPE
2568: ,information7 hr_item_properties_b.information7%TYPE
2569: ,information8 hr_item_properties_b.information8%TYPE
2570: ,information9 hr_item_properties_b.information9%TYPE
2571: ,information10 hr_item_properties_b.information10%TYPE
2572: ,information11 hr_item_properties_b.information11%TYPE
2573: ,information12 hr_item_properties_b.information12%TYPE
2574: ,information13 hr_item_properties_b.information13%TYPE
2575: ,information14 hr_item_properties_b.information14%TYPE
2568: ,information7 hr_item_properties_b.information7%TYPE
2569: ,information8 hr_item_properties_b.information8%TYPE
2570: ,information9 hr_item_properties_b.information9%TYPE
2571: ,information10 hr_item_properties_b.information10%TYPE
2572: ,information11 hr_item_properties_b.information11%TYPE
2573: ,information12 hr_item_properties_b.information12%TYPE
2574: ,information13 hr_item_properties_b.information13%TYPE
2575: ,information14 hr_item_properties_b.information14%TYPE
2576: ,information15 hr_item_properties_b.information15%TYPE
2569: ,information8 hr_item_properties_b.information8%TYPE
2570: ,information9 hr_item_properties_b.information9%TYPE
2571: ,information10 hr_item_properties_b.information10%TYPE
2572: ,information11 hr_item_properties_b.information11%TYPE
2573: ,information12 hr_item_properties_b.information12%TYPE
2574: ,information13 hr_item_properties_b.information13%TYPE
2575: ,information14 hr_item_properties_b.information14%TYPE
2576: ,information15 hr_item_properties_b.information15%TYPE
2577: ,information16 hr_item_properties_b.information16%TYPE
2570: ,information9 hr_item_properties_b.information9%TYPE
2571: ,information10 hr_item_properties_b.information10%TYPE
2572: ,information11 hr_item_properties_b.information11%TYPE
2573: ,information12 hr_item_properties_b.information12%TYPE
2574: ,information13 hr_item_properties_b.information13%TYPE
2575: ,information14 hr_item_properties_b.information14%TYPE
2576: ,information15 hr_item_properties_b.information15%TYPE
2577: ,information16 hr_item_properties_b.information16%TYPE
2578: ,information17 hr_item_properties_b.information17%TYPE
2571: ,information10 hr_item_properties_b.information10%TYPE
2572: ,information11 hr_item_properties_b.information11%TYPE
2573: ,information12 hr_item_properties_b.information12%TYPE
2574: ,information13 hr_item_properties_b.information13%TYPE
2575: ,information14 hr_item_properties_b.information14%TYPE
2576: ,information15 hr_item_properties_b.information15%TYPE
2577: ,information16 hr_item_properties_b.information16%TYPE
2578: ,information17 hr_item_properties_b.information17%TYPE
2579: ,information18 hr_item_properties_b.information18%TYPE
2572: ,information11 hr_item_properties_b.information11%TYPE
2573: ,information12 hr_item_properties_b.information12%TYPE
2574: ,information13 hr_item_properties_b.information13%TYPE
2575: ,information14 hr_item_properties_b.information14%TYPE
2576: ,information15 hr_item_properties_b.information15%TYPE
2577: ,information16 hr_item_properties_b.information16%TYPE
2578: ,information17 hr_item_properties_b.information17%TYPE
2579: ,information18 hr_item_properties_b.information18%TYPE
2580: ,information19 hr_item_properties_b.information19%TYPE
2573: ,information12 hr_item_properties_b.information12%TYPE
2574: ,information13 hr_item_properties_b.information13%TYPE
2575: ,information14 hr_item_properties_b.information14%TYPE
2576: ,information15 hr_item_properties_b.information15%TYPE
2577: ,information16 hr_item_properties_b.information16%TYPE
2578: ,information17 hr_item_properties_b.information17%TYPE
2579: ,information18 hr_item_properties_b.information18%TYPE
2580: ,information19 hr_item_properties_b.information19%TYPE
2581: ,information20 hr_item_properties_b.information20%TYPE
2574: ,information13 hr_item_properties_b.information13%TYPE
2575: ,information14 hr_item_properties_b.information14%TYPE
2576: ,information15 hr_item_properties_b.information15%TYPE
2577: ,information16 hr_item_properties_b.information16%TYPE
2578: ,information17 hr_item_properties_b.information17%TYPE
2579: ,information18 hr_item_properties_b.information18%TYPE
2580: ,information19 hr_item_properties_b.information19%TYPE
2581: ,information20 hr_item_properties_b.information20%TYPE
2582: ,information21 hr_item_properties_b.information21%TYPE
2575: ,information14 hr_item_properties_b.information14%TYPE
2576: ,information15 hr_item_properties_b.information15%TYPE
2577: ,information16 hr_item_properties_b.information16%TYPE
2578: ,information17 hr_item_properties_b.information17%TYPE
2579: ,information18 hr_item_properties_b.information18%TYPE
2580: ,information19 hr_item_properties_b.information19%TYPE
2581: ,information20 hr_item_properties_b.information20%TYPE
2582: ,information21 hr_item_properties_b.information21%TYPE
2583: ,information22 hr_item_properties_b.information22%TYPE
2576: ,information15 hr_item_properties_b.information15%TYPE
2577: ,information16 hr_item_properties_b.information16%TYPE
2578: ,information17 hr_item_properties_b.information17%TYPE
2579: ,information18 hr_item_properties_b.information18%TYPE
2580: ,information19 hr_item_properties_b.information19%TYPE
2581: ,information20 hr_item_properties_b.information20%TYPE
2582: ,information21 hr_item_properties_b.information21%TYPE
2583: ,information22 hr_item_properties_b.information22%TYPE
2584: ,information23 hr_item_properties_b.information23%TYPE
2577: ,information16 hr_item_properties_b.information16%TYPE
2578: ,information17 hr_item_properties_b.information17%TYPE
2579: ,information18 hr_item_properties_b.information18%TYPE
2580: ,information19 hr_item_properties_b.information19%TYPE
2581: ,information20 hr_item_properties_b.information20%TYPE
2582: ,information21 hr_item_properties_b.information21%TYPE
2583: ,information22 hr_item_properties_b.information22%TYPE
2584: ,information23 hr_item_properties_b.information23%TYPE
2585: ,information24 hr_item_properties_b.information24%TYPE
2578: ,information17 hr_item_properties_b.information17%TYPE
2579: ,information18 hr_item_properties_b.information18%TYPE
2580: ,information19 hr_item_properties_b.information19%TYPE
2581: ,information20 hr_item_properties_b.information20%TYPE
2582: ,information21 hr_item_properties_b.information21%TYPE
2583: ,information22 hr_item_properties_b.information22%TYPE
2584: ,information23 hr_item_properties_b.information23%TYPE
2585: ,information24 hr_item_properties_b.information24%TYPE
2586: ,information25 hr_item_properties_b.information25%TYPE
2579: ,information18 hr_item_properties_b.information18%TYPE
2580: ,information19 hr_item_properties_b.information19%TYPE
2581: ,information20 hr_item_properties_b.information20%TYPE
2582: ,information21 hr_item_properties_b.information21%TYPE
2583: ,information22 hr_item_properties_b.information22%TYPE
2584: ,information23 hr_item_properties_b.information23%TYPE
2585: ,information24 hr_item_properties_b.information24%TYPE
2586: ,information25 hr_item_properties_b.information25%TYPE
2587: ,information26 hr_item_properties_b.information26%TYPE
2580: ,information19 hr_item_properties_b.information19%TYPE
2581: ,information20 hr_item_properties_b.information20%TYPE
2582: ,information21 hr_item_properties_b.information21%TYPE
2583: ,information22 hr_item_properties_b.information22%TYPE
2584: ,information23 hr_item_properties_b.information23%TYPE
2585: ,information24 hr_item_properties_b.information24%TYPE
2586: ,information25 hr_item_properties_b.information25%TYPE
2587: ,information26 hr_item_properties_b.information26%TYPE
2588: ,information27 hr_item_properties_b.information27%TYPE
2581: ,information20 hr_item_properties_b.information20%TYPE
2582: ,information21 hr_item_properties_b.information21%TYPE
2583: ,information22 hr_item_properties_b.information22%TYPE
2584: ,information23 hr_item_properties_b.information23%TYPE
2585: ,information24 hr_item_properties_b.information24%TYPE
2586: ,information25 hr_item_properties_b.information25%TYPE
2587: ,information26 hr_item_properties_b.information26%TYPE
2588: ,information27 hr_item_properties_b.information27%TYPE
2589: ,information28 hr_item_properties_b.information28%TYPE
2582: ,information21 hr_item_properties_b.information21%TYPE
2583: ,information22 hr_item_properties_b.information22%TYPE
2584: ,information23 hr_item_properties_b.information23%TYPE
2585: ,information24 hr_item_properties_b.information24%TYPE
2586: ,information25 hr_item_properties_b.information25%TYPE
2587: ,information26 hr_item_properties_b.information26%TYPE
2588: ,information27 hr_item_properties_b.information27%TYPE
2589: ,information28 hr_item_properties_b.information28%TYPE
2590: ,information29 hr_item_properties_b.information29%TYPE
2583: ,information22 hr_item_properties_b.information22%TYPE
2584: ,information23 hr_item_properties_b.information23%TYPE
2585: ,information24 hr_item_properties_b.information24%TYPE
2586: ,information25 hr_item_properties_b.information25%TYPE
2587: ,information26 hr_item_properties_b.information26%TYPE
2588: ,information27 hr_item_properties_b.information27%TYPE
2589: ,information28 hr_item_properties_b.information28%TYPE
2590: ,information29 hr_item_properties_b.information29%TYPE
2591: ,information30 hr_item_properties_b.information30%TYPE
2584: ,information23 hr_item_properties_b.information23%TYPE
2585: ,information24 hr_item_properties_b.information24%TYPE
2586: ,information25 hr_item_properties_b.information25%TYPE
2587: ,information26 hr_item_properties_b.information26%TYPE
2588: ,information27 hr_item_properties_b.information27%TYPE
2589: ,information28 hr_item_properties_b.information28%TYPE
2590: ,information29 hr_item_properties_b.information29%TYPE
2591: ,information30 hr_item_properties_b.information30%TYPE
2592: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
2585: ,information24 hr_item_properties_b.information24%TYPE
2586: ,information25 hr_item_properties_b.information25%TYPE
2587: ,information26 hr_item_properties_b.information26%TYPE
2588: ,information27 hr_item_properties_b.information27%TYPE
2589: ,information28 hr_item_properties_b.information28%TYPE
2590: ,information29 hr_item_properties_b.information29%TYPE
2591: ,information30 hr_item_properties_b.information30%TYPE
2592: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
2593: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
2586: ,information25 hr_item_properties_b.information25%TYPE
2587: ,information26 hr_item_properties_b.information26%TYPE
2588: ,information27 hr_item_properties_b.information27%TYPE
2589: ,information28 hr_item_properties_b.information28%TYPE
2590: ,information29 hr_item_properties_b.information29%TYPE
2591: ,information30 hr_item_properties_b.information30%TYPE
2592: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
2593: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
2594: );
2587: ,information26 hr_item_properties_b.information26%TYPE
2588: ,information27 hr_item_properties_b.information27%TYPE
2589: ,information28 hr_item_properties_b.information28%TYPE
2590: ,information29 hr_item_properties_b.information29%TYPE
2591: ,information30 hr_item_properties_b.information30%TYPE
2592: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
2593: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
2594: );
2595:
2588: ,information27 hr_item_properties_b.information27%TYPE
2589: ,information28 hr_item_properties_b.information28%TYPE
2590: ,information29 hr_item_properties_b.information29%TYPE
2591: ,information30 hr_item_properties_b.information30%TYPE
2592: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
2593: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
2594: );
2595:
2596: l_rec l_rec_type;
2589: ,information28 hr_item_properties_b.information28%TYPE
2590: ,information29 hr_item_properties_b.information29%TYPE
2591: ,information30 hr_item_properties_b.information30%TYPE
2592: ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
2593: ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
2594: );
2595:
2596: l_rec l_rec_type;
2597:
2675: ,DECODE(p_information29,hr_api.g_varchar2,itp.information29,p_information29)
2676: ,DECODE(p_information30,hr_api.g_varchar2,itp.information30,p_information30)
2677: ,DECODE(p_next_navigation_item_id,hr_api.g_number,itp.next_navigation_item_id,p_next_navigation_item_id)
2678: ,DECODE(p_previous_navigation_item_id,hr_api.g_number,itp.previous_navigation_item_id,p_previous_navigation_item_id)
2679: FROM hr_item_properties_b itp
2680: , hr_template_item_contexts_b tic
2681: WHERE itp.template_item_context_id = tic.template_item_context_id
2682: AND tic.template_item_context_id = p_template_item_context_id_frm;
2683:
2690: ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label) label
2691: ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text) prompt_text
2692: ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text) tooltip_text
2693: FROM hr_item_properties_tl itptl
2694: ,hr_item_properties_b itp
2695: WHERE itptl.item_property_id = itp.item_property_id
2696: AND itp.template_item_context_id = p_template_item_context_id_frm
2697: GROUP BY itptl.source_lang
2698: ,DECODE(p_default_value,hr_api.g_varchar2,itptl.default_value,p_default_value)
2942: hr_utility.set_location(' Leaving:'||l_proc, 90);
2943: raise;
2944: end copy_item_property;
2945: --
2946: end hr_item_properties_bsi;