eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_RECEIPT_VAL_PVT dependencies on AR_CASH_RECEIPTS

Line 881: ar_cash_receipts.currency_code%TYPE) RETURN VARCHAR2 IS

877: RAISE;
878: END Validate_Exchange_Rate;
879:
880: FUNCTION Is_currency_valid(p_currency_code IN
881: ar_cash_receipts.currency_code%TYPE) RETURN VARCHAR2 IS
882: l_currency_valid VARCHAR2(1);
883: BEGIN
884: SELECT 'Y'
885: INTO l_currency_valid

Line 903: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

899: raise;
900: END Is_currency_valid;
901:
902: PROCEDURE Validate_Currency(
903: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
904: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
905: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
906: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
907: p_return_status OUT NOCOPY VARCHAR2) IS

Line 904: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,

900: END Is_currency_valid;
901:
902: PROCEDURE Validate_Currency(
903: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
904: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
905: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
906: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
907: p_return_status OUT NOCOPY VARCHAR2) IS
908: BEGIN

Line 905: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

901:
902: PROCEDURE Validate_Currency(
903: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
904: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
905: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
906: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
907: p_return_status OUT NOCOPY VARCHAR2) IS
908: BEGIN
909: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 906: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,

902: PROCEDURE Validate_Currency(
903: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
904: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
905: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
906: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
907: p_return_status OUT NOCOPY VARCHAR2) IS
908: BEGIN
909: p_return_status := FND_API.G_RET_STS_SUCCESS;
910: IF (Is_currency_valid(p_currency_code) = 'Y') THEN

Line 940: FROM ar_cash_receipts cr

936: p_return_status OUT NOCOPY VARCHAR2) IS
937: l_duplicate_receipt varchar2(1) := 'N';
938: CURSOR validate_duplicate_receipt IS
939: SELECT 'Y'
940: FROM ar_cash_receipts cr
941: WHERE cr.receipt_number = p_receipt_number
942: AND cr.receipt_date = p_receipt_date
943: AND cr.amount = p_amount
944: AND NVL(cr.pay_from_customer, -99999) = NVL(p_customer_id, -99999)

Line 989: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,

985: END IF;
986: END val_duplicate_receipt;
987:
988: PROCEDURE Validate_Cash_Receipt(
989: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
990: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
991: p_state IN ar_receipt_classes.creation_status%TYPE,
992: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
993: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

Line 990: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,

986: END val_duplicate_receipt;
987:
988: PROCEDURE Validate_Cash_Receipt(
989: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
990: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
991: p_state IN ar_receipt_classes.creation_status%TYPE,
992: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
993: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
994: p_maturity_date IN DATE,

Line 992: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

988: PROCEDURE Validate_Cash_Receipt(
989: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
990: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
991: p_state IN ar_receipt_classes.creation_status%TYPE,
992: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
993: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
994: p_maturity_date IN DATE,
995: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
996: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,

Line 995: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,

991: p_state IN ar_receipt_classes.creation_status%TYPE,
992: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
993: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
994: p_maturity_date IN DATE,
995: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
996: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
997: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
998: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
999: /* 6612301 */

Line 996: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,

992: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
993: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
994: p_maturity_date IN DATE,
995: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
996: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
997: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
998: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
999: /* 6612301 */
1000: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,

Line 997: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,

993: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
994: p_maturity_date IN DATE,
995: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
996: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
997: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
998: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
999: /* 6612301 */
1000: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1001: p_location IN hz_cust_site_uses.location%TYPE,

Line 998: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,

994: p_maturity_date IN DATE,
995: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
996: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
997: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
998: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
999: /* 6612301 */
1000: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1001: p_location IN hz_cust_site_uses.location%TYPE,
1002: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,

Line 1000: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,

996: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
997: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
998: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
999: /* 6612301 */
1000: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1001: p_location IN hz_cust_site_uses.location%TYPE,
1002: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
1003: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1004: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,

Line 1002: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,

998: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
999: /* 6612301 */
1000: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1001: p_location IN hz_cust_site_uses.location%TYPE,
1002: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
1003: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1004: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
1005: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
1006: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 1003: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,

999: /* 6612301 */
1000: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1001: p_location IN hz_cust_site_uses.location%TYPE,
1002: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
1003: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1004: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
1005: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
1006: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1007: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,

Line 1004: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,

1000: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1001: p_location IN hz_cust_site_uses.location%TYPE,
1002: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
1003: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1004: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
1005: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
1006: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1007: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
1008: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

Line 1005: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,

1001: p_location IN hz_cust_site_uses.location%TYPE,
1002: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
1003: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1004: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
1005: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
1006: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1007: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
1008: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1009: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,

Line 1006: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

1002: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
1003: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1004: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
1005: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
1006: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1007: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
1008: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1009: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1010: p_doc_sequence_value IN NUMBER,

Line 1007: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,

1003: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1004: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
1005: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
1006: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1007: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
1008: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1009: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1010: p_doc_sequence_value IN NUMBER,
1011: p_called_from IN VARCHAR2,

Line 1008: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

1004: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
1005: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
1006: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1007: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
1008: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1009: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1010: p_doc_sequence_value IN NUMBER,
1011: p_called_from IN VARCHAR2,
1012: p_return_status OUT NOCOPY VARCHAR2)

Line 1009: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,

1005: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
1006: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1007: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
1008: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1009: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1010: p_doc_sequence_value IN NUMBER,
1011: p_called_from IN VARCHAR2,
1012: p_return_status OUT NOCOPY VARCHAR2)
1013: IS

Line 2474: FROM ar_cash_receipts cr,

2470: IF p_cash_receipt_id IS NOT NULL THEN
2471:
2472: SELECT count(*)
2473: INTO l_valid
2474: FROM ar_cash_receipts cr,
2475: ar_cash_receipt_history crh
2476: WHERE cr.cash_receipt_id = p_cash_receipt_id
2477: and cr.cash_receipt_id = crh.cash_receipt_id
2478: and crh.current_record_flag = 'Y'

Line 2800: FROM ar_cash_receipts cr,

2796: IF p_applied_ps_id IN (-6, -9) THEN
2797: BEGIN
2798: SELECT NVL(arm.payment_channel_code,'NONE')
2799: INTO l_payment_type
2800: FROM ar_cash_receipts cr,
2801: ar_receipt_methods arm
2802: WHERE cr.receipt_method_id = arm.receipt_method_id
2803: AND cr.cash_receipt_id=p_cash_receipt_id;
2804:

Line 2899: l_functional_currency ar_cash_receipts.currency_code%TYPE;

2895:
2896: --Bug 5367753
2897: l_exchange_rate NUMBER;
2898: l_tot_writeoff_amt_func NUMBER;
2899: l_functional_currency ar_cash_receipts.currency_code%TYPE;
2900:
2901: cursor activity_type is
2902: select type
2903: from ar_receivables_trx rt

Line 2962: FROM ar_cash_receipts

2958:
2959: --Bug 5367753 fetch exchange_rate of the receipt.
2960: SELECT nvl(exchange_rate,1)
2961: INTO l_exchange_rate
2962: FROM ar_cash_receipts
2963: WHERE cash_receipt_id = p_cash_receipt_id;
2964:
2965: l_tot_write_off_amt := NVL(l_existing_wo_amount,0) + NVL(p_applied_amount,0);
2966:

Line 3661: from ar_cash_receipts

3657: ELSIF (p_reference_type = 'RECEIPT' ) THEN
3658: --
3659: select 'y'
3660: into l_reference_valid
3661: from ar_cash_receipts
3662: where cash_receipt_id = p_reference_id
3663: and remit_bank_acct_use_id = p_remittance_bank_account_id;
3664: ELSIF (p_reference_type = 'REMITTANCE' ) THEN
3665: --

Line 3853: ar_cash_receipts cr

3849:
3850: SELECT NVL(payment_channel_code,'CASH')
3851: INTO l_payment_type_code
3852: FROM ar_receipt_methods arm,
3853: ar_cash_receipts cr
3854: WHERE cr.receipt_method_id = arm.receipt_method_id
3855: AND cr.cash_receipt_id=l_cash_receipt_id;
3856:
3857:

Line 3863: ar_cash_receipts cr,

3859:
3860: SELECT NVL(payment_channel_code,'CASH')
3861: INTO l_payment_type_code
3862: FROM ar_receipt_methods arm,
3863: ar_cash_receipts cr,
3864: ar_receivable_applications app
3865: WHERE cr.receipt_method_id = arm.receipt_method_id
3866: AND app.cash_receipt_id=cr.cash_receipt_id
3867: AND app.receivable_application_id = p_receivable_application_id;

Line 4149: FROM ar_cash_receipts

4145: -- Check if unapplication will send the applied-to receipt negative
4146:
4147: SELECT amount
4148: INTO l_cr_amount
4149: FROM ar_cash_receipts
4150: WHERE cash_receipt_id = p_applied_cash_receipt_id;
4151:
4152: SELECT NVL(SUM(amount_applied),0)
4153: INTO l_amount_applied