INV_LABEL_PUB.print_label-For p_transaction_id what value to pass to insert into Label History tabl
Dear Experts
Application # R12.2.7
DB # Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
Could anyone please let me know, whether you have any idea what parameter value we have pass for transaction_id to create Label(material)/record through this API in wms_label_requests_hist table.
INV_LABEL_PUB.print_label
================================================
set serveroutput on
declare
l_return_status varchar2(1);
l_msg_count NUMBER;
l_msg_data VARCHAR2(4000);
l_label_status VARCHAR2(100);
p_txn_id INV_LABEL_PUB.transaction_id_rec_type ;
begin
p_txn_id(1) := 0 ; -- transaction_id
dbms_output.put_line ('Calling API INV_LABEL_PUB.print_label') ;
Application # R12.2.7
DB # Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
Could anyone please let me know, whether you have any idea what parameter value we have pass for transaction_id to create Label(material)/record through this API in wms_label_requests_hist table.
INV_LABEL_PUB.print_label
================================================
set serveroutput on
declare
l_return_status varchar2(1);
l_msg_count NUMBER;
l_msg_data VARCHAR2(4000);
l_label_status VARCHAR2(100);
p_txn_id INV_LABEL_PUB.transaction_id_rec_type ;
begin
p_txn_id(1) := 0 ; -- transaction_id
dbms_output.put_line ('Calling API INV_LABEL_PUB.print_label') ;
0