http://www.sunnybtoc.com/page/M0/S747/747081.html

PURPOSE:

 

 

This post is to provide a sample script to Apply hold on a sales order using an APIOE_ORDER_PUB.PROCESS_ORDER.

 

 

 

TEST INSTANCE:  R12.1.1

 

 

 

SCRIPT:

 

 

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">SET<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> SERVEROUTPUT <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">ON;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">DECLARE<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_api_version_number           <span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">NUMBER<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">:=<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">1<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_return_status                <span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">VARCHAR2<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">2000<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_msg_count                    <span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">NUMBER<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_msg_data                     <span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">VARCHAR2<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">2000<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

 

 

<span "courier="" new"";="" color:="" green;="" font-size:="" x-small"="">-- IN Variables --<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_header_rec                   oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">header_rec_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_line_tbl                     oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">line_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_action_request_tbl           oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">request_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_line_adj_tbl                 oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">line_adj_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

 

 

<span "courier="" new"";="" color:="" green;="" font-size:="" x-small"="">-- OUT Variables --<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_header_rec_out               oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">header_rec_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_header_val_rec_out           oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">header_val_rec_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_header_adj_tbl_out           oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">header_adj_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_header_adj_val_tbl_out       oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">header_adj_val_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_header_price_att_tbl_out     oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">header_price_att_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_header_adj_att_tbl_out       oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">header_adj_att_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_header_adj_assoc_tbl_out     oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">header_adj_assoc_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_header_scredit_tbl_out       oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">header_scredit_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_header_scredit_val_tbl_out   oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">header_scredit_val_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_line_tbl_out                 oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">line_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_line_val_tbl_out             oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">line_val_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_line_adj_tbl_out             oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">line_adj_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_line_adj_val_tbl_out         oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">line_adj_val_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_line_price_att_tbl_out       oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">line_price_att_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_line_adj_att_tbl_out         oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">line_adj_att_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_line_adj_assoc_tbl_out       oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">line_adj_assoc_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_line_scredit_tbl_out         oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">line_scredit_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_line_scredit_val_tbl_out     oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">line_scredit_val_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_lot_serial_tbl_out           oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">lot_serial_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_lot_serial_val_tbl_out       oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">lot_serial_val_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_action_request_tbl_out       oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">request_tbl_type<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

 

 

 

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">BEGIN<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

 

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">DBMS_OUTPUT<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">PUT_LINE<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">""Starting of script""<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

 

 

<span "courier="" new"";="" color:="" green;="" font-size:="" x-small"="">-- Setting the Enviroment --<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

 

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">mo_global<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">init<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">""ONT""<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">fnd_global<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">apps_initialize <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> user_id      <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">2585<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">                            <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">res p_id      <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">50864<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">                            <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">res p_appl_id <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">660<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">mo_global<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">set_policy_context<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">""S""<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">83<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

 

 

--THIS IS TO APPLY HOLD AN ORDER HEADER<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_action_request_tbl <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">1<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">)<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">              <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">:=<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">oe_order_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">g_miss_request_rec<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_action_request_tbl <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">1<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">).<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">entity_id    <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">:=<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">6012<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_action_request_tbl <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">1<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">).<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">entity_code  <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">:=<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">OE_GLOBALS<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">G_ENTITY_HEADER<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_action_request_tbl <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">1<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">).<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">request_type <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">:=<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">OE_GLOBALS<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">G_APPLY_HOLD<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_action_request_tbl <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">1<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">).<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">param1       <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">:=<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">50<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">    <span "courier="" new"";="" color:="" green;="" font-size:="" x-small"="">-- hold_id <span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_action_request_tbl <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">1<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">).<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">param2       <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">:=<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">""O""<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">   <span "courier="" new"";="" color:="" green;="" font-size:="" x-small"="">-- indicator that it is an order hold<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">v_action_request_tbl <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">1<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">).<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">param3       <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">:=<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">6012<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" green;="" font-size:="" x-small"="">-- Header ID of the order<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

 

 

 

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">DBMS_OUTPUT<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">PUT_LINE<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">""Starting of API""<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

 

 

-- CALLING THE API TO APPLY HOLD ON EXISTING ORDER --<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

 

 

OE_ORDER_PUB.PROCESS_ORDER<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">p_api_version_number            <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_api_version_number

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> p_header_rec                  <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_header_rec

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> p_line_tbl                    <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_line_tbl

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> p_action_request_tbl          <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_action_request_tbl

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> p_line_adj_tbl                <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_line_adj_tbl

 

<span "courier="" new"";="" color:="" green;="" font-size:="" x-small"="">-- OUT variables<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_header_rec                  <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_header_rec_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_header_val_rec              <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_header_val_rec_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_header_adj_tbl              <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_header_adj_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_header_adj_val_tbl          <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_header_adj_val_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_header_price_att_tbl        <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_header_price_att_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_header_adj_att_tbl          <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_header_adj_att_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_header_adj_assoc_tbl        <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_header_adj_assoc_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_header_scredit_tbl          <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_header_scredit_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_header_scredit_val_tbl      <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_header_scredit_val_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_line_tbl                    <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_line_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_line_val_tbl                <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_line_val_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_line_adj_tbl                <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_line_adj_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_line_adj_val_tbl            <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_line_adj_val_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_line_price_att_tbl          <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_line_price_att_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_line_adj_att_tbl            <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_line_adj_att_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_line_adj_assoc_tbl          <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_line_adj_assoc_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_line_scredit_tbl            <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_line_scredit_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_line_scredit_val_tbl        <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_line_scredit_val_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_lot_serial_tbl              <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_lot_serial_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_lot_serial_val_tbl          <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_lot_serial_val_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_action_request_tbl          <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_action_request_tbl_out

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_return_status               <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_return_status

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_msg_count                   <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_msg_count

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> x_msg_data                    <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_msg_data

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

 

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">DBMS_OUTPUT<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">PUT_LINE<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">""Completion of API""<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

 

 

 

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">IF<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_return_status <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> fnd_api<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">g_ret_sts_success <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">THEN<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">    <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">COMMIT;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">    DBMS_OUTPUT<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">put_line <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">""Applying Hold on Sales Order is Success ""<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">ELSE<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">    DBMS_OUTPUT<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">put_line <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">""Applying Hold on Sales Orderfailed:""<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">||v_msg_data<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">    <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">ROLLBACK;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">    <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">FOR<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> i <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">IN<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">1<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">..<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_msg_count

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">    <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">LOOP<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">      v_msg_data <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">:=<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> oe_msg_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">get<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> p_msg_index <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> i<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">p_encoded <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">""F""<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">      dbms_output<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">put_line<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> i|| <span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">"") ""<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">|| v_msg_data<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">    <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">END<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">LOOP<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">END<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">IF;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">FOR<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> i <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">IN<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" maroon;="" font-size:="" x-small"="">1<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">..<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> v_msg_count

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">    <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">LOOP<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">      v_msg_data <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">:=<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> oe_msg_pub<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">get<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> p_msg_index <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> i<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">,<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">p_encoded <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">=><span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">""F""<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">      dbms_output<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">.<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">put_line<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">(<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> i|| <span "courier="" new"";="" color:="" red;="" font-size:="" x-small"="">"") ""<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">|| v_msg_data<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">);<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">    <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">END<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"=""> <span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">LOOP<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

 

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">END;<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">

 

<span "courier="" new"";="" color:="" #0000f0;="" font-size:="" x-small"="">/<span "courier="" new"";="" color:="" black;="" font-size:="" x-small"="">
 

 

Admin