APPS.CN_IMPORT_PVT dependencies on CN_PROCESS_AUDITS

Line 88: l_process_audit_id cn_process_audits.process_audit_id%TYPE;

84:
85: l_request_id NUMBER;
86: l_imp_type_code VARCHAR2(30);
87: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type := cn_imp_headers_pvt.G_MISS_IMP_HEADERS_REC;
88: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
89:
90: BEGIN
91: -- Standard Start of API savepoint
92: SAVEPOINT Import_Data;

Line 298: l_process_audit_id cn_process_audits.process_audit_id%TYPE;

294: l_imp_type_code VARCHAR2(30);
295: l_name VARCHAR2(30);
296: l_status_code VARCHAR2(30);
297: l_conc_pgm VARCHAR2(150);
298: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
299:
300: BEGIN
301: -- Standard Start of API savepoint
302: SAVEPOINT Export_Data;

Line 472: l_process_audit_id cn_process_audits.process_audit_id%TYPE;

468: l_loaded_rows NUMBER;
469: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type := cn_imp_headers_pvt.G_MISS_IMP_HEADERS_REC;
470: l_imp_type_code VARCHAR2(30);
471: l_msg_count NUMBER := 0;
472: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
473: l_api_name CONSTANT VARCHAR2(30) := 'Server_Stage_data';
474: l_api_version CONSTANT NUMBER := 1.0;
475: err_num NUMBER;
476:

Line 744: l_process_audit_id cn_process_audits.process_audit_id%TYPE;

740: l_message VARCHAR2(240);
741: l_loaded_rows NUMBER;
742:
743: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type := cn_imp_headers_pvt.G_MISS_IMP_HEADERS_REC;
744: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
745: l_imp_type_code VARCHAR2(30);
746: l_conc_program VARCHAR2(30);
747:
748: l_msg_count NUMBER := 0;

Line 955: l_process_audit_id cn_process_audits.process_audit_id%TYPE;

951: l_api_version CONSTANT NUMBER := 1.0;
952:
953: l_imp_type_code VARCHAR2(30);
954: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type := cn_imp_headers_pvt.G_MISS_IMP_HEADERS_REC;
955: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
956:
957: CURSOR c_tar_col_cv(c_imp_map_id NUMBER) IS
958: SELECT f.source_column,f.target_column_name,f.target_table_name,
959: m.object_version_number map_obj_ver