Line 1236: SELECT gem5_journal_id_s.nextval INTO x_ic_jrnl_mst_row.journal_id FROM DUAL;
1232: x_ic_jrnl_mst_row := p_ic_jrnl_mst_row;
1233:
1234: IF x_ic_jrnl_mst_row.journal_id IS NULL
1235: THEN 1236: SELECT gem5_journal_id_s.nextval INTO x_ic_jrnl_mst_row.journal_id FROM DUAL; 1237: END IF;
1238:
1239: INSERT INTO ic_jrnl_mst
1240: ( journal_id