APPS.WSH_OTM_OUTBOUND dependencies on WSH_OTM_STOP_OBJ

Line 135: l_stop_obj WSH_OTM_STOP_OBJ;

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;
139: i1 NUMBER;

Line 216: -- Bug 6732184: Added null values for dock_dook_xid, start_time and end_time of WSH_OTM_STOP_OBJ

212: WSH_DEBUG_SV.log(l_sub_module_name,'Building the dymanic sql to fetch Trips');
213: END IF;
214:
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 ,'||

Line 265: 'WSH_OTM_STOP_OBJ(wts.STOP_ID , '||

261: '''OPERATOR'','||
262: '''ROUTING_INSTR'','||
263: 'null,'|| -- Stops
264: 'null ,null,null,null,null), '||
265: 'WSH_OTM_STOP_OBJ(wts.STOP_ID , '||
266: 'WTS.STOP_SEQUENCE_NUMBER,null,null,'||
267: 'TO_CHAR(WTS.PLANNED_ARRIVAL_DATE,''YYYYMMDDHH24MISS''),'||
268: 'TO_CHAR(WTS.PLANNED_DEPARTURE_DATE,''YYYYMMDDHH24MISS''),'||
269: 'TO_CHAR(WTS.ACTUAL_ARRIVAL_DATE,''YYYYMMDDHH24MISS''),'||