首页 > 代码库 > 详解ebs接口之客户配置文件导入(一)
详解ebs接口之客户配置文件导入(一)
DECLARE l_rec_profile_t hz_customer_profile_v2pub.customer_profile_rec_type; l_rec_profile hz_customer_profile_v2pub.cust_profile_amt_rec_type; l_profile_amt_id NUMBER; l_profile_id NUMBER; l_return_status1 VARCHAR2(30); l_msg_count1 NUMBER; l_msg_data1 VARCHAR2(2000); l_return_status2 VARCHAR2(30); l_msg_count2 NUMBER; l_msg_data2 VARCHAR2(2000); BEGIN mo_global.init('AR'); fnd_global.apps_initialize(user_id => 10177, resp_id => 52991, resp_appl_id => 222); l_rec_profile_t.cust_account_profile_id := NULL; l_rec_profile_t.cust_account_id := 487194; --CXY-TEST002 l_rec_profile_t.status := 'A'; l_rec_profile_t.collector_id := NULL; l_rec_profile_t.credit_analyst_id := NULL; l_rec_profile_t.credit_checking := NULL; l_rec_profile_t.next_credit_review_date := NULL; l_rec_profile_t.tolerance := NULL; l_rec_profile_t.discount_terms := NULL; l_rec_profile_t.dunning_letters := NULL; l_rec_profile_t.interest_charges := NULL; l_rec_profile_t.send_statements := NULL; l_rec_profile_t.credit_balance_statements := NULL; l_rec_profile_t.credit_hold := NULL; l_rec_profile_t.profile_class_id := NULL; l_rec_profile_t.site_use_id := 420072; --BILL_TO l_rec_profile_t.credit_rating := NULL; l_rec_profile_t.risk_code := NULL; l_rec_profile_t.standard_terms := NULL; l_rec_profile_t.override_terms := NULL; l_rec_profile_t.dunning_letter_set_id := NULL; l_rec_profile_t.interest_period_days := NULL; l_rec_profile_t.payment_grace_days := NULL; l_rec_profile_t.discount_grace_days := NULL; l_rec_profile_t.statement_cycle_id := NULL; l_rec_profile_t.account_status := NULL; l_rec_profile_t.percent_collectable := NULL; l_rec_profile_t.autocash_hierarchy_id := NULL; l_rec_profile_t.auto_rec_incl_disputed_flag := NULL; l_rec_profile_t.tax_printing_option := NULL; l_rec_profile_t.charge_on_finance_charge_flag := NULL; l_rec_profile_t.grouping_rule_id := NULL; l_rec_profile_t.clearing_days := NULL; l_rec_profile_t.cons_inv_flag := NULL; l_rec_profile_t.cons_inv_type := NULL; l_rec_profile_t.autocash_hierarchy_id_for_adr := NULL; l_rec_profile_t.lockbox_matching_option := NULL; l_rec_profile_t.created_by_module := 'BLC'; l_rec_profile_t.application_id := NULL; l_rec_profile_t.review_cycle := NULL; l_rec_profile_t.last_credit_review_date := NULL; l_rec_profile_t.party_id := NULL; l_rec_profile_t.credit_classification := NULL; l_rec_profile_t.cons_bill_level := NULL; l_rec_profile_t.late_charge_calculation_trx := NULL; l_rec_profile_t.credit_items_flag := NULL; l_rec_profile_t.disputed_transactions_flag := NULL; l_rec_profile_t.late_charge_type := NULL; l_rec_profile_t.late_charge_term_id := NULL; l_rec_profile_t.interest_calculation_period := NULL; l_rec_profile_t.hold_charged_invoices_flag := NULL; l_rec_profile_t.message_text_id := NULL; l_rec_profile_t.multiple_interest_rates_flag := NULL; l_rec_profile_t.charge_begin_date := NULL; l_rec_profile_t.automatch_set_id := NULL; hz_customer_profile_v2pub.create_customer_profile(p_init_msg_list => fnd_api.g_false, p_customer_profile_rec => l_rec_profile_t, p_create_profile_amt => fnd_api.g_true, x_cust_account_profile_id => l_profile_id, x_return_status => l_return_status2, x_msg_count => l_msg_count2, x_msg_data =http://www.mamicode.com/> l_msg_data2);>详解ebs接口之客户配置文件导入(一)
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。