DBA Data[Home] [Help]

APPS.MST_RELEASE dependencies on WSH_TRIP_STOPS_INTERFACE

Line 1591: , wsh_trip_stops_interface_s.nextval

1587: , mrt.group_id
1588: , mts.plan_id
1589: , mts.stop_id
1590: , mrt.trip_id_iface
1591: , wsh_trip_stops_interface_s.nextval
1592: , mrt.sr_trip_id
1593: , mrt.status_code
1594: , mts.sr_stop_id
1595: , mts.stop_location_id

Line 1620: insert into wsh_trip_stops_interface

1616: and mrt.trip_id = mts.trip_id
1617: and mrt.plan_id = mp.plan_id
1618: );
1619:
1620: insert into wsh_trip_stops_interface
1621: ( stop_interface_id
1622: , stop_id
1623: , trip_id
1624: , tp_stop_id

Line 3703: delete from wsh_trip_stops_interface

3699: end loop;
3700: print_info(g_log_must_message,'');
3701:
3702: for i in 1..g_delete_record_count_loop loop
3703: delete from wsh_trip_stops_interface
3704: where interface_action_code = g_tp_release_code
3705: and rownum < g_delete_record_count;
3706: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_trip_stops_interface.');
3707: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

Line 3706: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_trip_stops_interface.');

3702: for i in 1..g_delete_record_count_loop loop
3703: delete from wsh_trip_stops_interface
3704: where interface_action_code = g_tp_release_code
3705: and rownum < g_delete_record_count;
3706: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_trip_stops_interface.');
3707: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3708: fnd_message.set_token('N1',to_char(sql%rowcount));
3709: fnd_message.set_token('TABLE_NAME','WSH_TRIP_STOPS_INTERFACE');
3710: l_Message_Text := fnd_message.get;

Line 3709: fnd_message.set_token('TABLE_NAME','WSH_TRIP_STOPS_INTERFACE');

3705: and rownum < g_delete_record_count;
3706: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_trip_stops_interface.');
3707: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3708: fnd_message.set_token('N1',to_char(sql%rowcount));
3709: fnd_message.set_token('TABLE_NAME','WSH_TRIP_STOPS_INTERFACE');
3710: l_Message_Text := fnd_message.get;
3711: print_info(g_log_must_message,l_Message_Text);
3712: commit;
3713: end loop;