[Home] [Help]
2844: l_dunning_letters hz_customer_profiles.dunning_letters%TYPE := 'Y';
2845: l_interest_charges hz_customer_profiles.interest_charges%TYPE := 'Y';
2846: l_send_statements hz_customer_profiles.send_statements%TYPE := 'Y';
2847: l_statement_cycle_name VARCHAR2(80) := NULL;
2848: l_standard_terms_name VARCHAR2(80) := NULL;
2849: l_credit_balance_statements hz_customer_profiles.credit_balance_statements%TYPE := 'Y';
2850: l_credit_hold hz_customer_profiles.credit_hold%TYPE := 'N';
2851: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2852: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2851: l_profile_class_id hz_customer_profiles.profile_class_id%TYPE := 0;
2852: l_site_use_id hz_customer_profiles.site_use_id%TYPE := NULL;
2853: l_credit_rating hz_customer_profiles.credit_rating%TYPE := NULL;
2854: l_risk_code hz_customer_profiles.risk_code%TYPE := NULL;
2855: l_standard_terms hz_customer_profiles.standard_terms%TYPE := NULL;
2856: l_override_terms hz_customer_profiles.override_terms%TYPE := 'Y';
2857: l_dunning_letter_set_id hz_customer_profiles.dunning_letter_set_id%TYPE := NULL;
2858: l_dunning_letter_set_name VARCHAR2(80) := NULL;
2859: l_interest_period_days hz_customer_profiles.interest_period_days%TYPE := NULL;
2954: s_Customer_Category hz_cust_acct_sites_all.Customer_Category_code%TYPE := NULL;
2955: s_Key_Account_Flag hz_cust_acct_sites_all.Key_Account_Flag%TYPE := 'N';
2956: s_Territory_id hz_cust_acct_sites_all.Territory_id%TYPE := NULL;
2957: s_ece_tp_location_code hz_cust_acct_sites_all.ece_tp_location_code%TYPE := NULL;
2958: s_address_mode fnd_territories.address_style%TYPE := 'STANDARD';
2959: s_territory hz_cust_acct_sites_all.territory%TYPE := NULL;
2960: s_translated_customer_name hz_cust_acct_sites_all.translated_customer_name%TYPE := NULL;
2961: s_sales_tax_geo_code hz_locations.sales_tax_geocode%TYPE := NULL;
2962: s_sale_tax_inside_city_limits hz_locations.sales_tax_inside_city_limits%TYPE := '1';
3424: x_statements => l_send_statements,
3425: x_statement_cycle_id => l_statement_cycle_id,
3426: x_statement_cycle_name => l_statement_cycle_name,
3427: x_credit_balance_statements => l_credit_balance_statements,
3428: x_standard_terms => l_standard_terms,
3429: x_standard_terms_name => l_standard_terms_name,
3430: x_override_terms => l_override_terms,
3431: x_payment_grace_days => l_payment_grace_days,
3432: x_dunning_letters => l_dunning_letters,
3425: x_statement_cycle_id => l_statement_cycle_id,
3426: x_statement_cycle_name => l_statement_cycle_name,
3427: x_credit_balance_statements => l_credit_balance_statements,
3428: x_standard_terms => l_standard_terms,
3429: x_standard_terms_name => l_standard_terms_name,
3430: x_override_terms => l_override_terms,
3431: x_payment_grace_days => l_payment_grace_days,
3432: x_dunning_letters => l_dunning_letters,
3433: x_dunning_letter_set_id => l_dunning_letter_set_id,
3509: RAISE EXCP_USER_DEFINED;
3510: END IF;
3511:
3512: -- if auto generate customer number is no, pass the customer number to the API
3513: IF nvl(arp_standard.sysparm.generate_customer_number,'Y') <> 'N' THEN
3514: l_customer_number := NULL;
3515: ELSE
3516: OPEN l_customer_number_csr;
3517: FETCH l_customer_number_csr into l_customer_number;
3678: p_profile_class_id => l_customer_profile_class_id,
3679: p_site_use_id => l_site_use_id,
3680: p_credit_rating => l_credit_rating,
3681: p_risk_code => l_risk_code,
3682: p_standard_terms => l_standard_terms,
3683: p_override_terms => l_override_terms,
3684: p_dunning_letter_set_id => l_dunning_letter_set_id,
3685: p_interest_period_days => l_interest_period_days,
3686: p_payment_grace_days => l_payment_grace_days,