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_CUST_TRX_LINE_GL_DIST_ALL

Line 643: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;

639: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
640: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;
641: lv_process_flag VARCHAR2(10) ;
642: lv_process_message VARCHAR2(4000) ;
643: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;
644: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE ;
645:
646:
647: /*

Line 699: CURSOR cur_get_gl_date(cp_acct_class ra_cust_trx_line_gl_dist_all.account_class%type)

695: regime_code = jai_constants.vat_regime AND
696: jtc.org_id = pr_new.org_id ;
697:
698:
699: CURSOR cur_get_gl_date(cp_acct_class ra_cust_trx_line_gl_dist_all.account_class%type)
700: IS
701: SELECT
702: gl_date
703: FROM

Line 704: ra_cust_trx_line_gl_dist_all

700: IS
701: SELECT
702: gl_date
703: FROM
704: ra_cust_trx_line_gl_dist_all
705: WHERE
706: customer_trx_id = pr_new.customer_trx_id AND
707: account_class = cp_acct_class AND /*--'REC' AND*/
708: latest_rec_flag = 'Y';

Line 1371: CURSOR cur_get_gl_date(cp_account_class ra_cust_trx_line_gl_dist_all.account_class%type)

1367: WHERE
1368: customer_trx_id = pr_new.customer_trx_id ;
1369:
1370:
1371: CURSOR cur_get_gl_date(cp_account_class ra_cust_trx_line_gl_dist_all.account_class%type)
1372: IS
1373: SELECT
1374: gl_date
1375: FROM

Line 1376: ra_cust_trx_line_gl_dist_all

1372: IS
1373: SELECT
1374: gl_date
1375: FROM
1376: ra_cust_trx_line_gl_dist_all
1377: WHERE
1378: customer_trx_id = pr_new.customer_trx_id AND
1379: account_class = cp_account_class AND /* 'REC' AND -- Ramananda for removal of SQL LITERALs */
1380: latest_rec_flag = 'Y';

Line 1395: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;

1391: lv_pla_cess_avlbl VARCHAR2(10);
1392: lv_vat_invoice_number JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
1393: lv_vat_taxes_exist VARCHAR2(1);
1394: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE; -- := 'N'; --Ramananda for File.Sql.35
1395: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
1396: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1397: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1398:
1399:

Line 2429: lv_acct_class_tax RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;

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
2433:

Line 2430: lv_acct_class_freight RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;

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
2433:
2434: CURSOR C_GET_TRX_DETAILS

Line 2450: FROM RA_CUST_TRX_LINE_GL_DIST_ALL

2446: --('TAX','FREIGHT');
2447:
2448: CURSOR C_GET_GL_DIST_ALL_COUNT IS
2449: SELECT COUNT(*)
2450: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
2451: WHERE CUSTOMER_TRX_ID = pr_new.CUSTOMER_TRX_ID
2452: AND ACCOUNT_CLASS IN (lv_acct_class_tax , lv_acct_class_freight ); /* Modified by Ramananda for removal of SQL LITERALs */
2453: --AND ACCOUNT_CLASS IN ('TAX','FREIGHT');
2454:

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: