APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_IMP_HEADERS

Line 2149: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type

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;
2153: l_msg_count NUMBER := 0;

Line 2150: := cn_imp_headers_pvt.g_miss_imp_headers_rec;

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;
2153: l_msg_count NUMBER := 0;
2154: l_exp_id NUMBER;

Line 2197: FROM cn_imp_headers

2193: , l_imp_header.server_flag
2194: , l_imp_header.imp_map_id
2195: , l_imp_header.source_column_num
2196: , l_imp_header.import_type_code
2197: FROM cn_imp_headers
2198: WHERE imp_header_id = p_imp_header_id;
2199:
2200: -- open process audit batch
2201: cn_message_pkg.begin_batch(

Line 2568: FROM cn_imp_headers h, cn_import_types t

2564: , t.view_name
2565: INTO l_name
2566: , l_type
2567: , l_view_name
2568: FROM cn_imp_headers h, cn_import_types t
2569: WHERE h.imp_header_id = p_imp_header_id AND t.import_type_code = h.import_type_code;
2570:
2571: -- open process audit batch
2572: cn_message_pkg.begin_batch(