642: ==============================*/
643:
644: CURSOR get_text_dtl IS
645: SELECT *
646: FROM qc_text_tbl
647: WHERE text_code = p_text_code;
648:
649: l_text_rec qc_text_tbl%ROWTYPE;
650:
645: SELECT *
646: FROM qc_text_tbl
647: WHERE text_code = p_text_code;
648:
649: l_text_rec qc_text_tbl%ROWTYPE;
650:
651: BEGIN
652:
653:
683: );
684:
685:
686: /*====================================
687: Insert qc_text_tbl.
688: ====================================*/
689:
690: OPEN get_text_dtl;
691: FETCH get_text_dtl INTO l_text_rec;
692: WHILE get_text_dtl%FOUND LOOP
693: /*=============================
694: Insert a Copy.
695: =============================*/
696: INSERT INTO qc_text_tbl
697: (
698: TEXT_CODE,
699: LANG_CODE,
700: PARAGRAPH_CODE,
725: /*=============================
726: Insert to TL Table.
727: =============================*/
728:
729: GMA_QC_TEXT_TBL_PKG.INSERT_ROW (
730: X_ROWID => l_rowid,
731: X_TEXT_CODE => l_text_code,
732: X_LANG_CODE => l_text_rec.lang_code,
733: X_PARAGRAPH_CODE => l_text_rec.paragraph_code,