APPS.MST_RELEASE dependencies on WSH_DEL_LEGS_INTERFACE

Line 1752: insert into wsh_del_legs_interface

1748: where mrt.release_id = p_release_id
1749: and mrt.delivery_id is not null
1750: );
1751:
1752: insert into wsh_del_legs_interface
1753: ( delivery_leg_interface_id
1754: , delivery_leg_id
1755: , delivery_id
1756: , delivery_interface_id

Line 1775: select wsh_del_legs_interface_s.nextval

1771: , last_updated_by
1772: , last_update_login
1773: )
1774: (
1775: select wsh_del_legs_interface_s.nextval
1776: , mdl.sr_delivery_leg_id
1777: , mrt1.sr_delivery_id
1778: , mrt1.delivery_id_iface
1779: , mdl.sequence_number

Line 3731: delete from wsh_del_legs_interface

3727: end loop;
3728: print_info(g_log_must_message,'');
3729:
3730: for i in 1..g_delete_record_count_loop loop
3731: delete from wsh_del_legs_interface
3732: where interface_action_code = g_tp_release_code
3733: and rownum < g_delete_record_count;
3734: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_legs_interface.');
3735: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

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

3730: for i in 1..g_delete_record_count_loop loop
3731: delete from wsh_del_legs_interface
3732: where interface_action_code = g_tp_release_code
3733: and rownum < g_delete_record_count;
3734: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_legs_interface.');
3735: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3736: fnd_message.set_token('N1',to_char(sql%rowcount));
3737: fnd_message.set_token('TABLE_NAME','WSH_DEL_LEGS_INTERFACE');
3738: l_Message_Text := fnd_message.get;

Line 3737: fnd_message.set_token('TABLE_NAME','WSH_DEL_LEGS_INTERFACE');

3733: and rownum < g_delete_record_count;
3734: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_legs_interface.');
3735: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3736: fnd_message.set_token('N1',to_char(sql%rowcount));
3737: fnd_message.set_token('TABLE_NAME','WSH_DEL_LEGS_INTERFACE');
3738: l_Message_Text := fnd_message.get;
3739: print_info(g_log_must_message,l_Message_Text);
3740: commit;
3741: end loop;