APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_WMS_SYNC_TMP

Line 973: UPDATE wsh_wms_sync_tmp

969:
970:
971: IF (p_temp_update_flag = 'Y') THEN
972: --{
973: UPDATE wsh_wms_sync_tmp
974: SET temp_col = 'Y',
975: parent_delivery_detail_id = p_delivery_id
976: WHERE delivery_id = p_old_delivery_id
977: AND operation_type = 'VENDOR_MRG';

Line 979: UPDATE wsh_wms_sync_tmp

975: parent_delivery_detail_id = p_delivery_id
976: WHERE delivery_id = p_old_delivery_id
977: AND operation_type = 'VENDOR_MRG';
978: ELSIF (p_temp_update_flag = 'N') THEN
979: UPDATE wsh_wms_sync_tmp
980: SET temp_col = 'Y'
981: WHERE delivery_id = p_old_delivery_id
982: AND operation_type = 'VENDOR_MRG';
983: --}

Line 988: 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);

984: END IF;
985:
986: IF l_debug_on THEN
987: --{
988: 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);
989: --}
990: END IF;
991:
992:

Line 1558: FROM wsh_wms_sync_tmp

1554: --
1555:
1556: CURSOR find_delivery IS
1557: SELECT distinct delivery_id
1558: FROM wsh_wms_sync_tmp
1559: WHERE operation_type = 'VENDOR_MRG'
1560: AND temp_col IS NULL
1561: AND delivery_id IS NOT NULL;
1562: --

Line 1605: FROM wsh_wms_sync_tmp wwst,

1601: --
1602:
1603: CURSOR check_temp (p_delivery_id NUMBER) IS
1604: SELECT parent_delivery_detail_id
1605: FROM wsh_wms_sync_tmp wwst,
1606: wsh_delivery_details wdd
1607: WHERE wwst.delivery_id = p_delivery_id
1608: AND wwst.temp_col IS NOT NULL
1609: AND operation_type = 'VENDOR_MRG'

Line 1619: FROM wsh_wms_sync_tmp

1615: --
1616:
1617: CURSOR check_detail(p_delivery_id NUMBER) IS
1618: SELECT delivery_detail_id
1619: FROM wsh_wms_sync_tmp
1620: WHERE delivery_id = p_delivery_id
1621: AND operation_type = 'VENDOR_MRG'
1622: AND temp_col IS NULL;
1623: --

Line 1842: INSERT INTO wsh_wms_sync_tmp

1838:
1839: IF l_dd_list.COUNT > 0 THEN
1840: --{
1841: FORALL j IN l_dd_list.FIRST..l_dd_list.LAST
1842: INSERT INTO wsh_wms_sync_tmp
1843: ( delivery_detail_id,
1844: delivery_id,
1845: operation_type,
1846: creation_date )

Line 1854: 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);

1850: sysdate );
1851:
1852: IF l_debug_on THEN
1853: --{
1854: 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);
1855: --}
1856: END IF;
1857:
1858: --