eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on CN_SCA_HEADERS_INTERFACE

Line 394: l_header_interface_id cn_sca_headers_interface.sca_headers_interface_id%TYPE;

390: query_cur rc;
391: i NUMBER;
392: l_header_rec cn_comm_lines_api%ROWTYPE;
393: l_lines_output_id cn_sca_lines_output.sca_lines_output_id%TYPE;
394: l_header_interface_id cn_sca_headers_interface.sca_headers_interface_id%TYPE;
395: l_comm_lines_api_id cn_comm_lines_api.comm_lines_api_id%TYPE;
396: l_source_id cn_sca_headers_interface.source_id%TYPE;
397: l_order_number cn_comm_lines_api.order_number%TYPE;
398: l_invoice_number cn_comm_lines_api.invoice_number%TYPE;

Line 396: l_source_id cn_sca_headers_interface.source_id%TYPE;

392: l_header_rec cn_comm_lines_api%ROWTYPE;
393: l_lines_output_id cn_sca_lines_output.sca_lines_output_id%TYPE;
394: l_header_interface_id cn_sca_headers_interface.sca_headers_interface_id%TYPE;
395: l_comm_lines_api_id cn_comm_lines_api.comm_lines_api_id%TYPE;
396: l_source_id cn_sca_headers_interface.source_id%TYPE;
397: l_order_number cn_comm_lines_api.order_number%TYPE;
398: l_invoice_number cn_comm_lines_api.invoice_number%TYPE;
399: l_id NUMBER;
400: l_logical_batch_size NUMBER;

Line 417: l_sql_stmt_count := 'SELECT count(1) FROM cn_sca_headers_interface cshi ';

413: debugmsg('Allocation Process : p_start_date = ' || p_start_date);
414: debugmsg('Allocation Process : p_end_date = ' || p_end_date);
415: -- Get the number of transactions that needs to be processed,
416: -- i.e. the logical batch size
417: l_sql_stmt_count := 'SELECT count(1) FROM cn_sca_headers_interface cshi ';
418: l_sql_stmt :=
419: 'WHERE cshi.processed_date BETWEEN :p_start_date AND :p_end_date '
420: || 'AND cshi.transaction_source = :p_transaction_source '
421: || 'AND cshi.process_status = ''SCA_UNPROCESSED'' '

Line 500: 'SELECT cshi.sca_headers_interface_id ' || 'FROM cn_sca_headers_interface CSHI ';

496: END IF;
497:
498: IF (NOT l_no_trx) THEN
499: l_sql_stmt_id :=
500: 'SELECT cshi.sca_headers_interface_id ' || 'FROM cn_sca_headers_interface CSHI ';
501: l_sql_stmt_id := l_sql_stmt_id || l_sql_stmt;
502: l_sql_stmt_id :=
503: 'SELECT sca_headers_interface_id FROM '
504: || '(SELECT rownum row_number, sca_headers_interface_id FROM '