APPS.WSH_ITM_EXPORT_SCREENING dependencies on WSH_TRANSACTIONS_HISTORY

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 761: FROM WSH_TRANSACTIONS_HISTORY

757: --Checking if record Exists for this delivery in
758: -- Transactions Hsitory Table
759: BEGIN
760: SELECT 1 INTO l_rec_found
761: FROM WSH_TRANSACTIONS_HISTORY
762: WHERE DOCUMENT_TYPE = 'SS' AND
763: ENTITY_NUMBER = l_varchar_delivery_name_tab(k);
764:
765: EXCEPTION

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