Book An Order Using OE_INBOUND_INT.PROCESS_ORDER
Book an order using oe_inbound_int.process_order API
DECLARE
l_session_id NUMBER;
l_user_id NUMBER := 0;
l_responsibility_id NUMBER := 21623;
l_login_id NUMBER := 2987330;
l_count NUMBER;
l_msg_count NUMBER := 0;
x_cnt NUMBER := 3;
l_return_status VARCHAR2 (1);
l_msg_data VARCHAR2 (2000);
x_msg_data VARCHAR2 (2000);
x_msg_details VARCHAR2 (2000);
x_msg_count VARCHAR2 (2000);
msg_text VARCHAR2 (2000);
l_header_rec oe_order_pub.header_rec_type;
l_header_rec_miss oe_order_pub.header_rec_type;
l_header_val_rec oe_order_pub.header_val_rec_type;
l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
l_header_scredit_val_tbl oe_order_pub.header_scredit_val_tbl_type;
l_header_payment_tbl oe_order_pub.header_payment_tbl_type;
l_header_payment_val_tbl oe_order_pub.header_payment_val_tbl_type;
l_old_header_rec oe_order_pub.header_rec_type;
l_old_header_val_rec oe_order_pub.header_val_rec_type;
l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
l_old_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
l_old_header_scredit_val_tbl oe_order_pub.header_scredit_val_tbl_type;
l_old_header_payment_tbl oe_order_pub.header_payment_tbl_type;
l_old_header_payment_val_tbl oe_order_pub.header_payment_val_tbl_type;
l_line_tbl oe_order_pub.line_tbl_type;
l_line_tbl_miss oe_order_pub.line_tbl_type;
l_line_val_tbl oe_order_pub.line_val_tbl_type;
l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
l_line_adj_val_tbl oe_order_pub.line_adj_val_tbl_type;
l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
l_line_scredit_val_tbl oe_order_pub.line_scredit_val_tbl_type;
l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
l_lot_serial_val_tbl oe_order_pub.lot_serial_val_tbl_type;
l_line_payment_tbl oe_order_pub.line_payment_tbl_type;
l_line_payment_val_tbl oe_order_pub.line_payment_val_tbl_type;
l_old_line_tbl oe_order_pub.line_tbl_type;
l_old_line_val_tbl oe_order_pub.line_val_tbl_type;
l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
l_old_line_adj_val_tbl oe_order_pub.line_adj_val_tbl_type;
l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
l_old_line_scredit_val_tbl oe_order_pub.line_scredit_val_tbl_type;
l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
l_old_lot_serial_val_tbl oe_order_pub.lot_serial_val_tbl_type;
l_old_line_payment_tbl oe_order_pub.line_payment_tbl_type;
l_old_line_payment_val_tbl oe_order_pub.line_payment_val_tbl_type;
l_action_request_tbl oe_order_pub.request_tbl_type;
l_action_request_tbl_miss oe_order_pub.request_tbl_type;
o_header_rec oe_order_pub.header_rec_type;
o_header_val_rec oe_order_pub.header_val_rec_type;
o_header_adj_tbl oe_order_pub.header_adj_tbl_type;
o_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
o_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
o_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
o_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
o_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
o_header_scredit_val_tbl oe_order_pub.header_scredit_val_tbl_type;
o_line_tbl oe_order_pub.line_tbl_type;
o_line_val_tbl oe_order_pub.line_val_tbl_type;
o_line_adj_tbl oe_order_pub.line_adj_tbl_type;
o_line_adj_val_tbl oe_order_pub.line_adj_val_tbl_type;
o_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
o_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
o_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
o_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
o_line_scredit_val_tbl oe_order_pub.line_scredit_val_tbl_type;
o_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
o_lot_serial_val_tbl oe_order_pub.lot_serial_val_tbl_type;
o_action_request_tbl oe_order_pub.request_tbl_type;
x_messages oe_message_obj_t := oe_message_obj_t ();
p_header_rec oe_order_pub_header_rec_type;
p_old_header_rec oe_order_pub_header_rec_type;
p_header_val_rec oe_order_pub_header_val_rec_t;
p_old_header_val_rec oe_order_pub_header_val_rec_t;
p_header_adj_tbl oe_order_pub_header_adj_tbl_t;
p_old_header_adj_tbl oe_order_pub_header_adj_tbl_t;
p_header_adj_val_tbl oe_order_pub_header_adj_val_t;
p_old_header_adj_val_tbl oe_order_pub_header_adj_val_t;
p_header_price_att_tbl oe_order_pub_header_price_att;
p_old_header_price_att_tbl oe_order_pub_header_price_att;
p_header_adj_att_tbl oe_order_pub_header_adj_att_t;
p_old_header_adj_att_tbl oe_order_pub_header_adj_att_t;
p_header_adj_assoc_tbl oe_order_pub_header_adj_assoc;
p_old_header_adj_assoc_tbl oe_order_pub_header_adj_assoc;
p_header_scredit_tbl oe_order_pub_header_scredit_t;
p_old_header_scredit_tbl oe_order_pub_header_scredit_t;
p_header_scredit_val_tbl oe_order_pub_header_scredit_v;
p_old_header_scredit_val_tbl oe_order_pub_header_scredit_v;
p_header_payment_tbl oe_order_pub_header_payment_t;
p_old_header_payment_tbl oe_order_pub_header_payment_t;
p_header_payment_val_tbl oe_order_pub_header_payment_v;
p_old_header_payment_val_tbl oe_order_pub_header_payment_v;
p_line_tbl oe_order_pub_line_tbl_type;
p_old_line_tbl oe_order_pub_line_tbl_type;
p_line_val_tbl oe_order_pub_line_val_tbl_typ;
p_old_line_val_tbl oe_order_pub_line_val_tbl_typ;
p_line_adj_tbl oe_order_pub_line_adj_tbl_typ;
p_old_line_adj_tbl oe_order_pub_line_adj_tbl_typ;
p_line_adj_val_tbl oe_order_pub_line_adj_val_tbl;
p_old_line_adj_val_tbl oe_order_pub_line_adj_val_tbl;
p_line_price_att_tbl oe_order_pub_line_price_att_t;
p_old_line_price_att_tbl oe_order_pub_line_price_att_t;
p_line_adj_att_tbl oe_order_pub_line_adj_att_tbl;
p_old_line_adj_att_tbl oe_order_pub_line_adj_att_tbl;
p_line_adj_assoc_tbl oe_order_pub_line_adj_assoc_t;
p_old_line_adj_assoc_tbl oe_order_pub_line_adj_assoc_t;
p_line_scredit_tbl oe_order_pub_line_scredit_tbl;
p_old_line_scredit_tbl oe_order_pub_line_scredit_tbl;
p_line_scredit_val_tbl oe_order_pub_line_scredit_val;
p_old_line_scredit_val_tbl oe_order_pub_line_scredit_val;
p_line_payment_tbl oe_order_pub_line_payment_tbl;
p_old_line_payment_tbl oe_order_pub_line_payment_tbl;
p_line_payment_val_tbl oe_order_pub_line_payment_val;
p_old_line_payment_val_tbl oe_order_pub_line_payment_val;
p_lot_serial_tbl oe_order_pub_lot_serial_tbl_t;
p_old_lot_serial_tbl oe_order_pub_lot_serial_tbl_t;
p_lot_serial_val_tbl oe_order_pub_lot_serial_val_t;
p_old_lot_serial_val_tbl oe_order_pub_lot_serial_val_t;
p_action_request_tbl oe_order_pub_request_tbl_type;
x_header_rec oe_order_pub_header_rec_type;
x_header_val_rec oe_order_pub_header_val_rec_t;
x_header_adj_tbl oe_order_pub_header_adj_tbl_t;
x_header_adj_val_tbl oe_order_pub_header_adj_val_t;
x_header_price_att_tbl oe_order_pub_header_price_att;
x_header_adj_att_tbl oe_order_pub_header_adj_att_t;
x_header_adj_assoc_tbl oe_order_pub_header_adj_assoc;
x_header_scredit_tbl oe_order_pub_header_scredit_t;
x_header_scredit_val_tbl oe_order_pub_header_scredit_v;
x_line_tbl oe_order_pub_line_tbl_type;
x_line_val_tbl oe_order_pub_line_val_tbl_typ;
x_line_adj_tbl oe_order_pub_line_adj_tbl_typ;
x_line_adj_val_tbl oe_order_pub_line_adj_val_tbl;
x_line_price_att_tbl oe_order_pub_line_price_att_t;
x_line_adj_att_tbl oe_order_pub_line_adj_att_tbl;
x_line_adj_assoc_tbl oe_order_pub_line_adj_assoc_t;
x_line_scredit_tbl oe_order_pub_line_scredit_tbl;
x_line_scredit_val_tbl oe_order_pub_line_scredit_val;
x_lot_serial_tbl oe_order_pub_lot_serial_tbl_t;
x_lot_serial_val_tbl oe_order_pub_lot_serial_val_t;
x_action_request_tbl oe_order_pub_request_tbl_type;
x_header_payment_tbl oe_order_pub_header_payment_t;
x_header_payment_val_tbl oe_order_pub_header_payment_v;
x_line_payment_tbl oe_order_pub_line_payment_tbl;
x_line_payment_val_tbl oe_order_pub_line_payment_val;
l_payment_term_id NUMBER;
l_line_type_id NUMBER;
-- degug_file_name
dbg_file VARCHAR2 (1024);
BEGIN
oe_debug_pub.initialize;
oe_debug_pub.debug_on;
oe_debug_pub.setdebuglevel (5);
dbg_file := oe_debug_pub.set_debug_mode ('file');
DBMS_OUTPUT.put_line (
'the debug file is : '
|| oe_debug_pub.g_dir
|| '/'
|| oe_debug_pub.g_file);
fnd_global.initialize (session_id => l_session_id,
user_id => l_user_id,
resp_id => l_responsibility_id,
resp_appl_id => 660,
security_group_id => 0,
site_id => NULL,
login_id => l_login_id,
conc_login_id => NULL,
prog_appl_id => NULL,
conc_program_id => NULL,
conc_request_id => NULL,
conc_priority_request => NULL);
oe_msg_pub.initialize;
l_action_request_tbl (1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
l_action_request_tbl (1).request_type := OE_GLOBALS.G_BOOK_ORDER;
l_action_request_tbl (1).Entity_id := 10004765;
--==================================================================================================
-- calling process order api
--==================================================================================================
DBMS_OUTPUT.put_line ('calling process order.....');
p_header_rec := oe_inbound_int.pl_to_sql1 (l_header_rec);
p_old_header_rec := oe_inbound_int.pl_to_sql1 (l_old_header_rec);
p_header_val_rec := oe_inbound_int.pl_to_sql2 (l_header_val_rec);
p_old_header_val_rec := oe_inbound_int.pl_to_sql2 (l_old_header_val_rec);
p_header_adj_tbl := oe_inbound_int.pl_to_sql3 (l_header_adj_tbl);
p_old_header_adj_tbl := oe_inbound_int.pl_to_sql3 (l_old_header_adj_tbl);
p_header_adj_val_tbl := oe_inbound_int.pl_to_sql4 (l_header_adj_val_tbl);
p_old_header_adj_val_tbl :=
oe_inbound_int.pl_to_sql4 (l_old_header_adj_val_tbl);
p_header_price_att_tbl :=
oe_inbound_int.pl_to_sql5 (l_header_price_att_tbl);
p_old_header_price_att_tbl :=
oe_inbound_int.pl_to_sql5 (l_old_header_price_att_tbl);
p_header_adj_att_tbl := oe_inbound_int.pl_to_sql6 (l_header_adj_att_tbl);
p_old_header_adj_att_tbl :=
oe_inbound_int.pl_to_sql6 (l_old_header_adj_att_tbl);
p_header_adj_assoc_tbl :=
oe_inbound_int.pl_to_sql7 (l_header_adj_assoc_tbl);
p_old_header_adj_assoc_tbl :=
oe_inbound_int.pl_to_sql7 (l_old_header_adj_assoc_tbl);
p_header_scredit_tbl := oe_inbound_int.pl_to_sql8 (l_header_scredit_tbl);
p_old_header_scredit_tbl :=
oe_inbound_int.pl_to_sql8 (l_old_header_scredit_tbl);
p_header_scredit_val_tbl :=
oe_inbound_int.pl_to_sql9 (l_header_scredit_val_tbl);
p_old_header_scredit_val_tbl :=
oe_inbound_int.pl_to_sql9 (l_old_header_scredit_val_tbl);
p_header_payment_tbl := oe_inbound_int.pl_to_sql10 (l_header_payment_tbl);
p_old_header_payment_tbl :=
oe_inbound_int.pl_to_sql10 (l_old_header_payment_tbl);
p_header_payment_val_tbl :=
oe_inbound_int.pl_to_sql11 (l_header_payment_val_tbl);
p_old_header_payment_val_tbl :=
oe_inbound_int.pl_to_sql11 (l_old_header_payment_val_tbl);
p_line_tbl := oe_inbound_int.pl_to_sql12 (l_line_tbl);
p_old_line_tbl := oe_inbound_int.pl_to_sql12 (l_old_line_tbl);
p_line_val_tbl := oe_inbound_int.pl_to_sql13 (l_line_val_tbl);
p_old_line_val_tbl := oe_inbound_int.pl_to_sql13 (l_old_line_val_tbl);
p_line_adj_tbl := oe_inbound_int.pl_to_sql14 (l_line_adj_tbl);
p_old_line_adj_tbl := oe_inbound_int.pl_to_sql14 (l_old_line_adj_tbl);
p_line_adj_val_tbl := oe_inbound_int.pl_to_sql15 (l_line_adj_val_tbl);
p_old_line_adj_val_tbl :=
oe_inbound_int.pl_to_sql15 (l_old_line_adj_val_tbl);
p_line_price_att_tbl := oe_inbound_int.pl_to_sql16 (l_line_price_att_tbl);
p_old_line_price_att_tbl :=
oe_inbound_int.pl_to_sql16 (l_old_line_price_att_tbl);
p_line_adj_att_tbl := oe_inbound_int.pl_to_sql17 (l_line_adj_att_tbl);
p_old_line_adj_att_tbl :=
oe_inbound_int.pl_to_sql17 (l_old_line_adj_att_tbl);
p_line_adj_assoc_tbl := oe_inbound_int.pl_to_sql18 (l_line_adj_assoc_tbl);
p_old_line_adj_assoc_tbl :=
oe_inbound_int.pl_to_sql18 (l_old_line_adj_assoc_tbl);
p_line_scredit_tbl := oe_inbound_int.pl_to_sql19 (l_line_scredit_tbl);
p_old_line_scredit_tbl :=
oe_inbound_int.pl_to_sql19 (l_old_line_scredit_tbl);
p_line_scredit_val_tbl :=
oe_inbound_int.pl_to_sql20 (l_line_scredit_val_tbl);
p_old_line_scredit_val_tbl :=
oe_inbound_int.pl_to_sql20 (l_old_line_scredit_val_tbl);
p_line_payment_tbl := oe_inbound_int.pl_to_sql21 (l_line_payment_tbl);
p_old_line_payment_tbl :=
oe_inbound_int.pl_to_sql21 (l_old_line_payment_tbl);
p_line_payment_val_tbl :=
oe_inbound_int.pl_to_sql22 (l_line_payment_val_tbl);
p_old_line_payment_val_tbl :=
oe_inbound_int.pl_to_sql22 (l_old_line_payment_val_tbl);
p_lot_serial_tbl := oe_inbound_int.pl_to_sql23 (l_lot_serial_tbl);
p_old_lot_serial_tbl := oe_inbound_int.pl_to_sql23 (l_old_lot_serial_tbl);
p_lot_serial_val_tbl := oe_inbound_int.pl_to_sql24 (l_lot_serial_val_tbl);
p_old_lot_serial_val_tbl :=
oe_inbound_int.pl_to_sql24 (l_old_lot_serial_val_tbl);
x_header_rec := oe_inbound_int.pl_to_sql1 (l_header_rec_miss);
x_header_val_rec := oe_inbound_int.pl_to_sql2 (l_header_val_rec);
x_header_adj_tbl := oe_inbound_int.pl_to_sql3 (l_header_adj_tbl);
x_header_adj_val_tbl := oe_inbound_int.pl_to_sql4 (l_header_adj_val_tbl);
x_header_price_att_tbl :=
oe_inbound_int.pl_to_sql5 (l_header_price_att_tbl);
x_header_adj_att_tbl := oe_inbound_int.pl_to_sql6 (l_header_adj_att_tbl);
x_header_adj_assoc_tbl :=
oe_inbound_int.pl_to_sql7 (l_header_adj_assoc_tbl);
x_header_scredit_tbl := oe_inbound_int.pl_to_sql8 (l_header_scredit_tbl);
x_header_scredit_val_tbl :=
oe_inbound_int.pl_to_sql9 (l_header_scredit_val_tbl);
x_header_payment_tbl := oe_inbound_int.pl_to_sql10 (l_header_payment_tbl);
x_header_payment_val_tbl :=
oe_inbound_int.pl_to_sql11 (l_header_payment_val_tbl);
x_line_tbl := oe_inbound_int.pl_to_sql12 (l_line_tbl_miss);
x_line_val_tbl := oe_inbound_int.pl_to_sql13 (l_line_val_tbl);
x_line_adj_tbl := oe_inbound_int.pl_to_sql14 (l_line_adj_tbl);
x_line_adj_val_tbl := oe_inbound_int.pl_to_sql15 (l_line_adj_val_tbl);
x_line_price_att_tbl := oe_inbound_int.pl_to_sql16 (l_line_price_att_tbl);
x_line_adj_att_tbl := oe_inbound_int.pl_to_sql17 (l_line_adj_att_tbl);
x_line_adj_assoc_tbl := oe_inbound_int.pl_to_sql18 (l_line_adj_assoc_tbl);
x_line_scredit_tbl := oe_inbound_int.pl_to_sql19 (l_line_scredit_tbl);
x_line_scredit_val_tbl :=
oe_inbound_int.pl_to_sql20 (l_line_scredit_val_tbl);
x_line_payment_tbl := oe_inbound_int.pl_to_sql21 (l_line_payment_tbl);
x_line_payment_val_tbl :=
oe_inbound_int.pl_to_sql22 (l_line_payment_val_tbl);
x_lot_serial_tbl := oe_inbound_int.pl_to_sql23 (l_lot_serial_tbl);
x_lot_serial_val_tbl := oe_inbound_int.pl_to_sql24 (l_lot_serial_val_tbl);
x_action_request_tbl :=
oe_inbound_int.pl_to_sql25 (l_action_request_tbl_miss);
p_action_request_tbl := oe_inbound_int.pl_to_sql25 (l_action_request_tbl);
oe_inbound_int.process_order (
p_api_version_number => 1.0,
p_init_msg_list => fnd_api.g_true,
p_return_values => fnd_api.g_true,
p_action_commit => fnd_api.g_false,
x_return_status => l_return_status,
x_messages => x_messages,
p_header_rec => p_header_rec,
p_old_header_rec => p_old_header_rec,
p_header_val_rec => p_header_val_rec,
p_old_header_val_rec => p_old_header_val_rec,
p_header_adj_tbl => p_header_adj_tbl,
p_old_header_adj_tbl => p_old_header_adj_tbl,
p_header_adj_val_tbl => p_header_adj_val_tbl,
p_old_header_adj_val_tbl => p_old_header_adj_val_tbl,
p_header_price_att_tbl => p_header_price_att_tbl,
p_old_header_price_att_tbl => p_old_header_price_att_tbl,
p_header_adj_att_tbl => p_header_adj_att_tbl,
p_old_header_adj_att_tbl => p_old_header_adj_att_tbl,
p_header_adj_assoc_tbl => p_header_adj_assoc_tbl,
p_old_header_adj_assoc_tbl => p_old_header_adj_assoc_tbl,
p_header_scredit_tbl => p_header_scredit_tbl,
p_old_header_scredit_tbl => p_old_header_scredit_tbl,
p_header_scredit_val_tbl => p_header_scredit_val_tbl,
p_old_header_scredit_val_tbl => p_old_header_scredit_val_tbl,
p_header_payment_tbl => p_header_payment_tbl,
p_old_header_payment_tbl => p_old_header_payment_tbl,
p_header_payment_val_tbl => p_header_payment_val_tbl,
p_old_header_payment_val_tbl => p_old_header_payment_val_tbl,
p_line_tbl => p_line_tbl,
p_old_line_tbl => p_old_line_tbl,
p_line_val_tbl => p_line_val_tbl,
p_old_line_val_tbl => p_old_line_val_tbl,
p_line_adj_tbl => p_line_adj_tbl,
p_old_line_adj_tbl => p_old_line_adj_tbl,
p_line_adj_val_tbl => p_line_adj_val_tbl,
p_old_line_adj_val_tbl => p_old_line_adj_val_tbl,
p_line_price_att_tbl => p_line_price_att_tbl,
p_old_line_price_att_tbl => p_old_line_price_att_tbl,
p_line_adj_att_tbl => p_line_adj_att_tbl,
p_old_line_adj_att_tbl => p_old_line_adj_att_tbl,
p_line_adj_assoc_tbl => p_line_adj_assoc_tbl,
p_old_line_adj_assoc_tbl => p_old_line_adj_assoc_tbl,
p_line_scredit_tbl => p_line_scredit_tbl,
p_old_line_scredit_tbl => p_old_line_scredit_tbl,
p_line_scredit_val_tbl => p_line_scredit_val_tbl,
p_old_line_scredit_val_tbl => p_old_line_scredit_val_tbl,
p_line_payment_tbl => p_line_payment_tbl,
p_old_line_payment_tbl => p_old_line_payment_tbl,
p_line_payment_val_tbl => p_line_payment_val_tbl,
p_old_line_payment_val_tbl => p_old_line_payment_val_tbl,
p_lot_serial_tbl => p_lot_serial_tbl,
p_old_lot_serial_tbl => p_old_lot_serial_tbl,
p_lot_serial_val_tbl => p_lot_serial_val_tbl,
p_old_lot_serial_val_tbl => p_old_lot_serial_val_tbl,
p_action_request_tbl => p_action_request_tbl,
x_header_rec => x_header_rec,
x_header_val_rec => x_header_val_rec,
x_header_adj_tbl => x_header_adj_tbl,
x_header_adj_val_tbl => x_header_adj_val_tbl,
x_header_price_att_tbl => x_header_price_att_tbl,
x_header_adj_att_tbl => x_header_adj_att_tbl,
x_header_adj_assoc_tbl => x_header_adj_assoc_tbl,
x_header_scredit_tbl => x_header_scredit_tbl,
x_header_scredit_val_tbl => x_header_scredit_val_tbl,
x_header_payment_tbl => x_header_payment_tbl,
x_header_payment_val_tbl => x_header_payment_val_tbl,
x_line_tbl => x_line_tbl,
x_line_val_tbl => x_line_val_tbl,
x_line_adj_tbl => x_line_adj_tbl,
x_line_adj_val_tbl => x_line_adj_val_tbl,
x_line_price_att_tbl => x_line_price_att_tbl,
x_line_adj_att_tbl => x_line_adj_att_tbl,
x_line_adj_assoc_tbl => x_line_adj_assoc_tbl,
x_line_scredit_tbl => x_line_scredit_tbl,
x_line_scredit_val_tbl => x_line_scredit_val_tbl,
x_line_payment_tbl => x_line_payment_tbl,
x_line_payment_val_tbl => x_line_payment_val_tbl,
x_lot_serial_tbl => x_lot_serial_tbl,
x_lot_serial_val_tbl => x_lot_serial_val_tbl,
x_action_request_tbl => x_action_request_tbl,
p_rtrim_data => 'n');
o_header_rec := oe_inbound_int.sql_to_pl1 (x_header_rec);
o_line_tbl := oe_inbound_int.sql_to_pl12 (x_line_tbl);
IF x_messages.COUNT > 0
THEN
FOR i IN 1 .. x_messages.COUNT
LOOP
msg_text := x_messages (i).MESSAGE_TEXT;
DBMS_OUTPUT.put_line ('message : ' || msg_text);
END LOOP;
END IF;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('error : ' || SQLERRM);
END;
DECLARE
l_session_id NUMBER;
l_user_id NUMBER := 0;
l_responsibility_id NUMBER := 21623;
l_login_id NUMBER := 2987330;
l_count NUMBER;
l_msg_count NUMBER := 0;
x_cnt NUMBER := 3;
l_return_status VARCHAR2 (1);
l_msg_data VARCHAR2 (2000);
x_msg_data VARCHAR2 (2000);
x_msg_details VARCHAR2 (2000);
x_msg_count VARCHAR2 (2000);
msg_text VARCHAR2 (2000);
l_header_rec oe_order_pub.header_rec_type;
l_header_rec_miss oe_order_pub.header_rec_type;
l_header_val_rec oe_order_pub.header_val_rec_type;
l_header_adj_tbl oe_order_pub.header_adj_tbl_type;
l_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
l_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
l_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
l_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
l_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
l_header_scredit_val_tbl oe_order_pub.header_scredit_val_tbl_type;
l_header_payment_tbl oe_order_pub.header_payment_tbl_type;
l_header_payment_val_tbl oe_order_pub.header_payment_val_tbl_type;
l_old_header_rec oe_order_pub.header_rec_type;
l_old_header_val_rec oe_order_pub.header_val_rec_type;
l_old_header_adj_tbl oe_order_pub.header_adj_tbl_type;
l_old_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
l_old_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
l_old_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
l_old_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
l_old_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
l_old_header_scredit_val_tbl oe_order_pub.header_scredit_val_tbl_type;
l_old_header_payment_tbl oe_order_pub.header_payment_tbl_type;
l_old_header_payment_val_tbl oe_order_pub.header_payment_val_tbl_type;
l_line_tbl oe_order_pub.line_tbl_type;
l_line_tbl_miss oe_order_pub.line_tbl_type;
l_line_val_tbl oe_order_pub.line_val_tbl_type;
l_line_adj_tbl oe_order_pub.line_adj_tbl_type;
l_line_adj_val_tbl oe_order_pub.line_adj_val_tbl_type;
l_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
l_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
l_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
l_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
l_line_scredit_val_tbl oe_order_pub.line_scredit_val_tbl_type;
l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
l_lot_serial_val_tbl oe_order_pub.lot_serial_val_tbl_type;
l_line_payment_tbl oe_order_pub.line_payment_tbl_type;
l_line_payment_val_tbl oe_order_pub.line_payment_val_tbl_type;
l_old_line_tbl oe_order_pub.line_tbl_type;
l_old_line_val_tbl oe_order_pub.line_val_tbl_type;
l_old_line_adj_tbl oe_order_pub.line_adj_tbl_type;
l_old_line_adj_val_tbl oe_order_pub.line_adj_val_tbl_type;
l_old_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
l_old_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
l_old_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
l_old_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
l_old_line_scredit_val_tbl oe_order_pub.line_scredit_val_tbl_type;
l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
l_old_lot_serial_val_tbl oe_order_pub.lot_serial_val_tbl_type;
l_old_line_payment_tbl oe_order_pub.line_payment_tbl_type;
l_old_line_payment_val_tbl oe_order_pub.line_payment_val_tbl_type;
l_action_request_tbl oe_order_pub.request_tbl_type;
l_action_request_tbl_miss oe_order_pub.request_tbl_type;
o_header_rec oe_order_pub.header_rec_type;
o_header_val_rec oe_order_pub.header_val_rec_type;
o_header_adj_tbl oe_order_pub.header_adj_tbl_type;
o_header_adj_val_tbl oe_order_pub.header_adj_val_tbl_type;
o_header_price_att_tbl oe_order_pub.header_price_att_tbl_type;
o_header_adj_att_tbl oe_order_pub.header_adj_att_tbl_type;
o_header_adj_assoc_tbl oe_order_pub.header_adj_assoc_tbl_type;
o_header_scredit_tbl oe_order_pub.header_scredit_tbl_type;
o_header_scredit_val_tbl oe_order_pub.header_scredit_val_tbl_type;
o_line_tbl oe_order_pub.line_tbl_type;
o_line_val_tbl oe_order_pub.line_val_tbl_type;
o_line_adj_tbl oe_order_pub.line_adj_tbl_type;
o_line_adj_val_tbl oe_order_pub.line_adj_val_tbl_type;
o_line_price_att_tbl oe_order_pub.line_price_att_tbl_type;
o_line_adj_att_tbl oe_order_pub.line_adj_att_tbl_type;
o_line_adj_assoc_tbl oe_order_pub.line_adj_assoc_tbl_type;
o_line_scredit_tbl oe_order_pub.line_scredit_tbl_type;
o_line_scredit_val_tbl oe_order_pub.line_scredit_val_tbl_type;
o_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
o_lot_serial_val_tbl oe_order_pub.lot_serial_val_tbl_type;
o_action_request_tbl oe_order_pub.request_tbl_type;
x_messages oe_message_obj_t := oe_message_obj_t ();
p_header_rec oe_order_pub_header_rec_type;
p_old_header_rec oe_order_pub_header_rec_type;
p_header_val_rec oe_order_pub_header_val_rec_t;
p_old_header_val_rec oe_order_pub_header_val_rec_t;
p_header_adj_tbl oe_order_pub_header_adj_tbl_t;
p_old_header_adj_tbl oe_order_pub_header_adj_tbl_t;
p_header_adj_val_tbl oe_order_pub_header_adj_val_t;
p_old_header_adj_val_tbl oe_order_pub_header_adj_val_t;
p_header_price_att_tbl oe_order_pub_header_price_att;
p_old_header_price_att_tbl oe_order_pub_header_price_att;
p_header_adj_att_tbl oe_order_pub_header_adj_att_t;
p_old_header_adj_att_tbl oe_order_pub_header_adj_att_t;
p_header_adj_assoc_tbl oe_order_pub_header_adj_assoc;
p_old_header_adj_assoc_tbl oe_order_pub_header_adj_assoc;
p_header_scredit_tbl oe_order_pub_header_scredit_t;
p_old_header_scredit_tbl oe_order_pub_header_scredit_t;
p_header_scredit_val_tbl oe_order_pub_header_scredit_v;
p_old_header_scredit_val_tbl oe_order_pub_header_scredit_v;
p_header_payment_tbl oe_order_pub_header_payment_t;
p_old_header_payment_tbl oe_order_pub_header_payment_t;
p_header_payment_val_tbl oe_order_pub_header_payment_v;
p_old_header_payment_val_tbl oe_order_pub_header_payment_v;
p_line_tbl oe_order_pub_line_tbl_type;
p_old_line_tbl oe_order_pub_line_tbl_type;
p_line_val_tbl oe_order_pub_line_val_tbl_typ;
p_old_line_val_tbl oe_order_pub_line_val_tbl_typ;
p_line_adj_tbl oe_order_pub_line_adj_tbl_typ;
p_old_line_adj_tbl oe_order_pub_line_adj_tbl_typ;
p_line_adj_val_tbl oe_order_pub_line_adj_val_tbl;
p_old_line_adj_val_tbl oe_order_pub_line_adj_val_tbl;
p_line_price_att_tbl oe_order_pub_line_price_att_t;
p_old_line_price_att_tbl oe_order_pub_line_price_att_t;
p_line_adj_att_tbl oe_order_pub_line_adj_att_tbl;
p_old_line_adj_att_tbl oe_order_pub_line_adj_att_tbl;
p_line_adj_assoc_tbl oe_order_pub_line_adj_assoc_t;
p_old_line_adj_assoc_tbl oe_order_pub_line_adj_assoc_t;
p_line_scredit_tbl oe_order_pub_line_scredit_tbl;
p_old_line_scredit_tbl oe_order_pub_line_scredit_tbl;
p_line_scredit_val_tbl oe_order_pub_line_scredit_val;
p_old_line_scredit_val_tbl oe_order_pub_line_scredit_val;
p_line_payment_tbl oe_order_pub_line_payment_tbl;
p_old_line_payment_tbl oe_order_pub_line_payment_tbl;
p_line_payment_val_tbl oe_order_pub_line_payment_val;
p_old_line_payment_val_tbl oe_order_pub_line_payment_val;
p_lot_serial_tbl oe_order_pub_lot_serial_tbl_t;
p_old_lot_serial_tbl oe_order_pub_lot_serial_tbl_t;
p_lot_serial_val_tbl oe_order_pub_lot_serial_val_t;
p_old_lot_serial_val_tbl oe_order_pub_lot_serial_val_t;
p_action_request_tbl oe_order_pub_request_tbl_type;
x_header_rec oe_order_pub_header_rec_type;
x_header_val_rec oe_order_pub_header_val_rec_t;
x_header_adj_tbl oe_order_pub_header_adj_tbl_t;
x_header_adj_val_tbl oe_order_pub_header_adj_val_t;
x_header_price_att_tbl oe_order_pub_header_price_att;
x_header_adj_att_tbl oe_order_pub_header_adj_att_t;
x_header_adj_assoc_tbl oe_order_pub_header_adj_assoc;
x_header_scredit_tbl oe_order_pub_header_scredit_t;
x_header_scredit_val_tbl oe_order_pub_header_scredit_v;
x_line_tbl oe_order_pub_line_tbl_type;
x_line_val_tbl oe_order_pub_line_val_tbl_typ;
x_line_adj_tbl oe_order_pub_line_adj_tbl_typ;
x_line_adj_val_tbl oe_order_pub_line_adj_val_tbl;
x_line_price_att_tbl oe_order_pub_line_price_att_t;
x_line_adj_att_tbl oe_order_pub_line_adj_att_tbl;
x_line_adj_assoc_tbl oe_order_pub_line_adj_assoc_t;
x_line_scredit_tbl oe_order_pub_line_scredit_tbl;
x_line_scredit_val_tbl oe_order_pub_line_scredit_val;
x_lot_serial_tbl oe_order_pub_lot_serial_tbl_t;
x_lot_serial_val_tbl oe_order_pub_lot_serial_val_t;
x_action_request_tbl oe_order_pub_request_tbl_type;
x_header_payment_tbl oe_order_pub_header_payment_t;
x_header_payment_val_tbl oe_order_pub_header_payment_v;
x_line_payment_tbl oe_order_pub_line_payment_tbl;
x_line_payment_val_tbl oe_order_pub_line_payment_val;
l_payment_term_id NUMBER;
l_line_type_id NUMBER;
-- degug_file_name
dbg_file VARCHAR2 (1024);
BEGIN
oe_debug_pub.initialize;
oe_debug_pub.debug_on;
oe_debug_pub.setdebuglevel (5);
dbg_file := oe_debug_pub.set_debug_mode ('file');
DBMS_OUTPUT.put_line (
'the debug file is : '
|| oe_debug_pub.g_dir
|| '/'
|| oe_debug_pub.g_file);
fnd_global.initialize (session_id => l_session_id,
user_id => l_user_id,
resp_id => l_responsibility_id,
resp_appl_id => 660,
security_group_id => 0,
site_id => NULL,
login_id => l_login_id,
conc_login_id => NULL,
prog_appl_id => NULL,
conc_program_id => NULL,
conc_request_id => NULL,
conc_priority_request => NULL);
oe_msg_pub.initialize;
l_action_request_tbl (1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
l_action_request_tbl (1).request_type := OE_GLOBALS.G_BOOK_ORDER;
l_action_request_tbl (1).Entity_id := 10004765;
--==================================================================================================
-- calling process order api
--==================================================================================================
DBMS_OUTPUT.put_line ('calling process order.....');
p_header_rec := oe_inbound_int.pl_to_sql1 (l_header_rec);
p_old_header_rec := oe_inbound_int.pl_to_sql1 (l_old_header_rec);
p_header_val_rec := oe_inbound_int.pl_to_sql2 (l_header_val_rec);
p_old_header_val_rec := oe_inbound_int.pl_to_sql2 (l_old_header_val_rec);
p_header_adj_tbl := oe_inbound_int.pl_to_sql3 (l_header_adj_tbl);
p_old_header_adj_tbl := oe_inbound_int.pl_to_sql3 (l_old_header_adj_tbl);
p_header_adj_val_tbl := oe_inbound_int.pl_to_sql4 (l_header_adj_val_tbl);
p_old_header_adj_val_tbl :=
oe_inbound_int.pl_to_sql4 (l_old_header_adj_val_tbl);
p_header_price_att_tbl :=
oe_inbound_int.pl_to_sql5 (l_header_price_att_tbl);
p_old_header_price_att_tbl :=
oe_inbound_int.pl_to_sql5 (l_old_header_price_att_tbl);
p_header_adj_att_tbl := oe_inbound_int.pl_to_sql6 (l_header_adj_att_tbl);
p_old_header_adj_att_tbl :=
oe_inbound_int.pl_to_sql6 (l_old_header_adj_att_tbl);
p_header_adj_assoc_tbl :=
oe_inbound_int.pl_to_sql7 (l_header_adj_assoc_tbl);
p_old_header_adj_assoc_tbl :=
oe_inbound_int.pl_to_sql7 (l_old_header_adj_assoc_tbl);
p_header_scredit_tbl := oe_inbound_int.pl_to_sql8 (l_header_scredit_tbl);
p_old_header_scredit_tbl :=
oe_inbound_int.pl_to_sql8 (l_old_header_scredit_tbl);
p_header_scredit_val_tbl :=
oe_inbound_int.pl_to_sql9 (l_header_scredit_val_tbl);
p_old_header_scredit_val_tbl :=
oe_inbound_int.pl_to_sql9 (l_old_header_scredit_val_tbl);
p_header_payment_tbl := oe_inbound_int.pl_to_sql10 (l_header_payment_tbl);
p_old_header_payment_tbl :=
oe_inbound_int.pl_to_sql10 (l_old_header_payment_tbl);
p_header_payment_val_tbl :=
oe_inbound_int.pl_to_sql11 (l_header_payment_val_tbl);
p_old_header_payment_val_tbl :=
oe_inbound_int.pl_to_sql11 (l_old_header_payment_val_tbl);
p_line_tbl := oe_inbound_int.pl_to_sql12 (l_line_tbl);
p_old_line_tbl := oe_inbound_int.pl_to_sql12 (l_old_line_tbl);
p_line_val_tbl := oe_inbound_int.pl_to_sql13 (l_line_val_tbl);
p_old_line_val_tbl := oe_inbound_int.pl_to_sql13 (l_old_line_val_tbl);
p_line_adj_tbl := oe_inbound_int.pl_to_sql14 (l_line_adj_tbl);
p_old_line_adj_tbl := oe_inbound_int.pl_to_sql14 (l_old_line_adj_tbl);
p_line_adj_val_tbl := oe_inbound_int.pl_to_sql15 (l_line_adj_val_tbl);
p_old_line_adj_val_tbl :=
oe_inbound_int.pl_to_sql15 (l_old_line_adj_val_tbl);
p_line_price_att_tbl := oe_inbound_int.pl_to_sql16 (l_line_price_att_tbl);
p_old_line_price_att_tbl :=
oe_inbound_int.pl_to_sql16 (l_old_line_price_att_tbl);
p_line_adj_att_tbl := oe_inbound_int.pl_to_sql17 (l_line_adj_att_tbl);
p_old_line_adj_att_tbl :=
oe_inbound_int.pl_to_sql17 (l_old_line_adj_att_tbl);
p_line_adj_assoc_tbl := oe_inbound_int.pl_to_sql18 (l_line_adj_assoc_tbl);
p_old_line_adj_assoc_tbl :=
oe_inbound_int.pl_to_sql18 (l_old_line_adj_assoc_tbl);
p_line_scredit_tbl := oe_inbound_int.pl_to_sql19 (l_line_scredit_tbl);
p_old_line_scredit_tbl :=
oe_inbound_int.pl_to_sql19 (l_old_line_scredit_tbl);
p_line_scredit_val_tbl :=
oe_inbound_int.pl_to_sql20 (l_line_scredit_val_tbl);
p_old_line_scredit_val_tbl :=
oe_inbound_int.pl_to_sql20 (l_old_line_scredit_val_tbl);
p_line_payment_tbl := oe_inbound_int.pl_to_sql21 (l_line_payment_tbl);
p_old_line_payment_tbl :=
oe_inbound_int.pl_to_sql21 (l_old_line_payment_tbl);
p_line_payment_val_tbl :=
oe_inbound_int.pl_to_sql22 (l_line_payment_val_tbl);
p_old_line_payment_val_tbl :=
oe_inbound_int.pl_to_sql22 (l_old_line_payment_val_tbl);
p_lot_serial_tbl := oe_inbound_int.pl_to_sql23 (l_lot_serial_tbl);
p_old_lot_serial_tbl := oe_inbound_int.pl_to_sql23 (l_old_lot_serial_tbl);
p_lot_serial_val_tbl := oe_inbound_int.pl_to_sql24 (l_lot_serial_val_tbl);
p_old_lot_serial_val_tbl :=
oe_inbound_int.pl_to_sql24 (l_old_lot_serial_val_tbl);
x_header_rec := oe_inbound_int.pl_to_sql1 (l_header_rec_miss);
x_header_val_rec := oe_inbound_int.pl_to_sql2 (l_header_val_rec);
x_header_adj_tbl := oe_inbound_int.pl_to_sql3 (l_header_adj_tbl);
x_header_adj_val_tbl := oe_inbound_int.pl_to_sql4 (l_header_adj_val_tbl);
x_header_price_att_tbl :=
oe_inbound_int.pl_to_sql5 (l_header_price_att_tbl);
x_header_adj_att_tbl := oe_inbound_int.pl_to_sql6 (l_header_adj_att_tbl);
x_header_adj_assoc_tbl :=
oe_inbound_int.pl_to_sql7 (l_header_adj_assoc_tbl);
x_header_scredit_tbl := oe_inbound_int.pl_to_sql8 (l_header_scredit_tbl);
x_header_scredit_val_tbl :=
oe_inbound_int.pl_to_sql9 (l_header_scredit_val_tbl);
x_header_payment_tbl := oe_inbound_int.pl_to_sql10 (l_header_payment_tbl);
x_header_payment_val_tbl :=
oe_inbound_int.pl_to_sql11 (l_header_payment_val_tbl);
x_line_tbl := oe_inbound_int.pl_to_sql12 (l_line_tbl_miss);
x_line_val_tbl := oe_inbound_int.pl_to_sql13 (l_line_val_tbl);
x_line_adj_tbl := oe_inbound_int.pl_to_sql14 (l_line_adj_tbl);
x_line_adj_val_tbl := oe_inbound_int.pl_to_sql15 (l_line_adj_val_tbl);
x_line_price_att_tbl := oe_inbound_int.pl_to_sql16 (l_line_price_att_tbl);
x_line_adj_att_tbl := oe_inbound_int.pl_to_sql17 (l_line_adj_att_tbl);
x_line_adj_assoc_tbl := oe_inbound_int.pl_to_sql18 (l_line_adj_assoc_tbl);
x_line_scredit_tbl := oe_inbound_int.pl_to_sql19 (l_line_scredit_tbl);
x_line_scredit_val_tbl :=
oe_inbound_int.pl_to_sql20 (l_line_scredit_val_tbl);
x_line_payment_tbl := oe_inbound_int.pl_to_sql21 (l_line_payment_tbl);
x_line_payment_val_tbl :=
oe_inbound_int.pl_to_sql22 (l_line_payment_val_tbl);
x_lot_serial_tbl := oe_inbound_int.pl_to_sql23 (l_lot_serial_tbl);
x_lot_serial_val_tbl := oe_inbound_int.pl_to_sql24 (l_lot_serial_val_tbl);
x_action_request_tbl :=
oe_inbound_int.pl_to_sql25 (l_action_request_tbl_miss);
p_action_request_tbl := oe_inbound_int.pl_to_sql25 (l_action_request_tbl);
oe_inbound_int.process_order (
p_api_version_number => 1.0,
p_init_msg_list => fnd_api.g_true,
p_return_values => fnd_api.g_true,
p_action_commit => fnd_api.g_false,
x_return_status => l_return_status,
x_messages => x_messages,
p_header_rec => p_header_rec,
p_old_header_rec => p_old_header_rec,
p_header_val_rec => p_header_val_rec,
p_old_header_val_rec => p_old_header_val_rec,
p_header_adj_tbl => p_header_adj_tbl,
p_old_header_adj_tbl => p_old_header_adj_tbl,
p_header_adj_val_tbl => p_header_adj_val_tbl,
p_old_header_adj_val_tbl => p_old_header_adj_val_tbl,
p_header_price_att_tbl => p_header_price_att_tbl,
p_old_header_price_att_tbl => p_old_header_price_att_tbl,
p_header_adj_att_tbl => p_header_adj_att_tbl,
p_old_header_adj_att_tbl => p_old_header_adj_att_tbl,
p_header_adj_assoc_tbl => p_header_adj_assoc_tbl,
p_old_header_adj_assoc_tbl => p_old_header_adj_assoc_tbl,
p_header_scredit_tbl => p_header_scredit_tbl,
p_old_header_scredit_tbl => p_old_header_scredit_tbl,
p_header_scredit_val_tbl => p_header_scredit_val_tbl,
p_old_header_scredit_val_tbl => p_old_header_scredit_val_tbl,
p_header_payment_tbl => p_header_payment_tbl,
p_old_header_payment_tbl => p_old_header_payment_tbl,
p_header_payment_val_tbl => p_header_payment_val_tbl,
p_old_header_payment_val_tbl => p_old_header_payment_val_tbl,
p_line_tbl => p_line_tbl,
p_old_line_tbl => p_old_line_tbl,
p_line_val_tbl => p_line_val_tbl,
p_old_line_val_tbl => p_old_line_val_tbl,
p_line_adj_tbl => p_line_adj_tbl,
p_old_line_adj_tbl => p_old_line_adj_tbl,
p_line_adj_val_tbl => p_line_adj_val_tbl,
p_old_line_adj_val_tbl => p_old_line_adj_val_tbl,
p_line_price_att_tbl => p_line_price_att_tbl,
p_old_line_price_att_tbl => p_old_line_price_att_tbl,
p_line_adj_att_tbl => p_line_adj_att_tbl,
p_old_line_adj_att_tbl => p_old_line_adj_att_tbl,
p_line_adj_assoc_tbl => p_line_adj_assoc_tbl,
p_old_line_adj_assoc_tbl => p_old_line_adj_assoc_tbl,
p_line_scredit_tbl => p_line_scredit_tbl,
p_old_line_scredit_tbl => p_old_line_scredit_tbl,
p_line_scredit_val_tbl => p_line_scredit_val_tbl,
p_old_line_scredit_val_tbl => p_old_line_scredit_val_tbl,
p_line_payment_tbl => p_line_payment_tbl,
p_old_line_payment_tbl => p_old_line_payment_tbl,
p_line_payment_val_tbl => p_line_payment_val_tbl,
p_old_line_payment_val_tbl => p_old_line_payment_val_tbl,
p_lot_serial_tbl => p_lot_serial_tbl,
p_old_lot_serial_tbl => p_old_lot_serial_tbl,
p_lot_serial_val_tbl => p_lot_serial_val_tbl,
p_old_lot_serial_val_tbl => p_old_lot_serial_val_tbl,
p_action_request_tbl => p_action_request_tbl,
x_header_rec => x_header_rec,
x_header_val_rec => x_header_val_rec,
x_header_adj_tbl => x_header_adj_tbl,
x_header_adj_val_tbl => x_header_adj_val_tbl,
x_header_price_att_tbl => x_header_price_att_tbl,
x_header_adj_att_tbl => x_header_adj_att_tbl,
x_header_adj_assoc_tbl => x_header_adj_assoc_tbl,
x_header_scredit_tbl => x_header_scredit_tbl,
x_header_scredit_val_tbl => x_header_scredit_val_tbl,
x_header_payment_tbl => x_header_payment_tbl,
x_header_payment_val_tbl => x_header_payment_val_tbl,
x_line_tbl => x_line_tbl,
x_line_val_tbl => x_line_val_tbl,
x_line_adj_tbl => x_line_adj_tbl,
x_line_adj_val_tbl => x_line_adj_val_tbl,
x_line_price_att_tbl => x_line_price_att_tbl,
x_line_adj_att_tbl => x_line_adj_att_tbl,
x_line_adj_assoc_tbl => x_line_adj_assoc_tbl,
x_line_scredit_tbl => x_line_scredit_tbl,
x_line_scredit_val_tbl => x_line_scredit_val_tbl,
x_line_payment_tbl => x_line_payment_tbl,
x_line_payment_val_tbl => x_line_payment_val_tbl,
x_lot_serial_tbl => x_lot_serial_tbl,
x_lot_serial_val_tbl => x_lot_serial_val_tbl,
x_action_request_tbl => x_action_request_tbl,
p_rtrim_data => 'n');
o_header_rec := oe_inbound_int.sql_to_pl1 (x_header_rec);
o_line_tbl := oe_inbound_int.sql_to_pl12 (x_line_tbl);
IF x_messages.COUNT > 0
THEN
FOR i IN 1 .. x_messages.COUNT
LOOP
msg_text := x_messages (i).MESSAGE_TEXT;
DBMS_OUTPUT.put_line ('message : ' || msg_text);
END LOOP;
END IF;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('error : ' || SQLERRM);
END;
No comments:
Post a Comment