APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_IMP_HEADERS

Line 2130: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type

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;

Line 2131: := cn_imp_headers_pvt.g_miss_imp_headers_rec;

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;

Line 2178: FROM cn_imp_headers

2174: , l_imp_header.server_flag
2175: , l_imp_header.imp_map_id
2176: , l_imp_header.source_column_num
2177: , l_imp_header.import_type_code
2178: FROM cn_imp_headers
2179: WHERE imp_header_id = p_imp_header_id;
2180:
2181: -- open process audit batch
2182: cn_message_pkg.begin_batch(

Line 2550: FROM cn_imp_headers h, cn_import_types t

2546: , t.view_name
2547: INTO l_name
2548: , l_type
2549: , l_view_name
2550: FROM cn_imp_headers h, cn_import_types t
2551: WHERE h.imp_header_id = p_imp_header_id AND t.import_type_code = h.import_type_code;
2552:
2553: -- open process audit batch
2554: cn_message_pkg.begin_batch(