DBA Data[Home] [Help]

APPS.AR_DEPOSIT_LIB_PVT dependencies on RA_CUSTOMER_TRX

Line 1158: p_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,

1154: | Find_Exchange_Rate will find the exchanage rate
1155: +=======================================================================*/
1156:
1157: FUNCTION Find_Exchange_Rate(
1158: p_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
1159: p_exchange_rate_date IN ra_customer_trx.exchange_date%TYPE,
1160: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type
1161: )
1162: RETURN NUMBER IS

Line 1159: p_exchange_rate_date IN ra_customer_trx.exchange_date%TYPE,

1155: +=======================================================================*/
1156:
1157: FUNCTION Find_Exchange_Rate(
1158: p_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
1159: p_exchange_rate_date IN ra_customer_trx.exchange_date%TYPE,
1160: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type
1161: )
1162: RETURN NUMBER IS
1163: l_count BINARY_INTEGER;

Line 1160: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type

1156:
1157: FUNCTION Find_Exchange_Rate(
1158: p_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
1159: p_exchange_rate_date IN ra_customer_trx.exchange_date%TYPE,
1160: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type
1161: )
1162: RETURN NUMBER IS
1163: l_count BINARY_INTEGER;
1164: l_index_curr BINARY_INTEGER;

Line 1268: p_currency_code IN OUT NOCOPY ra_customer_trx.invoice_currency_code%TYPE,

1264: | Default_Currency_info will find the default currency info
1265: +=======================================================================*/
1266:
1267: PROCEDURE Default_Currency_info(
1268: p_currency_code IN OUT NOCOPY ra_customer_trx.invoice_currency_code%TYPE,
1269: p_receipt_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
1270: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
1271: p_exchange_rate_type IN OUT NOCOPY ra_customer_trx.exchange_rate_type%TYPE,
1272: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,

Line 1269: p_receipt_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,

1265: +=======================================================================*/
1266:
1267: PROCEDURE Default_Currency_info(
1268: p_currency_code IN OUT NOCOPY ra_customer_trx.invoice_currency_code%TYPE,
1269: p_receipt_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
1270: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
1271: p_exchange_rate_type IN OUT NOCOPY ra_customer_trx.exchange_rate_type%TYPE,
1272: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,
1273: p_return_status OUT NOCOPY VARCHAR2

Line 1270: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,

1266:
1267: PROCEDURE Default_Currency_info(
1268: p_currency_code IN OUT NOCOPY ra_customer_trx.invoice_currency_code%TYPE,
1269: p_receipt_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
1270: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
1271: p_exchange_rate_type IN OUT NOCOPY ra_customer_trx.exchange_rate_type%TYPE,
1272: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,
1273: p_return_status OUT NOCOPY VARCHAR2
1274: ) IS

Line 1271: p_exchange_rate_type IN OUT NOCOPY ra_customer_trx.exchange_rate_type%TYPE,

1267: PROCEDURE Default_Currency_info(
1268: p_currency_code IN OUT NOCOPY ra_customer_trx.invoice_currency_code%TYPE,
1269: p_receipt_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
1270: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
1271: p_exchange_rate_type IN OUT NOCOPY ra_customer_trx.exchange_rate_type%TYPE,
1272: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,
1273: p_return_status OUT NOCOPY VARCHAR2
1274: ) IS
1275:

Line 1272: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,

1268: p_currency_code IN OUT NOCOPY ra_customer_trx.invoice_currency_code%TYPE,
1269: p_receipt_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
1270: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
1271: p_exchange_rate_type IN OUT NOCOPY ra_customer_trx.exchange_rate_type%TYPE,
1272: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,
1273: p_return_status OUT NOCOPY VARCHAR2
1274: ) IS
1275:
1276: l_euro_to_emu_rate NUMBER;

Line 2662: ra_customer_trx.invoice_currency_code%TYPE,

2658:
2659:
2660: PROCEDURE Get_deposit_Defaults(
2661: p_currency_code IN OUT NOCOPY
2662: ra_customer_trx.invoice_currency_code%TYPE,
2663: p_exchange_rate_type IN OUT NOCOPY
2664: ra_customer_trx.exchange_rate_type%TYPE,
2665: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,
2666: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,

Line 2664: ra_customer_trx.exchange_rate_type%TYPE,

2660: PROCEDURE Get_deposit_Defaults(
2661: p_currency_code IN OUT NOCOPY
2662: ra_customer_trx.invoice_currency_code%TYPE,
2663: p_exchange_rate_type IN OUT NOCOPY
2664: ra_customer_trx.exchange_rate_type%TYPE,
2665: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,
2666: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
2667: p_start_date_commitmenmt IN OUT NOCOPY DATE,
2668: p_end_date_commitmenmt IN OUT NOCOPY DATE,

Line 2665: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,

2661: p_currency_code IN OUT NOCOPY
2662: ra_customer_trx.invoice_currency_code%TYPE,
2663: p_exchange_rate_type IN OUT NOCOPY
2664: ra_customer_trx.exchange_rate_type%TYPE,
2665: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,
2666: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
2667: p_start_date_commitmenmt IN OUT NOCOPY DATE,
2668: p_end_date_commitmenmt IN OUT NOCOPY DATE,
2669: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,

Line 2666: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,

2662: ra_customer_trx.invoice_currency_code%TYPE,
2663: p_exchange_rate_type IN OUT NOCOPY
2664: ra_customer_trx.exchange_rate_type%TYPE,
2665: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,
2666: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
2667: p_start_date_commitmenmt IN OUT NOCOPY DATE,
2668: p_end_date_commitmenmt IN OUT NOCOPY DATE,
2669: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
2670: p_deposit_date IN OUT NOCOPY DATE,

Line 2997: IF p_desc_flex_name = 'RA_CUSTOMER_TRX' THEN /* bug 5467021 if-else condition added and get_flex_title called in set_token*/

2993: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
2994: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
2995: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
2996:
2997: IF p_desc_flex_name = 'RA_CUSTOMER_TRX' THEN /* bug 5467021 if-else condition added and get_flex_title called in set_token*/
2998:
2999: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
3000: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
3001: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);

Line 3020: FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name||' - Flex Field Name : "' ||get_flex_title('RA_CUSTOMER_TRX')||'"');

3016: THEN
3017:
3018: FND_MESSAGE.SET_NAME('AR', 'AR_RAPI_DESC_FLEX_INVALID');
3019: -- FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name);
3020: FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name||' - Flex Field Name : "' ||get_flex_title('RA_CUSTOMER_TRX')||'"');
3021: FND_MSG_PUB.ADD ;
3022: p_return_status := FND_API.G_RET_STS_ERROR;
3023: END IF;
3024: