APPS.FA_RX_PUBLISH dependencies on FA_RX_REP_COLUMNS

Line 687: from fa_rx_rep_columns

683:
684: procedure check_group_display_type(fidx in number)
685: is
686: cursor c is select Least(display_length, 255) display_length
687: from fa_rx_rep_columns
688: where report_id = m_formats(fidx).report_id
689: and attribute_set = m_formats(fidx).attribute_set
690: and break = 'Y'
691: and break_group_level >=

Line 727: from fa_rx_rep_columns

723: current_pos := current_pos + crec.display_length + 2;
724: end loop;
725:
726: select max(Least(display_length, 255)) into max_len
727: from fa_rx_rep_columns
728: where report_id = m_formats(fidx).report_id
729: and attribute_set = m_formats(fidx).attribute_set
730: and nvl(break, 'N') = 'N'
731: and display_status = 'YES';

Line 1138: fa_rx_rep_columns

1134: units,
1135: format_mask,
1136: break_group_level
1137: from
1138: fa_rx_rep_columns
1139: where
1140: report_id = m_formats(s_current_format_idx).report_id
1141: and display_status = 'YES'
1142: and attribute_set = m_formats(s_current_format_idx).attribute_set

Line 1317: (select column_name from fa_rx_rep_columns c

1313: report_id = m_formats(s_current_format_idx).report_id
1314: and attribute_set = m_formats(s_current_format_idx).attribute_set
1315: and display_status = 'Y'
1316: and column_name in
1317: (select column_name from fa_rx_rep_columns c
1318: where c.report_id=s.report_id and
1319: c.attribute_set=s.attribute_set and
1320: display_status = 'YES')
1321: order by print_level, compute_level, reset_level;

Line 2369: from fa_rx_rep_columns

2365: procedure Expand_Complex_Multiformat(p_formats in formattab, p_count in number)
2366: is
2367: cursor cols(p_report_id in number, p_attribute_set in varchar2) is select
2368: column_name, display_format
2369: from fa_rx_rep_columns
2370: where report_id = p_report_id
2371: and attribute_set = p_attribute_set
2372: and break = 'Y'
2373: and break_group_level = 1

Line 2512: from fa_rx_rep_columns

2508:
2509: cursor col(min_level in NUMBER, break_flag IN varchar2) is select
2510: attribute_name,
2511: Least(display_length, 255) display_length
2512: from fa_rx_rep_columns
2513: where report_id = m_formats(format_idx).report_id and attribute_set = m_formats(format_idx).attribute_set
2514: and display_status = 'YES'
2515: and decode(break, 'Y', break_group_level, -999) >= min_level
2516: AND Nvl(break, 'N') = break_flag

Line 2520: select min(break_group_level) into min_level from fa_rx_rep_columns

2516: AND Nvl(break, 'N') = break_flag
2517: ORDER BY Nvl(break,'N') DESC, break_group_level, attribute_counter;
2518: begin
2519: if break_flag = 'Y' then
2520: select min(break_group_level) into min_level from fa_rx_rep_columns
2521: where report_id = m_formats(format_idx).report_id and attribute_set = m_formats(format_idx).attribute_set
2522: and display_status = 'YES';
2523:
2524: if m_formats(format_idx).display_page_break = 'Y' then