DBA Data[Home] [Help]

APPS.CN_IMP_TRXAPI_PVT dependencies on CN_IMP_HEADERS

Line 197: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type := cn_imp_headers_pvt.G_MISS_IMP_HEADERS_REC;

193: l_header_list VARCHAR2(2000);
194: l_sql_stmt VARCHAR2(2000);
195: err_num NUMBER;
196: l_msg_count NUMBER := 0;
197: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type := cn_imp_headers_pvt.G_MISS_IMP_HEADERS_REC;
198: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
199: l_temp NUMBER;
200: l_err_flag CHAR(1);
201:

Line 211: FROM cn_imp_headers

207: import_type_code
208: INTO l_imp_header.name ,l_imp_header.status_code ,
209: l_imp_header.server_flag, l_imp_header.imp_map_id,
210: l_imp_header.source_column_num,l_imp_header.import_type_code
211: FROM cn_imp_headers
212: WHERE imp_header_id = p_imp_header_id;
213:
214: -- open process audit batch
215: cn_message_pkg.begin_batch