2126: , p_org_id IN NUMBER
2127: ) IS
2128: l_api_name CONSTANT VARCHAR2(30) := 'import';
2129: l_status_code cn_imp_lines.status_code%TYPE := 'STAGE';
2130: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type
2131: := cn_imp_headers_pvt.g_miss_imp_headers_rec;
2132: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
2133: err_num NUMBER;
2134: l_msg_count NUMBER := 0;
2127: ) IS
2128: l_api_name CONSTANT VARCHAR2(30) := 'import';
2129: l_status_code cn_imp_lines.status_code%TYPE := 'STAGE';
2130: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type
2131: := cn_imp_headers_pvt.g_miss_imp_headers_rec;
2132: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
2133: err_num NUMBER;
2134: l_msg_count NUMBER := 0;
2135: l_exp_id NUMBER;