868:
869: -- generate sequence for header id
870: cursor cur_draft_inv_seq is
871: select jai_pa_draft_invoices_s.nextval
872: from dual ;
873:
874: -- generate sequence for line id
875: cursor cur_draft_inv_line_seq is
876: select jai_pa_draft_invoice_lines_s.nextval
873:
874: -- generate sequence for line id
875: cursor cur_draft_inv_line_seq is
876: select jai_pa_draft_invoice_lines_s.nextval
877: from dual ;
878:
879: --for credit memo invoice generation
880: -- this cursor find out organization id and location id from header table
881: