APPS.WSH_MBOLS_PVT dependencies on WSH_DOCUMENT_INSTANCES

Line 35: FROM wsh_document_instances

31: trip_id = l_trip_id;
32:
33: CURSOR c_get_seq_num (l_trip_id NUMBER) IS
34: SELECT sequence_number
35: FROM wsh_document_instances
36: WHERE entity_name = 'WSH_TRIPS'
37: AND entity_id = l_trip_id
38: AND status <> 'CANCELLED';
39:

Line 42: l_document_number WSH_DOCUMENT_INSTANCES.SEQUENCE_NUMBER%TYPE;

38: AND status <> 'CANCELLED';
39:
40: l_trip_name WSH_TRIPS.NAME%TYPE;
41: l_freight_code WSH_CARRIERS.FREIGHT_CODE%TYPE;
42: l_document_number WSH_DOCUMENT_INSTANCES.SEQUENCE_NUMBER%TYPE;
43: l_ledger_id NUMBER; -- LE Uptake
44: l_msg_count NUMBER;
45: l_msg_data VARCHAR2(2000);
46: l_return_status VARCHAR2(1);

Line 323: FROM wsh_document_instances

319: EXIT WHEN c_get_delivery_info%NOTFOUND;
320:
321: SELECT count(*)
322: INTO l_bol_count
323: FROM wsh_document_instances
324: WHERE entity_name = 'WSH_DELIVERY_LEGS'
325: AND entity_id = l_delivery_leg_id
326: AND status <> 'CANCELLED';
327:

Line 846: from wsh_document_instances

842: IS
843: --
844: cursor mbol_num_cur (p_trip_id number) is
845: select document_instance_id
846: from wsh_document_instances
847: where entity_id = p_trip_id
848: AND document_type = 'MBOL'
849: AND status in ('OPEN', 'PLANNED');
850:

Line 908: from wsh_document_instances

904:
905: FOR i IN l_mbol_num_tab.FIRST..l_mbol_num_tab.LAST
906: LOOP
907: select 1 into l_tmp
908: from wsh_document_instances
909: where document_instance_id = l_mbol_num_tab(i).document_instance_id
910: FOR UPDATE NOWAIT;
911: END LOOP;
912: