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 874: ar_cash_receipts.currency_code%TYPE) RETURN VARCHAR2 IS

870: RAISE;
871: END Validate_Exchange_Rate;
872:
873: FUNCTION Is_currency_valid(p_currency_code IN
874: ar_cash_receipts.currency_code%TYPE) RETURN VARCHAR2 IS
875: l_currency_valid VARCHAR2(1);
876: BEGIN
877: SELECT 'Y'
878: INTO l_currency_valid

Line 896: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

892: raise;
893: END Is_currency_valid;
894:
895: PROCEDURE Validate_Currency(
896: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
897: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
898: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
899: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
900: p_return_status OUT NOCOPY VARCHAR2) IS

Line 897: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,

893: END Is_currency_valid;
894:
895: PROCEDURE Validate_Currency(
896: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
897: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
898: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
899: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
900: p_return_status OUT NOCOPY VARCHAR2) IS
901: BEGIN

Line 898: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

894:
895: PROCEDURE Validate_Currency(
896: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
897: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
898: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
899: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
900: p_return_status OUT NOCOPY VARCHAR2) IS
901: BEGIN
902: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 899: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,

895: PROCEDURE Validate_Currency(
896: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
897: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
898: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
899: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
900: p_return_status OUT NOCOPY VARCHAR2) IS
901: BEGIN
902: p_return_status := FND_API.G_RET_STS_SUCCESS;
903: IF (Is_currency_valid(p_currency_code) = 'Y') THEN

Line 933: FROM ar_cash_receipts cr

929: p_return_status OUT NOCOPY VARCHAR2) IS
930: l_duplicate_receipt varchar2(1) := 'N';
931: CURSOR validate_duplicate_receipt IS
932: SELECT 'Y'
933: FROM ar_cash_receipts cr
934: WHERE cr.receipt_number = p_receipt_number
935: AND cr.receipt_date = p_receipt_date
936: AND cr.amount = p_amount
937: AND NVL(cr.pay_from_customer, -99999) = NVL(p_customer_id, -99999)

Line 980: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,

976: END IF;
977: END val_duplicate_receipt;
978:
979: PROCEDURE Validate_Cash_Receipt(
980: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
981: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
982: p_state IN ar_receipt_classes.creation_status%TYPE,
983: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
984: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,

Line 981: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,

977: END val_duplicate_receipt;
978:
979: PROCEDURE Validate_Cash_Receipt(
980: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
981: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
982: p_state IN ar_receipt_classes.creation_status%TYPE,
983: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
984: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
985: p_maturity_date IN DATE,

Line 983: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,

979: PROCEDURE Validate_Cash_Receipt(
980: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
981: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
982: p_state IN ar_receipt_classes.creation_status%TYPE,
983: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
984: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
985: p_maturity_date IN DATE,
986: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
987: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,

Line 986: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,

982: p_state IN ar_receipt_classes.creation_status%TYPE,
983: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
984: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
985: p_maturity_date IN DATE,
986: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
987: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
988: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
989: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
990: /* 6612301 */

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

983: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
984: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
985: p_maturity_date IN DATE,
986: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
987: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
988: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
989: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
990: /* 6612301 */
991: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,

Line 988: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,

984: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
985: p_maturity_date IN DATE,
986: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
987: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
988: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
989: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
990: /* 6612301 */
991: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
992: p_location IN hz_cust_site_uses.location%TYPE,

Line 989: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,

985: p_maturity_date IN DATE,
986: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE,
987: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
988: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
989: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
990: /* 6612301 */
991: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
992: p_location IN hz_cust_site_uses.location%TYPE,
993: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,

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

987: p_amount IN OUT NOCOPY ar_cash_receipts.amount%TYPE,
988: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
989: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
990: /* 6612301 */
991: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
992: p_location IN hz_cust_site_uses.location%TYPE,
993: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
994: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
995: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,

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

989: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
990: /* 6612301 */
991: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
992: p_location IN hz_cust_site_uses.location%TYPE,
993: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
994: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
995: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
996: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
997: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 994: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,

990: /* 6612301 */
991: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
992: p_location IN hz_cust_site_uses.location%TYPE,
993: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
994: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
995: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
996: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
997: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
998: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,

Line 995: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,

991: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
992: p_location IN hz_cust_site_uses.location%TYPE,
993: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
994: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
995: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
996: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
997: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
998: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
999: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

Line 996: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,

992: p_location IN hz_cust_site_uses.location%TYPE,
993: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
994: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
995: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
996: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
997: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
998: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
999: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1000: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,

Line 997: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

993: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
994: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
995: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
996: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
997: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
998: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
999: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1000: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1001: p_doc_sequence_value IN NUMBER,

Line 998: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,

994: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
995: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
996: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
997: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
998: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
999: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1000: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1001: p_doc_sequence_value IN NUMBER,
1002: p_called_from IN VARCHAR2,

Line 999: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,

995: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
996: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
997: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
998: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
999: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1000: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1001: p_doc_sequence_value IN NUMBER,
1002: p_called_from IN VARCHAR2,
1003: p_return_status OUT NOCOPY VARCHAR2)

Line 1000: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,

996: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,
997: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
998: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE,
999: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1000: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
1001: p_doc_sequence_value IN NUMBER,
1002: p_called_from IN VARCHAR2,
1003: p_return_status OUT NOCOPY VARCHAR2)
1004: IS

Line 2404: FROM ar_cash_receipts cr,

2400: IF p_cash_receipt_id IS NOT NULL THEN
2401:
2402: SELECT count(*)
2403: INTO l_valid
2404: FROM ar_cash_receipts cr,
2405: ar_cash_receipt_history crh
2406: WHERE cr.cash_receipt_id = p_cash_receipt_id
2407: and cr.cash_receipt_id = crh.cash_receipt_id
2408: and crh.current_record_flag = 'Y'

Line 2719: FROM ar_cash_receipts cr,

2715: IF p_applied_ps_id = -6 THEN
2716: BEGIN
2717: SELECT NVL(arm.payment_channel_code,'NONE')
2718: INTO l_payment_type
2719: FROM ar_cash_receipts cr,
2720: ar_receipt_methods arm
2721: WHERE cr.receipt_method_id = arm.receipt_method_id
2722: AND cr.cash_receipt_id=p_cash_receipt_id;
2723:

Line 2770: l_functional_currency ar_cash_receipts.currency_code%TYPE;

2766:
2767: --Bug 5367753
2768: l_exchange_rate NUMBER;
2769: l_tot_writeoff_amt_func NUMBER;
2770: l_functional_currency ar_cash_receipts.currency_code%TYPE;
2771:
2772: cursor activity_type is
2773: select type
2774: from ar_receivables_trx rt

Line 2831: FROM ar_cash_receipts

2827:
2828: --Bug 5367753 fetch exchange_rate of the receipt.
2829: SELECT nvl(exchange_rate,1)
2830: INTO l_exchange_rate
2831: FROM ar_cash_receipts
2832: WHERE cash_receipt_id = p_cash_receipt_id;
2833:
2834: l_tot_write_off_amt := NVL(l_existing_wo_amount,0) + NVL(p_applied_amount,0);
2835:

Line 3523: from ar_cash_receipts

3519: ELSIF (p_reference_type = 'RECEIPT' ) THEN
3520: --
3521: select 'y'
3522: into l_reference_valid
3523: from ar_cash_receipts
3524: where cash_receipt_id = p_reference_id
3525: and remit_bank_acct_use_id = p_remittance_bank_account_id;
3526: ELSIF (p_reference_type = 'REMITTANCE' ) THEN
3527: --

Line 3715: ar_cash_receipts cr

3711:
3712: SELECT NVL(payment_channel_code,'CASH')
3713: INTO l_payment_type_code
3714: FROM ar_receipt_methods arm,
3715: ar_cash_receipts cr
3716: WHERE cr.receipt_method_id = arm.receipt_method_id
3717: AND cr.cash_receipt_id=l_cash_receipt_id;
3718:
3719:

Line 3725: ar_cash_receipts cr,

3721:
3722: SELECT NVL(payment_channel_code,'CASH')
3723: INTO l_payment_type_code
3724: FROM ar_receipt_methods arm,
3725: ar_cash_receipts cr,
3726: ar_receivable_applications app
3727: WHERE cr.receipt_method_id = arm.receipt_method_id
3728: AND app.cash_receipt_id=cr.cash_receipt_id
3729: AND app.receivable_application_id = p_receivable_application_id;

Line 4011: FROM ar_cash_receipts

4007: -- Check if unapplication will send the applied-to receipt negative
4008:
4009: SELECT amount
4010: INTO l_cr_amount
4011: FROM ar_cash_receipts
4012: WHERE cash_receipt_id = p_applied_cash_receipt_id;
4013:
4014: SELECT NVL(SUM(amount_applied),0)
4015: INTO l_amount_applied