DBA Data[Home] [Help]

APPS.GMD_QC_MIG12 dependencies on QC_TEXT_TBL

Line 646: FROM qc_text_tbl

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:

Line 649: l_text_rec qc_text_tbl%ROWTYPE;

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:

Line 687: Insert qc_text_tbl.

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;

Line 696: INSERT INTO qc_text_tbl

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,

Line 729: GMA_QC_TEXT_TBL_PKG.INSERT_ROW (

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,