DBA Data[Home] [Help]

APPS.WSH_OTM_OUTBOUND dependencies on WSH_OTM_TRIP_OBJ

Line 134: l_trip_obj WSH_OTM_TRIP_OBJ;

130: l_lpns WSH_OTM_LPN_TAB;
131: l_pick_up_flag VARCHAR2(1);
132: l_drop_off_flag VARCHAR2(1);
133: l_trips_sql VARCHAR2(2000);
134: l_trip_obj WSH_OTM_TRIP_OBJ;
135: l_stop_obj WSH_OTM_STOP_OBJ;
136: c_trips WSH_UTIL_CORE.RefCurType;
137: bind_col_tab WSH_UTIL_CORE.tbl_varchar;
138: i NUMBER;

Line 219: 'WSH_OTM_TRIP_OBJ(WT.TP_PLAN_NAME, '||

215: --dbms_output.put_line('Building the sql');
216: -- Bug 6732184: Added null values for dock_dook_xid, start_time and end_time of WSH_OTM_STOP_OBJ
217: l_trips_sql :=
218: 'select '||
219: 'WSH_OTM_TRIP_OBJ(WT.TP_PLAN_NAME, '||
220: 'NAME ,'||
221: 'null,'||
222: '''RC'','||
223: 'WT.carrier_id,'||