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 1400: CURSOR cur_get_gl_date(cp_account_class ra_cust_trx_line_gl_dist_all.account_class%type)

1396: WHERE
1397: customer_trx_id = pr_new.customer_trx_id ;
1398:
1399:
1400: CURSOR cur_get_gl_date(cp_account_class ra_cust_trx_line_gl_dist_all.account_class%type)
1401: IS
1402: SELECT
1403: gl_date
1404: FROM

Line 1405: ra_cust_trx_line_gl_dist_all

1401: IS
1402: SELECT
1403: gl_date
1404: FROM
1405: ra_cust_trx_line_gl_dist_all
1406: WHERE
1407: customer_trx_id = pr_new.customer_trx_id AND
1408: account_class = cp_account_class AND /* 'REC' AND -- Ramananda for removal of SQL LITERALs */
1409: latest_rec_flag = 'Y';

Line 1424: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;

1420: lv_pla_cess_avlbl VARCHAR2(10);
1421: lv_vat_invoice_number JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
1422: lv_vat_taxes_exist VARCHAR2(1);
1423: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE; -- := 'N'; --Ramananda for File.Sql.35
1424: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
1425: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1426: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1427:
1428:

Line 2787: lv_acct_class_tax RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;

2783: v_order_type VARCHAR2(30);
2784:
2785: lv_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;
2786: lv_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;
2787: lv_acct_class_tax RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;
2788: lv_acct_class_freight RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;
2789:
2790: ld_st_accrual_date DATE; /*11821537*/
2791:

Line 2788: lv_acct_class_freight RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;

2784:
2785: lv_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;
2786: lv_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%type ;
2787: lv_acct_class_tax RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;
2788: lv_acct_class_freight RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%type ;
2789:
2790: ld_st_accrual_date DATE; /*11821537*/
2791:
2792: /*Bug 11821537 - Fetch the effective date on which Service Tax needs to accounted in accrual basis instead of cash*/

Line 2841: FROM ra_cust_trx_line_gl_dist_all

2837:
2838: --Xiao for POT changes, reg bug#12533434
2839: CURSOR c_get_trx_date(pn_customer_trx_line_id NUMBER) IS
2840: SELECT gl_date
2841: FROM ra_cust_trx_line_gl_dist_all
2842: WHERE customer_trx_id = pr_new.customer_trx_id
2843: AND customer_trx_line_id = pn_customer_trx_line_id
2844: AND account_class = 'REV';
2845:

Line 2869: FROM RA_CUST_TRX_LINE_GL_DIST_ALL

2865: --('TAX','FREIGHT');
2866:
2867: CURSOR C_GET_GL_DIST_ALL_COUNT IS
2868: SELECT COUNT(*)
2869: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
2870: WHERE CUSTOMER_TRX_ID = pr_new.CUSTOMER_TRX_ID
2871: AND ACCOUNT_CLASS IN (lv_acct_class_tax , lv_acct_class_freight ); /* Modified by Ramananda for removal of SQL LITERALs */
2872: --AND ACCOUNT_CLASS IN ('TAX','FREIGHT');
2873:

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

3032:
3033:
3034:
3035: IF v_TRX_TAX_COUNT <> v_trx_gl_dist_COUNT THEN
3036: /* RAISE_APPLICATION_ERROR(-20102,'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables');
3037: */ 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 ;
3038: END IF ;
3039:
3040: FOR v_trx_rec in C_GET_TRX_DETAILS

Line 3037: */ 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 ;

3033:
3034:
3035: IF v_TRX_TAX_COUNT <> v_trx_gl_dist_COUNT THEN
3036: /* RAISE_APPLICATION_ERROR(-20102,'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables');
3037: */ 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 ;
3038: END IF ;
3039:
3040: FOR v_trx_rec in C_GET_TRX_DETAILS
3041:

Line 3990: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;

3986: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
3987: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;
3988: lv_process_flag VARCHAR2(10) ;
3989: lv_process_message VARCHAR2(4000) ;
3990: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;
3991: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE ;
3992:
3993: ln_rma_flag NUMBER;
3994: ln_order_line_id NUMBER;

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

4084: AND regime_code = jai_constants.vat_regime
4085: AND jtc.org_id = pr_new.org_id ;
4086:
4087:
4088: CURSOR cur_get_gl_date(cp_acct_class ra_cust_trx_line_gl_dist_all.account_class%type)
4089: IS
4090: SELECT gl_date
4091: FROM ra_cust_trx_line_gl_dist_all
4092: WHERE customer_trx_id = pr_new.customer_trx_id

Line 4091: FROM ra_cust_trx_line_gl_dist_all

4087:
4088: CURSOR cur_get_gl_date(cp_acct_class ra_cust_trx_line_gl_dist_all.account_class%type)
4089: IS
4090: SELECT gl_date
4091: FROM ra_cust_trx_line_gl_dist_all
4092: WHERE customer_trx_id = pr_new.customer_trx_id
4093: AND account_class = cp_acct_class
4094: AND latest_rec_flag = 'Y';
4095: