Line 26: SELECT Gem5_text_code_s.nextval INTO l_text_code FROM sys.dual;
22: Begin
23:
24: /* Get the text code */
25: IF (Cur_lab_tmp.text_code IS NOT NULL) THEN 26: SELECT Gem5_text_code_s.nextval INTO l_text_code FROM sys.dual; 27:
28: OPEN Cur_get_text(Cur_lab_tmp.text_code);
29: LOOP
30: FETCH Cur_get_text INTO l_temp_rec;
Line 95: FROM DUAL ;
91: 'SY_ORGN_MST',
92: Cur_lab_tmp.lab_type,
93: Cur_lab_tmp.lab_type,
94: error_msg 95: FROM DUAL ; 96: End;
97:
98: END LOOP;
99: