650: ==============================*/
651:
652: CURSOR get_text_dtl IS
653: SELECT *
654: FROM qc_text_tbl
655: WHERE text_code = p_text_code;
656:
657: l_text_rec qc_text_tbl%ROWTYPE;
658:
653: SELECT *
654: FROM qc_text_tbl
655: WHERE text_code = p_text_code;
656:
657: l_text_rec qc_text_tbl%ROWTYPE;
658:
659: BEGIN
660:
661:
691: );
692:
693:
694: /*====================================
695: Insert qc_text_tbl.
696: ====================================*/
697:
698: OPEN get_text_dtl;
699: FETCH get_text_dtl INTO l_text_rec;
700: WHILE get_text_dtl%FOUND LOOP
701: /*=============================
702: Insert a Copy.
703: =============================*/
704: INSERT INTO qc_text_tbl
705: (
706: TEXT_CODE,
707: LANG_CODE,
708: PARAGRAPH_CODE,
733: /*=============================
734: Insert to TL Table.
735: =============================*/
736:
737: GMA_QC_TEXT_TBL_PKG.INSERT_ROW (
738: X_ROWID => l_rowid,
739: X_TEXT_CODE => l_text_code,
740: X_LANG_CODE => l_text_rec.lang_code,
741: X_PARAGRAPH_CODE => l_text_rec.paragraph_code,