DBA Data[Home] [Help]

APPS.GMD_QC_MIG12 dependencies on QC_TEXT_TBL

Line 654: FROM qc_text_tbl

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:

Line 657: l_text_rec qc_text_tbl%ROWTYPE;

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:

Line 695: Insert qc_text_tbl.

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;

Line 704: INSERT INTO qc_text_tbl

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,

Line 737: GMA_QC_TEXT_TBL_PKG.INSERT_ROW (

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,