430: g_imav_tbl OKL_IMA_PVT.imav_tbl_type;
431: g_imav_counter NUMBER := 0;
432:
433: TYPE msg_rec IS RECORD (
434: id okl_invoice_mssgs_v.id%type,
435: priority okl_invoice_mssgs_v.priority%type,
436: pkg_name okl_invoice_mssgs_v.pkg_name%type,
437: proc_name okl_invoice_mssgs_v.proc_name%type,
438: start_date okl_invoice_mssgs_v.start_date%TYPE,
431: g_imav_counter NUMBER := 0;
432:
433: TYPE msg_rec IS RECORD (
434: id okl_invoice_mssgs_v.id%type,
435: priority okl_invoice_mssgs_v.priority%type,
436: pkg_name okl_invoice_mssgs_v.pkg_name%type,
437: proc_name okl_invoice_mssgs_v.proc_name%type,
438: start_date okl_invoice_mssgs_v.start_date%TYPE,
439: end_date okl_invoice_mssgs_v.end_date%TYPE);
432:
433: TYPE msg_rec IS RECORD (
434: id okl_invoice_mssgs_v.id%type,
435: priority okl_invoice_mssgs_v.priority%type,
436: pkg_name okl_invoice_mssgs_v.pkg_name%type,
437: proc_name okl_invoice_mssgs_v.proc_name%type,
438: start_date okl_invoice_mssgs_v.start_date%TYPE,
439: end_date okl_invoice_mssgs_v.end_date%TYPE);
440: -- fmiao 5232919 change end
433: TYPE msg_rec IS RECORD (
434: id okl_invoice_mssgs_v.id%type,
435: priority okl_invoice_mssgs_v.priority%type,
436: pkg_name okl_invoice_mssgs_v.pkg_name%type,
437: proc_name okl_invoice_mssgs_v.proc_name%type,
438: start_date okl_invoice_mssgs_v.start_date%TYPE,
439: end_date okl_invoice_mssgs_v.end_date%TYPE);
440: -- fmiao 5232919 change end
441:
434: id okl_invoice_mssgs_v.id%type,
435: priority okl_invoice_mssgs_v.priority%type,
436: pkg_name okl_invoice_mssgs_v.pkg_name%type,
437: proc_name okl_invoice_mssgs_v.proc_name%type,
438: start_date okl_invoice_mssgs_v.start_date%TYPE,
439: end_date okl_invoice_mssgs_v.end_date%TYPE);
440: -- fmiao 5232919 change end
441:
442: TYPE msg_tbl IS TABLE OF msg_rec
435: priority okl_invoice_mssgs_v.priority%type,
436: pkg_name okl_invoice_mssgs_v.pkg_name%type,
437: proc_name okl_invoice_mssgs_v.proc_name%type,
438: start_date okl_invoice_mssgs_v.start_date%TYPE,
439: end_date okl_invoice_mssgs_v.end_date%TYPE);
440: -- fmiao 5232919 change end
441:
442: TYPE msg_tbl IS TABLE OF msg_rec
443: INDEX BY BINARY_INTEGER;