APPS.MST_RELEASE dependencies on WSH_NEW_DEL_INTERFACE

Line 1281: -- , wsh_new_del_interface_s.nextval

1277: )
1278: , md.delivery_id
1279: , md.sr_delivery_id
1280: , md.out_of_scope
1281: -- , wsh_new_del_interface_s.nextval
1282: , nvl(md.status_code,1) status_code
1283: , md.pickup_date
1284: , md.dropoff_date
1285: , md.pickup_location_id

Line 1326: SET mrt.delivery_id_iface = wsh_new_del_interface_s.nextval

1322: );
1323:
1324: -- update delivery_id_iface and planned_flag for deliveries in mst_release_temp_gt
1325: UPDATE mst_release_temp_gt mrt
1326: SET mrt.delivery_id_iface = wsh_new_del_interface_s.nextval
1327: WHERE mrt.release_id = p_release_id
1328: AND mrt.delivery_id IS NOT NULL;
1329:
1330: -- update planned_flag for deliveries of RCF trips

Line 1415: update wsh_new_del_interface

1411: close cur_wdd_loc_ids;
1412:
1413: if nvl(l_delivery_iface_id_tab.last,0) > 0 then
1414: forall i in 1..l_delivery_iface_id_tab.last
1415: update wsh_new_del_interface
1416: set ultimate_dropoff_location_id = l_ship_to_location_id_tab(i)
1417: where delivery_interface_id = l_delivery_iface_id_tab(i);
1418: end if;
1419:

Line 1684: insert into wsh_new_del_interface

1680: where mrt.release_id = p_release_id
1681: and mrt.stop_id is not null
1682: );
1683:
1684: insert into wsh_new_del_interface
1685: ( delivery_interface_id
1686: , delivery_id
1687: , planned_flag
1688: , status_code

Line 2447: , wsh_new_del_interface wndi

2443: cursor cur_deliveries (l_release_id in pls_integer, l_group_id in pls_integer)
2444: is
2445: select mrt.delivery_id, wndi.delivery_id
2446: from mst_release_temp_gt mrt
2447: , wsh_new_del_interface wndi
2448: where mrt.release_id = l_release_id
2449: and mrt.group_id = l_group_id
2450: and mrt.delivery_id is not null
2451: and mrt.delivery_id_iface = wndi.delivery_interface_id;

Line 3717: delete from wsh_new_del_interface

3713: end loop;
3714: print_info(g_log_must_message,'');
3715:
3716: for i in 1..g_delete_record_count_loop loop
3717: delete from wsh_new_del_interface
3718: where interface_action_code = g_tp_release_code
3719: and rownum < g_delete_record_count;
3720: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_new_del_interface.');
3721: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');

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

3716: for i in 1..g_delete_record_count_loop loop
3717: delete from wsh_new_del_interface
3718: where interface_action_code = g_tp_release_code
3719: and rownum < g_delete_record_count;
3720: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_new_del_interface.');
3721: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3722: fnd_message.set_token('N1',to_char(sql%rowcount));
3723: fnd_message.set_token('TABLE_NAME','WSH_NEW_DEL_INTERFACE');
3724: l_Message_Text := fnd_message.get;

Line 3723: fnd_message.set_token('TABLE_NAME','WSH_NEW_DEL_INTERFACE');

3719: and rownum < g_delete_record_count;
3720: print_info(g_log_must_message,'Attempted to delete '||sql%rowcount||' records from wsh_new_del_interface.');
3721: fnd_message.set_name('MST','MST_REL_BK_MESSAGE_44');
3722: fnd_message.set_token('N1',to_char(sql%rowcount));
3723: fnd_message.set_token('TABLE_NAME','WSH_NEW_DEL_INTERFACE');
3724: l_Message_Text := fnd_message.get;
3725: print_info(g_log_must_message,l_Message_Text);
3726: commit;
3727: end loop;