1、事务处理创建【标准API】
ar_invoice_api_pub.create_invoice(p_api_version => 1.0,
p_init_msg_list => fnd_api.g_true,
p_commit => fnd_api.g_false,
p_batch_source_rec => l_batch_source_rec,
p_trx_header_tbl => l_trx_header_tbl,
p_trx_lines_tbl => l_trx_lines_tbl,
p_trx_dist_tbl => l_trx_dist_tbl,
p_trx_salescredits_tbl => l_trx_salescredits_tbl,
--x_customer_trx_id => l_customer_trx_id,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
2、事务处理贷记【标准API】
mo_global.set_policy_context('S', l_org_id);
ar_cm_api_pub.apply_on_account(p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_error_message,
p_cm_app_rec => l_cm_unapp_rec,
x_out_rec_application_id => x_out_rec_application_id,
p_org_id => l_org_id,
x_acctd_amount_applied_from => x_acctd_amount_applied_from,
x_acctd_amount_applied_to => x_acctd_amount_applied_to);
3、事务处理取消贷项核销【标准API】
ar_cm_api_pub.unapply_on_account(p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_error_message,
p_cm_unapp_rec => l_cm_unapp_rec_type,
p_org_id => l_org_id);
4、事务处理删除【标准API】
apps.ar_invoice_api_pub.delete_transaction(p_api_name => l_api_name,
p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_validation_level => fnd_api.g_valid_level_full,
p_customer_trx_id => l_customer_trx_id,
p_return_status => l_s,
p_msg_count => l_count,
p_msg_data => l_msg_data,
p_errors => l_err);
5、事务处理删除非标准API
有时候,标准的事务处理删除不好用,可以对一下表进行清理!
gl_import_references
xla_ae_lines
xla_ae_headers
xla_events
ra_customer_trx_all
ra_customer_trx_lines_all
ar_payment_schedules_all
ra_cust_trx_line_gl_dist_all
xla.xla_transaction_entities
ar_trx_summary_hist
zx_lines_det_factors
zx_lines