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.AR_ARXCCS_XMLP_PKG dependencies on GL_CURRENCY_API

Line 1132: gl_currency_api.convert_amount_sql

1128: l_aging_unapplied_profile -
1129: l_aging_on_account_profile;
1130:
1131: base_amount :=
1132: gl_currency_api.convert_amount_sql
1133: ( trx_curr,
1134: CP_limit_currency,
1135: SYSDATE,
1136: 'Corporate',

Line 3041: Xchg_rate := gl_currency_api.get_rate_sql

3037: /*srw.message(300,'DEBUG: trx_curr :'||trx_cur);*/null;
3038:
3039: /*srw.message(300,'DEBUG: cp_limit_currency :'||CP_limit_currency);*/null;
3040:
3041: Xchg_rate := gl_currency_api.get_rate_sql
3042: (trx_cur,CP_limit_currency,SYSDATE,'Corporate');
3043:
3044: if Xchg_rate = -1 then
3045:

Line 3081: CP_limit_curr_amt := gl_currency_api.convert_amount_sql(trx_cur,CP_limit_currency,SYSDATE,'Corporate',CP_adjusted_amount);

3077:
3078:
3079: cp_adjusted_amount := trx_amount_due - l_aging_unapplied_profile - l_aging_on_account_profile;
3080:
3081: CP_limit_curr_amt := gl_currency_api.convert_amount_sql(trx_cur,CP_limit_currency,SYSDATE,'Corporate',CP_adjusted_amount);
3082:
3083: if CP_limit_curr_amt = -1 then
3084: CP_limit_curr_amt:=TO_NUMBER(null);
3085:

Line 3146: Xchg_rate := gl_currency_api.get_rate_sql

3142: /*srw.message(300, 'DEBUG: present : '|| to_char(present));*/null;
3143:
3144:
3145: if present <> 0 then
3146: Xchg_rate := gl_currency_api.get_rate_sql
3147: (trx_cur2,limit_currency,SYSDATE,'Corporate');
3148: if Xchg_rate = -1 then
3149:
3150: FND_MESSAGE.SET_NAME('AR','AR_CC_INVALID_EXCHANGE_RATE');

Line 3189: Cp_limit_curr_amt1 := gl_currency_api.convert_amount_sql(trx_cur2,limit_currency,SYSDATE,NULL,CP_adjusted_amount1);

3185:
3186:
3187: cp_adjusted_amount1 := trx_amount_due1 - l_aging_unapplied_profile - l_aging_on_account_profile;
3188:
3189: Cp_limit_curr_amt1 := gl_currency_api.convert_amount_sql(trx_cur2,limit_currency,SYSDATE,NULL,CP_adjusted_amount1);
3190:
3191: if Cp_limit_curr_amt1 = -1 then
3192: Cp_limit_curr_amt1:=TO_NUMBER(null);
3193: FND_MESSAGE.SET_NAME('AR','AR_CC_INVALID_EXCHANGE_RATE');

Line 3344: base_amount := gl_currency_api.convert_amount_sql(trx_curr,limit_currency,SYSDATE,'Corporate',trx_amount);

3340: and ar_receivable_applications.gl_date <= sysdate;
3341:
3342: trx_amount := trx_rec.ammount_due - l_aging_unapplied_profile - l_aging_on_account_profile;
3343:
3344: base_amount := gl_currency_api.convert_amount_sql(trx_curr,limit_currency,SYSDATE,'Corporate',trx_amount);
3345: IF base_amount = -1 THEN
3346: FND_MESSAGE.SET_NAME('AR','AR_CC_INVALID_EXCHANGE_RATE');
3347: FND_MESSAGE.SET_TOKEN('CC',trx_curr,FALSE);
3348: /*SRW.MESSAGE(200,FND_MESSAGE.GET);*/null;

Line 3439: Xchg_rate := gl_currency_api.get_rate_sql(org_trx_cur,limit_currency,SYSDATE,NULL);

3435: /*srw.message(300, 'DEBUG: present : '|| to_char(present));*/null;
3436:
3437:
3438: if present <> 0 then
3439: Xchg_rate := gl_currency_api.get_rate_sql(org_trx_cur,limit_currency,SYSDATE,NULL);
3440: if Xchg_rate = -1 then
3441: FND_MESSAGE.SET_NAME('AR','AR_CC_INVALID_EXCHANGE_RATE');
3442: FND_MESSAGE.SET_TOKEN('CC',org_trx_cur,FALSE);
3443: /*SRW.MESSAGE(300,FND_MESSAGE.GET);*/null;

Line 3480: Cp_limit_curr_amt2 := gl_currency_api.convert_amount_sql(org_trx_cur,limit_currency,SYSDATE,NULL,CP_adjusted_amount2);

3476:
3477:
3478: cp_adjusted_amount2 := trx_amount_due2 - l_aging_unapplied_profile - l_aging_on_account_profile;
3479:
3480: Cp_limit_curr_amt2 := gl_currency_api.convert_amount_sql(org_trx_cur,limit_currency,SYSDATE,NULL,CP_adjusted_amount2);
3481:
3482: if Cp_limit_curr_amt2 = -1 then
3483: Cp_limit_curr_amt2:=TO_NUMBER(null);
3484: FND_MESSAGE.SET_NAME('AR','AR_CC_INVALID_EXCHANGE_RATE');

Line 3804: base_amount := gl_currency_api.convert_amount_sql

3800: and ar_receivable_applications.gl_date <= sysdate;
3801:
3802: trx_amount := trx_rec.ammount_due - l_aging_unapplied_profile - l_aging_on_account_profile;
3803:
3804: base_amount := gl_currency_api.convert_amount_sql
3805: (trx_curr,limit_currency,SYSDATE,'Corporate',trx_amount);
3806: IF base_amount = -1 THEN
3807: base_amount := 0;
3808: FND_MESSAGE.SET_NAME('AR','AR_CC_INVALID_EXCHANGE_RATE');