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_ALL

Line 944: REM Removed references to ra_customer_trx_all and replaced it with jai_ar_trx.

940: REM -----------------------------------------------------------------------
941: REM 1. 04-Jul-2006 aiyer 5364288 120.3
942: REM -----------------------------------------------------------------------
943: REM Comments:-
944: REM Removed references to ra_customer_trx_all and replaced it with jai_ar_trx.
945: REM -----------------------------------------------------------------------
946: REM 2. 01-Sep-2010 Bo Li 10043656 12.1.3
947: REM -----------------------------------------------------------------------
948: REM Comments:- GST Enhancement

Line 1284: CURSOR cur_chk_temp_lines_exist( cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE ) /* changed the RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE to JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE for the bug 5364288 */

1280: || Cursor added by aiyer for the bug 4185033
1281: || Check whether the JAI_AR_TRX_INS_LINES_T table still has the row corresponding to the current
1282: || customer_trx_id
1283: */
1284: CURSOR cur_chk_temp_lines_exist( cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE ) /* changed the RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE to JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE for the bug 5364288 */
1285: IS
1286: /* commented and added the below for bug#11664009 and added the below
1287: SELECT
1288: 1

Line 2738: REM Removed references to ra_customer_trx_all and replaced it with jai_ar_trx.

2734: REM -----------------------------------------------------------------------
2735: REM 1. 04-Jul-2006 aiyer 5364288 120.3
2736: REM -----------------------------------------------------------------------
2737: REM Comments:-
2738: REM Removed references to ra_customer_trx_all and replaced it with jai_ar_trx.
2739: REM also removed the cursor org_cur which was trying to fetch the org_id from ra_customer_trx_all.
2740: REM This was not required as pr_new.org_id is already being passed to the procedure and has the
2741: REM value of org_id.
2742: REM -----------------------------------------------------------------------

Line 2739: REM also removed the cursor org_cur which was trying to fetch the org_id from ra_customer_trx_all.

2735: REM 1. 04-Jul-2006 aiyer 5364288 120.3
2736: REM -----------------------------------------------------------------------
2737: REM Comments:-
2738: REM Removed references to ra_customer_trx_all and replaced it with jai_ar_trx.
2739: REM also removed the cursor org_cur which was trying to fetch the org_id from ra_customer_trx_all.
2740: REM This was not required as pr_new.org_id is already being passed to the procedure and has the
2741: REM value of org_id.
2742: REM -----------------------------------------------------------------------
2743: REM 2. 24-May-2011 Xiao for POT change, reg bug#12533434.

Line 2977: ||changed the variable definition from RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE to JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE

2973: v_err_mesg VARCHAR2(250);
2974:
2975: /*
2976: || start of bug 5364288 - code modified by aiyer
2977: ||changed the variable definition from RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE to JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE
2978: */
2979: v_trx_num JAI_AR_TRXS.TRX_NUMBER%TYPE;
2980:
2981: /* End of bug 5364288 */

Line 3067: || Assigned the value of pr_new.org_id to v_org and instead removed the cursor org_cur which was picking org_id from ra_customer_trx_all

3063: c_conversion_date := pr_new.exchange_date ;
3064: c_conversion_rate := pr_new.exchange_rate;
3065:
3066: /*
3067: || Assigned the value of pr_new.org_id to v_org and instead removed the cursor org_cur which was picking org_id from ra_customer_trx_all
3068: || and causing mutation issue
3069: */
3070: v_org_id := pr_new.org_id;
3071: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);