Service contracts API

How to create a service contract using API

You can call API "oks_contracts_pub" to create service cotract header,line, billing schedule etc.
okc_contract_pub


Creating contracts from API is creating it from back-end through program whereas using responsibility it is using Oracle provided standard form.
If your requirement is just to create service contract then use form otherwise you can use API within your program as follows:

Creation of contract header

oks_contracts_pub.create_contract_header(p_k_header_rec, p_header_contacts_tbl, p_header_sales_crd_tbl, p_header_articles_tbl, x_chrid, l_return_status, l_msg_count, l_msg_data);

This API can be used to pass in various header variables like the contract number,short description,start date, end date of the contract, the customer id,bill to and ship to locations of he customer, the status of the contract('Entered','Active'), price list used, invoicing rule type,accounting rule type,contract renewal type etc..

Creation of contract lines

oks_contracts_pub.create_service_line(l_k_line_rec, p_line_contact_tbl, p_line_sales_crd_tbl, x_service_line_id, l_return_status, l_msg_count, l_msg_data);

Creation of contract sub-lines

oks_contracts_pub.create_covered_line(p_k_covd_rec, p_price_attribs, x_cp_line_id, l_return_status, l_msg_count, l_msg_data);

Creation of contract billing schedule

oks_contracts_pub.create_bill_schedule(l_billing_sch, l_strm_level_tbl, l_invoice_rule_id, l_return_status);

Good luck.

1 comments:

  1. Thank you so much for your professional and effective help.
    Service Contracts

    ReplyDelete