DBA Data[Home] [Help]

APPS.AR_CC_LOCKBOX dependencies on GL_CURRENCY_API

Line 1039: l_is_fixed_rate := gl_currency_api.is_fixed_rate(

1035: * profile enabled or we are dealing with a fixed rate
1036: * currency
1037: ************************************************************/
1038:
1039: l_is_fixed_rate := gl_currency_api.is_fixed_rate(
1040: l_currency_code, /*receipt currency */
1041: l_invoice_currency_code1, /* inv currency */
1042: nvl(l_receipt_date,sysdate));
1043:

Line 1077: gl_currency_api.get_rate(

1073: **********************************************/
1074: IF (l_is_fixed_rate = 'Y') THEN
1075: /* get the fixed rate from GL */
1076: l_trans_to_receipt_rate1 :=
1077: gl_currency_api.get_rate(
1078: l_invoice_currency_code1,
1079: l_currency_code,
1080: l_receipt_date);
1081:

Line 1153: gl_currency_api.get_rate_sql(

1149: debug1( 'need to derive rate ');
1150: IF (p_default_exchange_rate_type IS NOT NULL or
1151: l_is_fixed_rate = 'Y' ) THEN
1152: l_trans_to_receipt_rate1 :=
1153: gl_currency_api.get_rate_sql(
1154: l_invoice_currency_code1,
1155: l_currency_code,
1156: l_receipt_date,
1157: p_default_exchange_rate_type);

Line 1578: l_is_fixed_rate := gl_currency_api.is_fixed_rate(

1574: * profile enabled or we are dealing with a fixed rate
1575: * currency
1576: ************************************************************/
1577:
1578: l_is_fixed_rate := gl_currency_api.is_fixed_rate(
1579: l_currency_code, /*receipt currency */
1580: l_invoice_currency_code2, /* inv currency */
1581: nvl(l_receipt_date,sysdate));
1582: debug1('is this a fixed rate = ' || l_is_fixed_rate);

Line 1612: gl_currency_api.get_rate(

1608:
1609: IF (l_is_fixed_rate = 'Y') THEN
1610: /* get the fixed rate from GL */
1611: l_trans_to_receipt_rate2 :=
1612: gl_currency_api.get_rate(
1613: l_invoice_currency_code2,
1614: l_currency_code,
1615: l_receipt_date);
1616: /*************************************************

Line 1688: gl_currency_api.get_rate_sql(

1684: /* need to derive the rate if possible*/
1685: IF (p_default_exchange_rate_type IS NOT NULL or
1686: l_is_fixed_rate = 'Y' ) THEN
1687: l_trans_to_receipt_rate2 :=
1688: gl_currency_api.get_rate_sql(
1689: l_invoice_currency_code2,
1690: l_currency_code,
1691: l_receipt_date,
1692: p_default_exchange_rate_type);

Line 2107: l_is_fixed_rate := gl_currency_api.is_fixed_rate(

2103: * profile enabled or we are dealing with a fixed rate
2104: * currency
2105: ************************************************************/
2106:
2107: l_is_fixed_rate := gl_currency_api.is_fixed_rate(
2108: l_currency_code, /*receipt currency */
2109: l_invoice_currency_code3, /* inv currency */
2110: nvl(l_receipt_date,sysdate));
2111:

Line 2146: gl_currency_api.get_rate(

2142:
2143: IF (l_is_fixed_rate = 'Y') THEN
2144: /* get the fixed rate from GL */
2145: l_trans_to_receipt_rate3 :=
2146: gl_currency_api.get_rate(
2147: l_invoice_currency_code3,
2148: l_currency_code,
2149: l_receipt_date);
2150:

Line 2221: gl_currency_api.get_rate_sql(

2217: debug1( 'need to derive rate ');
2218: IF (p_default_exchange_rate_type IS NOT NULL or
2219: l_is_fixed_rate = 'Y' ) THEN
2220: l_trans_to_receipt_rate3 :=
2221: gl_currency_api.get_rate_sql(
2222: l_invoice_currency_code3,
2223: l_currency_code,
2224: l_receipt_date,
2225: p_default_exchange_rate_type);

Line 2643: l_is_fixed_rate := gl_currency_api.is_fixed_rate(

2639: * profile enabled or we are dealing with a fixed rate
2640: * currency
2641: ************************************************************/
2642:
2643: l_is_fixed_rate := gl_currency_api.is_fixed_rate(
2644: l_currency_code, /*receipt currency */
2645: l_invoice_currency_code4, /* inv currency */
2646: nvl(l_receipt_date,sysdate));
2647:

Line 2681: gl_currency_api.get_rate(

2677: **********************************************/
2678: IF (l_is_fixed_rate = 'Y') THEN
2679: /* get the fixed rate from GL */
2680: l_trans_to_receipt_rate4 :=
2681: gl_currency_api.get_rate(
2682: l_invoice_currency_code4,
2683: l_currency_code,
2684: l_receipt_date);
2685:

Line 2757: gl_currency_api.get_rate_sql(

2753: debug1( 'need to derive rate ');
2754: IF (p_default_exchange_rate_type IS NOT NULL or
2755: l_is_fixed_rate = 'Y' ) THEN
2756: l_trans_to_receipt_rate4 :=
2757: gl_currency_api.get_rate_sql(
2758: l_invoice_currency_code4,
2759: l_currency_code,
2760: l_receipt_date,
2761: p_default_exchange_rate_type);

Line 3175: l_is_fixed_rate := gl_currency_api.is_fixed_rate(

3171: * profile enabled or we are dealing with a fixed rate
3172: * currency
3173: ************************************************************/
3174:
3175: l_is_fixed_rate := gl_currency_api.is_fixed_rate(
3176: l_currency_code, /*receipt currency */
3177: l_invoice_currency_code5, /* inv currency */
3178: nvl(l_receipt_date,sysdate));
3179:

Line 3213: gl_currency_api.get_rate(

3209: **********************************************/
3210: IF (l_is_fixed_rate = 'Y') THEN
3211: /* get the fixed rate from GL */
3212: l_trans_to_receipt_rate5 :=
3213: gl_currency_api.get_rate(
3214: l_invoice_currency_code5,
3215: l_currency_code,
3216: l_receipt_date);
3217:

Line 3289: gl_currency_api.get_rate_sql(

3285: debug1( 'need to derive rate ');
3286: IF (p_default_exchange_rate_type IS NOT NULL or
3287: l_is_fixed_rate = 'Y' ) THEN
3288: l_trans_to_receipt_rate5 :=
3289: gl_currency_api.get_rate_sql(
3290: l_invoice_currency_code5,
3291: l_currency_code,
3292: l_receipt_date,
3293: p_default_exchange_rate_type);

Line 3706: l_is_fixed_rate := gl_currency_api.is_fixed_rate(

3702: * profile enabled or we are dealing with a fixed rate
3703: * currency
3704: ************************************************************/
3705:
3706: l_is_fixed_rate := gl_currency_api.is_fixed_rate(
3707: l_currency_code, /*receipt currency */
3708: l_invoice_currency_code6, /* inv currency */
3709: nvl(l_receipt_date,sysdate));
3710:

Line 3744: gl_currency_api.get_rate(

3740: **********************************************/
3741: IF (l_is_fixed_rate = 'Y') THEN
3742: /* get the fixed rate from GL */
3743: l_trans_to_receipt_rate6 :=
3744: gl_currency_api.get_rate(
3745: l_invoice_currency_code6,
3746: l_currency_code,
3747: l_receipt_date);
3748:

Line 3820: gl_currency_api.get_rate_sql(

3816: debug1( 'need to derive rate ');
3817: IF (p_default_exchange_rate_type IS NOT NULL or
3818: l_is_fixed_rate = 'Y' ) THEN
3819: l_trans_to_receipt_rate6 :=
3820: gl_currency_api.get_rate_sql(
3821: l_invoice_currency_code6,
3822: l_currency_code,
3823: l_receipt_date,
3824: p_default_exchange_rate_type);

Line 4236: l_is_fixed_rate := gl_currency_api.is_fixed_rate(

4232: * profile enabled or we are dealing with a fixed rate
4233: * currency
4234: ************************************************************/
4235:
4236: l_is_fixed_rate := gl_currency_api.is_fixed_rate(
4237: l_currency_code, /*receipt currency */
4238: l_invoice_currency_code7, /* inv currency */
4239: nvl(l_receipt_date,sysdate));
4240:

Line 4274: gl_currency_api.get_rate(

4270: **********************************************/
4271: IF (l_is_fixed_rate = 'Y') THEN
4272: /* get the fixed rate from GL */
4273: l_trans_to_receipt_rate7 :=
4274: gl_currency_api.get_rate(
4275: l_invoice_currency_code7,
4276: l_currency_code,
4277: l_receipt_date);
4278:

Line 4350: gl_currency_api.get_rate_sql(

4346: debug1( 'need to derive rate ');
4347: IF (p_default_exchange_rate_type IS NOT NULL or
4348: l_is_fixed_rate = 'Y' ) THEN
4349: l_trans_to_receipt_rate7 :=
4350: gl_currency_api.get_rate_sql(
4351: l_invoice_currency_code7,
4352: l_currency_code,
4353: l_receipt_date,
4354: p_default_exchange_rate_type);

Line 4767: l_is_fixed_rate := gl_currency_api.is_fixed_rate(

4763: * profile enabled or we are dealing with a fixed rate
4764: * currency
4765: ************************************************************/
4766:
4767: l_is_fixed_rate := gl_currency_api.is_fixed_rate(
4768: l_currency_code, /*receipt currency */
4769: l_invoice_currency_code8, /* inv currency */
4770: nvl(l_receipt_date,sysdate));
4771:

Line 4805: gl_currency_api.get_rate(

4801: **********************************************/
4802: IF (l_is_fixed_rate = 'Y') THEN
4803: /* get the fixed rate from GL */
4804: l_trans_to_receipt_rate8 :=
4805: gl_currency_api.get_rate(
4806: l_invoice_currency_code8,
4807: l_currency_code,
4808: l_receipt_date);
4809:

Line 4881: gl_currency_api.get_rate_sql(

4877: debug1( 'need to derive rate ');
4878: IF (p_default_exchange_rate_type IS NOT NULL or
4879: l_is_fixed_rate = 'Y' ) THEN
4880: l_trans_to_receipt_rate8 :=
4881: gl_currency_api.get_rate_sql(
4882: l_invoice_currency_code8,
4883: l_currency_code,
4884: l_receipt_date,
4885: p_default_exchange_rate_type);