390: l_num_delivery_id_tab DBMS_SQL.Number_Table;
391: l_varchar_delivery_name_tab DBMS_SQL.Varchar2_Table;
392:
393: --AJPRABHA for inserting DATA into Transactions History.
394: l_tranx_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
395: x_txns_id NUMBER;
396: l_rec_found NUMBER DEFAULT 0;
397: l_request_control_id_s NUMBER;
398:
792:
793: SELECT WSH_DOCUMENT_NUMBER_S.NEXTVAL
794: INTO l_tranx_history_rec.document_number FROM DUAL;
795:
796: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History(
797: l_tranx_history_rec,
798: x_txns_id,
799: x_return_status
800: );