APPS.WSH_TRANSACTIONS_TPW_UTIL dependencies on WSH_NEW_DELIVERIES

Line 719: FROM wsh_new_deliveries

715:
716: CURSOR l_new_del_status_cur (c_Delivery_Name VARCHAR2,
717: c_Organization_ID NUMBER) IS
718: SELECT status_code, Delivery_ID
719: FROM wsh_new_deliveries
720: WHERE Organization_id = c_Organization_ID
721: AND Name = c_Delivery_Name;
722: /*
723:

Line 1693: FROM wsh_new_deliveries

1689:
1690: -- LSP PROJECT : Added client_id
1691: CURSOR l_new_del_status_cur ( c_Delivery_ID VARCHAR2, c_Organization_ID NUMBER ) IS
1692: SELECT Name, status_code,client_id
1693: FROM wsh_new_deliveries
1694: WHERE Organization_id = c_Organization_ID
1695: AND Delivery_ID = c_Delivery_ID;
1696:
1697: CURSOR l_del_details_cur (c_Delivery_ID NUMBER, c_Org_ID NUMBER) IS

Line 1701: wsh_new_deliveries wnd

1697: CURSOR l_del_details_cur (c_Delivery_ID NUMBER, c_Org_ID NUMBER) IS
1698: SELECT 'X'
1699: FROM wsh_delivery_details wdd,
1700: wsh_delivery_assignments_v wda,
1701: wsh_new_deliveries wnd
1702: WHERE wdd.container_flag = 'N'
1703: AND wdd.source_code = 'WSH'
1704: AND wdd.Delivery_Detail_ID = wda.Delivery_Detail_ID
1705: AND wda.Delivery_ID = wnd.Delivery_ID

Line 1902: UPDATE wsh_new_deliveries

1898: -- R12.1.1 STANDALONE PROJECT
1899: IF l_debug_on THEN
1900: wsh_debug_sv.logmsg (l_module_name, 'Updating Delivery Pending_Advice_Flag Status to Null');
1901: END IF;
1902: UPDATE wsh_new_deliveries
1903: SET pending_advice_flag = NULL,
1904: last_update_date = SYSDATE,
1905: last_updated_by = fnd_global.user_id,
1906: program_application_id = fnd_global.prog_appl_id,