DBA Data[Home] [Help]

APPS.AR_DEPOSIT_LIB_PVT dependencies on RA_CUSTOMER_TRX

Line 1156: p_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,

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

Line 1157: p_exchange_rate_date IN ra_customer_trx.exchange_date%TYPE,

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

Line 1158: p_exchange_rate_type IN ra_customer_trx.exchange_rate_type%type

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

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

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

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

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

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

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

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

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

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

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

Line 2636: ra_customer_trx.invoice_currency_code%TYPE,

2632:
2633:
2634: PROCEDURE Get_deposit_Defaults(
2635: p_currency_code IN OUT NOCOPY
2636: ra_customer_trx.invoice_currency_code%TYPE,
2637: p_exchange_rate_type IN OUT NOCOPY
2638: ra_customer_trx.exchange_rate_type%TYPE,
2639: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,
2640: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,

Line 2638: ra_customer_trx.exchange_rate_type%TYPE,

2634: PROCEDURE Get_deposit_Defaults(
2635: p_currency_code IN OUT NOCOPY
2636: ra_customer_trx.invoice_currency_code%TYPE,
2637: p_exchange_rate_type IN OUT NOCOPY
2638: ra_customer_trx.exchange_rate_type%TYPE,
2639: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,
2640: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
2641: p_start_date_commitmenmt IN OUT NOCOPY DATE,
2642: p_end_date_commitmenmt IN OUT NOCOPY DATE,

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

2635: p_currency_code IN OUT NOCOPY
2636: ra_customer_trx.invoice_currency_code%TYPE,
2637: p_exchange_rate_type IN OUT NOCOPY
2638: ra_customer_trx.exchange_rate_type%TYPE,
2639: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,
2640: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
2641: p_start_date_commitmenmt IN OUT NOCOPY DATE,
2642: p_end_date_commitmenmt IN OUT NOCOPY DATE,
2643: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,

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

2636: ra_customer_trx.invoice_currency_code%TYPE,
2637: p_exchange_rate_type IN OUT NOCOPY
2638: ra_customer_trx.exchange_rate_type%TYPE,
2639: p_exchange_rate IN OUT NOCOPY ra_customer_trx.exchange_rate%TYPE,
2640: p_exchange_rate_date IN OUT NOCOPY ra_customer_trx.exchange_date%TYPE,
2641: p_start_date_commitmenmt IN OUT NOCOPY DATE,
2642: p_end_date_commitmenmt IN OUT NOCOPY DATE,
2643: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
2644: p_deposit_date IN OUT NOCOPY DATE,

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

2967: arp_util.debug('attribute14 : '||p_desc_flex_rec.attribute14);
2968: arp_util.debug('attribute15 : '||p_desc_flex_rec.attribute15);
2969: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
2970:
2971: IF p_desc_flex_name = 'RA_CUSTOMER_TRX' THEN /* bug 5467021 if-else condition added and get_flex_title called in set_token*/
2972:
2973: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
2974: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
2975: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);

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

2990: THEN
2991:
2992: FND_MESSAGE.SET_NAME('AR', 'AR_RAPI_DESC_FLEX_INVALID');
2993: -- FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name);
2994: FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name||' - Flex Field Name : "' ||get_flex_title('RA_CUSTOMER_TRX')||'"');
2995: FND_MSG_PUB.ADD ;
2996: p_return_status := FND_API.G_RET_STS_ERROR;
2997: END IF;
2998: