DBA Data[Home] [Help]

APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_IMP_LINES

Line 2148: l_status_code cn_imp_lines.status_code%TYPE := 'STAGE';

2144: , p_imp_header_id IN NUMBER
2145: , p_org_id IN NUMBER
2146: ) IS
2147: l_api_name CONSTANT VARCHAR2(30) := 'import';
2148: l_status_code cn_imp_lines.status_code%TYPE := 'STAGE';
2149: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type
2150: := cn_imp_headers_pvt.g_miss_imp_headers_rec;
2151: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
2152: err_num NUMBER;

Line 2670: -- set cn_imp_lines records status = 'COMPLETE'

2666: , p_staged_row => l_rowcount - l_longcount
2667: , p_failed_row => l_longcount
2668: );
2669:
2670: -- set cn_imp_lines records status = 'COMPLETE'
2671: UPDATE cn_exp_api_imp_v
2672: SET status_code = 'COMPLETE'
2673: WHERE imp_header_id = p_imp_header_id;
2674: