APPS.MST_RELEASE dependencies on FTE_TRIP_MOVES_INTERFACE

Line 1520: insert into fte_trip_moves_interface

1516: where mrt.release_id = p_release_id
1517: and mrt.continuous_move_id is not null
1518: );
1519:
1520: insert into fte_trip_moves_interface
1521: ( trip_move_interface_id
1522: , trip_move_id
1523: , move_interface_id
1524: , move_id

Line 1536: select fte_trip_moves_interface_s.nextval

1532: , last_updated_by
1533: , last_update_login
1534: )
1535: (
1536: select fte_trip_moves_interface_s.nextval
1537: , null
1538: , mrt1.continuous_move_id_iface
1539: , mrt1.sr_cm_trip_id
1540: , mrt2.trip_id_iface

Line 3689: delete from fte_trip_moves_interface

3685: end loop;
3686: print_info(g_log_must_message,'');
3687:
3688: for i in 1..g_delete_record_count_loop loop
3689: delete from fte_trip_moves_interface
3690: where interface_action_code = g_tp_release_code
3691: and rownum < g_delete_record_count;
3692: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_trip_moves_interface.');
3693: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

Line 3692: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_trip_moves_interface.');

3688: for i in 1..g_delete_record_count_loop loop
3689: delete from fte_trip_moves_interface
3690: where interface_action_code = g_tp_release_code
3691: and rownum < g_delete_record_count;
3692: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_trip_moves_interface.');
3693: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3694: fnd_message.set_token('N1',to_char(sql%rowcount));
3695: fnd_message.set_token('TABLE_NAME','FTE_TRIP_MOVES_INTERFACE');
3696: l_Message_Text := fnd_message.get;

Line 3695: fnd_message.set_token('TABLE_NAME','FTE_TRIP_MOVES_INTERFACE');

3691: and rownum < g_delete_record_count;
3692: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_trip_moves_interface.');
3693: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3694: fnd_message.set_token('N1',to_char(sql%rowcount));
3695: fnd_message.set_token('TABLE_NAME','FTE_TRIP_MOVES_INTERFACE');
3696: l_Message_Text := fnd_message.get;
3697: print_info(g_log_must_message,l_Message_Text);
3698: commit;
3699: end loop;