APPS.OKL_CONS_BILL dependencies on OKL_INVOICE_MSSGS_V

Line 351: FROM okl_invoice_mssgs_v

347: SELECT id,
348: priority,
349: pkg_name,
350: proc_name
351: FROM okl_invoice_mssgs_v
352: WHERE cp_consolidated_inv_date
353: BETWEEN NVL(START_DATE,cp_consolidated_inv_date) AND
354: NVL(END_DATE,cp_consolidated_inv_date);
355: -- fmiao 5232919 change end

Line 357: l_save_priority okl_invoice_mssgs_v.priority%TYPE;

353: BETWEEN NVL(START_DATE,cp_consolidated_inv_date) AND
354: NVL(END_DATE,cp_consolidated_inv_date);
355: -- fmiao 5232919 change end
356:
357: l_save_priority okl_invoice_mssgs_v.priority%TYPE;
358: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
359:
360: l_priority okl_invoice_mssgs_v.priority%TYPE;
361: l_pkg_name okl_invoice_mssgs_v.pkg_name%TYPE;

Line 358: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;

354: NVL(END_DATE,cp_consolidated_inv_date);
355: -- fmiao 5232919 change end
356:
357: l_save_priority okl_invoice_mssgs_v.priority%TYPE;
358: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
359:
360: l_priority okl_invoice_mssgs_v.priority%TYPE;
361: l_pkg_name okl_invoice_mssgs_v.pkg_name%TYPE;
362: l_proc_name okl_invoice_mssgs_v.proc_name%TYPE;

Line 360: l_priority okl_invoice_mssgs_v.priority%TYPE;

356:
357: l_save_priority okl_invoice_mssgs_v.priority%TYPE;
358: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
359:
360: l_priority okl_invoice_mssgs_v.priority%TYPE;
361: l_pkg_name okl_invoice_mssgs_v.pkg_name%TYPE;
362: l_proc_name okl_invoice_mssgs_v.proc_name%TYPE;
363:
364: l_bind_proc VARCHAR2(3000);

Line 361: l_pkg_name okl_invoice_mssgs_v.pkg_name%TYPE;

357: l_save_priority okl_invoice_mssgs_v.priority%TYPE;
358: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
359:
360: l_priority okl_invoice_mssgs_v.priority%TYPE;
361: l_pkg_name okl_invoice_mssgs_v.pkg_name%TYPE;
362: l_proc_name okl_invoice_mssgs_v.proc_name%TYPE;
363:
364: l_bind_proc VARCHAR2(3000);
365: l_msg_return VARCHAR2(1); --BOOLEAN;

Line 362: l_proc_name okl_invoice_mssgs_v.proc_name%TYPE;

358: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
359:
360: l_priority okl_invoice_mssgs_v.priority%TYPE;
361: l_pkg_name okl_invoice_mssgs_v.pkg_name%TYPE;
362: l_proc_name okl_invoice_mssgs_v.proc_name%TYPE;
363:
364: l_bind_proc VARCHAR2(3000);
365: l_msg_return VARCHAR2(1); --BOOLEAN;
366: l_ims_id okl_invoice_mssgs_v.id%TYPE;

Line 366: l_ims_id okl_invoice_mssgs_v.id%TYPE;

362: l_proc_name okl_invoice_mssgs_v.proc_name%TYPE;
363:
364: l_bind_proc VARCHAR2(3000);
365: l_msg_return VARCHAR2(1); --BOOLEAN;
366: l_ims_id okl_invoice_mssgs_v.id%TYPE;
367:
368:
369: BEGIN
370: IF (G_DEBUG_ENABLED = 'Y') THEN