APPS.WSH_OTM_OUTBOUND dependencies on WSH_OTM_DLV_TAB

Line 103: x_dlv_tab OUT NOCOPY WSH_OTM_DLV_TAB,

99: x_otm_user_name OUT NOCOPY VARCHAR2,
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

Line 114: l_dlv_tab WSH_OTM_DLV_TAB;

110:
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;

Line 143: l_all_dlv_tab WSH_OTM_DLV_TAB;

139: i1 NUMBER;
140: l_lpn_tab WSH_OTM_LPN_TAB;
141: l_organization_id NUMBER;
142: l_return_status VARCHAr2(10);
143: l_all_dlv_tab WSH_OTM_DLV_TAB;
144: l_total_freight_cost NUMBER;
145: l_currency_code VARCHAR2(15);
146: l_sob_id NUMBER;
147: l_car_type VARCHAR2(5) := 'CAR-';

Line 310: l_all_dlv_tab := WSH_OTM_DLV_TAB();

306: x_trip_tab := WSH_OTM_TRIP_TAB();
307: l_trip_tab := WSH_OTM_TRIP_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

Line 814: -- in the form of objects (WSH_OTM_DLV_TAB)

810: -- +==================================================================================================+
811: -- Procedure : GET_DELIVERY_OBJECTS
812: -- Description:
813: -- Procedure to get the delivery,delivery details and Lpn info
814: -- in the form of objects (WSH_OTM_DLV_TAB)
815:
816: -- Inputs/Outputs:
817: -- p_dlv_id_tab - id table (list of delivery Ids)
818: -- p_user_id - User Id to set the context

Line 847: x_dlv_tab OUT NOCOPY WSH_OTM_DLV_TAB,

843: x_domain_name OUT NOCOPY VARCHAR2,
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

Line 854: l_dlv_tab wsh_otm_dlv_tab;

850:
851: -- Declare local variables
852:
853: l_sub_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_DELIVERY_OBJECTS';
854: l_dlv_tab wsh_otm_dlv_tab;
855: l_all_details wsh_otm_det_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;

Line 922: l_good_dlv_tab wsh_otm_dlv_tab;

918:
919: -- Bug 7207835
920: l_p_caller VARCHAR2(10);
921: -- 6922924
922: l_good_dlv_tab wsh_otm_dlv_tab;
923: l_upd_tms_interface_flags WSH_UTIL_CORE.COLUMN_TAB_TYPE;
924: l_upd_err_dlvys WSH_UTIL_CORE.ID_TAB_TYPE;
925:
926:

Line 1089: l_dlv_tab := wsh_otm_dlv_tab();

1085: i:=1;
1086:
1087: WSH_UTIL_CORE.OpenDynamicCursor(c_deliveries, l_deliveries_sql, bind_col_tab);
1088: l_count := 1;
1089: l_dlv_tab := wsh_otm_dlv_tab();
1090: --l_all_details - contains the delivery details of all the deliveries queried.
1091: l_all_details := wsh_otm_det_tab();
1092: -- 6922924
1093: l_good_dlv_tab := wsh_otm_dlv_tab();

Line 1093: l_good_dlv_tab := wsh_otm_dlv_tab();

1089: l_dlv_tab := wsh_otm_dlv_tab();
1090: --l_all_details - contains the delivery details of all the deliveries queried.
1091: l_all_details := wsh_otm_det_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