DBA Data[Home] [Help]

APPS.AR_RECEIPT_API_PUB dependencies on HZ_CUST_SITE_USES

Line 163: l_location hz_cust_site_uses.location%TYPE;

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;
165: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
166: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
167: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;

Line 164: l_customer_site_use_id hz_cust_site_uses.site_use_id%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;
165: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
166: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
167: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
168: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;

Line 1024: l_location hz_cust_site_uses.location%TYPE;

1020: l_maturity_date DATE;
1021: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1022: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1023: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1024: l_location hz_cust_site_uses.location%TYPE;
1025: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1026: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1027: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1028: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;

Line 1025: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;

1021: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1022: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1023: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1024: l_location hz_cust_site_uses.location%TYPE;
1025: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1026: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1027: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1028: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1029: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;

Line 4619: p_location IN hz_cust_site_uses.location%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
4622: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
4623: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,

Line 4620: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,

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
4622: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
4623: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
4624: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,

Line 4945: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,

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,
4947: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug 4448307-4509459
4948: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE
4949: DEFAULT NULL,

Line 4946: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE 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,
4947: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug 4448307-4509459
4948: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE
4949: DEFAULT NULL,
4950: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE