APPS.FUN_NET_ARAP_PKG dependencies on AR_CASH_RECEIPTS

Line 50: receipt_number ar_cash_receipts.receipt_number%TYPE,

46: exchange_rate ra_customer_trx.exchange_rate%TYPE,
47: exchange_rate_date ra_customer_trx.exchange_date%TYPE,
48: amount fun_net_batches.total_netted_amt%TYPE,
49: factor_discount_amount fun_net_batches.total_netted_amt%TYPE,
50: receipt_number ar_cash_receipts.receipt_number%TYPE,
51: receipt_date ar_cash_receipts.receipt_date%TYPE,
52: gl_date ar_cash_receipts.receipt_date%TYPE,
53: customer_id hz_cust_accounts.cust_account_id%TYPE,
54: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,

Line 51: receipt_date ar_cash_receipts.receipt_date%TYPE,

47: exchange_rate_date ra_customer_trx.exchange_date%TYPE,
48: amount fun_net_batches.total_netted_amt%TYPE,
49: factor_discount_amount fun_net_batches.total_netted_amt%TYPE,
50: receipt_number ar_cash_receipts.receipt_number%TYPE,
51: receipt_date ar_cash_receipts.receipt_date%TYPE,
52: gl_date ar_cash_receipts.receipt_date%TYPE,
53: customer_id hz_cust_accounts.cust_account_id%TYPE,
54: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
55: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,

Line 52: gl_date ar_cash_receipts.receipt_date%TYPE,

48: amount fun_net_batches.total_netted_amt%TYPE,
49: factor_discount_amount fun_net_batches.total_netted_amt%TYPE,
50: receipt_number ar_cash_receipts.receipt_number%TYPE,
51: receipt_date ar_cash_receipts.receipt_date%TYPE,
52: gl_date ar_cash_receipts.receipt_date%TYPE,
53: customer_id hz_cust_accounts.cust_account_id%TYPE,
54: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
55: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,
56: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,

Line 3803: x_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

3799: x_return_status := FND_API.G_FALSE;
3800: END Validate_AR_Txns;
3801: PROCEDURE create_cash_receipt(
3802: pARReceiptRec IN arReceiptRecType,
3803: x_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
3804: x_return_status OUT NOCOPY VARCHAR2,
3805: x_msg_data OUT NOCOPY VARCHAR2,
3806: x_msg_count OUT NOCOPY NUMBER)
3807: IS

Line 3868: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

3864: x_return_status := FND_API.G_FALSE;
3865: END create_cash_receipt;
3866: /*PROCEDURE apply2_cash_receipt
3867: (txnTable IN txnTblType,
3868: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3869: x_return_status OUT NOCOPY VARCHAR2)
3870: IS
3871: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3872: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;

Line 3971: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

3967: x_return_status := FND_API.G_FALSE;
3968: END apply2_cash_receipt; */
3969: PROCEDURE apply_cash_receipt
3970: (txnTable IN txnTblType,
3971: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3972: x_return_status OUT NOCOPY VARCHAR2)
3973: IS
3974: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3975: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;

Line 4033: from ar_cash_receipts

4029: l_path,
4030: 'Applying Transactions');
4031: -- Bug 52380292
4032: select currency_code into l_receipt_currecycode
4033: from ar_cash_receipts
4034: where cash_receipt_id = p_cash_receipt_id;
4035: FOR i in txnTable.FIRST..txnTable.LAST
4036: LOOP
4037: --Check if Amount due remaining has changed since it was validated ,

Line 4312: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;

4308: x_msg_data OUT NOCOPY VARCHAR2,
4309: x_msg_count OUT NOCOPY NUMBER)
4310: IS
4311: l_receipt_method_id ar_receipt_methods.receipt_method_id%TYPE;
4312: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
4313: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
4314: l_cust_site_use_id hz_cust_site_uses.site_use_id%TYPE;
4315: arReceiptRec arReceiptRecType;
4316: l_bank_acct_used NUMBER;