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.JAI_OPEN_API_PKG dependencies on USER_PROCEDURES

Line 6197: lv_object_name user_procedures.object_name%type;

6193: PROCEDURE delete_trx_data(p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
6194: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,
6195: p_process_status OUT NOCOPY VARCHAR2,
6196: p_process_message OUT NOCOPY VARCHAR2) IS
6197: lv_object_name user_procedures.object_name%type;
6198: lv_procedure_name user_procedures.procedure_name%type;
6199: ln_exists NUMBER := 0;
6200: lv_sqlstmt VARCHAR2(2000);
6201: lv_account_class_tax VARCHAR2(10) := 'TAX';

Line 6198: lv_procedure_name user_procedures.procedure_name%type;

6194: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,
6195: p_process_status OUT NOCOPY VARCHAR2,
6196: p_process_message OUT NOCOPY VARCHAR2) IS
6197: lv_object_name user_procedures.object_name%type;
6198: lv_procedure_name user_procedures.procedure_name%type;
6199: ln_exists NUMBER := 0;
6200: lv_sqlstmt VARCHAR2(2000);
6201: lv_account_class_tax VARCHAR2(10) := 'TAX';
6202: lv_account_class_freight VARCHAR2(10) := 'FREIGHT';

Line 6225: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type, cp_procedure_name user_procedures.procedure_name%type) IS

6221: NVL(cp_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
6222: ORDER BY link_to_cust_trx_line_id, customer_trx_line_id;
6223:
6224: /* Ramananda for bug#5219225. */
6225: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type, cp_procedure_name user_procedures.procedure_name%type) IS
6226: SELECT 1
6227: FROM user_procedures
6228: WHERE object_name = cp_object_name
6229: AND procedure_name = cp_procedure_name;

Line 6227: FROM user_procedures

6223:
6224: /* Ramananda for bug#5219225. */
6225: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type, cp_procedure_name user_procedures.procedure_name%type) IS
6226: SELECT 1
6227: FROM user_procedures
6228: WHERE object_name = cp_object_name
6229: AND procedure_name = cp_procedure_name;
6230:
6231: BEGIN