APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_WMS_SYNC_TMP

Line 980: UPDATE wsh_wms_sync_tmp

976:
977:
978: IF (p_temp_update_flag = 'Y') THEN
979: --{
980: UPDATE wsh_wms_sync_tmp
981: SET temp_col = 'Y',
982: parent_delivery_detail_id = p_delivery_id
983: WHERE delivery_id = p_old_delivery_id
984: AND operation_type = 'VENDOR_MRG';

Line 986: UPDATE wsh_wms_sync_tmp

982: parent_delivery_detail_id = p_delivery_id
983: WHERE delivery_id = p_old_delivery_id
984: AND operation_type = 'VENDOR_MRG';
985: ELSIF (p_temp_update_flag = 'N') THEN
986: UPDATE wsh_wms_sync_tmp
987: SET temp_col = 'Y'
988: WHERE delivery_id = p_old_delivery_id
989: AND operation_type = 'VENDOR_MRG';
990: --}

Line 995: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_wms_sync_tmp. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);

991: END IF;
992:
993: IF l_debug_on THEN
994: --{
995: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_wms_sync_tmp. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
996: --}
997: END IF;
998:
999:

Line 1565: FROM wsh_wms_sync_tmp

1561: --
1562:
1563: CURSOR find_delivery IS
1564: SELECT distinct delivery_id
1565: FROM wsh_wms_sync_tmp
1566: WHERE operation_type = 'VENDOR_MRG'
1567: AND temp_col IS NULL
1568: AND delivery_id IS NOT NULL;
1569: --

Line 1612: FROM wsh_wms_sync_tmp wwst,

1608: --
1609:
1610: CURSOR check_temp (p_delivery_id NUMBER) IS
1611: SELECT parent_delivery_detail_id
1612: FROM wsh_wms_sync_tmp wwst,
1613: wsh_delivery_details wdd
1614: WHERE wwst.delivery_id = p_delivery_id
1615: AND wwst.temp_col IS NOT NULL
1616: AND operation_type = 'VENDOR_MRG'

Line 1626: FROM wsh_wms_sync_tmp

1622: --
1623:
1624: CURSOR check_detail(p_delivery_id NUMBER) IS
1625: SELECT delivery_detail_id
1626: FROM wsh_wms_sync_tmp
1627: WHERE delivery_id = p_delivery_id
1628: AND operation_type = 'VENDOR_MRG'
1629: AND temp_col IS NULL;
1630: --

Line 1849: INSERT INTO wsh_wms_sync_tmp

1845:
1846: IF l_dd_list.COUNT > 0 THEN
1847: --{
1848: FORALL j IN l_dd_list.FIRST..l_dd_list.LAST
1849: INSERT INTO wsh_wms_sync_tmp
1850: ( delivery_detail_id,
1851: delivery_id,
1852: operation_type,
1853: creation_date )

Line 1861: WSH_DEBUG_SV.logmsg(l_module_name,'Inserted records into wsh_wms_sync_tmp. Number of Rows inserted is ' || l_dd_list.count, WSH_DEBUG_SV.C_STMT_LEVEL);

1857: sysdate );
1858:
1859: IF l_debug_on THEN
1860: --{
1861: WSH_DEBUG_SV.logmsg(l_module_name,'Inserted records into wsh_wms_sync_tmp. Number of Rows inserted is ' || l_dd_list.count, WSH_DEBUG_SV.C_STMT_LEVEL);
1862: --}
1863: END IF;
1864:
1865: --