DBA Data[Home] [Help]

APPS.MST_RELEASE dependencies on FTE_MOVES_INTERFACE

Line 685: , fte_moves_interface_s.nextval

681: , p_group_id
682: , l_cm_planned_flag
683: , p_cm_id_of_trip
684: , l_sr_cm_trip_id
685: , fte_moves_interface_s.nextval
686: , l_lane_id
687: , l_service_level
688: , l_compile_designator
689: , l_cm_trip_number

Line 1486: insert into fte_moves_interface

1482: where mrt.release_id = p_release_id
1483: and mrt.trip_id is not null
1484: );
1485:
1486: insert into fte_moves_interface
1487: ( move_interface_id
1488: , move_id
1489: , lane_id
1490: , service_level

Line 3675: delete from fte_moves_interface

3671: end loop;
3672: print_info(g_log_must_message,'');
3673:
3674: for i in 1..g_delete_record_count_loop loop
3675: delete from fte_moves_interface
3676: where interface_action_code = g_tp_release_code
3677: and rownum < g_delete_record_count;
3678: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_moves_interface.');
3679: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

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

3674: for i in 1..g_delete_record_count_loop loop
3675: delete from fte_moves_interface
3676: where interface_action_code = g_tp_release_code
3677: and rownum < g_delete_record_count;
3678: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_moves_interface.');
3679: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3680: fnd_message.set_token('N1',to_char(sql%rowcount));
3681: fnd_message.set_token('TABLE_NAME','FTE_MOVES_INTERFACE');
3682: l_Message_Text := fnd_message.get;

Line 3681: fnd_message.set_token('TABLE_NAME','FTE_MOVES_INTERFACE');

3677: and rownum < g_delete_record_count;
3678: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from fte_moves_interface.');
3679: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3680: fnd_message.set_token('N1',to_char(sql%rowcount));
3681: fnd_message.set_token('TABLE_NAME','FTE_MOVES_INTERFACE');
3682: l_Message_Text := fnd_message.get;
3683: print_info(g_log_must_message,l_Message_Text);
3684: commit;
3685: end loop;