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_SYNC_TMP_PKG dependencies on WSH_WMS_LPN_GRP

Line 54: WSH_DEBUG_SV.log(l_module_name, 'WSH_WMS_LPN_GRP.G_HW_TIME_STAMP', WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);

50: WSH_DEBUG_SV.log(l_module_name, 'Delivery Detail Id', p_sync_tmp_rec.delivery_detail_id);
51: WSH_DEBUG_SV.log(l_module_name, 'Delivery Id', p_sync_tmp_rec.delivery_id);
52: WSH_DEBUG_SV.log(l_module_name, 'Parent Delivery Detail Id', p_sync_tmp_rec.parent_delivery_detail_id);
53: WSH_DEBUG_SV.log(l_module_name, 'Operation Type', p_sync_tmp_rec.operation_type);
54: WSH_DEBUG_SV.log(l_module_name, 'WSH_WMS_LPN_GRP.G_HW_TIME_STAMP', WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);
55:
56: END IF;
57: --
58: SAVEPOINT WSH_WMS_SYNC_TMP_PKG_MERGE;

Line 62: IF (WSH_WMS_LPN_GRP.G_HW_TIME_STAMP IS NULL) THEN

58: SAVEPOINT WSH_WMS_SYNC_TMP_PKG_MERGE;
59: --
60: x_return_status := wsh_util_core.g_ret_sts_success;
61:
62: IF (WSH_WMS_LPN_GRP.G_HW_TIME_STAMP IS NULL) THEN
63: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP := sysdate;
64: END IF;
65: --
66: IF (p_sync_tmp_rec.operation_type IN ('UPDATE', 'PRIOR')) THEN

Line 63: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP := sysdate;

59: --
60: x_return_status := wsh_util_core.g_ret_sts_success;
61:
62: IF (WSH_WMS_LPN_GRP.G_HW_TIME_STAMP IS NULL) THEN
63: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP := sysdate;
64: END IF;
65: --
66: IF (p_sync_tmp_rec.operation_type IN ('UPDATE', 'PRIOR')) THEN
67: --{

Line 75: AND creation_date > WSH_WMS_LPN_GRP.G_HW_TIME_STAMP) S

71: USING (SELECT delivery_detail_id
72: FROM WSH_WMS_SYNC_TMP
73: WHERE delivery_detail_id = p_sync_tmp_rec.delivery_detail_id
74: AND operation_type= p_sync_tmp_rec.operation_type
75: AND creation_date > WSH_WMS_LPN_GRP.G_HW_TIME_STAMP) S
76: ON (T.delivery_detail_id = S.delivery_detail_id)
77: WHEN MATCHED THEN
78: UPDATE
79: SET T.temp_col = null

Line 95: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);

91: */
92: -- The above stmt does not work. Therefore, using the following logic.
93: open l_sync_tmp_rec_csr(p_sync_tmp_rec.delivery_detail_id,
94: p_sync_tmp_rec.operation_type,
95: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);
96: fetch l_sync_tmp_rec_csr into l_rec_exists;
97: close l_sync_tmp_rec_csr;
98:
99: IF (l_rec_exists is null) THEN

Line 111: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP,

107: values (p_sync_tmp_rec.delivery_detail_id,
108: p_sync_tmp_rec.parent_delivery_detail_id,
109: p_sync_tmp_rec.delivery_id,
110: p_sync_tmp_rec.operation_type,
111: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP,
112: p_sync_tmp_rec.call_level);
113:
114: IF l_debug_on THEN
115: WSH_DEBUG_SV.logmsg(l_module_name, 'INSERTED '||SQL%ROWCOUNT||' RECORDS IN WSH_WMS_SYNC_TMP' );

Line 208: WSH_DEBUG_SV.log(l_module_name, 'WSH_WMS_LPN_GRP.G_HW_TIME_STAMP', WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);

204: IF l_debug_on THEN
205: WSH_DEBUG_SV.push(l_module_name);
206: WSH_DEBUG_SV.log(l_module_name, 'Input operation type', p_operation_type);
207: WSH_DEBUG_SV.log(l_module_name, 'Count of Input Table ', p_sync_tmp_recTbl.delivery_detail_id_tbl.count);
208: WSH_DEBUG_SV.log(l_module_name, 'WSH_WMS_LPN_GRP.G_HW_TIME_STAMP', WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);
209: END IF;
210: --
211: SAVEPOINT WSH_WMS_SYNC_TMP_PKG_MRG_BULK;
212: --

Line 221: IF (WSH_WMS_LPN_GRP.G_HW_TIME_STAMP IS NULL) THEN

217: IF l_debug_on THEN
218: WSH_DEBUG_SV.log(l_module_name, 'operation type', l_operation_type);
219: END IF;
220:
221: IF (WSH_WMS_LPN_GRP.G_HW_TIME_STAMP IS NULL) THEN
222: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP := sysdate;
223: END IF;
224: /*
225: IF (l_operation_type = 'UPDATE') THEN

Line 222: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP := sysdate;

218: WSH_DEBUG_SV.log(l_module_name, 'operation type', l_operation_type);
219: END IF;
220:
221: IF (WSH_WMS_LPN_GRP.G_HW_TIME_STAMP IS NULL) THEN
222: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP := sysdate;
223: END IF;
224: /*
225: IF (l_operation_type = 'UPDATE') THEN
226: --{

Line 233: AND creation_date > WSH_WMS_LPN_GRP.G_HW_TIME_STAMP) S

229: USING ( SELECT delivery_detail_id
230: FROM WSH_WMS_SYNC_TMP
231: WHERE delivery_detail_id = p_sync_tmp_recTbl.delivery_detail_id_tbl(i)
232: AND operation_type= p_sync_tmp_recTbl.operation_type_tbl(i)
233: AND creation_date > WSH_WMS_LPN_GRP.G_HW_TIME_STAMP) S
234: on (T.delivery_detail_id = S.delivery_detail_id)
235: WHEN MATCHED THEN
236: UPDATE
237: SET T.temp_col = null

Line 263: AND creation_date > WSH_WMS_LPN_GRP.G_HW_TIME_STAMP) S

259: USING ( SELECT delivery_detail_id
260: FROM WSH_WMS_SYNC_TMP
261: WHERE delivery_detail_id = p_sync_tmp_recTbl.delivery_detail_id_tbl(i)
262: AND operation_type= p_sync_tmp_recTbl.operation_type_tbl(i)
263: AND creation_date > WSH_WMS_LPN_GRP.G_HW_TIME_STAMP) S
264: on (T.delivery_detail_id = S.delivery_detail_id)
265: WHEN MATCHED THEN
266: UPDATE
267: SET T.temp_col = null

Line 313: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);

309: --{
310: -- The above stmt does not work. Therefore, using the following logic.
311: open l_sync_tmp_rec_csr(p_sync_tmp_recTbl.delivery_detail_id_tbl(i),
312: l_operation_type,
313: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);
314: fetch l_sync_tmp_rec_csr into l_rec_exists;
315: close l_sync_tmp_rec_csr;
316:
317: IF (l_rec_exists is null) THEN

Line 363: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);

359: VALUES (l_sync_tmp_recTbl.delivery_detail_id_tbl(i),
360: l_sync_tmp_recTbl.parent_detail_id_tbl(i),
361: l_sync_tmp_recTbl.delivery_id_tbl(i),
362: l_operation_type,
363: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);
364: --
365: IF l_debug_on THEN
366: WSH_DEBUG_SV.logmsg(l_module_name, 'INSERTED '||SQL%ROWCOUNT||' RECORDS IN WSH_WMS_SYNC_TMP - 1' );
367: END IF;

Line 383: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP,

379: VALUES (l_sync_tmp_recTbl.delivery_detail_id_tbl(i),
380: NULL,
381: NULL,
382: l_operation_type,
383: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP,
384: l_sync_tmp_recTbl.call_level(i));
385: --
386: IF l_debug_on THEN
387: WSH_DEBUG_SV.logmsg(l_module_name, 'INSERTED '||SQL%ROWCOUNT||' RECORDS IN WSH_WMS_SYNC_TMP - 1' );