eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_INVOICE_MSSGS_V

Line 2096: FROM okl_invoice_mssgs_v;

2092: SELECT id,
2093: priority,
2094: pkg_name,
2095: proc_name
2096: FROM okl_invoice_mssgs_v;
2097:
2098: l_save_priority okl_invoice_mssgs_v.priority%TYPE;
2099: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
2100:

Line 2098: l_save_priority okl_invoice_mssgs_v.priority%TYPE;

2094: pkg_name,
2095: proc_name
2096: FROM okl_invoice_mssgs_v;
2097:
2098: l_save_priority okl_invoice_mssgs_v.priority%TYPE;
2099: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
2100:
2101: l_priority okl_invoice_mssgs_v.priority%TYPE;
2102: l_pkg_name okl_invoice_mssgs_v.pkg_name%TYPE;

Line 2099: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;

2095: proc_name
2096: FROM okl_invoice_mssgs_v;
2097:
2098: l_save_priority okl_invoice_mssgs_v.priority%TYPE;
2099: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
2100:
2101: l_priority okl_invoice_mssgs_v.priority%TYPE;
2102: l_pkg_name okl_invoice_mssgs_v.pkg_name%TYPE;
2103: l_proc_name okl_invoice_mssgs_v.proc_name%TYPE;

Line 2101: l_priority okl_invoice_mssgs_v.priority%TYPE;

2097:
2098: l_save_priority okl_invoice_mssgs_v.priority%TYPE;
2099: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
2100:
2101: l_priority okl_invoice_mssgs_v.priority%TYPE;
2102: l_pkg_name okl_invoice_mssgs_v.pkg_name%TYPE;
2103: l_proc_name okl_invoice_mssgs_v.proc_name%TYPE;
2104:
2105: l_bind_proc VARCHAR2(3000);

Line 2102: l_pkg_name okl_invoice_mssgs_v.pkg_name%TYPE;

2098: l_save_priority okl_invoice_mssgs_v.priority%TYPE;
2099: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
2100:
2101: l_priority okl_invoice_mssgs_v.priority%TYPE;
2102: l_pkg_name okl_invoice_mssgs_v.pkg_name%TYPE;
2103: l_proc_name okl_invoice_mssgs_v.proc_name%TYPE;
2104:
2105: l_bind_proc VARCHAR2(3000);
2106: l_msg_return VARCHAR2(1); --BOOLEAN;

Line 2103: l_proc_name okl_invoice_mssgs_v.proc_name%TYPE;

2099: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
2100:
2101: l_priority okl_invoice_mssgs_v.priority%TYPE;
2102: l_pkg_name okl_invoice_mssgs_v.pkg_name%TYPE;
2103: l_proc_name okl_invoice_mssgs_v.proc_name%TYPE;
2104:
2105: l_bind_proc VARCHAR2(3000);
2106: l_msg_return VARCHAR2(1); --BOOLEAN;
2107: l_ims_id okl_invoice_mssgs_v.id%TYPE;

Line 2107: l_ims_id okl_invoice_mssgs_v.id%TYPE;

2103: l_proc_name okl_invoice_mssgs_v.proc_name%TYPE;
2104:
2105: l_bind_proc VARCHAR2(3000);
2106: l_msg_return VARCHAR2(1); --BOOLEAN;
2107: l_ims_id okl_invoice_mssgs_v.id%TYPE;
2108:
2109:
2110: BEGIN
2111:

Line 2475: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;

2471: -- temporary records for storing CNR table of records
2472: l_cnr_tbl cnr_tbl_type;
2473: -- ssiruvol - Bug#5354130 - Added - End
2474:
2475: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
2476: l_save_priority okl_invoice_mssgs_v.priority%TYPE;
2477: l_bind_proc VARCHAR2(3000);
2478: l_msg_return VARCHAR2(1);
2479:

Line 2476: l_save_priority okl_invoice_mssgs_v.priority%TYPE;

2472: l_cnr_tbl cnr_tbl_type;
2473: -- ssiruvol - Bug#5354130 - Added - End
2474:
2475: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
2476: l_save_priority okl_invoice_mssgs_v.priority%TYPE;
2477: l_bind_proc VARCHAR2(3000);
2478: l_msg_return VARCHAR2(1);
2479:
2480: p_api_version NUMBER := 1.0;

Line 3313: FROM okl_invoice_mssgs_v;

3309: -- based on the consolidated invoice date
3310: CURSOR msg_csr_perf IS
3311: SELECT id, priority, pkg_name, proc_name
3312: , start_date, end_date
3313: FROM okl_invoice_mssgs_v;
3314: -- fmiao - Bug#5232919 - Modified - End
3315:
3316: BEGIN
3317:

Line 4183: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;

4179: -- Defining table record for out record of Invoice Message Attribute
4180: x_imav_tbl Okl_Ima_Pvt.imav_tbl_type;
4181: -- fmiao - Bug#5232919 - Modified - End
4182:
4183: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
4184: l_save_priority okl_invoice_mssgs_v.priority%TYPE;
4185: l_bind_proc VARCHAR2(3000);
4186: l_msg_return VARCHAR2(1);
4187:

Line 4184: l_save_priority okl_invoice_mssgs_v.priority%TYPE;

4180: x_imav_tbl Okl_Ima_Pvt.imav_tbl_type;
4181: -- fmiao - Bug#5232919 - Modified - End
4182:
4183: l_save_ims_id okl_invoice_mssgs_v.id%TYPE;
4184: l_save_priority okl_invoice_mssgs_v.priority%TYPE;
4185: l_bind_proc VARCHAR2(3000);
4186: l_msg_return VARCHAR2(1);
4187:
4188: l_temp_cnr_id number;