2807: l_tmp_score_name VARCHAR2(60);
2808: l_SCORE_COMP_REC IEX_SCORE_PUB.SCORE_COMP_REC_TYPE ;
2809: l_score_comp_id NUMBER ;
2810: l_score_comp_id_new NUMBER ;
2811: l_score_comp_id_tbl DBMS_SQL.NUMBER_TABLE;
2812: l_score_comp_id_new_tbl DBMS_SQL.NUMBER_TABLE;
2813: l_SCORE_COMP_DET_REC IEX_SCORE_PUB.SCORE_COMP_DET_REC_TYPE;
2814: l_score_comp_det_id NUMBER;
2815: idx NUMBER;
2808: l_SCORE_COMP_REC IEX_SCORE_PUB.SCORE_COMP_REC_TYPE ;
2809: l_score_comp_id NUMBER ;
2810: l_score_comp_id_new NUMBER ;
2811: l_score_comp_id_tbl DBMS_SQL.NUMBER_TABLE;
2812: l_score_comp_id_new_tbl DBMS_SQL.NUMBER_TABLE;
2813: l_SCORE_COMP_DET_REC IEX_SCORE_PUB.SCORE_COMP_DET_REC_TYPE;
2814: l_score_comp_det_id NUMBER;
2815: idx NUMBER;
2816: newidx NUMBER;