827:
828: -- generate sequence for header id
829: cursor cur_draft_inv_seq is
830: select jai_pa_draft_invoices_s.nextval
831: from dual ;
832:
833: -- generate sequence for line id
834: cursor cur_draft_inv_line_seq is
835: select jai_pa_draft_invoice_lines_s.nextval
832:
833: -- generate sequence for line id
834: cursor cur_draft_inv_line_seq is
835: select jai_pa_draft_invoice_lines_s.nextval
836: from dual ;
837:
838: --for credit memo invoice generation
839: -- this cursor find out organization id and location id from header table
840: