APPS.MST_RELEASE dependencies on WSH_DEL_ASSGN_INTERFACE

Line 1394: , wsh_del_assgn_interface wda_iface

1390: is
1391: select wda_iface.delivery_interface_id, wdd_iface.delivery_detail_interface_id, mplav.cust_location_id
1392: from mst_po_location_asso_v mplav
1393: , wsh_del_details_interface wdd_iface
1394: , wsh_del_assgn_interface wda_iface
1395: , wsh_delivery_details wdd
1396: , mst_release_temp_gt mrt
1397: where mplav.location_id = wdd_iface.ship_to_location_id
1398: and wdd_iface.delivery_detail_id = wdd.delivery_detail_id

Line 2013: insert into wsh_del_assgn_interface

2009: and hzr.status (+) = 'A'
2010: and hzr.subject_id (+) = mdd.supplier_id
2011: );
2012:
2013: insert into wsh_del_assgn_interface
2014: ( del_assgn_interface_id
2015: , delivery_assignment_id
2016: , delivery_interface_id
2017: , delivery_id

Line 2028: select wsh_del_assgn_interface_s.nextval

2024: , last_updated_by
2025: , last_update_login
2026: )
2027: (
2028: select wsh_del_assgn_interface_s.nextval
2029: , null -- mrt.sr_delivery_assignment_id commented as not need in TE (william)
2030: , mrt.delivery_id_iface
2031: , mrt.sr_delivery_id
2032: , mrt.delivery_detail_id_iface

Line 3745: delete from wsh_del_assgn_interface

3741: end loop;
3742: print_info(g_log_must_message,'');
3743:
3744: for i in 1..g_delete_record_count_loop loop
3745: delete from wsh_del_assgn_interface
3746: where interface_action_code = g_tp_release_code
3747: and rownum < g_delete_record_count;
3748: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_assgn_interface.');
3749: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

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

3744: for i in 1..g_delete_record_count_loop loop
3745: delete from wsh_del_assgn_interface
3746: where interface_action_code = g_tp_release_code
3747: and rownum < g_delete_record_count;
3748: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_assgn_interface.');
3749: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3750: fnd_message.set_token('N1',to_char(sql%rowcount));
3751: fnd_message.set_token('TABLE_NAME','WSH_DEL_ASSGN_INTERFACE');
3752: l_Message_Text := fnd_message.get;

Line 3751: fnd_message.set_token('TABLE_NAME','WSH_DEL_ASSGN_INTERFACE');

3747: and rownum < g_delete_record_count;
3748: --print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_del_assgn_interface.');
3749: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3750: fnd_message.set_token('N1',to_char(sql%rowcount));
3751: fnd_message.set_token('TABLE_NAME','WSH_DEL_ASSGN_INTERFACE');
3752: l_Message_Text := fnd_message.get;
3753: print_info(g_log_must_message,l_Message_Text);
3754: commit;
3755: end loop;