Line 1234: select EDR_PSIG_DETAILS_S.nextval into l_signature_id from dual;
1230: END IF;
1231:
1232: --Bug 3330240 : end
1233: /* Get New Signature Id */ 1234: select EDR_PSIG_DETAILS_S.nextval into l_signature_id from dual; 1235: /* Insert signature Details */
1236:
1237: --Bug 3330240 : Start
1238: --Inert the adhoc_status, signature_sequence also