Category Archives: update an existing order header

Update Order Header Details Using Process_Order API For R12 DECLARE  l_header_rec OE_ORDER_PUB.Header_Rec_Type;  v_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;  l_header_adj_tbl OE_ORDER_PUB.Header_Adj_Tbl_Type;  l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_Type;  l_header_scr_tbl OE_ORDER_PUB.Header_Scredit_Tbl_Type;  l_line_scredit_tbl OE_ORDER_PUB.Line_Scredit_Tbl_Type;  l_request_rec OE_ORDER_PUB.Request_Rec_Type ;  l_return_status VARCHAR2(1000);  l_msg_count NUMBER;  l_msg_data VARCHAR2(1000);  p_api_version_number NUMBER :=1.0;  p_init_msg_list VARCHAR2(10) … Continue reading →