APPS.FTE_DELIVERY_ACTIVITY dependencies on WSH_DELIVERY_LEG_ACTIVITIES

Line 44: select wsh_delivery_leg_activities_s.nextval into s_activity_id from dual;

40: s_activity_id NUMBER;
41:
42: BEGIN
43:
44: select wsh_delivery_leg_activities_s.nextval into s_activity_id from dual;
45:
46: insert into wsh_delivery_leg_activities
47: (ACTIVITY_ID, DELIVERY_LEG_ID, ACTIVITY_DATE, ACTIVITY_TYPE, CREATION_DATE, CREATED_BY,
48: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,

Line 46: insert into wsh_delivery_leg_activities

42: BEGIN
43:
44: select wsh_delivery_leg_activities_s.nextval into s_activity_id from dual;
45:
46: insert into wsh_delivery_leg_activities
47: (ACTIVITY_ID, DELIVERY_LEG_ID, ACTIVITY_DATE, ACTIVITY_TYPE, CREATION_DATE, CREATED_BY,
48: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
49: ACTION_BY, ACTION_BY_NAME, REMARKS, RESULT_STATUS, INITIAL_STATUS, TRIP_ID,CARRIER_ID,MODE_OF_TRANSPORT,SERVICE_LEVEL) values
50: (s_activity_id, p_delivery_leg_id, p_activity_date, p_activity_type, sysdate, -1,

Line 187: SELECT wsh_delivery_leg_activities_s.nextval into s_activity_id FROM DUAL;

183:
184:
185: FOR c_rec IN c_dlegs(p_trip_id) LOOP
186:
187: SELECT wsh_delivery_leg_activities_s.nextval into s_activity_id FROM DUAL;
188:
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting',WSH_DEBUG_SV.C_EXCEP_LEVEL);
191: END IF;

Line 196: INSERT INTO wsh_delivery_leg_activities

192:
193: dbms_output.put_line( ' Testing 1212 ' || p_delivery_leg_activity_rec.activity_type);
194:
195:
196: INSERT INTO wsh_delivery_leg_activities
197: ( ACTIVITY_ID,
198: DELIVERY_LEG_ID,
199: ACTIVITY_DATE,
200: ACTIVITY_TYPE,