[Home] [Help]
2338: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';
2339: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';
2340: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';
2341: l_statement_cycle_name VARCHAR2(80) := NULL;
2342: l_standard_terms_name VARCHAR2(80) := NULL;
2343: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';
2344: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';
2345: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2346: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2345: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2346: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2347: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2348: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2349: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2350: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2351: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2352: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2353: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2448: s_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE := NULL;
2449: s_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE := 'N';
2450: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;
2451: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2452: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2453: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;
2454: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;
2455: s_sales_tax_geo_code hz_locations.sales_tax_geocode%TYPE := NULL;
2456: s_sale_tax_inside_city_limits hz_locations.sales_tax_inside_city_limits%TYPE := '1';
2869: x_statements => l_send_statements,
2870: x_statement_cycle_id => l_statement_cycle_id,
2871: x_statement_cycle_name => l_statement_cycle_name,
2872: x_credit_balance_statements => l_credit_balance_statements,
2873: x_standard_terms => l_standard_terms,
2874: x_standard_terms_name => l_standard_terms_name,
2875: x_override_terms => l_override_terms,
2876: x_payment_grace_days => l_payment_grace_days,
2877: x_dunning_letters => l_dunning_letters,
2870: x_statement_cycle_id => l_statement_cycle_id,
2871: x_statement_cycle_name => l_statement_cycle_name,
2872: x_credit_balance_statements => l_credit_balance_statements,
2873: x_standard_terms => l_standard_terms,
2874: x_standard_terms_name => l_standard_terms_name,
2875: x_override_terms => l_override_terms,
2876: x_payment_grace_days => l_payment_grace_days,
2877: x_dunning_letters => l_dunning_letters,
2878: x_dunning_letter_set_id => l_dunning_letter_set_id,
2954: RAISE EXCP_USER_DEFINED;
2955: END IF;
2956:
2957: -- if auto generate customer number is no, pass the customer number to the API
2958: IF nvl(arp_standard.sysparm.generate_customer_number,'Y') <> 'N' THEN
2959: l_customer_number := NULL;
2960: ELSE
2961: OPEN l_customer_number_csr;
2962: FETCH l_customer_number_csr into l_customer_number;
3123: p_profile_class_id => l_customer_profile_class_id,
3124: p_site_use_id => l_site_use_id,
3125: p_credit_rating => l_credit_rating,
3126: p_risk_code => l_risk_code,
3127: p_standard_terms => l_standard_terms,
3128: p_override_terms => l_override_terms,
3129: p_dunning_letter_set_id => l_dunning_letter_set_id,
3130: p_interest_period_days => l_interest_period_days,
3131: p_payment_grace_days => l_payment_grace_days,