DBA Data[Home] [Help]

APPS.CN_IMPORT_PVT dependencies on CN_IMP_HEADERS_PVT

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

83: l_api_version CONSTANT NUMBER := 1.0;
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

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

465: l_dev_phase VARCHAR2(30);
466: l_dev_status VARCHAR2(30);
467: l_message VARCHAR2(240);
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';

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

739: l_dev_status VARCHAR2(30);
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:

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

950: l_api_name CONSTANT VARCHAR2(30) := 'Client_Stage_Data';
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,