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_AR_RCTA_TRIGGER_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 2407: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;

2403: v_salesrep_id NUMBER;
2404: v_line_type VARCHAR2(30);
2405: v_vat_tax NUMBER;
2406: v_ccid NUMBER;
2407: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;
2408: v_customer_trx_line_id NUMBER ;
2409: v_customer_trx_id NUMBER; -- := pr_new.customer_trx_id; --Ramananda for File.Sql.35
2410: v_created_from VARCHAR2(30);
2411: c_from_currency_code VARCHAR2(15);

Line 2427: lv_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;

2423: v_org_id NUMBER(15);
2424: -- Bug 5207772. Added by Lakshmi Gopalsami
2425: v_order_type VARCHAR2(30);
2426:
2427: lv_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;
2428: lv_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;
2429: lv_acct_class_tax RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;
2430: lv_acct_class_freight RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;
2431:

Line 2428: lv_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;

2424: -- Bug 5207772. Added by Lakshmi Gopalsami
2425: v_order_type VARCHAR2(30);
2426:
2427: lv_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;
2428: lv_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;
2429: lv_acct_class_tax RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;
2430: lv_acct_class_freight RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;
2431:
2432: -- CURSOR ADDED BY SRIRAM - BUG # 2654567

Line 2443: FROM RA_CUSTOMER_TRX_LINES_ALL

2439:
2440: CURSOR C_GET_TRX_COUNT
2441: IS
2442: SELECT COUNT(*)
2443: FROM RA_CUSTOMER_TRX_LINES_ALL
2444: WHERE CUSTOMER_TRX_ID = pr_new.CUSTOMER_TRX_ID
2445: AND LINE_TYPE in (lv_line_type_tax, lv_line_type_freight); /* Modified by Ramananda for removal of SQL LITERALs */
2446: --('TAX','FREIGHT');
2447:

Line 2606: /* RAISE_APPLICATION_ERROR(-20102,'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables');

2602:
2603:
2604:
2605: IF v_TRX_TAX_COUNT <> v_trx_gl_dist_COUNT THEN
2606: /* RAISE_APPLICATION_ERROR(-20102,'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables');
2607: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables' ; return ;
2608: END IF ;
2609:
2610: FOR v_trx_rec in C_GET_TRX_DETAILS

Line 2607: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables' ; return ;

2603:
2604:
2605: IF v_TRX_TAX_COUNT <> v_trx_gl_dist_COUNT THEN
2606: /* RAISE_APPLICATION_ERROR(-20102,'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables');
2607: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables' ; return ;
2608: END IF ;
2609:
2610: FOR v_trx_rec in C_GET_TRX_DETAILS
2611: