APPS.FA_RX_REPORTS_PKG dependencies on DUAL

Line 84: select fa_rx_reports_s.currval into x_curr_report_id_s from dual;

80: declare
81: seq_no_curr exception;
82: pragma exception_init(seq_no_curr, -8002);
83: begin
84: select fa_rx_reports_s.currval into x_curr_report_id_s from dual;
85: exception
86: when seq_no_curr then
87: select fa_rx_reports_s.nextval into x_curr_report_id_s from dual;
88: end;

Line 87: select fa_rx_reports_s.nextval into x_curr_report_id_s from dual;

83: begin
84: select fa_rx_reports_s.currval into x_curr_report_id_s from dual;
85: exception
86: when seq_no_curr then
87: select fa_rx_reports_s.nextval into x_curr_report_id_s from dual;
88: end;
89: for i in x_curr_report_id_s .. x_max_report_id loop
90: select fa_rx_reports_s.nextval into dummy from dual;
91: end loop;

Line 90: select fa_rx_reports_s.nextval into dummy from dual;

86: when seq_no_curr then
87: select fa_rx_reports_s.nextval into x_curr_report_id_s from dual;
88: end;
89: for i in x_curr_report_id_s .. x_max_report_id loop
90: select fa_rx_reports_s.nextval into dummy from dual;
91: end loop;
92:
93: -- EXCEPTION
94: -- WHEN Others THEN