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 654: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,

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

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

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;

Line 885: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,

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

Line 1029: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,

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

Line 2606: p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,

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

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

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