18: |
19: +=========================================================================*/
20: /*
21: TYPE layout_rec_type IS RECORD (
22: line_number hz_style_fmt_layouts_b.line_number%TYPE,
23: position hz_style_fmt_layouts_b.position%TYPE,
24: attribute_code hz_style_fmt_layouts_b.attribute_code%TYPE,
25: use_initial_flag hz_style_fmt_layouts_b.use_initial_flag%TYPE,
26: uppercase_flag hz_style_fmt_layouts_b.uppercase_flag%TYPE,
19: +=========================================================================*/
20: /*
21: TYPE layout_rec_type IS RECORD (
22: line_number hz_style_fmt_layouts_b.line_number%TYPE,
23: position hz_style_fmt_layouts_b.position%TYPE,
24: attribute_code hz_style_fmt_layouts_b.attribute_code%TYPE,
25: use_initial_flag hz_style_fmt_layouts_b.use_initial_flag%TYPE,
26: uppercase_flag hz_style_fmt_layouts_b.uppercase_flag%TYPE,
27: transform_function hz_style_fmt_layouts_b.transform_function%TYPE,
20: /*
21: TYPE layout_rec_type IS RECORD (
22: line_number hz_style_fmt_layouts_b.line_number%TYPE,
23: position hz_style_fmt_layouts_b.position%TYPE,
24: attribute_code hz_style_fmt_layouts_b.attribute_code%TYPE,
25: use_initial_flag hz_style_fmt_layouts_b.use_initial_flag%TYPE,
26: uppercase_flag hz_style_fmt_layouts_b.uppercase_flag%TYPE,
27: transform_function hz_style_fmt_layouts_b.transform_function%TYPE,
28: delimiter_before hz_style_fmt_layouts_b.delimiter_before%TYPE,
21: TYPE layout_rec_type IS RECORD (
22: line_number hz_style_fmt_layouts_b.line_number%TYPE,
23: position hz_style_fmt_layouts_b.position%TYPE,
24: attribute_code hz_style_fmt_layouts_b.attribute_code%TYPE,
25: use_initial_flag hz_style_fmt_layouts_b.use_initial_flag%TYPE,
26: uppercase_flag hz_style_fmt_layouts_b.uppercase_flag%TYPE,
27: transform_function hz_style_fmt_layouts_b.transform_function%TYPE,
28: delimiter_before hz_style_fmt_layouts_b.delimiter_before%TYPE,
29: delimiter_after hz_style_fmt_layouts_b.delimiter_after%TYPE,
22: line_number hz_style_fmt_layouts_b.line_number%TYPE,
23: position hz_style_fmt_layouts_b.position%TYPE,
24: attribute_code hz_style_fmt_layouts_b.attribute_code%TYPE,
25: use_initial_flag hz_style_fmt_layouts_b.use_initial_flag%TYPE,
26: uppercase_flag hz_style_fmt_layouts_b.uppercase_flag%TYPE,
27: transform_function hz_style_fmt_layouts_b.transform_function%TYPE,
28: delimiter_before hz_style_fmt_layouts_b.delimiter_before%TYPE,
29: delimiter_after hz_style_fmt_layouts_b.delimiter_after%TYPE,
30: blank_lines_before hz_style_fmt_layouts_b.blank_lines_before%TYPE,
23: position hz_style_fmt_layouts_b.position%TYPE,
24: attribute_code hz_style_fmt_layouts_b.attribute_code%TYPE,
25: use_initial_flag hz_style_fmt_layouts_b.use_initial_flag%TYPE,
26: uppercase_flag hz_style_fmt_layouts_b.uppercase_flag%TYPE,
27: transform_function hz_style_fmt_layouts_b.transform_function%TYPE,
28: delimiter_before hz_style_fmt_layouts_b.delimiter_before%TYPE,
29: delimiter_after hz_style_fmt_layouts_b.delimiter_after%TYPE,
30: blank_lines_before hz_style_fmt_layouts_b.blank_lines_before%TYPE,
31: blank_lines_after hz_style_fmt_layouts_b.blank_lines_after%TYPE,
24: attribute_code hz_style_fmt_layouts_b.attribute_code%TYPE,
25: use_initial_flag hz_style_fmt_layouts_b.use_initial_flag%TYPE,
26: uppercase_flag hz_style_fmt_layouts_b.uppercase_flag%TYPE,
27: transform_function hz_style_fmt_layouts_b.transform_function%TYPE,
28: delimiter_before hz_style_fmt_layouts_b.delimiter_before%TYPE,
29: delimiter_after hz_style_fmt_layouts_b.delimiter_after%TYPE,
30: blank_lines_before hz_style_fmt_layouts_b.blank_lines_before%TYPE,
31: blank_lines_after hz_style_fmt_layouts_b.blank_lines_after%TYPE,
32: attribute_value VARCHAR2(240)
25: use_initial_flag hz_style_fmt_layouts_b.use_initial_flag%TYPE,
26: uppercase_flag hz_style_fmt_layouts_b.uppercase_flag%TYPE,
27: transform_function hz_style_fmt_layouts_b.transform_function%TYPE,
28: delimiter_before hz_style_fmt_layouts_b.delimiter_before%TYPE,
29: delimiter_after hz_style_fmt_layouts_b.delimiter_after%TYPE,
30: blank_lines_before hz_style_fmt_layouts_b.blank_lines_before%TYPE,
31: blank_lines_after hz_style_fmt_layouts_b.blank_lines_after%TYPE,
32: attribute_value VARCHAR2(240)
33: );
26: uppercase_flag hz_style_fmt_layouts_b.uppercase_flag%TYPE,
27: transform_function hz_style_fmt_layouts_b.transform_function%TYPE,
28: delimiter_before hz_style_fmt_layouts_b.delimiter_before%TYPE,
29: delimiter_after hz_style_fmt_layouts_b.delimiter_after%TYPE,
30: blank_lines_before hz_style_fmt_layouts_b.blank_lines_before%TYPE,
31: blank_lines_after hz_style_fmt_layouts_b.blank_lines_after%TYPE,
32: attribute_value VARCHAR2(240)
33: );
34: */
27: transform_function hz_style_fmt_layouts_b.transform_function%TYPE,
28: delimiter_before hz_style_fmt_layouts_b.delimiter_before%TYPE,
29: delimiter_after hz_style_fmt_layouts_b.delimiter_after%TYPE,
30: blank_lines_before hz_style_fmt_layouts_b.blank_lines_before%TYPE,
31: blank_lines_after hz_style_fmt_layouts_b.blank_lines_after%TYPE,
32: attribute_value VARCHAR2(240)
33: );
34: */
35: /*=========================================================================+
3702: delimiter_before,
3703: delimiter_after,
3704: blank_lines_before,
3705: blank_lines_after
3706: FROM hz_style_fmt_layouts_b
3707: WHERE
3708: style_format_code = p_style_format_code
3709: AND variation_number = p_variation_number
3710: AND (SYSDATE BETWEEN start_date_active