[Home] [Help]
757: p_creation_method_code
758: FROM ar_receipt_methods arm,
759: ra_cust_receipt_methods rcrm,
760: ar_receipt_method_accounts arma,
761: ce_bank_accounts cba,
762: ce_bank_acct_uses aba,
763: ar_receipt_classes arc,
764: ce_bank_branches_v bp /*Bug3348454*/
765: WHERE arm.receipt_method_id = rcrm.receipt_method_id
889: hz_cust_accounts.cust_account_id%type,
890: p_parent_site_use_id IN
891: hz_cust_site_uses.site_use_id%type,
892: p_crtrx_cust_bank_account_id IN
893: ce_bank_accounts.bank_account_id%type,
894: p_cust_bank_account_id OUT NOCOPY
895: ce_bank_accounts.bank_account_id%type,
896: p_paying_customer_id OUT NOCOPY
897: hz_cust_accounts.cust_account_id%type)
891: hz_cust_site_uses.site_use_id%type,
892: p_crtrx_cust_bank_account_id IN
893: ce_bank_accounts.bank_account_id%type,
894: p_cust_bank_account_id OUT NOCOPY
895: ce_bank_accounts.bank_account_id%type,
896: p_paying_customer_id OUT NOCOPY
897: hz_cust_accounts.cust_account_id%type)
898: RETURN BOOLEAN IS
899: l_cust_bank_account_id ce_bank_accounts.bank_account_id%type;
895: ce_bank_accounts.bank_account_id%type,
896: p_paying_customer_id OUT NOCOPY
897: hz_cust_accounts.cust_account_id%type)
898: RETURN BOOLEAN IS
899: l_cust_bank_account_id ce_bank_accounts.bank_account_id%type;
900: l_paying_customer_id hz_cust_accounts.cust_account_id%type;
901: l_account_valid boolean := FALSE;
902: BEGIN
903: /* BICHATTE removed the validation for bank account
1023: ra_salesreps.salesrep_id%type,
1024: p_receipt_method_id IN
1025: ar_receipt_methods.receipt_method_id%type,
1026: p_customer_bank_account_id IN
1027: ce_bank_accounts.bank_account_id%type,
1028: p_paying_customer_id IN
1029: hz_cust_accounts.cust_account_id%type,
1030: p_paying_site_use_id IN
1031: hz_cust_site_uses.site_use_id%type,
1078: --
1079: p_crtrx_receipt_method_id IN
1080: ar_receipt_methods.receipt_method_id%type,
1081: p_crtrx_cust_bank_account_id IN
1082: ce_bank_accounts.bank_account_id%type,
1083: p_crtrx_ship_via IN
1084: ra_customer_trx.ship_via%type,
1085: p_crtrx_ship_date_actual IN
1086: ra_customer_trx.ship_date_actual%type,
1140: ra_salesreps.salesrep_id%type,
1141: p_default_receipt_method_id OUT NOCOPY
1142: ar_receipt_methods.receipt_method_id%type,
1143: p_default_cust_bank_account_id OUT NOCOPY
1144: ce_bank_accounts.bank_account_id%type,
1145: p_default_paying_customer_id OUT NOCOPY
1146: hz_cust_accounts.cust_account_id%type,
1147: p_default_paying_site_use_id OUT NOCOPY
1148: hz_cust_site_uses.site_use_id%type,
1190:
1191: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
1192: l_payment_method_name ar_receipt_methods.name%type;
1193: l_creation_method_code ar_receipt_classes.creation_method_code%type;
1194: l_cust_bank_account_id ce_bank_accounts.bank_account_id%type;
1195: l_bank_account_num ce_bank_accounts.bank_account_num%type;
1196: l_bank_name ce_bank_branches_v.bank_name%type;
1197: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
1198: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;
1191: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
1192: l_payment_method_name ar_receipt_methods.name%type;
1193: l_creation_method_code ar_receipt_classes.creation_method_code%type;
1194: l_cust_bank_account_id ce_bank_accounts.bank_account_id%type;
1195: l_bank_account_num ce_bank_accounts.bank_account_num%type;
1196: l_bank_name ce_bank_branches_v.bank_name%type;
1197: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
1198: l_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;
1199:
1204:
1205: -- Added for bug # 2712726
1206: -- ORASHID
1207: --
1208: l_nocopy_cust_bank_account_id ce_bank_accounts.bank_account_id%type;
1209:
1210: BEGIN
1211: IF PG_DEBUG in ('Y', 'C') THEN
1212: arp_util.debug('arp_process_credit_util.get_cm_header_defaults()+');