DBA Data[Home] [Help]

APPS.GMA_EDITTEXT_PKG dependencies on GEM5_TEXT_CODE_S

Line 52: SELECT gem5_text_code_s.nextval into l_New_Text_code

48: -- Process the new insert if rows exists otherwise no
49: IF dbms_sql.fetch_rows (l_Cursor) > 0 THEN
50:
51: -- Generate new Text_code from sequence.
52: SELECT gem5_text_code_s.nextval into l_New_Text_code
53: FROM DUAL;
54:
55: -- Main sql stmt which inserts all text lines, replacing text_code with sequence
56: l_TL_Sql_statement:= 'INSERT INTO '||X_To_Text_table||