DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_PICK_LIST

Line 1094: WSH_DEBUG_SV.log(l_module_name, 'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID);

1090: WSH_DEBUG_SV.log(l_module_name, 'p_group_by_header', p_group_by_header);
1091: WSH_DEBUG_SV.log(l_module_name, 'p_commit', p_commit);
1092: WSH_DEBUG_SV.log(l_module_name, 'p_lock_rows', p_lock_rows);
1093: WSH_DEBUG_SV.log(l_module_name, 'p_check_fte_compatibility', p_check_fte_compatibility);
1094: WSH_DEBUG_SV.log(l_module_name, 'WSH_PICK_LIST.G_BATCH_ID', WSH_PICK_LIST.G_BATCH_ID);
1095:
1096: END IF;
1097:
1098: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1152: IF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NULL THEN

1148: -- lock the delivery detail record
1149: select delivery_detail_id into l_delivery_detail_id from wsh_delivery_details where
1150: delivery_detail_id = p_delivery_detail_tbl(l_index) for update nowait;
1151: END IF;
1152: IF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NULL THEN
1153: x_unappended_det_tbl(x_unappended_det_tbl.count+1) := l_detail_info(l_index).entity_id;
1154: l_detail_info.delete(l_index);
1155: ELSIF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NOT NULL THEN
1156: l_detail_info(l_index).batch_id := WSH_PICK_LIST.G_BATCH_ID;

Line 1155: ELSIF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NOT NULL THEN

1151: END IF;
1152: IF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NULL THEN
1153: x_unappended_det_tbl(x_unappended_det_tbl.count+1) := l_detail_info(l_index).entity_id;
1154: l_detail_info.delete(l_index);
1155: ELSIF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NOT NULL THEN
1156: l_detail_info(l_index).batch_id := WSH_PICK_LIST.G_BATCH_ID;
1157:
1158: END IF;
1159: END IF;

Line 1156: l_detail_info(l_index).batch_id := WSH_PICK_LIST.G_BATCH_ID;

1152: IF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NULL THEN
1153: x_unappended_det_tbl(x_unappended_det_tbl.count+1) := l_detail_info(l_index).entity_id;
1154: l_detail_info.delete(l_index);
1155: ELSIF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NOT NULL THEN
1156: l_detail_info(l_index).batch_id := WSH_PICK_LIST.G_BATCH_ID;
1157:
1158: END IF;
1159: END IF;
1160: <>