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);