DBA Data[Home] [Help]

APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on WSH_OTM_ENTITY_REC_TYPE

Line 233: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,

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

Line 615: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,

611: END EXTRACT_DLVY_INFO;
612:
613: PROCEDURE EXTRACT_TRIP_INFO
614: (
615: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,
616: p_transmission_id IN NUMBER,
617: x_return_status OUT NOCOPY VARCHAR2
618: )
619: IS

Line 622: l_entity_rec WSH_OTM_ENTITY_REC_TYPE := WSH_OTM_ENTITY_REC_TYPE(NULL,NULL,NULL,NULL,WSH_OTM_RD_NUM_TBL_TYPE(),

618: )
619: IS
620: --{
621: -- Local Variables
622: l_entity_rec WSH_OTM_ENTITY_REC_TYPE := WSH_OTM_ENTITY_REC_TYPE(NULL,NULL,NULL,NULL,WSH_OTM_RD_NUM_TBL_TYPE(),
623: WSH_OTM_RD_NUM_TBL_TYPE());
624: l_return_status VARCHAR2(1);
625: l_num_errors NUMBER := 0;
626: l_num_warnings NUMBER := 0;

Line 846: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,

842: END EXTRACT_TRIP_INFO;
843:
844: PROCEDURE EXTRACT_CARRIER_INFO
845: (
846: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,
847: p_transmission_id IN NUMBER,
848: x_return_status OUT NOCOPY VARCHAR2
849: )
850: IS

Line 990: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,

986:
987: --- wms-otm-proj
988: PROCEDURE EXTRACT_ORG_INFO
989: (
990: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,
991: p_transmission_id IN NUMBER,
992: x_return_status OUT NOCOPY VARCHAR2
993: )
994: IS

Line 2567: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,

2563: END EXTRACT_LOCATION_INFO;
2564:
2565: PROCEDURE SEND_LOCATIONS
2566: (
2567: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,
2568: x_loc_xmission_rec OUT NOCOPY WSH_OTM_LOC_XMISSION_REC_TYPE,
2569: x_transmission_id OUT NOCOPY NUMBER,
2570: x_return_status OUT NOCOPY VARCHAR2,
2571: x_msg_data OUT NOCOPY VARCHAR2

Line 2585: l_entity_rec WSH_OTM_ENTITY_REC_TYPE := WSH_OTM_ENTITY_REC_TYPE(NULL,NULL,NULL,NULL,WSH_OTM_RD_NUM_TBL_TYPE(),

2581: l_tkt_valid VARCHAR2(1);
2582: l_msg_count NUMBER;
2583:
2584: l_transmission_id NUMBER;
2585: l_entity_rec WSH_OTM_ENTITY_REC_TYPE := WSH_OTM_ENTITY_REC_TYPE(NULL,NULL,NULL,NULL,WSH_OTM_RD_NUM_TBL_TYPE(),
2586: WSH_OTM_RD_NUM_TBL_TYPE());
2587: l_in_rec IN_REC_TYPE;
2588:
2589: -- cursors