APPS.FA_RX_PUBLISH dependencies on FA_RX_REP_COLUMNS

Line 686: from fa_rx_rep_columns

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

Line 726: from fa_rx_rep_columns

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

Line 1154: fa_rx_rep_columns

1150: units,
1151: format_mask,
1152: break_group_level
1153: from
1154: fa_rx_rep_columns
1155: where
1156: report_id = m_formats(s_current_format_idx).report_id
1157: and display_status = 'YES'
1158: and attribute_set = m_formats(s_current_format_idx).attribute_set

Line 1333: (select column_name from fa_rx_rep_columns c

1329: report_id = m_formats(s_current_format_idx).report_id
1330: and attribute_set = m_formats(s_current_format_idx).attribute_set
1331: and display_status = 'Y'
1332: and column_name in
1333: (select column_name from fa_rx_rep_columns c
1334: where c.report_id=s.report_id and
1335: c.attribute_set=s.attribute_set and
1336: display_status = 'YES')
1337: order by print_level, compute_level, reset_level;

Line 2437: from fa_rx_rep_columns

2433: procedure Expand_Complex_Multiformat(p_formats in formattab, p_count in number)
2434: is
2435: cursor cols(p_report_id in number, p_attribute_set in varchar2) is select
2436: column_name, display_format
2437: from fa_rx_rep_columns
2438: where report_id = p_report_id
2439: and attribute_set = p_attribute_set
2440: and break = 'Y'
2441: and break_group_level = 1

Line 2580: from fa_rx_rep_columns

2576:
2577: cursor col(min_level in NUMBER, break_flag IN varchar2) is select
2578: attribute_name,
2579: Least(display_length, 255) display_length
2580: from fa_rx_rep_columns
2581: where report_id = m_formats(format_idx).report_id and attribute_set = m_formats(format_idx).attribute_set
2582: and display_status = 'YES'
2583: and decode(break, 'Y', break_group_level, -999) >= min_level
2584: AND Nvl(break, 'N') = break_flag

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

2584: AND Nvl(break, 'N') = break_flag
2585: ORDER BY Nvl(break,'N') DESC, break_group_level, attribute_counter;
2586: begin
2587: if break_flag = 'Y' then
2588: select min(break_group_level) into min_level from fa_rx_rep_columns
2589: where report_id = m_formats(format_idx).report_id and attribute_set = m_formats(format_idx).attribute_set
2590: and display_status = 'YES';
2591:
2592: if m_formats(format_idx).display_page_break = 'Y' then