APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_IMP_LINES

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

2125: , p_imp_header_id IN NUMBER
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;

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

2648: , p_staged_row => l_rowcount - l_longcount
2649: , p_failed_row => l_longcount
2650: );
2651:
2652: -- set cn_imp_lines records status = 'COMPLETE'
2653: UPDATE cn_exp_api_imp_v
2654: SET status_code = 'COMPLETE'
2655: WHERE imp_header_id = p_imp_header_id;
2656: