[Home] [Help]
158: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
159: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
160: l_maturity_date DATE;
161: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
162: l_customer_name hz_parties.party_name%TYPE; /*tca uptake*/
163: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
164: /* 6612301 */
165: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
166: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
1029: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1030: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1031: l_maturity_date DATE;
1032: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1033: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1034: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1035: l_location hz_cust_site_uses.location%TYPE;
1036: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1037: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
3832: FROM ar_cash_receipts_all cr,
3833: ar_receipt_methods rm,
3834: ar_receipt_classes rc,
3835: hz_cust_accounts hca,
3836: hz_parties party,
3837: /* Need to pass country code for SEPA specific receipts */
3838: ce_bank_acct_uses bau,
3839: ce_bank_accounts cba,
3840: hz_parties bank,
3836: hz_parties party,
3837: /* Need to pass country code for SEPA specific receipts */
3838: ce_bank_acct_uses bau,
3839: ce_bank_accounts cba,
3840: hz_parties bank,
3841: hz_organization_profiles pr
3842: WHERE cr.cash_receipt_id = p_cash_receipt_id
3843: AND hca.cust_account_id = cr.pay_from_customer
3844: AND party.party_id = hca.party_id
4397: ELSE
4398: SELECT party.party_id
4399: INTO l_party_id
4400: FROM hz_cust_accounts hca,
4401: hz_parties party
4402: WHERE hca.party_id = party.party_id
4403: AND hca.cust_account_id = l_customer_id ;
4404:
4405: SELECT INSTR_ASSIGNMENT_ID
4584:
4585: l_customer_id ra_customer_trx.paying_customer_id%type;
4586: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
4587: l_org_id ra_customer_trx.org_id%type;
4588: l_party_id hz_parties.party_id%type;
4589: l_trx_number ra_customer_trx.trx_number%type;
4590: l_payment_channel_code ar_receipt_methods.payment_channel_code%type;
4591: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
4592:
4608:
4609: SELECT party.party_id
4610: INTO l_party_id
4611: FROM hz_cust_accounts hca,
4612: hz_parties party
4613: WHERE hca.party_id = party.party_id
4614: AND hca.cust_account_id = l_customer_id ;
4615:
4616: SELECT payment_channel_code
4781: p_maturity_date IN DATE DEFAULT NULL,
4782: p_postmark_date IN DATE DEFAULT NULL,
4783: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4784: /* tca uptake */
4785: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
4786: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4787: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
4788: /* 6612301 */
4789: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL,
5104: p_maturity_date IN DATE DEFAULT NULL,
5105: p_postmark_date IN DATE DEFAULT NULL,
5106: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
5107: /* tca uptake */
5108: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
5109: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
5110: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
5111: DEFAULT NULL,
5112: /* 6612301 */
7391: ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE
7392: ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE
7393: ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE
7394: ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE
7395: ,p_party_id IN hz_parties.party_id%TYPE
7396: ,p_party_site_id IN hz_party_sites.party_site_id%TYPE
7397: ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
7398: ,p_payment_priority IN ap_invoices_interface.PAYMENT_PRIORITY%TYPE --Bug8290172
7399: ,p_terms_id IN ap_invoices_interface.TERMS_ID%TYPE --Bug8290172
7425: l_acctd_amount_applied_to NUMBER;
7426: l_org_return_status VARCHAR2(1);
7427: l_org_id NUMBER;
7428:
7429: l_party_id hz_parties.party_id%TYPE;
7430: l_party_name hz_parties.party_name%TYPE;
7431: l_party_number hz_parties.party_number%TYPE;
7432: l_party_site_id hz_party_sites.party_site_id%TYPE;
7433: l_party_address VARCHAR2(360);
7426: l_org_return_status VARCHAR2(1);
7427: l_org_id NUMBER;
7428:
7429: l_party_id hz_parties.party_id%TYPE;
7430: l_party_name hz_parties.party_name%TYPE;
7431: l_party_number hz_parties.party_number%TYPE;
7432: l_party_site_id hz_party_sites.party_site_id%TYPE;
7433: l_party_address VARCHAR2(360);
7434: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
7427: l_org_id NUMBER;
7428:
7429: l_party_id hz_parties.party_id%TYPE;
7430: l_party_name hz_parties.party_name%TYPE;
7431: l_party_number hz_parties.party_number%TYPE;
7432: l_party_site_id hz_party_sites.party_site_id%TYPE;
7433: l_party_address VARCHAR2(360);
7434: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
7435: l_payment_method_name iby_payment_methods_vl.payment_method_name%TYPE;
12021: BEGIN
12022: SELECT cust_acct.cust_account_id
12023: INTO l_customer_id
12024: FROM hz_cust_accounts cust_acct,
12025: hz_parties party
12026: WHERE cust_acct.party_id = party.party_id
12027: and cust_acct.cust_account_id = l_customer_id
12028: and cust_acct.status = 'A' ;
12029: EXCEPTION
12037: BEGIN
12038: SELECT cust_acct.cust_account_id
12039: INTO l_customer_id
12040: FROM hz_cust_accounts cust_acct,
12041: hz_parties party
12042: WHERE cust_acct.party_id = party.party_id
12043: AND cust_acct.status = 'A'
12044: AND cust_acct.cust_account_id = l_customer_id
12045: AND cust_acct.cust_account_id in