eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_WMS_LPN_GRP dependencies on WSH_DELIVERY_DETAILS

Line 64: FROM wsh_delivery_details

60: l_dummy NUMBER;
61:
62: CURSOR c_lock_container(v_lpn_id number) IS
63: SELECT delivery_detail_id
64: FROM wsh_delivery_details
65: WHERE lpn_id = v_lpn_id AND
66: --LPN reuse project
67: released_status = 'X'
68: FOR UPDATE NOWAIT;

Line 72: FROM wsh_delivery_details

68: FOR UPDATE NOWAIT;
69:
70: CURSOR c_lpn_exist (v_lpn_id NUMBER) IS
71: SELECT 1
72: FROM wsh_delivery_details
73: WHERE lpn_id = v_lpn_id
74: AND
75: --LPN reuse project
76: released_status = 'X';

Line 176: UPDATE wsh_delivery_details

172: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
173: RAISE FND_API.G_EXC_ERROR;
174: END;
175:
176: UPDATE wsh_delivery_details
177: SET lpn_id = NULL
178: WHERE lpn_id = p_detail_info_tab(i).lpn_id AND
179: --LPN reuse project
180: released_status = 'X';

Line 214: FROM WSH_DELIVERY_DETAILS

210: BEGIN
211:
212: SELECT delivery_detail_id
213: INTO p_detail_info_tab(i).delivery_detail_id
214: FROM WSH_DELIVERY_DETAILS
215: WHERE lpn_id = p_detail_info_tab(i).lpn_id AND
216: --LPN reuse project
217: released_status = 'X';
218:

Line 223: wsh_debug_sv.log(l_module_name,'There are no records in wsh_delivery_details for lpn_id: ', p_detail_info_tab(i).lpn_id);

219:
220: EXCEPTION
221: WHEN NO_DATA_FOUND THEN
222: IF l_debug_on THEN
223: wsh_debug_sv.log(l_module_name,'There are no records in wsh_delivery_details for lpn_id: ', p_detail_info_tab(i).lpn_id);
224: END IF;
225:
226: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_DETAIL'); --bmso new message
227: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 285: wsh_delivery_details_grp.create_update_delivery_detail(

281:
282: i := p_detail_info_tab.NEXT(i);
283: END LOOP; --}
284: END IF ;--}
285: wsh_delivery_details_grp.create_update_delivery_detail(
286: p_api_version_number => p_api_version,
287: p_init_msg_list => FND_API.G_FALSE,
288: p_commit => FND_API.G_FALSE,
289: x_return_status => l_return_status,

Line 741: from wsh_delivery_details

737: --{
738:
739: cursor l_lpn_exists_csr(p_lpn_id IN NUMBER) is
740: select 'X'
741: from wsh_delivery_details
742: where lpn_id = p_lpn_id
743: --LPN Reuse project
744: and released_status = 'X';
745:

Line 749: from wsh_delivery_details

745:
746: cursor l_get_detail_csr(p_lpn_id IN NUMBER) is
747: select delivery_detail_id,
748: inventory_item_id
749: from wsh_delivery_details
750: where lpn_id = p_lpn_id
751: --LPN Reuse project
752: and released_status = 'X';
753:

Line 774: FROM wsh_delivery_details

770: shipping_control,
771: party_id,
772: line_direction,
773: source_line_id
774: FROM wsh_delivery_details
775: WHERE delivery_detail_id = p_detail_id;
776:
777: CURSOR l_det_lpn_id_csr(p_lpn_id IN NUMBER) IS
778: SELECT wdd.released_status,

Line 799: FROM wsh_delivery_details wdd,

795: wdd.line_direction,
796: wdd.source_line_id,
797: wda.delivery_id,
798: wda.parent_delivery_detail_id
799: FROM wsh_delivery_details wdd,
800: wsh_delivery_assignments wda
801: WHERE wdd.lpn_id = p_lpn_id
802: and nvl(wda.type,'S') in ('S', 'C')
803: and wdd.delivery_detail_id = wda.delivery_detail_id

Line 958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

954: --
955: -- Debug Statements
956: --
957: IF l_debug_on THEN
958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
959: END IF;
960: --
961: wsh_delivery_details_grp.create_update_delivery_detail(
962: p_api_version_number => p_api_version_number,

Line 961: wsh_delivery_details_grp.create_update_delivery_detail(

957: IF l_debug_on THEN
958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
959: END IF;
960: --
961: wsh_delivery_details_grp.create_update_delivery_detail(
962: p_api_version_number => p_api_version_number,
963: p_init_msg_list => FND_API.G_FALSE,
964: p_commit => FND_API.G_FALSE,
965: x_return_status => l_return_status,

Line 1146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);

1142: --
1143: -- Debug Statements
1144: --
1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1147: END IF;
1148: --
1149: wsh_delivery_details_grp.Delivery_Detail_Action(
1150: p_api_version_number => p_api_version_number,

Line 1149: wsh_delivery_details_grp.Delivery_Detail_Action(

1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1147: END IF;
1148: --
1149: wsh_delivery_details_grp.Delivery_Detail_Action(
1150: p_api_version_number => p_api_version_number,
1151: p_init_msg_list => FND_API.G_FALSE,
1152: p_commit => FND_API.G_FALSE,
1153: x_return_status => l_return_status,

Line 1191: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

1187: --
1188: -- Debug Statements
1189: --
1190: IF l_debug_on THEN
1191: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
1192: END IF;
1193: --
1194: wsh_delivery_details_grp.create_update_delivery_detail(
1195: p_api_version_number => p_api_version_number,

Line 1194: wsh_delivery_details_grp.create_update_delivery_detail(

1190: IF l_debug_on THEN
1191: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
1192: END IF;
1193: --
1194: wsh_delivery_details_grp.create_update_delivery_detail(
1195: p_api_version_number => p_api_version_number,
1196: p_init_msg_list => FND_API.G_FALSE,
1197: p_commit => FND_API.G_FALSE,
1198: x_return_status => l_return_status,

Line 1355: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);

1351: --
1352: -- Debug Statements
1353: --
1354: IF l_debug_on THEN
1355: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1356: END IF;
1357: --
1358: wsh_container_actions.delete_containers (
1359: p_container_id => l_del_det_id_tbl(l_index),

Line 1659: Wsh_lpn_purge_tmp wt, wsh_delivery_details wdd

1655: Update wsh_lpn_purge_tmp
1656: Set eligible_flag = 'N' where
1657: Lpn_id in (
1658: Select wt.lpn_id from
1659: Wsh_lpn_purge_tmp wt, wsh_delivery_details wdd
1660: Where wt.lpn_id = wdd.lpn_id
1661: And nvl(wt.ELIGIBLE_FLAG ,'Y') = 'Y'
1662: And NVL(wdd.line_direction,'O') IN ('IO','O')
1663: And wdd.released_status <> 'C');

Line 1687: UPDATE wsh_delivery_details

1683: IF l_debug_on THEN
1684: wsh_debug_sv.log (l_module_name,'Rows updated',SQL%rowcount);
1685: END IF;
1686:
1687: UPDATE wsh_delivery_details
1688: SET lpn_id = NULL WHERE
1689: lpn_id IN (SELECT LPN_ID FROM wsh_lpn_purge_tmp
1690: WHERE eligible_flag = 'Y');
1691: