[Home] [Help]
92: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
93: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
94: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
95: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
96: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
97: p_doc_sequence_value IN NUMBER DEFAULT NULL,
98: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
99: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
100: p_called_from IN VARCHAR2 DEFAULT NULL,
157: l_response_error_code VARCHAR2(80);
158:
159: --Bug 3220078 --
160: l_cash_receipt_status ar_receipt_classes.creation_status%type;
161: l_payment_type ar_receipt_methods.payment_type_code%type;
162:
163: l_api_name CONSTANT VARCHAR2(20) := 'Create_Prepayment';
164: l_api_version CONSTANT NUMBER := 1.0;
165: l_org_return_status VARCHAR2(1);
178: cr.pay_from_customer,
179: cr.customer_site_use_id,
180: pr.home_country
181: FROM ar_cash_receipts_all cr,
182: ar_receipt_methods rm,
183: ar_receipt_classes rc,
184: hz_cust_accounts hca,
185: hz_parties party,
186: /* Need to pass country code for SEPA specific receipts */
290: /*--------------------------------------------------------------------
291: IF p_receipt_method_id is not null THEN
292: BEGIN
293: SELECT 'Y' into l_cc_check
294: FROM ar_receipt_methods
295: WHERE receipt_method_id=p_receipt_method_id
296: AND payment_type_code = 'CREDIT_CARD';
297: EXCEPTION
298: WHEN no_data_found THEN
442:
443:
444: SELECT payment_channel_code
445: INTO l_payment_type
446: FROM ar_receipt_methods
447: WHERE receipt_method_id = p_receipt_method_id;
448:
449:
450: l_payment_trxn_extension_id := p_payment_trxn_extension_id;
810: ----get the status and payment method of of the receipt -----
811: SELECT rc.creation_status , nvl(rm.payment_channel_code, 'CHECK')
812: INTO l_cash_receipt_status, l_payment_type
813: FROM ar_cash_receipts cr, ar_receipt_classes rc,
814: ar_receipt_methods rm
815: WHERE cr.cash_receipt_id = l_cash_receipt_id
816: AND cr.receipt_method_id = rm.receipt_method_id
817: AND rm.receipt_class_id = rc.receipt_class_id;
818: