APPS.FUN_NET_ARAP_PKG dependencies on AR_CASH_RECEIPTS

Line 62: receipt_number ar_cash_receipts.receipt_number%TYPE,

58: exchange_rate ra_customer_trx.exchange_rate%TYPE,
59: exchange_rate_date ra_customer_trx.exchange_date%TYPE,
60: amount fun_net_batches.total_netted_amt%TYPE,
61: factor_discount_amount fun_net_batches.total_netted_amt%TYPE,
62: receipt_number ar_cash_receipts.receipt_number%TYPE,
63: receipt_date ar_cash_receipts.receipt_date%TYPE,
64: gl_date ar_cash_receipts.receipt_date%TYPE,
65: customer_id hz_cust_accounts.cust_account_id%TYPE,
66: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,

Line 63: receipt_date ar_cash_receipts.receipt_date%TYPE,

59: exchange_rate_date ra_customer_trx.exchange_date%TYPE,
60: amount fun_net_batches.total_netted_amt%TYPE,
61: factor_discount_amount fun_net_batches.total_netted_amt%TYPE,
62: receipt_number ar_cash_receipts.receipt_number%TYPE,
63: receipt_date ar_cash_receipts.receipt_date%TYPE,
64: gl_date ar_cash_receipts.receipt_date%TYPE,
65: customer_id hz_cust_accounts.cust_account_id%TYPE,
66: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
67: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,

Line 64: gl_date ar_cash_receipts.receipt_date%TYPE,

60: amount fun_net_batches.total_netted_amt%TYPE,
61: factor_discount_amount fun_net_batches.total_netted_amt%TYPE,
62: receipt_number ar_cash_receipts.receipt_number%TYPE,
63: receipt_date ar_cash_receipts.receipt_date%TYPE,
64: gl_date ar_cash_receipts.receipt_date%TYPE,
65: customer_id hz_cust_accounts.cust_account_id%TYPE,
66: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
67: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,
68: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,

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

3124: END Validate_AR_Txns;
3125:
3126: PROCEDURE create_cash_receipt(
3127: pARReceiptRec IN arReceiptRecType,
3128: x_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
3129: x_return_status OUT NOCOPY VARCHAR2,
3130: x_msg_data OUT NOCOPY VARCHAR2,
3131: x_msg_count OUT NOCOPY NUMBER)
3132: IS

Line 3213: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

3209: END create_cash_receipt;
3210:
3211: /*PROCEDURE apply2_cash_receipt
3212: (txnTable IN txnTblType,
3213: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3214: x_return_status OUT NOCOPY VARCHAR2)
3215: IS
3216: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3217: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;

Line 3342: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

3338:
3339:
3340: PROCEDURE apply_cash_receipt
3341: (txnTable IN txnTblType,
3342: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3343: x_return_status OUT NOCOPY VARCHAR2)
3344: IS
3345: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3346: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;

Line 3401: from ar_cash_receipts

3397: 'Applying Transactions');
3398:
3399: -- Bug 52380292
3400: select currency_code into l_receipt_currecycode
3401: from ar_cash_receipts
3402: where cash_receipt_id = p_cash_receipt_id;
3403:
3404:
3405: FOR i in txnTable.FIRST..txnTable.LAST

Line 3706: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;

3702: IS
3703:
3704:
3705: l_receipt_method_id ar_receipt_methods.receipt_method_id%TYPE;
3706: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
3707: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
3708: l_cust_site_use_id hz_cust_site_uses.site_use_id%TYPE;
3709: arReceiptRec arReceiptRecType;
3710: