229: END GET_STOP_CORP_ID;
230:
231: PROCEDURE EXTRACT_DLVY_INFO
232: (
233: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,
234: p_transmission_id IN NUMBER,
235: x_return_status OUT NOCOPY VARCHAR2
236: )
237: IS
650: END EXTRACT_DLVY_INFO;
651:
652: PROCEDURE EXTRACT_TRIP_INFO
653: (
654: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,
655: p_transmission_id IN NUMBER,
656: x_return_status OUT NOCOPY VARCHAR2
657: )
658: IS
657: )
658: IS
659: --{
660: -- Local Variables
661: l_entity_rec WSH_OTM_ENTITY_REC_TYPE := WSH_OTM_ENTITY_REC_TYPE(NULL,NULL,NULL,NULL,WSH_OTM_RD_NUM_TBL_TYPE(),
662: WSH_OTM_RD_NUM_TBL_TYPE());
663: l_return_status VARCHAR2(1);
664: l_num_errors NUMBER := 0;
665: l_num_warnings NUMBER := 0;
881: END EXTRACT_TRIP_INFO;
882:
883: PROCEDURE EXTRACT_CARRIER_INFO
884: (
885: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,
886: p_transmission_id IN NUMBER,
887: x_return_status OUT NOCOPY VARCHAR2
888: )
889: IS
1025:
1026: --- wms-otm-proj
1027: PROCEDURE EXTRACT_ORG_INFO
1028: (
1029: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,
1030: p_transmission_id IN NUMBER,
1031: x_return_status OUT NOCOPY VARCHAR2
1032: )
1033: IS
2602: END EXTRACT_LOCATION_INFO;
2603:
2604: PROCEDURE SEND_LOCATIONS
2605: (
2606: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,
2607: x_loc_xmission_rec OUT NOCOPY WSH_OTM_LOC_XMISSION_REC_TYPE,
2608: x_transmission_id OUT NOCOPY NUMBER,
2609: x_return_status OUT NOCOPY VARCHAR2,
2610: x_msg_data OUT NOCOPY VARCHAR2
2620: l_tkt_valid VARCHAR2(1);
2621: l_msg_count NUMBER;
2622:
2623: l_transmission_id NUMBER;
2624: l_entity_rec WSH_OTM_ENTITY_REC_TYPE := WSH_OTM_ENTITY_REC_TYPE(NULL,NULL,NULL,NULL,WSH_OTM_RD_NUM_TBL_TYPE(),
2625: WSH_OTM_RD_NUM_TBL_TYPE());
2626: l_in_rec IN_REC_TYPE;
2627:
2628: -- cursors