844: ) IS
845: l_api_name CONSTANT VARCHAR2(30) := 'Hierarchy_Import';
846:
847: l_stage_status cn_imp_lines.status_code%TYPE := 'STAGE';
848: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type
849: := cn_imp_headers_pvt.G_MISS_IMP_HEADERS_REC;
850: l_processed_row NUMBER := 0;
851: l_failed_row NUMBER := 0;
852: l_message VARCHAR2(2000);
845: l_api_name CONSTANT VARCHAR2(30) := 'Hierarchy_Import';
846:
847: l_stage_status cn_imp_lines.status_code%TYPE := 'STAGE';
848: l_imp_header cn_imp_headers_pvt.imp_headers_rec_type
849: := cn_imp_headers_pvt.G_MISS_IMP_HEADERS_REC;
850: l_processed_row NUMBER := 0;
851: l_failed_row NUMBER := 0;
852: l_message VARCHAR2(2000);
853: l_error_code VARCHAR2(30);
949: import_type_code
950: INTO l_imp_header.name ,l_imp_header.status_code ,
951: l_imp_header.server_flag, l_imp_header.imp_map_id,
952: l_imp_header.source_column_num,l_imp_header.import_type_code
953: FROM cn_imp_headers
954: WHERE imp_header_id = p_imp_header_id;
955:
956: l_hier_record.imp_header_id := p_imp_header_id;
957: