APPS.WSH_ITM_EXPORT_SCREENING dependencies on WSH_TRANSACTIONS_HISTORY

Line 407: l_tranx_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;

403: l_num_delivery_id_tab DBMS_SQL.Number_Table;
404: l_varchar_delivery_name_tab DBMS_SQL.Varchar2_Table;
405:
406: --AJPRABHA for inserting DATA into Transactions History.
407: l_tranx_history_rec WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
408: x_txns_id NUMBER;
409: l_rec_found NUMBER DEFAULT 0;
410: l_request_control_id_s NUMBER;
411:

Line 774: FROM WSH_TRANSACTIONS_HISTORY

770: --Checking if record Exists for this delivery in
771: -- Transactions Hsitory Table
772: BEGIN
773: SELECT 1 INTO l_rec_found
774: FROM WSH_TRANSACTIONS_HISTORY
775: WHERE DOCUMENT_TYPE = 'SS' AND
776: ENTITY_NUMBER = l_varchar_delivery_name_tab(k);
777:
778: EXCEPTION

Line 809: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History(

805:
806: SELECT WSH_DOCUMENT_NUMBER_S.NEXTVAL
807: INTO l_tranx_history_rec.document_number FROM DUAL;
808:
809: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History(
810: l_tranx_history_rec,
811: x_txns_id,
812: x_return_status
813: );