55: concurrent_request_id;
56:
57: ------------------------------------------------------------------------------
58: --This function returns the predefined length of a column to be written. The
59: --length definition must be seeded in the por_feed_field_formats table.
60: -------------------------------------------------------------------------------
61:
62: FUNCTION Get_Field_Size (
63: i_column IN VARCHAR2,
68: BEGIN
69:
70: SELECT field_length
71: INTO l_size
72: FROM por_feed_field_formats
73: WHERE column_name = i_column
74: AND record_type = i_record_type
75: AND format_id = g_format_id
76: AND effective_date <= SYSDATE
128: SELECT column_name,
129: field_length,
130: default_value,
131: pad_character
132: FROM por_feed_field_formats
133: WHERE format_id = g_format_id
134: AND record_type = 'D'
135: AND effective_date <= SYSDATE
136: AND expiration_date IS NULL
332: SELECT column_name,
333: field_length,
334: default_value,
335: pad_character
336: FROM por_feed_field_formats
337: WHERE format_id = g_format_id
338: AND record_type = 'H'
339: AND effective_date <= SYSDATE
340: AND expiration_date IS NULL
678: SELECT column_name,
679: field_length,
680: default_value,
681: pad_character
682: FROM por_feed_field_formats
683: WHERE format_id = g_format_id
684: AND record_type = 'C'
685: AND effective_date <= SYSDATE
686: AND expiration_date IS NULL