-
OE_INF_POPULATE_PUB.populate_interface
declare v_return_status varchar2(10); v_order_number_from number; v_order_source_id number; begin oe_debug_pub.debug_on; oe_debug_pub.initialize; oe_debug_pub.add(‘Executing API..’,1); oe_inf_populate_pub.populate_interface ( p_api_version_number => 1.0 , x_return_status => v_return_status , p_order_number_from => v_order_number_from , p_order_source_id => v_order_source_id ); oe_debug_pub.add(‘API Executed.’,1); end;
-
OZF_OFFER_PUB.process_modifiers
SET serveroutput on; DECLARE — v_return_status VARCHAR2(1); –v_msg_count NUMBER; — v_msg_data VARCHAR2(20000); l_user_id NUMBER; l_resp_id NUMBER; l_api_version constant number := 1.0; l_qp_list_header_id NUMBER := 0; l_validation_level NUMBER := fnd_api.g_valid_level_none; l_return_status varchar2(1); l_msg_count number; l_msg_data varchar2(2000); l_error_location NUMBER := 0; l_modifier_list_rec OZF_Offer_Pub.modifier_list_rec_type; l_modifier_line_tbl OZF_Offer_Pub.modifier_line_tbl_type; l_qualifier_tbl OZF_Offer_Pub.qualifiers_tbl_type; l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type; l_budget_tbl OZF_Offer_Pub.budget_tbl_type; l_act_product_tbl OZF_Offer_Pub.act_product_tbl_type; l_discount_tbl OZF_Offer_Pub.discount_line_tbl_type; l_excl_tbl OZF_Offer_Pub.excl_rec_tbl_type;…
-
OZF_FUNDS_PUB
SET serveroutput on; DECLARE l_user_name VARCHAR2(100); l_user_id NUMBER; l_resource_id NUMBER; l_resp_id NUMBER; l_api_version NUMBER := 1.0; l_fund_id NUMBER; l_validation_level NUMBER := fnd_api.g_valid_level_none; l_return_status VARCHAR2(1); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_pvt_fund_rec OZF_FUNDS_PUB.fund_rec_type; l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type; l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type; l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type; l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type; l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type; l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type; l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type; BEGIN select resource_id into l_pvt_fund_rec.owner from JTF_RS_RESOURCE_EXTNS where user_id = 1177;…
-
OZF_FUND_UTILIZED_PVT.create_utilization
SET serveroutput on; DECLARE l_user_name VARCHAR2(100) ; l_user_id NUMBER; l_resp_id NUMBER; l_adj_rec OZF_FUND_UTILIZED_PVT.utilization_rec_type; l_return_status VARCHAR2(1); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_utilization_id NUMBER; BEGIN BEGIN select responsibility_id into l_resp_id from fnd_responsibility_vl where responsibility_key = ‘OZF_USER’; EXCEPTION WHEN OTHERS THEN l_resp_id := NULL; END; FND_GLOBAL.apps_initialize (user_id => 1234 — change this value , resp_id => l_resp_id,…
-
API: OE_OE_TOTALS_SUMMARY to get Sales Order’s Subtotal, discounts and tax details
OE_OE_TOTALS_SUMMARY.ORDER_TOTALS can be used to derive a sales order’s subtotal, discount, tax and charges. Below is the code snippet on how to use the API DECLARE v_HEADER_ID NUMBER; v_SUBTOTAL NUMBER; v_DISCOUNT NUMBER; v_CHARGES NUMBER; v_TAX NUMBER; BEGIN v_HEADER_ID := 5908; OE_OE_TOTALS_SUMMARY.ORDER_TOTALS( P_HEADER_ID => v_HEADER_ID, P_SUBTOTAL => v_SUBTOTAL, P_DISCOUNT => v_DISCOUNT, P_CHARGES => v_CHARGES, P_TAX => V_TAX ); DBMS_OUTPUT.PUT_LINE(‘SUBTOTAL =…
-
API: QP_PRICE_LIST_PUB Example To create and update Price Lists
QP_PRICE_LIST_PUB example To Create a New Price List: DECLARE v_return_status VARCHAR2(1) := NULL; v_msg_count NUMBER := 0; v_msg_data VARCHAR2 (2000); v_price_list_rec qp_price_list_pub.price_list_rec_type; v_price_list_val_rec qp_price_list_pub.price_list_val_rec_type; v_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type; v_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type; v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type; v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type; v_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type; v_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type; ppr_price_list_rec qp_price_list_pub.price_list_rec_type; ppr_price_list_val_rec qp_price_list_pub.price_list_val_rec_type; ppr_price_list_line_tbl qp_price_list_pub.price_list_line_tbl_type; ppr_price_list_line_val_tbl qp_price_list_pub.price_list_line_val_tbl_type; ppr_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type; ppr_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type; ppr_pricing_attr_tbl qp_price_list_pub.pricing_attr_tbl_type; ppr_pricing_attr_val_tbl qp_price_list_pub.pricing_attr_val_tbl_type; –apps initilization variables…
-
OE_ORDER_PUB: Cancel Sales Order Line
set serveroutput on; DECLARE v_api_version_number NUMBER := 1; v_return_status VARCHAR2 (2000); v_msg_count NUMBER; v_msg_data VARCHAR2 (2000); l_debug_level NUMBER := 1 — IN Variables — v_header_rec oe_order_pub.header_rec_type; v_line_tbl oe_order_pub.line_tbl_type; v_action_request_tbl oe_order_pub.request_tbl_type; v_line_adj_tbl oe_order_pub.line_adj_tbl_type; — OUT Variables — v_header_rec_out oe_order_pub.header_rec_type; v_header_val_rec_out oe_order_pub.header_val_rec_type; v_header_adj_tbl_out oe_order_pub.header_adj_tbl_type; v_header_adj_val_tbl_out oe_order_pub.header_adj_val_tbl_type; v_header_price_att_tbl_out oe_order_pub.header_price_att_tbl_type; v_header_adj_att_tbl_out oe_order_pub.header_adj_att_tbl_type; v_header_adj_assoc_tbl_out oe_order_pub.header_adj_assoc_tbl_type; v_header_scredit_tbl_out oe_order_pub.header_scredit_tbl_type; v_header_scredit_val_tbl_out oe_order_pub.header_scredit_val_tbl_type; v_line_tbl_out…
-
OE_ORDER_PUB: Book existing Sales Order
set serveroutput on; DECLARE l_api_version_number NUMBER := 1; l_return_status VARCHAR2(2000); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_debug_level NUMBER := 1; — OM DEBUG LEVEL (MAX 5) — IN Variables — l_header_rec oe_order_pub.header_rec_type; l_line_tbl oe_order_pub.line_tbl_type; l_action_request_tbl oe_order_pub.Request_Tbl_Type; — OUT Variables — l_header_rec_out oe_order_pub.header_rec_type; l_header_val_rec_out oe_order_pub.header_val_rec_type; l_header_adj_tbl_out oe_order_pub.header_adj_tbl_type; l_header_adj_val_tbl_out oe_order_pub.header_adj_val_tbl_type; l_header_price_att_tbl_out oe_order_pub.header_price_att_tbl_type; l_header_adj_att_tbl_out oe_order_pub.header_adj_att_tbl_type; l_header_adj_assoc_tbl_out oe_order_pub.header_adj_assoc_tbl_type; l_header_scredit_tbl_out oe_order_pub.header_scredit_tbl_type; l_header_scredit_val_tbl_out…
-
OE_ORDER_PUB: Add lines to existing Sales Order
OE_ORDER_PUB: Add lines to existing Sales Order set serveroutput on; DECLARE l_api_version_number NUMBER := 1; l_return_status VARCHAR2(2000); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_debug_level NUMBER := 1; — OM DEBUG LEVEL (MAX 5) — IN Variables — l_header_rec oe_order_pub.header_rec_type; l_line_tbl oe_order_pub.line_tbl_type; l_action_request_tbl oe_order_pub.Request_Tbl_Type; — OUT Variables — l_header_rec_out oe_order_pub.header_rec_type; l_header_val_rec_out oe_order_pub.header_val_rec_type; l_header_adj_tbl_out oe_order_pub.header_adj_tbl_type; l_header_adj_val_tbl_out oe_order_pub.header_adj_val_tbl_type; l_header_price_att_tbl_out oe_order_pub.header_price_att_tbl_type;…
-
OE_ORDER_PUB: Create and Book Sales Order
Create and Book Sales Order set serveroutput on; DECLARE l_api_version_number NUMBER := 1; l_return_status VARCHAR2(2000); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_debug_level NUMBER := 1; — OM DEBUG LEVEL (MAX 5) — IN Variables — l_header_rec oe_order_pub.header_rec_type; l_line_tbl oe_order_pub.line_tbl_type; l_action_request_tbl oe_order_pub.Request_Tbl_Type; — OUT Variables — l_header_rec_out oe_order_pub.header_rec_type; l_header_val_rec_out oe_order_pub.header_val_rec_type; l_header_adj_tbl_out oe_order_pub.header_adj_tbl_type; l_header_adj_val_tbl_out oe_order_pub.header_adj_val_tbl_type; l_header_price_att_tbl_out oe_order_pub.header_price_att_tbl_type; l_header_adj_att_tbl_out oe_order_pub.header_adj_att_tbl_type;…
-
OE_ORDER_PUB: Create Sales Order in Entered Status
set serveroutput on; DECLARE l_api_version_number NUMBER := 1; l_return_status VARCHAR2(2000); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_debug_level NUMBER := 1; — OM DEBUG LEVEL (MAX 5) — IN Variables — l_header_rec oe_order_pub.header_rec_type; l_line_tbl oe_order_pub.line_tbl_type; l_action_request_tbl oe_order_pub.Request_Tbl_Type; — OUT Variables — l_header_rec_out oe_order_pub.header_rec_type; l_header_val_rec_out oe_order_pub.header_val_rec_type; l_header_adj_tbl_out oe_order_pub.header_adj_tbl_type; l_header_adj_val_tbl_out oe_order_pub.header_adj_val_tbl_type; l_header_price_att_tbl_out oe_order_pub.header_price_att_tbl_type; l_header_adj_att_tbl_out oe_order_pub.header_adj_att_tbl_type; l_header_adj_assoc_tbl_out oe_order_pub.header_adj_assoc_tbl_type; l_header_scredit_tbl_out oe_order_pub.header_scredit_tbl_type; l_header_scredit_val_tbl_out…