DBA Data[Home] [Help]

APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on AR_RECEIPT_METHODS

Line 118: l_receipt_method_name ar_receipt_methods.name%TYPE := NULL;

114: l_paying_customer_name hz_parties.party_name%TYPE := NULL;
115: l_paying_customer_number hz_cust_accounts.account_number%TYPE := NULL;
116: l_paying_location hz_cust_site_uses.location%TYPE := NULL;
117: l_receipt_method_id ra_customer_trx.receipt_method_id%TYPE := NULL;
118: l_receipt_method_name ar_receipt_methods.name%TYPE := NULL;
119: l_cust_bank_account_id ra_customer_trx.customer_bank_account_id%TYPE := NULL;
120: l_cust_bank_account_name ap_bank_accounts.bank_account_name%TYPE := NULL;
121: l_cust_bank_account_number ap_bank_accounts.bank_account_num%TYPE := NULL;
122: l_start_date_commitment DATE := NULL;

Line 483: l_receipt_method_name ar_receipt_methods.name%TYPE DEFAULT NULL;

479: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL;
480: l_remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL;
481: l_deposit_date ar_cash_receipts.deposit_date%TYPE DEFAULT NULL;
482: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL;
483: l_receipt_method_name ar_receipt_methods.name%TYPE DEFAULT NULL;
484: l_doc_sequence_value NUMBER DEFAULT NULL;
485: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL;
486: l_anticipated_clearing_date ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL;
487: l_called_from VARCHAR2(20) DEFAULT NULL;

Line 5164: l_receipt_method_name ar_receipt_methods.NAME%TYPE;

5160: p_transaction_type_code IN VARCHAR2,
5161: p_org_id IN NUMBER,
5162: x_return_status OUT NOCOPY VARCHAR2)
5163: IS
5164: l_receipt_method_name ar_receipt_methods.NAME%TYPE;
5165: l_payment_channal_code ar_receipt_methods.payment_channel_code%TYPE;
5166: l_rm_start_date ar_receipt_methods.start_date%TYPE;
5167: l_rm_end_date ar_receipt_methods.end_date%TYPE;
5168: l_receipt_creation_method ar_receipt_classes.creation_method_code%TYPE;

Line 5165: l_payment_channal_code ar_receipt_methods.payment_channel_code%TYPE;

5161: p_org_id IN NUMBER,
5162: x_return_status OUT NOCOPY VARCHAR2)
5163: IS
5164: l_receipt_method_name ar_receipt_methods.NAME%TYPE;
5165: l_payment_channal_code ar_receipt_methods.payment_channel_code%TYPE;
5166: l_rm_start_date ar_receipt_methods.start_date%TYPE;
5167: l_rm_end_date ar_receipt_methods.end_date%TYPE;
5168: l_receipt_creation_method ar_receipt_classes.creation_method_code%TYPE;
5169: l_payment_type_name pon_emd_payment_types_tl.NAME%TYPE;

Line 5166: l_rm_start_date ar_receipt_methods.start_date%TYPE;

5162: x_return_status OUT NOCOPY VARCHAR2)
5163: IS
5164: l_receipt_method_name ar_receipt_methods.NAME%TYPE;
5165: l_payment_channal_code ar_receipt_methods.payment_channel_code%TYPE;
5166: l_rm_start_date ar_receipt_methods.start_date%TYPE;
5167: l_rm_end_date ar_receipt_methods.end_date%TYPE;
5168: l_receipt_creation_method ar_receipt_classes.creation_method_code%TYPE;
5169: l_payment_type_name pon_emd_payment_types_tl.NAME%TYPE;
5170: l_refund_payment_method_name iby_payment_methods_tl.payment_method_name%TYPE;

Line 5167: l_rm_end_date ar_receipt_methods.end_date%TYPE;

5163: IS
5164: l_receipt_method_name ar_receipt_methods.NAME%TYPE;
5165: l_payment_channal_code ar_receipt_methods.payment_channel_code%TYPE;
5166: l_rm_start_date ar_receipt_methods.start_date%TYPE;
5167: l_rm_end_date ar_receipt_methods.end_date%TYPE;
5168: l_receipt_creation_method ar_receipt_classes.creation_method_code%TYPE;
5169: l_payment_type_name pon_emd_payment_types_tl.NAME%TYPE;
5170: l_refund_payment_method_name iby_payment_methods_tl.payment_method_name%TYPE;
5171:

Line 5206: FROM AR_RECEIPT_METHODS RM,

5202: l_payment_channal_code,
5203: l_rm_start_date,
5204: l_rm_end_date,
5205: l_receipt_creation_method
5206: FROM AR_RECEIPT_METHODS RM,
5207: AR_RECEIPT_CLASSES RC
5208: WHERE RM.RECEIPT_CLASS_ID = RC.RECEIPT_CLASS_ID
5209: AND RM.RECEIPT_METHOD_ID = p_receipt_method_id;
5210: EXCEPTION