APPS.CSE_FA_STAGE_PKG dependencies on DUAL

Line 221: FROM sys.dual;

217: BEGIN
218:
219: SELECT csi_fa_headers_s.nextval
220: INTO l_interface_header_id
221: FROM sys.dual;
222:
223: csi_fa_headers_pkg.INSERT_ROW (
224: X_ROWID => l_rowid,
225: X_INTERFACE_HEADER_ID => l_interface_header_id,

Line 247: FROM sys.dual;

243: LOOP
244:
245: SELECT csi_fa_transactions_s.nextval
246: INTO l_interface_line_id
247: FROM sys.dual;
248:
249: csi_fa_transactions_pkg.INSERT_ROW (
250: X_ROWID => l_rowid,
251: X_INTERFACE_LINE_ID => l_interface_line_id,

Line 491: FROM sys.dual;

487: BEGIN
488:
489: SELECT fnd_profile.value('apps_framework_agent')||'/OA_HTML/OA.jsp?OAFunc=CSE_OANF_FA_SEARCH'
490: INTO l_ib_url
491: FROM sys.dual;
492:
493: x_ib_url := l_ib_url;
494:
495: END ib_url;

Line 515: FROM sys.dual;

511: debug('send mail');
512:
513: SELECT csi_wf_item_key_number_s.nextval
514: INTO l_item_key_seq
515: FROM sys.dual;
516:
517: l_item_key := l_item_type||'-'||l_item_key_seq;
518:
519: debug('item key : '||l_item_key);

Line 621: SELECT fnd_lobs_s.NEXTVAL INTO l_fid FROM DUAL;

617: report_output;
618:
619: l_request_id := fnd_global.conc_request_id;
620:
621: SELECT fnd_lobs_s.NEXTVAL INTO l_fid FROM DUAL;
622: l_file_name := l_program_name || '_' || l_request_id || '.out';
623: l_program_tag := l_request_id;
624:
625: --Convert the clob to blob to store it in the table FNB_LOBS