DBA Data[Home] [Help]

APPS.WSH_ITM_EXPORT_SCREENING dependencies on WSH_TRANSACTIONS_HISTORY_PKG

Line 394: l_tranx_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

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:

Line 796: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History(

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: );