DBA Data[Home] [Help]

APPS.AR_RECEIPT_API_PUB dependencies on IBY_EXT_BANK_ACCOUNTS

Line 159: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE;

155: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
156: l_customer_name hz_parties.party_name%TYPE; /*tca uptake*/
157: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
158: /* 6612301 */
159: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
160: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
161: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
162: l_customer_bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE;
163: l_location hz_cust_site_uses.location%TYPE;

Line 160: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;

156: l_customer_name hz_parties.party_name%TYPE; /*tca uptake*/
157: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
158: /* 6612301 */
159: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
160: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
161: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
162: l_customer_bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE;
163: l_location hz_cust_site_uses.location%TYPE;
164: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;

Line 4616: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL,

4612: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
4613: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4614: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
4615: /* 6612301 */
4616: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL,
4617: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL,
4618: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */
4619: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
4620: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,

Line 4617: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL,

4613: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4614: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
4615: /* 6612301 */
4616: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL,
4617: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL,
4618: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */
4619: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
4620: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
4621: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug4448307-4509459

Line 4940: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE

4936: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4937: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
4938: DEFAULT NULL,
4939: /* 6612301 */
4940: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE
4941: DEFAULT NULL,
4942: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE
4943: DEFAULT NULL,
4944: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */

Line 4942: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE

4938: DEFAULT NULL,
4939: /* 6612301 */
4940: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE
4941: DEFAULT NULL,
4942: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE
4943: DEFAULT NULL,
4944: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */
4945: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
4946: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,

Line 7143: l_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE;

7139: l_party_site_id hz_party_sites.party_site_id%TYPE;
7140: l_party_address VARCHAR2(360);
7141: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
7142: l_payment_method_name iby_payment_methods_vl.payment_method_name%TYPE;
7143: l_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE;
7144: l_bank_account_num iby_ext_bank_accounts.bank_account_num%TYPE;
7145: l_payment_reason_code iby_payment_reasons_vl.payment_reason_code%TYPE;
7146: l_payment_reason_name iby_payment_reasons_vl.meaning%TYPE;
7147: l_delivery_channel_code iby_delivery_channels_vl.delivery_channel_code%TYPE;

Line 7144: l_bank_account_num iby_ext_bank_accounts.bank_account_num%TYPE;

7140: l_party_address VARCHAR2(360);
7141: l_payment_method_code iby_payment_methods_vl.payment_method_code%TYPE;
7142: l_payment_method_name iby_payment_methods_vl.payment_method_name%TYPE;
7143: l_bank_account_id iby_ext_bank_accounts.ext_bank_account_id%TYPE;
7144: l_bank_account_num iby_ext_bank_accounts.bank_account_num%TYPE;
7145: l_payment_reason_code iby_payment_reasons_vl.payment_reason_code%TYPE;
7146: l_payment_reason_name iby_payment_reasons_vl.meaning%TYPE;
7147: l_delivery_channel_code iby_delivery_channels_vl.delivery_channel_code%TYPE;
7148: l_delivery_channel_name iby_delivery_channels_vl.meaning%TYPE;