eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_OTM_OUTBOUND dependencies on WSH_OTM_ID_TAB

Line 94: PROCEDURE GET_TRIP_OBJECTS(p_trip_id_tab IN OUT NOCOPY WSH_OTM_ID_TAB,

90: -- x_error_trip_id_tab - List of ids for which the data could not be retrieved
91: -- x_return_status
92: -- +==========================================================================================+
93:
94: PROCEDURE GET_TRIP_OBJECTS(p_trip_id_tab IN OUT NOCOPY WSH_OTM_ID_TAB,
95: p_user_id IN NUMBER,
96: p_resp_id IN NUMBER,
97: p_resp_appl_id IN NUMBER,
98: x_domain_name OUT NOCOPY VARCHAR2,

Line 104: x_error_trip_id_tab OUT NOCOPY WSH_OTM_ID_TAB,

100: x_otm_pwd OUT NOCOPY VARCHAR2,
101: x_server_tz_code OUT NOCOPY VARCHAR2,
102: x_trip_tab OUT NOCOPY WSH_OTM_TRIP_TAB,
103: x_dlv_tab OUT NOCOPY WSH_OTM_DLV_TAB,
104: x_error_trip_id_tab OUT NOCOPY WSH_OTM_ID_TAB,
105: x_return_status OUT NOCOPY VARCHAR2)IS
106:
107: -- Declare local variables
108:

Line 115: l_dlv_ids WSH_OTM_ID_TAB;

111: l_trip_tab WSH_OTM_TRIP_TAB;
112: l_stops_tab WSH_OTM_STOP_TAB;
113: --lpn_tab WSH_OTM_LPN_TAB;
114: l_dlv_tab WSH_OTM_DLV_TAB;
115: l_dlv_ids WSH_OTM_ID_TAB;
116: l_vol NUMBER;
117: l_gross_weight NUMBER;
118: l_net_weight NUMBER;
119: l_total_gross_wt NUMBER;

Line 169: x_error_dlv_id_tab WSH_OTM_ID_TAB;

165: SELECT stop_id,'ASR' tms_iface_new_status
166: FROM wsh_trip_stops
167: WHERE trip_id = c_trip_id;
168:
169: x_error_dlv_id_tab WSH_OTM_ID_TAB;
170: l_upd_trip_stops WSH_UTIL_CORE.ID_TAB_TYPE;
171: l_upd_tms_interface_flags WSH_UTIL_CORE.COLUMN_TAB_TYPE;
172: l_old_trip_id NUMBER;
173: l_del_trip_rec NUMBER := NULL;

Line 312: x_error_trip_id_tab := WSH_OTM_ID_TAB();

308: l_stops_tab := WSH_OTM_STOP_TAB();
309: l_stop_details := WSH_OTM_STOP_DET_TAB();
310: l_all_dlv_tab := WSH_OTM_DLV_TAB();
311: -- Bug 6497991: Populating error trips
312: x_error_trip_id_tab := WSH_OTM_ID_TAB();
313: l_old_trip_id := -1;
314: -- Bug 6497991:end
315: LOOP
316: --{

Line 480: l_dlv_ids := WSH_OTM_ID_TAB();

476: IF l_debug_on THEN
477: WSH_DEBUG_SV.log(l_sub_module_name,'Processing Trip with Id ' , l_trip_tab(i).trip_id);
478: END IF;
479:
480: l_dlv_ids := WSH_OTM_ID_TAB();
481: l_stops_tab := l_trip_tab(i).shipment_stops;
482:
483:
484:

Line 837: PROCEDURE GET_DELIVERY_OBJECTS(p_dlv_id_tab IN OUT NOCOPY WSH_OTM_ID_TAB,

833: -- +==================================================================================================+
834:
835:
836:
837: PROCEDURE GET_DELIVERY_OBJECTS(p_dlv_id_tab IN OUT NOCOPY WSH_OTM_ID_TAB,
838: p_user_id IN NUMBER,
839: p_resp_id IN NUMBER,
840: p_resp_appl_id IN NUMBER,
841: p_caller IN VARCHAR2 DEFAULT 'D',

Line 848: x_error_dlv_id_tab OUT NOCOPY WSH_OTM_ID_TAB,

844: x_otm_user_name OUT NOCOPY VARCHAR2,
845: x_otm_pwd OUT NOCOPY VARCHAR2,
846: x_server_tz_code OUT NOCOPY VARCHAR2,
847: x_dlv_tab OUT NOCOPY WSH_OTM_DLV_TAB,
848: x_error_dlv_id_tab OUT NOCOPY WSH_OTM_ID_TAB,
849: x_return_status OUT NOCOPY VARCHAR2 ) IS
850:
851: -- Declare local variables
852:

Line 860: l_loose_items_ids WSH_OTM_ID_TAB;

856: l_del_details wsh_otm_det_tab;
857: l_rl_details wsh_otm_det_tab;
858: l_lpn_tab wsh_otm_lpn_tab;
859: l_packed_items WSH_OTM_LPN_CONT_TAB;
860: l_loose_items_ids WSH_OTM_ID_TAB;
861: l_dlv_obj wsh_otm_dlv_obj;
862: l_det_obj wsh_otm_det_obj;
863: l_weight NUMBER;
864: l_dlv_id_tab WSH_OTM_ID_TAB;

Line 864: l_dlv_id_tab WSH_OTM_ID_TAB;

860: l_loose_items_ids WSH_OTM_ID_TAB;
861: l_dlv_obj wsh_otm_dlv_obj;
862: l_det_obj wsh_otm_det_obj;
863: l_weight NUMBER;
864: l_dlv_id_tab WSH_OTM_ID_TAB;
865: l_error_dlv_id_tab WSH_OTM_ID_TAB;
866:
867:
868: c_deliveries WSH_UTIL_CORE.RefCurType;

Line 865: l_error_dlv_id_tab WSH_OTM_ID_TAB;

861: l_dlv_obj wsh_otm_dlv_obj;
862: l_det_obj wsh_otm_det_obj;
863: l_weight NUMBER;
864: l_dlv_id_tab WSH_OTM_ID_TAB;
865: l_error_dlv_id_tab WSH_OTM_ID_TAB;
866:
867:
868: c_deliveries WSH_UTIL_CORE.RefCurType;
869: bind_col_tab WSH_UTIL_CORE.tbl_varchar;

Line 1096: l_dlv_id_tab := WSH_OTM_ID_TAB();

1092: -- 6922924
1093: l_good_dlv_tab := wsh_otm_dlv_tab();
1094:
1095: --l_dlv_obj := wsh_otm_dlv_obj();
1096: l_dlv_id_tab := WSH_OTM_ID_TAB();
1097: LOOP
1098: --{
1099: FETCH c_deliveries INTO l_dlv_obj,l_det_obj;
1100: EXIT WHEN (c_deliveries%NOTFOUND);

Line 1119: l_error_dlv_id_tab := WSH_OTM_ID_TAB();

1115:
1116: IF l_dlv_tab.COUNT >0 THEN
1117: --{ when l_dlv_tab count > 0
1118:
1119: l_error_dlv_id_tab := WSH_OTM_ID_TAB();
1120: FOR i in 1..l_dlv_tab.COUNT LOOP
1121: --{ -- 6922924 Loop Start
1122: BEGIN
1123:

Line 1676: p_entity_id_tab IN OUT NOCOPY WSH_OTM_ID_TAB,

1672: p_new_intf_status IN VARCHAR2,
1673: p_userId IN NUMBER DEFAULT NULL,
1674: p_respId IN NUMBER DEFAULT NULL,
1675: p_resp_appl_Id IN NUMBER DEFAULT NULL,
1676: p_entity_id_tab IN OUT NOCOPY WSH_OTM_ID_TAB,
1677: p_error_id_tab IN OUT NOCOPY WSH_OTM_ID_TAB
1678: ) IS
1679:
1680: -- Declare local variables

Line 1677: p_error_id_tab IN OUT NOCOPY WSH_OTM_ID_TAB

1673: p_userId IN NUMBER DEFAULT NULL,
1674: p_respId IN NUMBER DEFAULT NULL,
1675: p_resp_appl_Id IN NUMBER DEFAULT NULL,
1676: p_entity_id_tab IN OUT NOCOPY WSH_OTM_ID_TAB,
1677: p_error_id_tab IN OUT NOCOPY WSH_OTM_ID_TAB
1678: ) IS
1679:
1680: -- Declare local variables
1681:

Line 1683: l_entity_id_out_tab WSH_OTM_ID_TAB :=WSH_OTM_ID_TAB();

1679:
1680: -- Declare local variables
1681:
1682: l_sub_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ENTITY_INTF_STATUS';
1683: l_entity_id_out_tab WSH_OTM_ID_TAB :=WSH_OTM_ID_TAB();
1684: l_error_id_out_tab WSH_OTM_ID_TAB := WSH_OTM_ID_TAB();
1685: l_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1686: l_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1687: l_del_current_status varchar2(3);

Line 1684: l_error_id_out_tab WSH_OTM_ID_TAB := WSH_OTM_ID_TAB();

1680: -- Declare local variables
1681:
1682: l_sub_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ENTITY_INTF_STATUS';
1683: l_entity_id_out_tab WSH_OTM_ID_TAB :=WSH_OTM_ID_TAB();
1684: l_error_id_out_tab WSH_OTM_ID_TAB := WSH_OTM_ID_TAB();
1685: l_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1686: l_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1687: l_del_current_status varchar2(3);
1688: l_del_id_error_flag VARCHAR2(1) := 'N';